| Author: Pradeep Kumar Chaudhary 29 Aug 2008 | Member Level: Gold | Rating:  Points: 4 |
Dear Friend,
In case of C#.NET you need to install Microsoft SQL Server. From that you can easily configure your database.For your requirement of the project you can built your database and their table. For download the sql server you go through the microsoft site and easily install them in your system.
|
| Author: krishnakumari 29 Aug 2008 | Member Level: Bronze | Rating: Points: 6 |
Hi friend,
I have done inserstion to the mysql database.
For that I used DLL(mysql.data.sqlclient).
No error, but the data is not updated in the table.
this is the code:
string un = (string)Session["username"];
string dob = ddldate.Text + "/" + ddlmonth.Text + "/" + ddlyear.Text;
MySqlCommand cmd = new MySqlCommand("update tbl_users set firstname=@firstname,sex=@sex,DOB=@dob,country=@country,State=@state,city=@city,Email=@email where username="+"'" + un+"'", conn);
cmd.Parameters.AddWithValue("@firstname", txtfirst.Text);
cmd.Parameters.AddWithValue("@sex", rblsex.Text);
cmd.Parameters.AddWithValue("@dob", dob);
cmd.Parameters.AddWithValue("@country", ddlcountry.Text);
cmd.Parameters.AddWithValue("@state", txtstate.Text);
cmd.Parameters.AddWithValue("@city", txtcity.Text);
cmd.Parameters.AddWithValue("@email", txtemail.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
|