SQL Command Bulider

Question

could we used sql command builder in Windows Forms Application? if Yes So how could it do? Please Share Your valuable thoughts.I will very thank full to you...!!!

Mageshwaran R · Answer

Hi, please refer this link: https://www.c-sharpcorner.com/UploadFile/mahesh/commandbuilder-in-ado-net/

Mohammad Muzammil · Answer

Would like to explain it alone with your valuable words?

Laxmidhar Sahoo · Answer

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[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()); } } } }