SQL Command Bulider

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string connetionString = null;
SqlConnection connection ;
SqlDataAdapter adapter ;
SqlCommandBuilder cmdBuilder ;
DataSet ds = new DataSet();
string sql = null;
Int32 i ;
connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
connection = new SqlConnection(connetionString);
sql = "select * from Product";
try
{
connection.Open();
adapter = new SqlDataAdapter(sql, connection);
cmdBuilder = new SqlCommandBuilder(adapter);
adapter.Fill(ds);
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
ds.Tables[0].Rows[i].ItemArray[2] = Convert.ToInt32 (ds.Tables[0].Rows[i].ItemArray[2]) + 100;
}
adapter.Update(ds.Tables[0]);
connection.Close();
MessageBox.Show ("Data updated ! ");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R7y ago
Hi,
please refer this link:
https://www.c-sharpcorner.com/UploadFile/mahesh/commandbuilder-in-ado-net/
0
Mohammad Muzammil8y ago
Would like to explain it alone with your valuable words?
0
Laxmidhar Sahoo8y ago
1. using System;
2. using System.Data;
3. using System.Data.SqlClient;
4. using System.Windows.Forms;
6. namespace WindowsApplication1
7. {
8. public partial class Form1 : Form
9. {
10. public Form1()
11. {
12. InitializeComponent();
13. }
15. private void button1_Click(object sender, EventArgs e)
16. {
17. string connetionString = null;
18. SqlConnection connection ;
19. SqlDataAdapter adapter ;
20. SqlCommandBuilder cmdBuilder ;
21. DataSet ds = new DataSet();
22. string sql = null;
23. Int32 i ;
25. connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
26. connection = new SqlConnection(connetionString);
27. sql = "select * from Product";
28. try
29. {
30. connection.Open();
31. adapter = new SqlDataAdapter(sql, connection);
32. cmdBuilder = new SqlCommandBuilder(adapter);
33. adapter.Fill(ds);
34. for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
35. {
36. ds.Tables[0].Rows[i].ItemArray[2] = Convert.ToInt32 (ds.Tables[0].Rows[i].ItemArray[2]) + 100;
37. }
38. adapter.Update(ds.Tables[0]);
39. connection.Close();
40. MessageBox.Show ("Data updated ! ");
41. }
42. catch (Exception ex)
43. {
44. MessageBox.Show(ex.ToString());
45. }
47. }
48. }
49. }
0