how to update a record or value in sqlserver 2005 using asp.net. [Resolved]

Hi, hope this clears your problem. You can use Stored Procedure instead to reduce the code, to make it simpler i choose this way.

.aspx Page:



 <asp:TextBox ID="tbID" runat="server" />

 <asp:Button ID="btn" runat="server" Text="Update" OnClick="btnOk_Click" />



.aspx.cs:



 string _connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;



        protected void Page_Load(object sender, EventArgs e)

        {           

        }

        public void btnOk_Click(object sender, EventArgs e)

        {

            DateTime StartDate1 = DateTime.Parse(DateTime.Today.ToShortDateString());

            DateTime EndDate1 = DateTime.Parse(DateTime.Today.AddDays(1).ToShortDateString());

            TimeSpan diffResult = EndDate1.Subtract(StartDate1);

            int NoOfDays = Convert.ToInt32(diffResult.Days);

            ExecuteUpdate(NoOfDays);

        }

    private void ExecuteUpdate(int NoofDays) // help me in this code

    {

        int attendeddays; 

        using (SqlConnection conn = new SqlConnection(_connStr))

        {

            string sqlselect = "select DaysAttended From EmployeeTable where EmployeeID ="+int.Parse(tbID.Text); 

// Here i used a table EmployeeTable with EmployeeID and DaysAttended as columns.



            using (SqlCommand cmd = new SqlCommand(sqlselect, conn))

            {

                conn.Open();

                attendeddays = (int)cmd.ExecuteScalar();

                conn.Close();

            }

            int actualdays = attendeddays - NoofDays;

            string sqlupdate = "Update EmployeeTable Set DaysAttended ="+actualdays+"where EmployeeID ="+int.Parse(tbID.Text);

            using (SqlCommand cmd = new SqlCommand(sqlupdate, conn))

            {

                conn.Open();

                object obj = cmd.ExecuteNonQuery();

                conn.Close();

                if (obj != null)

                {

                    Response.Write("Succesully Updated");

                }

            }

        }

    } 

Regards,

Awesome Coding !! :)

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator

con.open();
Sql command cmd = new Sqlcommand("update table_name set name='"+Textbox1.text+"',salary='"+textbox2.text+"' where eno='"+textBox3.text+"'",con);
cmd.Executenonquery();
Response.write("<script>alert('Updated Successfully')</script>");
con.close();

vijay.k

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator

update table_name set ename='vijay',age=10 where eid=10

vijay.k

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator

hello vijay

i want to pass variable NoOfDays into the Executeupdate() method how it can be made..?

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator

private void ExecuteUpdate(int NoofDays) // I believe no of days is the above passed parameter (diff. of start date & end date)
{
con.Open();
string sql_update="UPDATE LeaveRecord SET DaysonLeave ="+NoofDays+"WHERE Id=' "+tbID.Text+" ' ";
// IF your EmplD is of type int in the database. then write Where Id = "+int.Parse(tbID.Text);
// here LeaveRecord is tablename, DaysonLeave is the assumed columns name to be updated, tbID.text is the employee id.
using(SqlCommand cmd1 = new SqlCommand(sql_update,con))
{
obj = cmd1.ExecuteNonQuery();
con.Close();
if(obj!=null)
{
response.write("Record Updated Succesfully");
}

}
}

Awesome Coding !! :)

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator

Hi, if you want to more clarity on ADO.NET CRUD (create read Update Delete) operations, please refer the following link:

http://www.dotnetfunda.com/articles/article1619-how-to-perform-edit-update-and-delete-operation-in-gridview-.aspx

Awesome Coding !! :)

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator

Try this

private void ExecuteUpdate(int NoOfDays) // Add Parameters here

    {

        con.Open();

        SqlCommand cmd1 = new SqlCommand();

        string sql_update="UPDATE LeaveRecord SET LeavesRemaining=' "+NoOfDays+" '  WHERE Id=' "+tbID.Text+" ' ";

        cmd1.CommandType = CommandType.Text;

        cmd1.ExecuteNonQuery();

        con.Close();

    } 

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator

thank you vasanth.

Siddu1281, if this helps please login to Mark As Answer. | Alert Moderator