how to give connection in windows application

selvi subramanian

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dileep Kumar Patel12y ago
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 Sharma12y ago
selvi subramanian This is the format of giving connection in window application. you try this.
selvi subramanian12y ago
Munesh sharma and Dileep Kumar Patel me asked in windows application
Munesh Sharma12y ago
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(ID,Name,Father) 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 Patel12y ago
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