how to give connection in windows application

Question

how to give sql connection in windows application using VB . we give connection in asp.net using webconfig file. but how to give connection in windows application

Dileep Kumar Patel · Answer

Dear selvi This class you can use whether window application or web application also.This is common class you can use every where also VB code.It will be change only VB code.

Munesh Sharma · Answer

selvi subramanian This is the format of giving connection in window application. you try this.

selvi subramanian · Answer

Munesh sharma and Dileep Kumar Patel me asked in windows application

Munesh Sharma · Answer

You can give connection in app.config file. But most of time we give connection in coding part. i am giving a example of insert values in sql server Code For Submit private void Submit_txt_Click( object sender EventArgs e) { //this is the connection with database string str = server = MUNESH\SQL2008R2;Database=datastore;UID=sa;Password=123; ; SqlConnection con = new SqlConnection(str); string query = insert into table(IDNameFather) values(' + this .id_txt.Text + '' + this .textBox1.Text + '' + this .textBox2.Text + ') ; SqlCommand cmd = new SqlCommand(query con); SqlDataReader dbr; try { con.Open(); dbr = cmd.ExecuteReader(); // MessageBox.Show(save); MessageBox.Show( Records saved successfully  user information ); while (dbr.Read()) { } textBox2.Text = string .Empty; textBox3.Text = string .Empty; id_txt.Text = string .Empty; con.Close(); }

Dileep Kumar Patel · Answer

Dear subramnian You can use with common class connection with this code: Common Connection(Common Class): using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; /// /// Summary description for DataClass /// public class DataClass { public string strcon; public SqlConnection cn; public SqlCommand cmd; public DataClass() { // // TODO: Add constructor logic here //strcon = Data Source=RICHA\SQLEXPRESS;Initial Catalog=NPsilvani;Integrated Security=true;; //strcon= Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NPsilvani.mdf;Integrated Security=True; //strcon = @Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NPsilvani.mdf;Integrated Security=true;User Instance=True; //strcon = @Data Source=111.118.178.5;DataBase=npsilwan_;Integrated Security=true; strcon = ConfigurationManager.ConnectionStrings[rupadbConnectionString].ConnectionString.ToString(); //a } public void Openconnection() { cn = new SqlConnection( strcon); cn.Open(); } public void Closeconnection() { if (cn.State == ConnectionState.Open) cn.Close(); } public void ExecuteCMD(string str) { Openconnection(); cmd = new SqlCommand(str cn); cmd.ExecuteNonQuery(); Closeconnection(); } } You can read my blog also for more : http://www.c-sharpcorner.com/Blogs/9227/types-of-connections-in-Asp-Net-and-ado-net.aspx