Question

please answer

Add the ability to insert a customer. Assume the Customer Table has the fields CustomerName, CustomerAddress, CustomerState, Customerid. You can google the format of a SQL INSERT statement if necessary. SqlCommand updcmd; updcmd = new SqlCommando; updcmd.Connection = myconn; updcmd.CommandText = "Update Customer_T set Customer State - @customerstate+'Where Customer @customerid and" + " CustomerVersion = @version"; updcmd.Parameters.Add("@version", SqlDbType.Binary, 50,"CustomerVersion"); updcmd.Parameters.Add("@customerstate", SqlDbType.NVarChar, 50,"CustomerState"); updcmd.Parameters.Add("@customerid", SqlDbType.int, 50,"CustomerID"); SqlDataAdapter myadapter = new SqlDataAdapter(); myadapter.UpdateCommand = updcmd; Smyadapter.ContinueUpdateOnError = true; YOUR CODE WOULD BE INSERTED HERE, Write your code in answer box. try myadapter.Update(mytable); catch (Exception ex) { mytxn.Rollback(); MessageBox.Show("Database has been updated. Please refill grid and make updates

Answer 1

Short Summary:

• Assuming, have to insert CustomerID, CustomerName, CustomerAddress, CustomerState columns only. If you want to include more columns, adjust the INSERT query and the parameters accrodingly.

Insert Command Codes:

            // Create new command for insert

            SqlCommand insertcmd;

            insertcmd = new SqlCommand();

            //Assign the connection

            insertcmd.Connection = myconn;

          // Add insert query

            insertcmd.CommandText = "INSERT INTO Customer (CustomerID, CustomerName, CustomerAddress, CustomerState) "

            + " VALUES (@customerID, @customername, @customeraddress, @customerstate)";

            //Assign the parameter values and map to sourcec column

            insertcmd.Parameters.Add("@customerID", SqlDbType.Int, 50, "CustomerID");

            insertcmd.Parameters.Add("@customername", SqlDbType.NVarChar, 50, "CustomerName");

            insertcmd.Parameters.Add("@customeraddress", SqlDbType.NVarChar, 100, "CustomerAddress");

            insertcmd.Parameters.Add("@customerstate", SqlDbType.NVarChar, 50, "CustomerState");

            //Assign the insert command to the adapter

            myadapter.InsertCommand = insertcmd;

SqlCommand updcmd; updcmd = new SqlCommand(); updcmd.Connection = myconn; updcmd.CommandText = "Update Customer_T Set Customerstate = @customerstate" + "where CustomerID = @customerid and + " Customerversion = @version"; updcmd.Parameters.Add("@version", SqlDbType.Binary, 50, "CustomerVersion"); updcmd.Parameters.Add("@customerstate", SqlDbType.nvarchal, 50, "Customerstate"); updcmd.Parameters.Add("@customerid", SqlDbType.Int, 188, "CustomerID"); SqlDataAdapter my adapter = new SqlDataAdapter(); myadapter UpdateCommand = updcmd; myadapter.ContinueUpdateOnError = true; 1/ Create new command for insert SqlCommand insertcmd; insertcmd = new SqlCommand); // Assign the connection insertcmd.Connection = myconn; // Add insert query insertcmd.CommandText = "INSERT INTO Customer (CustomerID, CustomerName, CustomerAddress, Customerstate)" +" VALUES (@customerID, @customername, @customeraddress, @customerstate)"; // Assign the parameter values and map to sourcec column insertcmd.Parameters.Add("@customerID", SqlDbType. Int, 58, "CustomerID"); insertcmd.Parameters.Add("@customername", SqlDbType.Nvarchar, 5e, "CustomerName"); insertcmd.Parameters.Add("@customeraddress", SqlDbType.Nvarchar, 1ee, "CustomerAddress"); insertcmd.Parameters.Add("@customerstate", SqlDbType.nvarchar, 5e, "Customerstate"); / /Assign the insert command to the adapter myadapter. Insert Command = insertcmd; try myadapter.Update(mytable);

******************************************************************************

Feel free to rate the answer and comment your questions, if you have any.

Please upvote the answer and appreciate our time.

Happy Studying!!!

******************************************************************************