C# Discussion Boards - CodeProject

3-Jun-07 22:28

I hv dropdownlist on a c# page connected to a database(MS Access).
I want to get values onto my datagrid when I select a value from the dropdownlist.The Item I select from the dropdown will determine what I get loaded onto the datagrid.

Please help with some code.Mine is*********

connect.ConnectionString = strng;

OleDbCommand command = new OleDbCommand("Select * from Extensions Where FilterByKey = '" + DropDownList1.SelectedItem + "'", connect);
connect.Open();
command.Connection = connect;
datareader = command.ExecuteReader();
if (datareader.Read())
{
// This will filter database data by the FilterByKey and then populate the datagrid
GridView1.Items.Add(datareader2[0].ToString());****not working
LabelMessage.Text = "All values displayed";
connect.Close();
datareader.Close();

kagiso

M. J. Jaya Chitra3-Jun-07 22:45

M. J. Jaya Chitra

3-Jun-07 22:45

What version you are using?

If it is 2005 then in the gridview's accessdatasource you can specify the table and in the "where" option you can bind the filter field with the control and select the dropdownlist,

Otherwise if you want to do it in coding write the below coding in the dropdownlist_selectedindexchanged event and don't forget to enable the option "enable Auto post back"

OleDbDataAdapter oda = new OleDbDataAdapter("Select * from Extensions Where FilterByKey = '" + DropDownList1.SelectedItem.ToString() + "'", connect);
connect.Open();
Dataset ds =new Dataset();
oda.fill(ds,"MyTable1");
GridView1.DataSource=ds.Tables[0];
Gridview1.DataBind();

Best Regards,
M. J. Jaya Chitra

matjame3-Jun-07 22:51

3-Jun-07 22:51

Thanx.

I will try now and give you the response

kagiso

matjame3-Jun-07 23:02

3-Jun-07 23:02

Its says Type or Name space 'DataSet' could not be found.
And it says 'Are you using or missing a using directive

kagiso

M. J. Jaya Chitra3-Jun-07 23:05

M. J. Jaya Chitra

3-Jun-07 23:05

DataSet is found in System.Data namespace so you import that namespace.

Best Regards,
M. J. Jaya Chitra

matjame3-Jun-07 23:26

read a XML file store on another system

3-Jun-07 23:26

Don worry.Its working 100%.

Thanx for your time and help.Thanx very very much

kagiso

devesh_code3-Jun-07 22:16

devesh_code

3-Jun-07 22:16

Hello

I want to read a XML file that is store on another system.
Reply me asap.

Thanks

Devesh Mishra

N a v a n e e t h3-Jun-07 22:23

N a v a n e e t h

3-Jun-07 22:23

give that machines path and read.. What is the problem here ?

Navaneeth
My Website

devesh_code3-Jun-07 22:30

devesh_code

3-Jun-07 22:30

Thanks for ur reply.
If you can provide me the exact syntax, then it'll be much helpful for me...

Is it necessary that file should be shared in this case ???
If yes, then programmatically how to make that file shared ???

Thanks

Devesh Mishra

Christian Graus3-Jun-07 22:43

Christian Graus

3-Jun-07 22:43

Wow. You want to know if a file needs to be shared before you can read it, and you want to know how to write code to force a file on another machine to be shared ?

Is someone paying you to write this code ?

Sandeep Akhare3-Jun-07 22:26

Sandeep Akhare

3-Jun-07 22:26

devesh_code wrote:
Reply me asap.

What does it mean ? Confused | :confused:

You should have reading permission to access that file

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

How to abandon paging of crystalreportviewer

blackjack21503-Jun-07 22:48

blackjack2150

3-Jun-07 22:48

Sandeep Akhare wrote:
devesh_code wrote:
Reply me asap.

What does it mean ?

It means "As Soon As Possible".

www.acronymfinder.com [^]

renhe3-Jun-07 21:04

renhe

3-Jun-07 21:04

Using the windows version crystal report, I want to show data without paging. While in ASP.NET,we can set the property of the crystal report viewer as "allow paging=false"; but in windows programs, the crystal report viewer does not provide such a property, how to fulfil such a function by coding.

Thanks, a lot. Smile | :)

Dependancy between methods of a class

KKrista3-Jun-07 20:50

KKrista

3-Jun-07 20:50

Hi All,
Can anyone suggest me a tool that will display the dependancy between methods of a class. That is, which method calls which other method of the class.

Thanks in advance,
Murali

Christian Graus3-Jun-07 21:03

Christian Graus

3-Jun-07 21:03

Isn't there something on the standard right click menu which does that, for the method selected ?

KKrista3-Jun-07 21:11

KKrista

3-Jun-07 21:11

Hi Chris,
U r right.. We can view the references of the methods on right click of them.

However I am in need of a tool that will take a class as input and give me the interdependancy of methods as the output.

Could u please suggest me on that?

Thanks in advance,
Murali

Expert Coming3-Jun-07 21:22

3-Jun-07 21:22

How about you write a program that does it?

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Expert Coming3-Jun-07 21:08

3-Jun-07 21:08

I think Visual Studio has something called an Outline that will show all that. Not sure, I am almost sure there is something built into Visual Studio though.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

blackjack21503-Jun-07 21:29

blackjack2150

3-Jun-07 21:29

It's the "Find all references" thing.

Expert Coming3-Jun-07 21:34

How To Get Activate Event And Fire some Code

3-Jun-07 21:34

Yes, that is one way to do it. I remember something that allowed you to see all the things you referenced, and then where all you did so.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Pankaj - Joshi3-Jun-07 20:42

Pankaj - Joshi

3-Jun-07 20:42

Sir,
I am from VB6 background and new to C#.
I am making a desktop application using the C#.

I have two windows forms say Winfrm1 and Winfrm2.

on Winfrm1 i have a command button named Button1 and also a grid which holds the customer names from the database.
when i click onto the button1, Winfrm2 form shows in modal manner i.e. showDialogue.
On Winfrm2, I fill the data and save it, when i close the Winfrm2 I want to see the newely added customer on
Winfrm1's grid ...
for that i call the fillgrid method on Winfrm1's activated, enter event but unable to get desirable output
when click to the any control on Winfrm1 then enter event is called and this makes me in trouble .

In vb 6 activate event calls whenever form got focus for this what i should do in C#....?

Confused | :confused:

Pankaj Joshi

Re: How To Get Activate Event And Fire some Code

Expert Coming3-Jun-07 21:10