Please tell me what is wri=ong

[Adrian]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Common;
namespace trial_a
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
string connect_string = "SELECT * FROM Customers, Invoice";
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server = fred\\sqlexpress; database
= newdb;integrated security = true";
using (SqlDataAdapter da = new
SqlDataAdapter(connect_string, conn))
{
using (DataSet ds = new DataSet())
{
da.TableMappings.Add("Table", "Customers");
da.TableMappings.Add("Table1","Invoice");
da.Fill(ds,"Table");

try
{
DataTable dt1 = ds.Tables[0];
DataTable dt2 = ds.Tables[1];
textBox1.Text =
dt1.Rows[0].ItemArray[0].ToString();
textBox2.Text =
dt2.Rows[0].ItemArray[0].ToString();
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
}
}
}

}
}
}

 

[Earl]

SELECT * FROM Customers, Invoice

 

[Adrian]

Yes, that was wrong.
Thank you.
Adrian.

SELECT * FROM Customers, Invoice

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Common;
namespace trial_a
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
string connect_string = "SELECT * FROM Customers, Invoice";
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server = fred\\sqlexpress;
database = newdb;integrated security = true";
using (SqlDataAdapter da = new
SqlDataAdapter(connect_string, conn))
{
using (DataSet ds = new DataSet())
{
da.TableMappings.Add("Table", "Customers");
da.TableMappings.Add("Table1","Invoice");
da.Fill(ds,"Table");

try
{
DataTable dt1 = ds.Tables[0];
DataTable dt2 = ds.Tables[1];
textBox1.Text =
dt1.Rows[0].ItemArray[0].ToString();
textBox2.Text =
dt2.Rows[0].ItemArray[0].ToString();
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
}
}
}

}
}
}