How I Can Use Command In Parameterized manner

yoord · June 21st, 2004, 01:12 AM

i was create two parameterized command for different need first 4 querying(using store proc) the database and secound for inserting value into same table in same db what i must to do i am get confused thati must declare new instant of SqlCommand Object or create new instance of it how i can do it .
Regards YoOrD

melvik · June 21st, 2004, 02:08 AM

Dear yoord:
I didnt get u clearly, why do u use a separate command to insert?!
Its better to do all in a SP. I guess u check something or .. & insert into ur Table, so do what ever u do in ur SP & then RUN insert command from SP too!
Can u explane more.

Always:),
Hovik Melkomian.

yoord · June 21st, 2004, 02:09 AM

Quote:

quote:Originally posted by yoord
i was create two parameterized command for different need first 4 querying(using store proc) the database and secound for inserting value into same table in same db what i must to do i am get confused thati must declare new instant of SqlCommand Object or create new instance of it how i can do it .
Regards YoOrD

i am using such this code to do its but it dont work properly

Code:

            SqlConnection objConnection=new SqlConnection(strConnection);  
            if(Page.IsPostBack)
            {
              SqlCommand objCommand=new SqlCommand("sp_check_user_pass",objConnection);
              objCommand.CommandType=CommandType.StoredProcedure;
              objCommand.Parameters.Add(new SqlParameter("@username",SqlDbType.NVarChar,50)).Value=username.Text;
              objCommand.Parameters.Add(new SqlParameter("@password",SqlDbType.NVarChar,50)).Value=password.Text;
              SqlParameter SqlParam=objCommand.Parameters.Add(new SqlParameter("@RowCount" ,SqlDbType.Int));
              SqlParam.Direction=ParameterDirection.ReturnValue;
              objConnection.Open();
            try
               {
                    objCommand.ExecuteNonQuery();
                    int rowcount=(int)objCommand.Parameters["@RowCount"].Value;
                    if(rowcount>0)
                     {
                       Response.Write(" User Exist Take Another Uaername");
                      }
                    else
                    {
                             swtch=false;
                           objConnection=new SqlConnection(strConnection);
                             strSql="insert into member_info(first,last,username,password,email) values(@first,@last,@username,@password,@email)";//select * from member_info where username=@username and password=@password";//
                            objCommand.CommandText=strSql;//=new SqlCommand(strSql,objConnection);
                            //objCommand.CommandType=CommandText;
                               objCommand.Parameters.Add(new SqlParameter("@first",SqlDbType.NVarChar,50));//.Value=username.Text;
                               objCommand.Parameters["@first"].Value=first.Text;//"ali";
                              objCommand.Parameters.Add(new SqlParameter("@last",SqlDbType.NVarChar,50));
                              objCommand.Parameters["@last"].Value=last.Text;//"12";
                               objCommand.Parameters.Add(new SqlParameter("@username",SqlDbType.NVarChar,50));
                               objCommand.Parameters["@username"].Value=username.Text;
                                  objCommand.Parameters.Add(new SqlParameter("@password",SqlDbType.NVarChar,50));
                               objCommand.Parameters["@password"].Value=password.Text;
                               objCommand.Parameters.Add(new SqlParameter("@email",SqlDbType.NVarChar,50));
                               objCommand.Parameters["@email"].Value=email.Text;
                            objCommand.Connection.Open();
                      }

yoord · June 21st, 2004, 02:14 AM

Quote:

quote:Originally posted by yoord

Quote:

quote:Originally posted by yoord

Quote:

i was create two parameterized command for different need first 4 querying(using store proc) the database and secound for inserting value into same table in same db what i must to do i am get confused thati must declare new instant of SqlCommand Object or create new instance of it how i can do it .
Regards YoOrD

i am using such this code to do its but it dont work properly

Code:

            SqlConnection objConnection=new SqlConnection(strConnection);  
            if(Page.IsPostBack)
            {
              SqlCommand objCommand=new SqlCommand("sp_check_user_pass",objConnection);
              objCommand.CommandType=CommandType.StoredProcedure;
              objCommand.Parameters.Add(new SqlParameter("@username",SqlDbType.NVarChar,50)).Value=username.Text;
              objCommand.Parameters.Add(new SqlParameter("@password",SqlDbType.NVarChar,50)).Value=password.Text;
              SqlParameter SqlParam=objCommand.Parameters.Add(new SqlParameter("@RowCount" ,SqlDbType.Int));
              SqlParam.Direction=ParameterDirection.ReturnValue;
              objConnection.Open();
            try
               {
                    objCommand.ExecuteNonQuery();
                    int rowcount=(int)objCommand.Parameters["@RowCount"].Value;
                    if(rowcount>0)
                     {
                       Response.Write(" User Exist Take Another Uaername");
                      }
                    else
                    {
                             swtch=false;
                           objConnection=new SqlConnection(strConnection);
                             strSql="insert into member_info(first,last,username,password,email) values(@first,@last,@username,@password,@email)";//select * from member_info where username=@username and password=@password";//
                            objCommand.CommandText=strSql;//=new SqlCommand(strSql,objConnection);
                            //objCommand.CommandType=CommandText;
                               objCommand.Parameters.Add(new SqlParameter("@first",SqlDbType.NVarChar,50));//.Value=username.Text;
                               objCommand.Parameters["@first"].Value=first.Text;//"ali";
                              objCommand.Parameters.Add(new SqlParameter("@last",SqlDbType.NVarChar,50));
                              objCommand.Parameters["@last"].Value=last.Text;//"12";
                               objCommand.Parameters.Add(new SqlParameter("@username",SqlDbType.NVarChar,50));
                               objCommand.Parameters["@username"].Value=username.Text;
                                  objCommand.Parameters.Add(new SqlParameter("@password",SqlDbType.NVarChar,50));
                               objCommand.Parameters["@password"].Value=password.Text;
                               objCommand.Parameters.Add(new SqlParameter("@email",SqlDbType.NVarChar,50));
                               objCommand.Parameters["@email"].Value=email.Text;
                            objCommand.Connection.Open();
                      }

yoord · June 21st, 2004, 02:21 AM

Quote:

quote:Originally posted by melvik
Dear yoord:
I didnt get u clearly, why do u use a separate command to insert?!
Its better to do all in a SP. I guess u check something or .. & insert into ur Table, so do what ever u do in ur SP & then RUN insert command from SP too!
Can u explane more.

Always:),
Hovik Melkomian.

Thanx 2 u
i am going to check for a username if it is exist(using SP) if it is exist it is exist i must alert the user to take another username if it is not exist i must to insert it into table.
and i do this in first(SP) and if it is not exist in Command i must build parameters and insert it into table the main problem i get that i dont know how i can do it (if i had create new command boject or create new SqlCommand Object.
Regards YoOrD.

melvik · June 21st, 2004, 02:24 AM

Im still in my last believe! check ur Username & insert it if not exist! & do all at a SP & not use another command!

REMEMBER SP's r much fast & ...

Always:),
Hovik Melkomian.

yoord · June 21st, 2004, 02:28 AM

Quote:

quote:Originally posted by melvik
Im still in my last believe! check ur Username & insert it if not exist! & do all at a SP & not use another command!

REMEMBER SP's r much fast & ...

Always:),
Hovik Melkomian.

thanx 2 u i must examine it , it is a good idea.
thanx 2 u again :)