如何在数据库中插入动态值？

问题描述：

大家好，

我创建数据行并在gridview中显示值。现在我想将这些值保存在数据库中。

这是我的代码：

我在按钮点击时调用了以下功能。

Hi All,
Iam creating datarows and show that values in gridview.Now i want to save that values in database.
This is my code:
I called this below function in button click.

Protected Sub BindGridviewData()
        Dim dt As New DataTable()
        dt.Columns.Add("UserId", GetType(Int32))
        dt.Columns.Add("FirstName", GetType(String))
        dt.Columns.Add("LastName", GetType(String))
        dt.Columns.Add("Education", GetType(String))
        dt.Columns.Add("Location", GetType(String))
        dt.Columns.Add("State", GetType(String))
        dt.Columns.Add("MobileNo", GetType(Long))
        Dim dtrow As DataRow = dt.NewRow()
        dtrow("UserId") = 1
        dtrow("FirstName") = "Hari"
        dtrow("LastName") = "I"
        dtrow("Education") = "MCA"
        dtrow("Location") = "Vizianagaram"
        dtrow("State") = "AndhraPradesh"
        dtrow("MobileNo") = 9966246869
        dt.Rows.Add(dtrow)
        dtrow = dt.NewRow()
        dtrow("UserId") = 2
        dtrow("FirstName") = "Vishak"
        dtrow("LastName") = "Nair"
        dtrow("Education") = "BCA"
        dtrow("Location") = "Kochi"
        dtrow("State") = "Kerala"
        dtrow("MobileNo") = 8886355702
        dt.Rows.Add(dtrow)
        dtrow = dt.NewRow()
        dtrow("UserId") = 3
        dtrow("FirstName") = "Samba"
        dtrow("LastName") = "Nallamala"
        dtrow("Education") = "B.Tech"
        dtrow("Location") = "Tirupathi"
        dtrow("State") = "AndhraPradesh"
        dtrow("MobileNo") = 9954786688
        dt.Rows.Add(dtrow)
        dtrow = dt.NewRow()
        dtrow("UserId") = 4
        dtrow("FirstName") = "Venkat"
        dtrow("LastName") = "K"
        dtrow("Education") = "B.Tech"
        dtrow("Location") = "Hyderabad"
        dtrow("State") = "AndhraPradesh"
        dtrow("MobileNo") = 7356588688
        dt.Rows.Add(dtrow)
        editgrid.DataSource = dt
        editgrid.DataBind()
    End Sub

谢谢和问候

Hari

Thanks&Regards
Hari

答

参考下面的代码..

Refer Below Code..

foreach (GridViewRow GVRow in GridView1.Rows)
   {
       Name = GVRow.Cells[1].Text;
       CarType = GVRow.Cells[2].Text;
       TechnicalNo = GVRow.Cells[3].Text;
       ProductionDate = GVRow.Cells[4].Text;
       EngaineType = GVRow.Cells[5].Text;
       NoInStock = GVRow.Cells[6].Text;
       NoForCar = GVRow.Cells[7].Text;
       Price = GVRow.Cells[8].Text;
       Image = GVRow.Cells[9].Text;
       Desc = GVRow.Cells[10].Text;
       PartType = GVRow.Cells[11].Text;
       Level = GVRow.Cells[12].Text;
       Unit = GVRow.Cells[13].Text;
       Ratio = GVRow.Cells[14].Text;
       Dirham = GVRow.Cells[15].Text;
       ExtraMoney = GVRow.Cells[16].Text;


   SqlConnection scn = new SqlConnection(clspublic.GetConnectionString());
using(con)
{
   SqlCommand scm = new SqlCommand();
   scm.Connection = scn;
   scm.CommandText = @"INSERT INTO tblProduct
                     (fName, fxCarType, fProductionDate, fEngineType, fNoinStock, fNoforCar, fPrice,fRatio,fDirham,fExtraMoney, fImage, fDesc, fxPartType, fxLevel,fUnitType,fTechnicalNo)
          VALUES     (@fName,@fxCarType,@fProductionDate,@fEngineType,@fNoinStock,@fNoforCar,@fPrice,@fRatio,@fDirham,@fExtraMoney,@fImage,@fDesc,@fxPartType,@fxLevel,@fUnitType,@fTechnicalNo)";

   scm.Parameters.AddWithValue("@fName", Name.ToString());
   scm.Parameters.AddWithValue("@fxCarType", CarType.ToString());
   scm.Parameters.AddWithValue("@fTechnicalNo", TechnicalNo.ToString());
   scm.Parameters.AddWithValue("@fProductionDate", ProductionDate.ToString());
   scm.Parameters.AddWithValue("@fEngineType", EngaineType.ToString());
   scm.Parameters.AddWithValue("@fNoinStock", NoInStock.ToString());
   scm.Parameters.AddWithValue("@fNoforCar", NoForCar.ToString());
   scm.Parameters.AddWithValue("@fPrice", Price.ToString());
   scm.Parameters.AddWithValue("@fRatio", Ratio.ToString());
   scm.Parameters.AddWithValue("@fDirham", Dirham.ToString());
   scm.Parameters.AddWithValue("@fExtraMoney", ExtraMoney.ToString());
   scm.Parameters.AddWithValue("@fImage", Image.ToString());
   scm.Parameters.AddWithValue("@fDesc", Desc.ToString());
   scm.Parameters.AddWithValue("@fxPartType", PartType.ToString());
   scm.Parameters.AddWithValue("@fUnitType", Unit.ToString());
   scm.Parameters.AddWithValue("@fxLevel", Level.ToString());

  scm.ExecuteNonQuery();
}

如何在数据库中插入动态值？

相关推荐