ASP.NET

Re: rebind Gridview after filtering with dropdownlist

15-Apr-07 12:03

Hi,

I have a gridview which is bound to a acessdatasource at page load. I also have a dropdownlist bound to a datasource with a list of countries. How do I rebind the gridview after a certain country was selected from the dropdown list? Thank you.

gauthee15-Apr-07 18:29

gauthee

15-Apr-07 18:29

You have to write your coding in item_command event of the datagrid.
when you add the dropdown to your datagrid specify the commandname as'xxxx'

then in your itemcommand event you give : if(e.commandname=="xxxx")

the selcted value from the ddl can be sent ot database and you can retrieve information accrdingly and finally bind the datagrid again.

Gautham

Re: rebind Gridview after filtering with dropdownlist

Albert8315-Apr-07 18:33

Re: rebind Gridview after filtering with dropdownlist

15-Apr-07 18:33

I am using Asp.net 2.0 there is no datagrid anymore. Thanks for your reply

Chetan Ranpariya19-Apr-07 23:38

Re: rebind Gridview after filtering with dropdownlist

19-Apr-07 23:38

Hi,

Have you put the dropdown list in the gridview or outside the gridview?

If its outside then you can create an event handler to handle SelectedIndexChanged event of DropDownList and filter data there and bind the gridview again.

Thanks and Regards,
Chetan Ranpariya

Albert8320-Apr-07 7:29

Re: rebind Gridview after filtering with dropdownlist [modified]

20-Apr-07 7:29

The dropdown is outside of the gridview. This is asp.net 2.0 not 1.1. So I initially bind the gridview do accessdatasource. And then inside gridview there is a datasourceid property. So I knew how to rebind in asp.net 1.1 I don't know how to rebind in asp.net 2.0.

Thank you

Chetan Ranpariya22-Apr-07 21:00

Re: rebind Gridview after filtering with dropdownlist

22-Apr-07 21:00

Hi,

You can create your AccessDataSource with parameters and on the click event of button you can provide value that parameter.
The following is the example of parameterized AccessDataSource

<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Northwind.mdb" SelectCommand="SELECT [ProductID], [ProductName], [CategoryID] FROM [Alphabetical List of Products] WHERE ([CategoryID] = ?)">
<SelectParameters>
<asp:Parameter Name="CategoryID" Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>

Here AccessDataSource1 has one parameter "CategoryID" which will need a integer value. Also you can see the WHERE clause in the SelectCommand Property of the AccessDataSouce1.

The following code shows you how a value is assigned to the paramter of AccessDataSource1 and GridView is rebounded.

protected void Button1_Click(object sender, EventArgs e)
{
AccessDataSource1.SelectParameters[0].DefaultValue =
ddlCategories.SelectedValue;
GV.DataBind();
}

Here ddlCategories is the dropdownlist whose value I am passing to the parameter of the AccessDataSource1.

I hope this will help you.

-- modified at 2:01 Tuesday 24th April, 2007

Thanks and Regards,
Chetan Ranpariya

Albert8323-Apr-07 19:42

Re: rebind Gridview after filtering with dropdownlist

23-Apr-07 19:42

Hi, thank you for such a detailed reply. One issue is that you included the code in a button event handler. I have no button. Rather once an item was selected from an dropdown category the viewgrid should be rebound. Maybe I didn't clearly understand your explanation.

Thank you.

Chetan Ranpariya23-Apr-07 20:04

Re: rebind Gridview after filtering with dropdownlist

23-Apr-07 20:04

Hi,

If you want your grid to be rebound when an item is selected in the dropdownlist, then you should write the code in the "SelectedIndexChanged"
event of the DropDownList.

protected void ddlCategories_SelectedIndexChanged(object sender, EventArgs e)
{
AccessDataSource1.SelectParameters[0].DefaultValue =
ddlCategories.SelectedValue;
GV.DataBind();
}

I hope this will help you.

Thanks and Regards,
Chetan Ranpariya

Albert8323-Apr-07 20:08

Re: rebind Gridview after filtering with dropdownlist

23-Apr-07 20:08

Thank you. I will try it. But I understand the solution. It seems that it got even simpler in asp.net 2.0. I assumed you have to create a datasource and then assign it to the gridview. And from what I see you just wrote gv.databind()

Thanks alot for your assistance.

Chetan Ranpariya23-Apr-07 20:11

Moving data from one gridview to another gridview

23-Apr-07 20:11

Hi,

No need to say thanks.

One thing I would like to remind you that dont forget to set "AutoPostBack" property of DropdownList to "true".

Thanks and Regards,
Chetan Ranpariya

Atif Ali Bhatti15-Apr-07 10:49

Atif Ali Bhatti

15-Apr-07 10:49

hi guys,
i have a problem. I have two gridviewss say A and B. gridview A has many records. on selecting a particular record, tht record shud be moved in the gridview B. in this way gridview B has all records selected from A.How am i suppposed to do so. Need ur help.
Thnx in advance.

sql server n ASP.NET

hariram2815-Apr-07 6:44

hariram28

15-Apr-07 6:44

cud any one help in how to get field type of table through coding..?

Re: sql server n ASP.NET

Jaiprakash M Bankolli15-Apr-07 7:50

Jaiprakash M Bankolli

15-Apr-07 7:50

I would suggest you to use typed dataset to get such information !!!

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
http://jaiprakash.blog.com/

page type in ASP.NET

hariram2815-Apr-07 6:17

hariram28

15-Apr-07 6:17

could any one help me how to change the page type like the one usually comes for printing etickets, with only borders no toolboxand all...?
got it r am i confusing..?
Help me plsss...

Jaiprakash M Bankolli15-Apr-07 7:51

Jaiprakash M Bankolli

15-Apr-07 7:51

Can you explain some more on your problem ?

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
http://jaiprakash.blog.com/

RichardGrimmer16-Apr-07 0:52

RichardGrimmer

16-Apr-07 0:52

window.open("MyUrl.aspx","srch",'toolbar=0,location=0,directories=0,menubar=0,scrollbars=1,status=0,resizable=1,top=10,left=10')

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

hariram2818-Apr-07 7:20

hariram28

18-Apr-07 7:20

thanx for ur reply.... but it dint works.... i'm using C# in ASP.NET 1.1....
would tat works for it..?

Populating and Implementing 4 DropDown Listboxes from one table on the Web Form

RichardGrimmer18-Apr-07 21:45

RichardGrimmer

18-Apr-07 21:45

Sorry, should've been clearer. It's a little bit of javascript. You have 2 options - either in the markup of your page, put a script tag with a function defined that just calls window.open, or alternatively, you can use the Page.RegisterStartupScript or Page.RegisterClientScriptBlock to emit it to the page, and it will then be run at the appropriate time.

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

koonda00715-Apr-07 3:45

koonda007

15-Apr-07 3:45

Hi all,

I have a Project due after one week. It is a web service project. I have a Web Form which communicates to the web service and this web service communicates to the database. I have all my SQL statements in the Data Acess Layer to create more secure web service application. The Web service class is also in the Data Access Layer. I need to populates the 4 Dropdown list boxes on the web form from one table. I have Customer table which contains information About CustomerName, CustomerType, Address, City. These 4 colum values should populate the 4 Dropdown lists. And then I need to implement those 4 dropdowns like this. When the user selects a Customername it should display relevant customer information in the GridView. Or when the user selects values from all 4 listboxes it should display all information on GridView as well.

For all the above I have just populated one listbox but I don't know how to populate the other 3 dropdown lists and implement them on the web form.

I have created one method in the Data Access Layer class and one method in the Web Service class and then I instaitiated the web service object in the web form by adding a web reference. It works fine for just populating one dropdown list box but for the whole 4 dropdown list I am unable to populated and Implement them.

Below are the methods and the code for one dropdownlist.

(1)Web Form code:

WebService.Service ws = new WebService.Service();

protected void Page_Load(object sender, EventArgs e)
{

object[] alist;
alist = ws.GetBusinessType(string.Empty);
DropDownList1.DataSource = alist;
DropDownList1.DataBind();

(2) Web Service Method:

[WebMethod]
public ArrayList GetBusinessType(string btype)
{
DAccess ODA = new DAccess(); //Data Access object
ArrayList list = new ArrayList();

list = ODA.GetBusinessType(btype); //Data Access method

return list;

}

(3) Data Access method:

public ArrayList GetBusinessType(string btype)
{
SqlConnection connection = GetConnection;
try
{
ArrayList arrbt = new ArrayList();

StringBuilder sql = new StringBuilder()
.AppendLine("SELECT")
.AppendLine("\tTYPENAME")
.AppendLine("\tFROM")
.AppendLine("\tBUSINESS_TYPE");

SqlParameter paramTYPENAME = new SqlParameter("TYPENAME", SqlDbType.NVarChar);
paramTYPENAME.Value = btype;

connection.Open();

SqlDataReader reader = ExecuteQuery(connection, sql.ToString(), paramTYPENAME);

while (reader.Read())
{
string result = reader["TYPENAME"].ToString();
arrbt.Add(result);

}

return arrbt;
}
catch (Exception ex)
{
return null;
//do some log here Call a class that logs the errors
}
finally
{
connection.Close();
}

All the above code works fine for just populating the one dropdown list but not implementing. I just want the implementation something like....When the user select one dropdown or all of them then it should display the result in the gridview. I have not shown the aspx code here but the main thing is the code above. Can any one help me to implement this

I really appreciate your help. Looking forward to your reply.

Thanks

Koonda

Re: Populating and Implementing 4 DropDown Listboxes from one table on the Web Form

Chetan Ranpariya19-Apr-07 23:43