I have two tables
1.Table1
ID(VARCHAR), Name(VARCHAR), ClientID(INT)
2.Table2
ID(VARCHAR(MAX),DIscription(VAECHAR),
I want to retrive data fro these two tables?
I am writting this following query it is correct or Wrong?
Plz give me the correct code for this one
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["stgdbConnectionString"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("Select * from Table Inner join Table2 where ClientID =" + Session["ClientId"], con);
DataSet ds = new DataSet();
da.Fill(ds);
Chart30.DataSource = ds.Tables["0"];
Chart30.DataBind();
Go to the complete details ...