i need windows application with sql connection example code

Question

windows application with sql connection and how to create multiple table in a database

Raja T · Answer

Hi Durga Velusamy try this using System; using System.Data; using System.Data.SqlClient; using System.Windows.Forms; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender EventArgs e) { string connetionString = null; SqlConnection connection ; SqlCommand command ; SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); int i = 0; string firstSql = null; string secondSql = null; connetionString = Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password; firstSql = Your First SQL Statement Here; secondSql = Your Second SQL Statement Here; connection = new SqlConnection(connetionString); try { connection.Open(); command = new SqlCommand(firstSql connection); adapter.SelectCommand = command; adapter.Fill(ds First Table); adapter.SelectCommand.CommandText = secondSql; adapter.Fill(ds Second Table); adapter.Dispose(); command.Dispose(); connection.Close(); //retrieve first table data for (i = 0; i { MessageBox.Show(ds.Tables[0].Rows[i].ItemArray[0] +  --  + ds.Tables[0].Rows[i].ItemArray[1]); } //retrieve second table data for (i = 0; i { MessageBox.Show(ds.Tables[1].Rows[i].ItemArray[0] +  --  + ds.Tables[1].Rows[i].ItemArray[1]); } } catch (Exception ex) { MessageBox.Show(Can not open connection ! ); } } } } Thanks