BeetleDev.com ::: BeetleBlog

Add a record to a database with a DataSet using C#

By: douglas - C# - 6/27/2003 2:11:00 AM

This code inserts a record into the database using a DataSet. Using this method you don't need to know SQL and have more control over how things are inserted. Good for adding or updating records.

//Set up connection string and create new connection
            string strConn=ConfigurationSettings.AppSettings["Conn"];
            SqlConnection Conn=new SqlConnection(strConn);
    
            //Open the connection and query the database
            SqlDataAdapter myDataAdapter = new SqlDataAdapter("Select * from MyTable", Conn);
            DataSet myDataSet = new DataSet();
            DataRow myDataRow;
    
            //Create command builder that will be used to update the database.
            SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myDataAdapter);
    
            // Set the MissingSchemaAction property to AddWithKey.
            // AddWithKey lets you retrieve the unique key info from the table 
            myDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
    
            // Fill the dataset with data from the database
            // Now the dataset has a copy of data from the database
            myDataAdapter.Fill(myDataSet, "MyTable");
    
            // Create a new row in the dataset
            myDataRow = myDataSet.Tables["MyTable"].NewRow();
            // Add values to the new row
         myDataRow["DatabseField"] = someVariable;
         myDataRow["AnotherField"] = anotherVariable;
         myDataRow["OtherField"] = otherVariable;
         myDataRow["EtcField"] = etcVariable;
    
            // Add the new row to the dataset
         myDataSet.Tables["MyTable"].Rows.Add(myDataRow);
    
            // Update the database.
            // This updates the changes made in the dataset with the actual database
            myDataAdapter.Update(myDataSet, "MyTable");
    
            // Close the connection
            Conn.Close();

Last Modified: 6/27/2003 2:25:00 AM