ravidaniweb

HI i am getting error on lbl.Visible = true and command.ExecuteNonQuery(); plz check and paste correct coding i doing new project plz help me. protected void Button1_Click1(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=RAVI-PCSQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); …

Hello everyone! i have problem in inserting data in my database from textbox, i m using c#. the code in .aspx.cs file is using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.Sql; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { SqlDataAdapter da …

hi i am getting error plz error SqlConnection conn = new SqlConnection("Data Source=RAVI-PC\\SQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); DataSet ds = new DataSet(); da.Fill(ds, "table_1"); conn.Open(); SqlCommand SQLINSERT =new SqlCommand(); command.Parameters = "insert into table_1(ID,name,address,phone,city)values('@id','@name','@address','@phone','@city')" ; SQLINSERT.Parameters.Add(("@ID",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@name",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@address",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@phone",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@city",Textbox1.Text.ToLower) SQLINSERT.ExecuteNonQuery()

hi this is my connection string SqlConnection conn = new SqlConnection("Data Source=RAVI-PC\\SQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); DataSet ds = new DataSet(); da.Fill(ds, "table_1"); conn.Open(); Actually my doubt is how to insert(data entered in texbox) and delete and update view record from …