public void grid() { if (btnSearch == null) { da = new SqlDataAdapter("select * from item where type='dutch'", cn); } else { string name = txtSearch.Text; da = new SqlDataAdapter("select * from item where type='dutch' and itemname like '%" + name + "%'", cn); } ds = new DataSet(); da.Fill(ds); GridView123.DataSource = ds.Tables[0]; GridView123.DataBind(); }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { //string configuration = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; //SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Samir\Documents\College.mdf;Integrated Security=True;Connect Timeout=30"); ////string dropdownvalue = DropDownList1.SelectedItem.Value.ToString(); ////string query = "SELECT STAFF.EMPLOYEEID, STAFF.NAME, STAFF.ADDRESS, STAFF.PHONE, STAFF.ROLEID, DESIGNATION.DESIGNATION FROM STAFF, DESIGNATION WHERE STAFF.ROLEID = DESIGNATION.ROLEID"; //string queryy = "Select * from [dbo].[Login] where UserName ='******'"; //conn.Open(); //SqlCommand command = new SqlCommand(queryy, conn); //SqlDataAdapter adapter = new SqlDataAdapter(command); //DataTable dataTable = new DataTable(); //adapter.Fill(dataTable); //GridView123.DataSource = dataTable; //GridView123.DataBind(); //conn.Close(); //string configuration = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; //SqlConnection conn = new SqlConnection(@"Data Source=localhost;User ID=samir;Password=***********;Unicode=True"); //string dropdownvalue = DropDownList1.SelectedItem.Value.ToString(); //string query = "SELECT STAFF.EMPLOYEEID, STAFF.NAME, STAFF.ADDRESS, STAFF.PHONE, STAFF.ROLEID, DESIGNATION.DESIGNATION FROM STAFF, DESIGNATION WHERE STAFF.ROLEID = DESIGNATION.ROLEID"; //string queryy="Select * from [dbo].[Designation] where Designation ='"+DropDownList1.SelectedItem.Text+"'"; //conn.Open(); //SqlCommand command = new SqlCommand(queryy, conn); //SqlDataAdapter adapter = new SqlDataAdapter(command); //DataTable dataTable = new DataTable(); //adapter.Fill(dataTable); //GridView123.DataSource = dataTable; //GridView123.DataBind(); //conn.Close(); string ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; OracleConnection connection = new OracleConnection(ConnectionString); connection.Open(); string quey = "Select * from DESIGNATION where Designation ='" + DropDownList1.SelectedItem.Text + "'"; OracleCommand command1 = new OracleCommand(quey, connection); GridView123.DataSource = command1.ExecuteReader(); GridView123.DataBind(); connection.Close(); }