i m trying to update a table in my sql database using stored procedure. i have executed my stored procedure and dat works fine, no problem in that. i knwo because the values are updated when i execute it. however when i try to do so through asp.net code that i have created, it doesnt update in the table plus it doesnt show me any error, all it does is displays the previous values as it was. can someone tell me wat d error cud be. my code is given below:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class UpdateEvents : System.Web.UI.Page
{
int eid;
string etype;
string edate;
string etime;
string eloc;
protected void Page_Load(object sender, EventArgs e)
{
LBL_msg2.Visible = false;
eid = (int)(Session["id"]);
Facade evntFacade = new Facade();
evntFacade.selectEvnt(eid, out etype, out edate, out etime, out eloc);
evntTypetxt.Text = etype;
evntDate2txt.Text= edate;
evntTime2txt.Text=etime;
loc2txt.Text = eloc;
protected void updatebtn_Click(object sender, EventArgs e)
{
int n;
eid = (int)(Session["id"]);
etype = evntTypetxt.Text;
edate = evntDate2txt.Text;
etime = evntTime2txt.Text;
eloc = loc2txt.Text;
LBL_ms.Text =etype;
Facade evntFacade = new Facade();
n = evntFacade.updateEvnt(eid, etype, edate, etime, eloc);
if (n > 0)
{
LBL_msg2.Text = "Succesfuly Updated";
}
else
{
LBL_msg2.Text = "Error in updation";
}
Label1.Text = etype;
i have a feeling that its not picking up the new values that i am entering in the textfields. i dont know how to make it pick up the new updatd values.
plz help if someone can...