'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code. Procedure or function 'usp_checklist_select' expects parameter '@system',which was not supplied. WHERE DID I GO WRONG IN THE CODE? RSS
Your statement is wrong, you should use EXEC instead of Update.
The code:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.AllowPaging = true;
GridView1.PageSize = 15;
GridView1.AllowSorting = false;
BindGridView();
}
}
private void BindGridView()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr527"].ToString()))
{
DataSet leo = new DataSet();
string sql = "EXEC dbo.uspGetAddress @Price = 'P1'";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
conn.Open();
//SqlCommand cmd = new SqlCommand();
//cmd.Connection = conn;
//cmd.CommandText = "UPDATE usp_checklist_select SET task_system = @System";
//cmd.CommandType = CommandType.Text;
//cmd.Parameters.Add("@System", SqlDbType.Char, 3);
da.Fill(leo);
GridView1.DataSource = leo;
GridView1.DataBind();
}
}
STORED PROCEDURE:
CREATE PROCEDURE dbo.uspGetPrice @Price nvarchar(30)
AS
SELECT * FROM Test3
WHERE Price = @Price
GO
The result:
Best regards,
Sam
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
None
0 Points
2 Posts
'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code...
Jun 12, 2019 02:20 PM|Elapache1032|LINK
I AM TRYING TO DISPLAY A GRIDVIEW WITH THE GIVEN INFORMATION FROM THE DATABASE AND STORED PROCEDURE
CODE C#
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace Checklist
{
public partial class Checklists : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack)
{
GridView1.AllowPaging = true;
GridView1.PageSize = 15;
GridView1.AllowSorting = false;
BindGridView();
}
}
private void BindGridView()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["VOICE"].ToString()))
{
DataSet leo = new DataSet();
string strSelectCmd = "usp_checklist_select";
SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "UPDATE usp_checklist_select SET task_system = @System";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@System", SqlDbType.Char, 3);
da.Fill(leo, "usp_checklist_select");
DataView list = leo.Tables["usp_checklist_select"].DefaultView;
GridView1.DataSource = list;
GridView1.DataBind();
}
}
protected void checklistDS_Inserting(object sender, SqlDataSourceCommandEventArgs e)
{
}
protected void checklistDS_Inserted(object sender, SqlDataSourceStatusEventArgs e)
{
}
protected void gridview_RowUpdating(object sender, GridViewUpdatedEventArgs e)
{
}
}
}
STORED PROCEDURE:
ALTER PROCEDURE [dbo].[usp_checklist_select]
-- Add the parameters for the stored procedure here
@System char(3)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT [task_id]
,[task_system]
,[task_time]
,[task_name]
,[task_status]
,[task_sched]
,[task_comment]
,[task_startendmonth]
,[task_hreflink]
,[task_signedoffby]
,[task_signedoffdatetime]
FROM [dbo].[checklist_master]
WHERE task_system = @System
END
Participant
1670 Points
635 Posts
Re: 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user...
Jun 13, 2019 10:06 AM|samwu|LINK
Hi Elapache1032,
Your statement is wrong, you should use EXEC instead of Update.
The code:
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GridView1.AllowPaging = true; GridView1.PageSize = 15; GridView1.AllowSorting = false; BindGridView(); } } private void BindGridView() { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr527"].ToString())) { DataSet leo = new DataSet(); string sql = "EXEC dbo.uspGetAddress @Price = 'P1'"; SqlDataAdapter da = new SqlDataAdapter(sql, conn); conn.Open(); //SqlCommand cmd = new SqlCommand(); //cmd.Connection = conn; //cmd.CommandText = "UPDATE usp_checklist_select SET task_system = @System"; //cmd.CommandType = CommandType.Text; //cmd.Parameters.Add("@System", SqlDbType.Char, 3); da.Fill(leo); GridView1.DataSource = leo; GridView1.DataBind(); } }STORED PROCEDURE:
The result:
Best regards,
Sam
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.