来自gridview的C＃sql INSERT值 [英] C# sql INSERT value from gridview

问题描述

我正在尝试从gridview获取值并减少它并且它可以工作，但是将它插入数据库是行不通的。怎么了？

I am trying get value from gridview and decrement it and it work, but insert it to database can't work. What's wrong?

protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
{
    m = GridView1.SelectedRow.Cells[5].Text;
    int nm = Convert.ToInt32(m);
    if (GridView1.SelectedRow.Cells[5].Text != "")
    {
        cn.Open();
        nm--;
        cmd.CommandText = ("INSERT INTO rezerwacje [miejsca] VALUES(@nm)");
        //cmd.ExecuteNonQuery();
        cmd.Clone();
        cn.Close();
    }

}

推荐答案

您需要为<添加参数 @nm 例如

You need to add the parameter for @nm e.g.

cmd.Parameters.Add("@nm", SqlDbType.SmallInt).Value = nm;

其次取消注释

Secondly uncomment the line

cmd.ExecuteNonQuery();

第三个摆脱of

Thirdly get rid of

cmd.Clone();

这篇关于来自gridview的C＃sql INSERT值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！