Compiler Error

Question

how to solved bellow maintain error Compiler Error Message: CS1061: 'ASP.empdetailsfromdb_aspx' does not contain a definition for 'GridView1_SelectedIndexChanged' and no extension method 'GridView1_SelectedIndexChanged' accepting a first argument of type 'ASP.empdetailsfromdb_aspx' could be found (are you missing a using directive or an assembly reference?) here is my design code onselectedindexchanged=GridView1_SelectedIndexChanged> and here is my back end code using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; using System.Data; using System.IO; namespace csvfileupload2 { public partial class empdetailsfromdb : System.Web.UI.Page { string str = Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { String strQuery = SELECT distinct (city) FROM profilesrr; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DropDownList1.DataSource = cmd.ExecuteReader(); DropDownList1.DataTextField = city; DropDownList1.DataValueField = city; DropDownList1.DataBind(); // DropDownList2.SelectedIndex = 1; } catch (Exception ex) { throw ex; } finally { con.Close(); // con.Dispose(); } } } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { String strQuery = SELECT distinct (first_name) FROM profilesrr; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DropDownList2.DataSource = cmd.ExecuteReader(); DropDownList2.DataTextField = first_name; DropDownList2.DataValueField = first_name; DropDownList2.DataBind(); // DropDownList2.SelectedIndex = 1; } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } } protected void Button1_Click(object sender EventArgs e) { string str = Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(select * from profilesrr where city = ' + DropDownList1.SelectedValue + ' and first_name=' + DropDownList2.SelectedValue + ' con); SqlDataAdapter Adpt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); Adpt.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } protected void DropDownList2_SelectedIndexChanged(object sender EventArgs e) { //code for DropDownList2_SelectedIndexChanged } protected void GridView1_SelectedIndexChanged(object sender EventArgs e) { } } } please help me

Raja T · Answer

Hi Saroj Just change in code like below in loadevent protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { String strQuery = SELECT distinct (city) FROM profilesrr; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DropDownList1.DataSource = cmd.ExecuteReader(); DropDownList1.DataTextField = city; DropDownList1.DataValueField = city; DropDownList1.DataBind(); // DropDownList2.SelectedIndex = 1; } catch (Exception ex) { throw ex; } finally { con.Close(); // con.Dispose(); } strQuery = SELECT distinct (first_name) FROM profilesrr; con = new SqlConnection(str); cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DropDownList2.DataSource = cmd.ExecuteReader(); DropDownList2.DataTextField = first_name; DropDownList2.DataValueField = first_name; DropDownList2.DataBind(); // DropDownList2.SelectedIndex = 1; } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } } } Try this let me know.. Thanks

Raja T · Answer

Hi Saroj I am here to help u at anytym with pleasure.. :)

saroj bhattacharya · Answer

@raja sir thank's a lot for solving my issue. i need more help from you in future. many many thank's

saroj bhattacharya · Answer

@raja sir i can't understand what are you trying to say please modify my code and then send me the code. i am fresher in this field thanks

Raja T · Answer

Hi Saroj I checked your code when you changed dropdownlist 1 changed any city that time only binding dropdownlist 2 also loading by default ony city only displaying in dropdownlist1. You want dropdownlist2 also by default load just changed in ispostback method change it. Thanks

saroj bhattacharya · Answer

@raja sir yes sir i already checked the db there is lot's of data in the field of first name.

Raja T · Answer

Hi Saroj Okay.Firstly check now in db below query contains records or not SELECT distinct (first_name) FROM profilesrr  Thanks

saroj bhattacharya · Answer

@sathish sir here is my .cs page code using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; using System.Data; using System.IO; namespace csvfileupload2 { public partial class empdetailsfromdb : System.Web.UI.Page { string str = Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { String strQuery = SELECT distinct (city) FROM profilesrr; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DropDownList1.DataSource = cmd.ExecuteReader(); DropDownList1.DataTextField = city; DropDownList1.DataValueField = city; DropDownList1.DataBind(); // DropDownList2.SelectedIndex = 1; } catch (Exception ex) { throw ex; } finally { con.Close(); // con.Dispose(); } } } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { String strQuery = SELECT distinct (first_name) FROM profilesrr; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DropDownList2.DataSource = cmd.ExecuteReader(); DropDownList2.DataTextField = first_name; DropDownList2.DataValueField = first_name; DropDownList2.DataBind(); // DropDownList2.SelectedIndex = 1; } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } } protected void Button1_Click(object sender EventArgs e) { string str = Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(select * from profilesrr where city = ' + DropDownList1.SelectedValue + ' and first_name=' + DropDownList2.SelectedValue + ' con); SqlDataAdapter Adpt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); Adpt.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } protected void DropDownList2_SelectedIndexChanged(object sender EventArgs e) { //code for DropDownList2_SelectedIndexChanged } } }

saroj bhattacharya · Answer

@ Raja Yadav yes sir my error is fixed but now in the dropdown list 2 (select first_name) part there is no no dropdown list item is showing. that why i am not able to select the first_name from dropdown list two. how to solved it?

Raja T · Answer

Hi Saroj Are you getting below error right? Compiler Error Message: CS1061: 'ASP.empdetailsfromdb_aspx' does not contain a definition for 'GridView1_SelectedIndexChanged' and no extension method 'GridView1_SelectedIndexChanged' accepting a first argument of type 'ASP.empdetailsfromdb_aspx' could be found (are you missing a using directive or an assembly reference?) So you can GridView1_SelectedIndexChanged removing above error is fixed i think. Now what you want clearly explain so i will help you Thanks.

Sathish Kumar · Answer

Hi Saroj Already submitted the .aspx code please provide the .aspx.designer.cs code... Regards Sathish.

Sathish Kumar · Answer

Hi Saroj Already submitted the .aspx code please provide the .aspx.designer.cs code... Regards Sathish.

saroj bhattacharya · Answer

@ Sathish Kumar sir my empdetailsfromdb.aspx code is bellow

saroj bhattacharya · Answer

@ raja yadav sir i know that. i am sued two dropdown list 1.select city 2.select first_name but in the dropdown list 2(select first_name) there is no data found i think that's why out put are not showing how to solved it? please help me

Sathish Kumar · Answer

Hi Saroj Please find my findings which may useful to fix the above issue. 1. Check the object name has been generated with in empdetailsfromdb .aspx.designer.cs file for ex if it's GridView1 then the object name generated like this. protected global::System.Web.UI.WebControls.GridView GridView1; 2. Check whether the namespace for the empdetailsfromdb class which is available in empdetailsfromdb .aspx.designer.cs file available with in a namespace csvfileupload2 Example: namespace csvfileupload2 { public partial class empdetailsfromdb { //Code implementation. } } Try this and let me know if possible please attach the whole .aspx file (.aspx .cs .designer) Regards Sathish.

Raja T · Answer

Hi Saroj Already binding data from db when you click on search button at the time of your writen code below protected void Button1_Click(object sender EventArgs e) { string str = Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(select * from profilesrr where city = ' + DropDownList1.SelectedValue + ' and first_name=' + DropDownList2.SelectedValue + ' con); SqlDataAdapter Adpt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); Adpt.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } So automatilcally show the data in gridview.No worries about show data in gridview. Thanks

Rajeesh Menoth · Answer

Hi saroj bhattacharya  There have no code inside this code snippet.so you can delete it.without code how it's display your gridview data? protected void GridView1_SelectedIndexChanged(object sender EventArgs e) { }

saroj bhattacharya · Answer

but when i am delete protected void GridView1_SelectedIndexChanged(object sender EventArgs e) { } then how to show my data?

Raja T · Answer

Hi Try this onselectedindexchanged=GridView1_SelectedIndexChanged> Instead of just remove the line in aspx file 'onselectedindexchanged=GridView1_SelectedIndexChanged ' Thanks

Rajeesh Menoth · Answer

Hi Delete the below code from code behind.. protected void GridView1_SelectedIndexChanged(object sender EventArgs e) { } Right click your gridview and check the property in event section delete the gridview selectedindexchanged event like  GridView1_SelectedIndexChanged