How Call sqlhelper sp in c#

DataGrid1.DataSource = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "getEmployeeDetailsByEmployeeId", new SqlParameter("@EmployeeID", 1));
DataGrid1.DataBind();

or

    



Forums » .NET » ASP.NET »

   
How to call stored procedure

Posted Date: 04 Apr 2012      Posted By:: varalakshmi     Member Level: Bronze    Member Rank: 4670     Points: 1   Responses: 4



Hi to All,

how to call stored procedure in code behind using sqlhelper.i would need to help.



Thanks & Regards
Varalakshmi.P


       


inShare
Responses
#665012    Author: Rajalingam      Member Level: Silver      Member Rank: 593     Date: 04/Apr/2012   Rating: 2 out of 52 out of 5     Points: 4

Hi,


Us this below code

string _connectionString=mention your database server details

SqlConnection conn = new SqlConnection(_connectionString)
SqlCommand cmd = new SqlCommand("select_directory_groups", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@directory_id", directoryID);

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();


da.Fill(ds);
retutn ds


#665015    Author: Bijit      Member Level: Gold      Member Rank: 146     Date: 04/Apr/2012   Rating: 2 out of 52 out of 5     Points: 4

try this code........
public static string GetConnStr()
{
string conn = "put connection string here";
return conn;

}

/// <summary>
/// Returns filled dataset from stored procedure name and its parameters
/// </summary>
public DataSet FillDataset(string sProc, SqlParameter[] parameter, object[] values)
{
return FillDataset(sProc, parameter, values, DataAccess.GetConnStr());
}

/// <summary>
/// Returns filled dataset from stored procedure name and its parameters
/// </summary>
public static DataSet FillDataset(string sProc, SqlParameter[] parameter, object[] values, string ConStr)
{
using (SqlConnection myConnection = new SqlConnection(ConStr))
{
using (SqlDataAdapter myAdapter = new SqlDataAdapter())
{

myAdapter.SelectCommand = new SqlCommand(sProc, myConnection);
myAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;

// assign all parameters with its values
for (int i = 0; i < parameter.Length; i++)
{
myAdapter.SelectCommand.Parameters.Add(parameter[i]).Value = values[i];
}

DataSet myDataSet = new DataSet();

myAdapter.Fill(myDataSet);

return myDataSet;
}
}
}


#665029    Author: Anil Kumar Pandey      Member Level: Platinum      Member Rank: 1     Date: 04/Apr/2012   Rating: 2 out of 52 out of 5     Points: 3

Please check this below sample code.


SqlParameter spc = new SqlParameter[4];
spc = SqlHelperParameterCache.GetSpParameterSet(cnn,"SPNAME");

spc[0]=productID
spc[1]=productName
spc[2]=unitPrice
spc[3]=qtyPerUnit

SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure,"SPNAME",spc);

//