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();
}
