views:

15

answers:

0

protected void Authorise(object sender, EventArgs e)
{
CheckBox chk;

        foreach (GridViewRow rowItem in GridView1.Rows)  
        {  
           // gets the Debit Reference number for each row checked  
            string type = GridView1.DataKeys[rowItem.RowIndex].Values[0].ToString();  
            // gets the Debit Error Type Number number for each row checked  
            string DDIREF = GridView1.DataKeys[rowItem.RowIndex].Values[1].ToString();  

            chk = (CheckBox)(rowItem.Cells[0].FindControl("RowChecker"));  

            // chk.checked will access the checkbox state on button click event  
            if (chk.Checked)  
            {  

                 if (type == "1")  
                 {  
                    // Message_ltr.Text = type + DDIREF;  
                     string[] posList;  
                     //   string a = "false";  
                     DataTable dt = this.ExcelToDatatable_dt;  

                     posList = positionList;  
                     foreach (DataRow row in dt.Rows)  
                     {  
                             string error = "No Error Message";  
                             fn.InsertNewDDIsTemporary_Proc(  
                                      row["DDIREF"].ToString()                    //  String DDIREF_P  
                                    , row["Sortcode"].ToString()                  //  String Sortcode_P  
                                    , row["AccountNo"].ToString()                 //  String AccountNo_P  
                                    , row["AccountName"].ToString()               //  String AccountName_P  
                                    , strCompanyID_V                              //  String CompanyID_P  
                                    , (posList[5].Length > 0) ? row["CompanyName"].ToString() : "-"                //  String CompanyName_P  
                                    , (posList[6].Length > 0) ? row["ADD1"].ToString() : "-"                      //  String ADD1_P  
                                    , (posList[7].Length > 0) ? row["ADD2"].ToString() : "-"                   //  String ADD2_P  
                                    , (posList[8].Length > 0) ? row["ADD3"].ToString() : "-"                    //  String ADD3_P  
                                    , (posList[9].Length > 0) ? row["ADD4"].ToString() : "-"                      //  String ADD4_P  
                                    , (posList[10].Length > 0) ? row["Postcode"].ToString() : "-"                  //  String Postcode_P  
                                    , (posList[11].Length > 0) ? row["email"].ToString() : "-"                     //  String email_P  
                                    , (posList[12].Length > 0) ? row["CollectionDay"].ToString() : "-"             //  String CollectionDay_P  
                                    , (posList[13].Length > 0) ? row["phone"].ToString() : "-"                    //  String phone_P  
                                    , (posList[14].Length > 0) ? row["fax"].ToString() : "-"                      //  String fax_P  
                                    , (posList[15].Length > 0) ? row["Notification"].ToString() : "-"             //  String Notification_P  
                                    , (posList[16].Length > 0) ? row["ContactName"].ToString() : "-"               //  String ContactName_P  
                                    , (posList[17].Length > 0) ? row["Companycode"].ToString() : "-"              //  String Companycode_P  
                                    , (posList[19].Length > 0) ? row["First_Amount"].ToString() : "-"              //  String First_Amount_P  
                                    , (posList[20].Length > 0) ? row["Monthly_amount"].ToString() : "-"           //  String Monthly_amount_P  
                                    , (posList[21].Length > 0) ? row["Total_amount"].ToString() : "-"             //  String Total_amount_P  
                                    , (posList[22].Length > 0) ? row["NO_TRANS"].ToString() : "-"                //  String NO_TRANS_P  
                                    , (posList[23].Length > 0) ? row["FREQUENCY"].ToString() : "-"                 //  String FREQUENCY_P  
                                    , DateTime.Now //(posList[24].ToString()) ?? row["First_Collection_Date"]     //  String First_Collection_Date_P  
                                    , DateTime.Now              //  String dateOfBirth_P  
                                    , null             //  String P_REPEATED_F_P  
                                    , DateTime.Now    //  String second_collection_date_P  
                                    , type                  //  String type_P  
                                    , (posList[27].Length > 0) ? row["MOBILE"].ToString() : "-"                  //  String MOBILE_P  
                                  , error);  

                     }  

                }  
                                    else  

                                        {  

                                            Message_ltr.Text = " Cannot Authorise";  
                                        }  

             }  
        }  

    }  

What I want is to insert selected row data(Grid View) into SQL database. The above code inserts all the data from the grid view to the database.

*ExcelToDatatable_dt : Get all the records from the grid view

*InsertNewDDIsTemporary_Proc : Insert Procedure

*positionList = gets the positions of all the columns of the template database from the SQL server, for instance posList[5] which is company name is a 5th column in SQL database

and (posList[5].Length > 0) ? row["CompanyName"].ToString() : "-", will check the row["CompanyName"] from datagridview to be inserted into the company name column in the SQL Server Database.

Hope you understand the above scenario.

Any help will be highly appreciated

What I want is to insert selected row data(Grid View) into SQL database. The above code inserts all the data from the gridview to the database. *ExcelToDatatable_dt : Get all the records from the gridview *InsertNewDDIsTemporary_Proc : Insert Procedure *positionList = gets the positions of all the columns of the template database from the SQL server, for instance posList[5] which is company name is a 5th column in SQL database and (posList[5].Length > 0) ? row["CompanyName"].ToString() : "-", will check the row["CompanyName"] from datagridview to be inserted into the company name column in the SQL Server Database. Hope you understand the above scenario. Any help will be highly appreciated