| Author: Syed Shakeer Hussain 10 Jan 2009 | Member Level: Diamond | Rating:  Points: 5 |
Hi..
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["connection"].ToString());
connection.Open();
string Table1cmd = "select * from Table1";
SqlDataAdapter adapter1 = new SqlDataAdapter(Table1cmd, connection);
SqlCommandBuilder builder1 = new SqlCommandBuilder(adapter1 );
DataSet dataset1 = new DataSet();
adapter1.Fill(dataset1, "Table1cmd");
//For Table2
string Table2cmd = "select * from Table2";
SqlDataAdapter adapter2 = new SqlDataAdapter(Table2cmd, connection);
SqlCommandBuilder builder2 = new SqlCommandBuilder(adapter2
DataSet dataset2 = new DataSet();
adapter2.Fill(dataset2, "Table2");
}
Thanks & Regards!
Syed Shakeer Hussain
|
| Author: Chan Lemo 13 Jan 2009 | Member Level: Bronze | Rating: Points: 1 |
check the following url
http://vb.net-informations.com/dataset/dataset-multiple-tables-sqlserver.htm
chan.
|