Add two parameters in SqlParameter

[Nzsquall]

Hi Code Masters,

I am an ASP beginner, I have a stored precodure which accepts two input parameters. In my ASP project, I have a button click event

protected void OnAddClick(object sender, EventArgs e)
    {
        string concept = txtConcept.Text;
        string keyword = txtKeyword.Text;
         .......
    int result = Helper.ConceptInsert(concept,keyword);
    }

In my Helper.cs, I have a method as

        public static int ConceptInsert(string description, string keyword)
        {
            int result = -1;
            string connString = ConfigurationManager.ConnectionStrings["MySpaceConnectionString"].ConnectionString;
            string commString = "exec dbo.Concept_Insert @description";

            using (SqlConnection conn = new SqlConnection(connString))
            {
                using (SqlCommand comm = new SqlCommand(commString, conn))
                {
                    comm.Parameters.Add(new SqlParameter("@description", description));
                    comm.Parameters.Add(new SqlParameter("@keyword", keyword));  
                    conn.Open();
                    result = comm.ExecuteNonQuery();
                }
            }

            return result;
        }

But when I run the code, error message is always Procedure or function 'Concept_Insert ' expects parameter '@keyword', which was not supplied.

How can I pass those two parameters together to the stored procedure? Thanks in advanced.

[Frinavale]

You could add a parameter to the SqlCommand.Para meters using one of the Add() methods or using the AddWithValue() method

Here is an example using an Add method:

public static int ConceptInsert(string description, string keyword)
        {
            int result = -1;
            string connString = ConfigurationManager.ConnectionStrings["MySpaceConnectionString"].ConnectionString;
            string commString = "exec dbo.Concept_Insert @description";
 
            using (SqlConnection conn = new SqlConnection(connString))
            {
                using (SqlCommand comm = new SqlCommand(commString, conn))
                {


                   comm.Parameters.Add("@description", SqlDbType.VarChar)
                   comm.Parameters("@description").Value = description
             
                   'comm.Parameters.Add("@keyword", SqlDbType.VarChar)
                   'comm.Parameters("@keyword").Value = keyword

                    conn.Open();
                    result = comm.ExecuteNonQuery();
                }
            }
 
            return result;
        }

-Frinny

[Nzsquall]

Hi Frinny,

Thanks for your reply, but sorry it didn't appear to be working.

I got error messages as no SqlDbType and Error 2 Non-invocable member System.Data.Sql Client.SqlComma nd.Parameters' cannot be used like a method.

[Frinavale]

Post what you have.

-Frinny

[danp129]

On this line: string commString = "exec dbo.Concept_Ins ert @description";

Add ", @keyword" after @description