How to save the data from datagridview to sql server

use sqlbulkcopy for save grid data into database.
Steps :
1. Save Griddata into datatable
2. Use sqlbulkcopy to insert data

public bool InserData(DataTable insertDt)
    {
// insertDt DataTable From UI
        using (SqlConnection objConn = new SqlConnection(objDBTrans.ConnectionString))
        {
            objConn.Open();
            using (SqlBulkCopy objBulkCopy = new SqlBulkCopy(objConn.ConnectionString, SqlBulkCopyOptions.FireTriggers))
            {
                objBulkCopy.DestinationTableName = "real_Propertytype";
               // Arvind W: Column Mapping with DataBase Table
                objBulkCopy.ColumnMappings.Add("Code", "code");

                objBulkCopy.WriteToServer(insertDt);
                objConn.Close();
                return true;
            }
        }
        return false;
    }

I hope this is helpful for u ...:thumbsup:
Arvind Wanjari....

Aarti wrote:

well i have call the data from one table and want to save the data to another table but i need to update one row in that table can you tell me any other way where this logic will work.


My Answer:

When you need to update only one row, then why are you calling all the rows and writing back all the rows again from frontend. (This will only increase the load and time on the machine).


You can do it otherwise by calling only that row from the database, which needs to be updated, and then writing back it to a new table, In the stored procedure you can simply write a command to write all the data from one table to another table leaving one single row, which you have edited and updated from the front end.This will decrease complexity and increase performance also.

Hi,

You can use SQLDataadapter object for updating data to database.