How to define common odbc connection??

Senthil Gopi

Hi
I'm new to .net , I'm creating a new windows application, i have 3 forms in it, all the forms will have related to database execution, so every time do i need to define same set of odbc connection or there any function to create it as common and can be called by the all the forms??

OdbcConnection dbcon = new OdbcConnection("Driver={IBM DB2 ODBC DRIVER};DBALIAS=TEST;Uid=db2admin;Pwd=xingmpeg;");

OdbcCommand cmd;

OdbcDataAdapter oda;

DataSet ds;

dbcon.Open();

string dbcmd = "Select * from tbl_login where u_name = '" + textBox1.Text + "'";

cmd = new OdbcCommand(dbcmd, dbcon);

oda = new OdbcDataAdapter();

ds = new DataSet();

oda.SelectCommand = cmd;

oda.Fill(ds);

dbcon.Close();

4 Replies

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

Senthil Gopi14y ago
hi achuta when try that method posted on the link I'm getting error as "Error 4 The name 'ConfigurationManager' does not exist in the current context D:\My Program\Form1.cs 18 25 My Program "
Satyapriya Nayak14y ago
App.xml file 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.OleDb; namespace Update_delete_datagridview { public partial class Form1 : Form { OleDbDataAdapter oledbda; OleDbCommandBuilder olcb; DataTable dataTable; BindingSource bindingSource; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "SELECT * FROM student"; oledbda = new OleDbDataAdapter(str, con); olcb = new OleDbCommandBuilder(oledbda); dataTable = new DataTable(); oledbda.Fill(dataTable); con.Close(); bindingSource = new BindingSource(); bindingSource.DataSource = dataTable; dataGridView1.DataSource = bindingSource; dataGridView1.Columns[0].Visible = false; } private void btnaddupdate_Click(object sender, EventArgs e) { try { oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show("Records updated"); } private void btndelete_Click(object sender, EventArgs e) { try { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index); oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show("Records Deleted"); } } }
Senthil Gopi14y ago
ok thank you will try in that method.
R ACHUTHA14y ago
hi
you can put the connection string in App.config file and use it when ever it's need.

refer the below url further more.

http://www.codeproject.com/Articles/28699/How-to-Store-and-Retrieve-a-ConnectionString-from