THREE TIRE PROJECT

Question

ANY ONE GIVE ME
THREE TIRE DEMO PROJEJT

Answer 1

Hi kiran,

According to my stroed procedure,

- user id is passed as a parameter.

-If that userid exists, activated column is updated to 1 and return 1. (If you want, you can pass the value for activated column also as a parameter.)

-If userid does not exist, it returns -1.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [mysp]
           
           @user_id    int

AS
BEGIN

 DECLARE @l_count                         INT 
         
SET  @l_count =  (SELECT COUNT (user_id_column_name)                  
                     FROM tabelname
                    WHERE (user_id_column_name = @user_id))       

if(@l_count)>0

Begin

 UPDATE tabelname
   SET
      activated = 1
 WHERE user_id_column_name = @user_id
return 1;
End

return -1;

GO

If you find my answer useful, please tick 'Do you like this answer' checkbox.

Answer 2

Hi Kiran,


Here is the code.



int user_id = 145;//This is the user_id

SqlConnection sqlConn = new SqlConnection("your connectionstring here");               

sqlConn.Open();
SqlCommand sqlCommand = new SqlCommand("sp_name", sqlConn);
sqlCommand.CommandType=CommandType.StoredProcedure;

SqlParameter sp1 = new SqlParameter("@result", 0);
sp1.Direction=ParameterDirection.Output;
sqlCommand.Parameters.Add(sp1);
sqlCommand.Parameters.Add(new SqlParameter("@user_id",user_id));

sqlCommand.CommandTimeout = 0;
sqlCommand.ExecuteNonQuery();

int result = Int32.Parse(sp1.Value.ToString());

if(result == 1)
{
MessageBox.Show("Successful");
}
else
MessageBox.Show("Error");

sqlConn.Close();

Answer 3

hi niki 
  your answer is appreciated, you are very helpful to me........
so i ll try execute this code now....one more doubt regarding my c# program.....how should i pass parameters from my program....just give any rough idea or if there is any article with you please post here
                         thank you my friend

Answer 4

hi niki,
       i am using sqlserver

Answer 5

hi niki,
       i am using sqlserver

Answer 6

Hi Kiran

What's your database?

SQL Server? Oracle ? Or something else?

Mention that. Ill help you.