Comments by hemantwithu (Top 72 by date)

Thanks you.I have one more question like Is service or WebAPI or REST are used to get the data from DB? So no event wire-up to the controls.

If we have a folder in the network shared path so How can we transfer the file with login credentials ?

But Here I am not inserting the record with direct insert query as "insert into table values(@c1,@c2)".I am inserting record using DataSet as like this
SqlConnection con = new SqlConnection(connStr);
DataSet ds = new DataSet();
DataRow dr;
SqlCommand cmd = new SqlCommand("select * from address",con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdBuilder;
da.FillSchema (ds,SchemaType.Source );
da.Fill(ds, "address");

dr = ds.Tables["address"].NewRow();
dr["sname"] = "tomy";
dr["fname"] = "peter";

ds.Tables["address"].Rows.Add(dr);

cmdBuilder = new SqlCommandBuilder(da);
da.Update(ds, "address");

Can any one explain why this is happening ?