SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB2TABS.mdf;Integrated Security=True;User Instance=True"); SqlCommand cmd = new SqlCommand(); conn.Open(); SqlCommand CMD = conn.CreateCommand(); CMD.CommandType = CommandType.Text; //TABCOS, TABDETS ARE THE TABLE NAMES CMD.CommandText = "SELECT TABCOS.REGNO. TABDETS.FIRSTNAME FROM TABCOS, TABDETS WHERE TABCOS.REGNO = TABDETS.REGNO"; SqlDataAdapter DA = new SqlDataAdapter(); DA.SelectCommand = CMD;
"SELECT `TC.REGNO`, `TD.FIRSTNAME` FROM `TABCOS` TC INNER JOIN `TADDETS` TD ON `TC.REGNO` = `TD.REGNO`"
SqlDataAdapter dt = new SqlDataAdapter(CommandObject) //Declare DataSet and assign dataadapter value to dataset using System.Data DataSet ds = new dataSet (); dt.fill(ds); //to bind gridview Use gridview1.DataSource = ds gridview1.DataBind();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)