updating datbase using datatable

Question

0.00/5 (No votes)

See more:

im new to .Net this is the code which my friend gave for updating a table in sql database using c#,asp.net code:

C#

{
  string dpt = (string)Session["deptmnt"];
  string con = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
                SqlConnection con1 = new SqlConnection(con);
                con1.Open();
 string qry = @"select * from faculty where ((fid like '%" + dpt + "%') and (fid='"+Label17.Text+"'))";
                    SqlDataAdapter da = new SqlDataAdapter();
                    da.SelectCommand = new SqlCommand(qry, con1);
                    
                    string upd = @"update faculty SET fname = '" + TextBox7.Text + "',gender='" + DropDownList10.SelectedValue + "', dept = '" + DropDownList5.SelectedValue + "', maxbooks = '" + DropDownList8.SelectedValue + "' WHERE fid = '" + Label17.Text + "'";
                                      SqlCommandBuilder cb = new SqlCommandBuilder(da);
                    DataSet ds = new DataSet();
                    da.Fill(ds, "faculty");


                    DataTable dt = ds.Tables["faculty"];
                    dt.Rows[1]["fname"] = TextBox7.Text;
                    dt.Rows[1]["gender"] = DropDownList10.SelectedValue;
                    dt.Rows[1]["dept"] = DropDownList5.SelectedValue;
                    dt.Rows[1]["maxbooks"] = DropDownList8.SelectedValue;

                    SqlCommand cmd = new SqlCommand(upd, con1);
                    da.UpdateCommand = cmd;

                    da.Update(ds, "faculty");

                    con1.Close();
}

when i debug the code,the control does not go after " dt.Rows[1]["fname"] = TextBox7.Text;"
why is it so? Im unable to find the reason.,what does dt.Rows[number] stand for? does it indicate the row number or what it is? plz help

Posted 3-Aug-13 20:45pm

sundaram meenakshi

Updated 3-Aug-13 21:24pm

Joezer BH

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kuthuparakkal · Accepted Answer · 2013-08-03T21:10:00

Solution 1

Change it as :

C#

dt.Rows[0]["fname"] = TextBox7.Text;
dt.Rows[0]["gender"] = DropDownList10.SelectedValue;
dt.Rows[0]["dept"] = DropDownList5.SelectedValue;
dt.Rows[0]["maxbooks"] = DropDownList8.SelectedValue;

Posted 3-Aug-13 21:10pm

Kuthuparakkal

Comments

sundaram meenakshi 4-Aug-13 3:17am

@Kuthuparakkal thank you soo much it worked superb.i have been trying for many hours,thank you.but,what does the 0 indicate can u explain?

ridoy 4-Aug-13 3:19am

It indicates first row of your datatable.

Kuthuparakkal 4-Aug-13 3:20am

Datatable/Rows/Columns etc have zero based indices, 0 first row, 1 second row etc.. In your case, there wasnt any second row so it fails there..

sundaram meenakshi 4-Aug-13 3:20am

can u plz tell if it indicates the first row,how the row specified in the where condition is identified?

Kuthuparakkal 4-Aug-13 3:23am

I dont understand yr question

ridoy 4-Aug-13 3:24am

after executing sql command,i mean after updating using where condition, your dataset is filled and then the datatable.so then 1st row of datatable specified.

ridoy 4-Aug-13 3:27am

+5 from me.

Kuthuparakkal 4-Aug-13 3:46am

Thanks Ridoy, appreciated!

ridoy 4-Aug-13 3:48am

:)

sundaram meenakshi 4-Aug-13 3:30am

ok ok now i understand thank you very much @Kuthuparakkal and @ridoy :)

Kuthuparakkal 4-Aug-13 3:45am

If it helped pls maark answer.. thanks!

ridoy 4-Aug-13 3:48am

glad to help you,:).