如何将数据从文本框更新到数据库sql [英] how to update the data from textbox to database sql

问题描述

现在我正在尝试基于Web的应用程序，请让我知道，如何将文本框中的数据更新到数据库sql，以及如何从数据库中删除数据并检查其是否可用?.

请指教.....
[DELETED] @ gmail.com
selvakumar v

[edit]已删除电子邮件地址，设置了标签-OriginalGriff [/edit]

now i trying web based appliaction please let me know, how to update the data from textbox to database sql, and how to delete the data from database and also check it its available or not?.

Please advice.....
[DELETED]@gmail.com
selvakumar v

[edit]Email address removed, tags set - OriginalGriff[/edit]

推荐答案

检查此

Hi ,
Check this

protected void Button1_Click(object sender, EventArgs e)
{
    using (
       SqlConnection con =
           new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
    {
        con.Open();
        using (SqlCommand cmd = new SqlCommand("UPDATE dbo.cate  SET cate = @cate , chk = @chk  where id  = @id", con))
        {
            cmd.Parameters.AddWithValue("@cate", txt1.Text);

            cmd.Parameters.AddWithValue("@chk", chk.Checked);

            cmd.Parameters.AddWithValue("@id", lbl1.Text);
            cmd.ExecuteNonQuery();
        }
    }
}

最好的问候
M.Mitwalli

Best Regards
M.Mitwalli

使用更新查询

use update query

update tablename set columnname='value of textbox' where condition

--to check use if Exist keywrod in stored procedure

if Exists(Select * from tablename where condition)
Begin
  -- update query/insert query what ever you want
     insert into table name (column1,column2) values(value1,value2) 
End

这篇关于如何将数据从文本框更新到数据库sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！