Compiler Error

11y2.1k.NET

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

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="empdetailsfromdb.aspx.cs" Inherits="csvfileupload2.empdetailsfromdb" %>

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

20 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T11y ago
Accepted 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 T11y ago
Hi Saroj, I am here to help u at anytym with pleasure.. :)
11y ago
@raja sir

thank's a lot for solving my issue.
i need more help from you in future.
many many thank's
11y ago
@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 T11y ago
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
11y ago
@raja sir

yes sir i already checked the db there is lot's of data in the field of first name.
Raja T11y ago
Hi Saroj,

Okay.Firstly check now in db below query contains records or not

"SELECT distinct (first_name) FROM profilesrr "

Thanks
11y ago
@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
}

}
}
11y ago
@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 T11y ago
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 Kumar11y ago
Hi Saroj, Already submitted the .aspx code, please provide the .aspx.designer.cs code... Regards, Sathish.
Sathish Kumar11y ago
Hi Saroj, Already submitted the .aspx code, please provide the .aspx.designer.cs code... Regards, Sathish.
11y ago
@Sathish Kumar sir

my empdetailsfromdb.aspx code is bellow

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="empdetailsfromdb.aspx.cs" Inherits="csvfileupload2.empdetailsfromdb" %>
11y ago
@ 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 Kumar11y ago
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 T11y ago
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 Menoth11y ago
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)
{
}
11y ago
but when i am delete
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}

then how to show my data?
Raja T11y ago
Hi,
Try this,

onselectedindexchanged="GridView1_SelectedIndexChanged">

Instead of

just remove the line in aspx file

'onselectedindexchanged="GridView1_SelectedIndexChanged" '

Thanks
Rajeesh Menoth11y ago
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"