How to set this Connection String?

EDN Admin · Sep 24, 2012

Hi expert, I need help here. Problem is connection string return null and no data load into datatable. Here is the code

<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue public<span style="font-size:9.5pt; font-family:Consolas
<span style="color:blue partial <span style="color:blue class <span style="color:#2B91AF
Form1 : 
{

<span style="color:#2B91AF OpenFileDialog dialog = <span style="color:blue
new 
<span style="color:#2B91AF DialogResult dr;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none


{

InitializeComponent();

}
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

<span style="color:blue private <span style="color:blue void button1_Click(<span style="color:blue object sender,

{
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

dialog.Filter = 
dialog.Title = 
dialog.FilterIndex = 1;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

dr = dialog.ShowDialog();

<span style="color:blue if (dr == 
{

textBox1.Text = dialog.FileName;

<span style="color:blue string dbConn = <span style="color:#A31515
"Provider=Microsoft.ACE.OLEDB.12.0;" +

<span style="color:#A31515 "Data Source=" + textBox1.Text.ToString() +

<span style="color:#A31515 "Jet OLEDB

atabase Password=123456;Persist Security Info=False";
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

<span style="color:#2B91AF DataTable dtLoad = <span style="color:blue
new 
<span style="color:#2B91AF DataRow strDatarow = 
dtLoad.Columns.Add(
dtLoad.Columns.Add(
dtLoad.Columns.Add(
dtLoad.Columns.Add(
dtLoad.Columns.Add(


<span style="color:blue string strGenReport = <span style="color:#A31515
"SELECT fname,lname,address,contact,regdate FROM tcustomer";
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

<span style="color:blue using (<span style="color:#2B91AF OleDbConnection conString =
<span style="color:blue new 
{

<span style="color:blue using (<span style="color:#2B91AF OleDbCommand cmdGenReport =
<span style="color:blue new <span style="color:#2B91AF OleDbCommand(strGenReport, conString))

 {


{

conString.Open();


readGenReport = cmdGenReport.ExecuteReader();
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none


{
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

strDatarow[<span style="color:#A31515 "First Name"] = readGenReport[
strDatarow[<span style="color:#A31515 "Last Name"] = readGenReport[
strDatarow[<span style="color:#A31515 "Address"] = readGenReport[
strDatarow[<span style="color:#A31515 "Contact"] = readGenReport[
strDatarow[<span style="color:#A31515 "Reg Date"] = readGenReport[
 dtLoad.Rows.Add(strDatarow);

}

readGenReport.Close();
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

}

<span style="color:blue catch (
{

ex.ToString();

}

}

}



dataGridView1.DataSource = dtLoad;



}


}


<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas }
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none



View the full article

How to set this Connection String?

EDN Admin

Well-known member

Similar threads