Am trying to create a sales input page were a user can inset records by his his or her UserID
This is the code behind:
Protected void btnSubmit_Click(object sender, EventArgs e)
{
string strConnString = ConfigurationManager.ConnectionStrings["datsa"].ConnectionString;
using (SqlConnection conn = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Sales_SellingPrice";
cmd.Connection = conn;
}
Connection();
query = "Sales"; //Stored Procedure name
SqlCommand com = new SqlCommand(query, con); //creating SqlCommand object
com.CommandType = CommandType.StoredProcedure; //here we declaring command type as ...
Go to the complete details ...