i want 2 pass values(enterd in textbox)to table in sql
server without using stored procedure in c#.plz tell me
code with an example.
- 5 Answers
- 13658 Views
- Softcon, Tecra, I also Faced
- E-Mail Answers
Answer Posted / bala
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication4
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs
e)
{
String ConnectionString = "Data
Source=ServerName;Initial Catalog=DatabaseName;Integrated
Security=true";
String Query = "insert into tablename values('"
+ textBox1.Text + "')";
SqlConnection Con = new SqlConnection
(ConnectionString) ;
Con.Open();
SqlCommand Cmd = new SqlCommand(Query, Con);
Cmd.ExecuteNonQuery();
Cmd.Dispose();
Con.Close();
}
}
}
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What are the different ado.net namespaces are available in .net?
What is the use of data grid?
How do you implement locking concept for dataset?
Can datareader hold data from multiple tables?
What is ado circle?
What is difference in record set and dataset?
What is disconnected data?
What are the pre-requisites for connection pooling?
What is ole in vb?
Explain how to pass multiple tables in datasets simultaneously?
What is data view and variable view?
Explain executenonquery?
What are the 3 major types of connection objects in ado.net?
What is a datareader object?
What are the ado.net connection pooling parameters?
