如何在数据库中插入动态值？ [英] How to insert dynamic values in database?

问题描述

大家好，

我创建数据行并在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();
}

这篇关于如何在数据库中插入动态值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！