I'm Trying to catch the result from the SP to display in the front end... Currently My code looks like the following.....
Store Procedure...
INSERT INTO [Table] ([created],[createdBy],[updated],[updatedBy],[name],[description],[order],[recycledFlag],[hardDeletedFlag])
VALUES ('2015-09-08',1,'2015-09-08',1,'test',10,0,0,0)
C# Code...
protected void Button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection("Data Source="";Initial Catalog="";User ID="";Password=""");
con.Open();
SqlCommand cmd = new SqlCommand("test", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuer ...
Go to the complete details ...