why this wont work?
error:
 Exception Details: System.Data.SqlClient.SqlException: Procedure or Function 'test1' expects parameter '@.cid', which was not supplied.
.............................................................
ASPX CODE:
      string cid12;       
        cid12 = "user5";
        // Connection
        ConnectionStringSettings mysettings;
        mysettings = System.Configuration.ConfigurationManager.ConnectionStrings["dbase1_connection"];
        string myConnectionString = mysettings.ConnectionString;
        SqlConnection conn1 = new SqlConnection(myConnectionString);
      SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn1;
        cmd.CommandText = "test1";
        cmd.CommandType = CommandType.StoredProcedure;
        SqlParameter param = cmd.Parameters.Add("@.cid", SqlDbType.NChar, 20);
        param.Direction = ParameterDirection.Input;
        param.Value = cid12;
       
        conn1.Open();
        cmd.ExecuteNonQuery();
        conn1.Close();
.............................................................
STORED PROCEDURE:
ALTER PROCEDURE dbo.test1   
    (       
        @.cid nvarchar(20)
    )
AS
    /* SET NOCOUNT ON */
    select tech_id, customer_id, issue_main from [case] where customer_id = @.cid
    --GO
    RETURN
.............................................................
im using asp.net, C#, and sql express
forgive me. im new to this .net
PLS HELP
pls ignore the post above. i found out that nothing is wrong with that code. i discovered that one on my grid view tables is causing the issue and it is indeed not passing a parameter and thats the reason why i have wasted 12hrs looking at my monitor. hehehe.
my fault. im just human. forgive me.
thanks to you all.
No comments:
Post a Comment