hi,
SqlCommand sqlCmd = new SqlCommand("[usp_PBCustomWorkFlowJobsList_GroupBy]", sqlcon);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dataAdapter = new SqlDataAdapter();
SqlParameter[] sqlparam = new SqlParameter[1];
sqlparam[0] = new SqlParameter("UserId", SqlDbType.Int);
sqlparam[0].Value = 148291;
sqlCmd.Parameters.Add(sqlparam[0]);
or
con.Open();
SqlCommand cmd = new SqlCommand("sp_questions", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@question", "sai"));
cmd.Parameters.Add(new SqlParameter("@answer", 2));
cmd.Parameters.Add(new SqlParameter("@option1", "saddf"));
cmd.Parameters.Add(new SqlParameter("@option2", "sagdf"));
SqlDataReader rdr = cmd.ExecuteReader();
con.Close();