Save all data from dataset in ADO.NET

Question

How can we Save all data from dataset?

Sandeep Singh Shekhawat · Answer

Please look below code and I have added comment as per code: /* Create an Sql Connection*/ string connectionString = Data Source=sandeepss-PC;database=Development;user=sa;password=knowdev; SqlConnection con = new SqlConnection(); con.ConnectionString = connectionString; /*Create an SqlDataAdapter object*/ SqlDataAdapter adapter = new SqlDataAdapter(select * from Movies con); DataSet ds = new DataSet(); /*Fill DataSet with Schema*/ adapter.FillSchema(ds SchemaType.Source); adapter.Fill(ds); /*Add New Row in dataTable which is in DataSet*/ DataRow dr = ds.Tables[0].NewRow(); dr[Title] = Movie1; dr[Director] = Director1; dr[ReleaseDate] = DateTime.Now; ds.Tables[0].Rows.Add(dr); /*Craete command to insert rows in database*/ SqlCommandBuilder cmd = new SqlCommandBuilder(adapter); /*update dataSet and Database*/ adapter.Update(ds.Tables[0]);