如何传递Sql参数

本文关键字：参数 Sql 何传递 | 更新日期: 2023-09-27 18:15:37

此错误将出现在我的代码过程或函数'gridalldata'期望参数'@order_no'，这是没有提供的。我正在向程序发送如下参数

try
{
    con.Open();
    SqlCommand cmd = new SqlCommand("gridalldata", con);
    cmd.Parameters.Add("@order_no", SqlDbType.NVarChar).Value = txt_orderno.Text;
    SqlDataReader dr = cmd.ExecuteReader();
    for (int i = 0; i < dataGridView1.Rows.Count; i++)
    {
        if (dr.HasRows)
        {
            dr.Read();
            dataGridView1.Rows[i].Cells[0].Value = dr[0].ToString();
            dataGridView1.Rows[i].Cells[2].Value = dr[2].ToString();
            dataGridView1.Rows[i].Cells[3].Value = dr[3].ToString();
            dataGridView1.Rows[i].Cells[4].Value = dr[4].ToString();
            dataGridView1.Rows[i].Cells[5].Value = dr[5].ToString();
            dataGridView1.Rows[i].Cells[6].Value = dr[6].ToString();
            dataGridView1.Rows[i].Cells[7].Value = dr[7].ToString();
            dataGridView1.Rows[i].Cells[8].Value = dr[8].ToString();
            dataGridView1.Rows[i].Cells[9].Value = dr[9].ToString();
            dataGridView1.Rows[i].Cells[10].Value = dr[13].ToString();
            dataGridView1.Rows[i].Cells[11].Value = dr[12].ToString();
        }
    }
    dr.Close();
    con.Close();
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}
finally
{
    con.Close();
}

如何修复

如何传递Sql参数

使用cmd.CommandType = CommandType.StoredProcedure;执行存储过程

Try This:

    Try
       {
         con.Open();
            string order= txt_orderno.Text;
            SqlCommand cmd = new SqlCommand("gridalldata", con);
               cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@order_no", SqlDbType.NVarChar).Value=order;
            SqlDataReader dr = cmd.ExecuteReader();
             for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
            if (dr.HasRows)
            {
                dr.Read();
                dataGridView1.Rows[i].Cells[0].Value = dr[0].ToString();
                dataGridView1.Rows[i].Cells[2].Value = dr[2].ToString();
                dataGridView1.Rows[i].Cells[3].Value = dr[3].ToString();
                dataGridView1.Rows[i].Cells[4].Value = dr[4].ToString();
                dataGridView1.Rows[i].Cells[5].Value = dr[5].ToString();
                dataGridView1.Rows[i].Cells[6].Value = dr[6].ToString();
                dataGridView1.Rows[i].Cells[7].Value = dr[7].ToString();
                dataGridView1.Rows[i].Cells[8].Value = dr[8].ToString();
                dataGridView1.Rows[i].Cells[9].Value = dr[9].ToString();
                dataGridView1.Rows[i].Cells[10].Value = dr[13].ToString();
                dataGridView1.Rows[i].Cells[11].Value = dr[12].ToString();
                }
                }
            dr.Close();
            con.Close();

        }

using (SqlConnection connection = new SqlConnection(connectionString))
 {
    connection.Open();
    String orderNo=txt_orderno.Text;
    // Am assuming gridalldata is your SP
    SqlCommand cmd= new SqlCommand(gridalldata, connection);
    cmd.CommandType=CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@order_no", orderNo);
    SqlDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
      // Code        
    }
 }

using语句确保在使用

之后关闭连接

你也应该像这样绑定你的Datagridview 

Public DataTable FillDataGrid(string orderID)
{
SqlCommand cmd = new SqlCommand("gridalldata", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@order_no", orderNo);
        SqlDataAdapter dap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        return ds.Tables[0];  
}

Datatable dt=FillDataGrid(txt_orderno.Text);
DataGridVIew1.DataSource=dt;
相关文章：