how to write simple query

Simple select statement you can use like this

Hi,
        You just need to call the procedure following is the way for calling.

        SqlConnection con=new SqlConnection("Your Connection string over here");
        SqlCommand cmd=new SqlCommand("ProcedureName",con);
        cmd.CommandType=CommandType.StoredProcedure;
        //if your procedure accepts parameter  you need to add it for instance if my proc accepts        //a parameter name @name I will add it in the following way.
        
        cmd.Parameter.AddWithValue("@name","value");


//        Rest of the execution is same what we do for single line query.


With Regards,
Vishal Gilbile

Hi
Please mark it as Accepted Answer, if it really helped you.



Hope it will help.