Re: iterate over datagrid - C# Discussion Boards

22-Jul-04 15:26

I have a datagrid with this structure:
Column1 Column2 Column3
Name URL FilePathtoSaveTo

There are 1000 rows in the grid and I want to use the url (Column2) in an httpwebrequest and httpwebresponse to get web pages and then use the FilePathtoSaveTo (Column3) to write the web page to disk.

Anyone know of a foreach loop (or some other way) that will allow me to do this (return the cell values from columns 2 and 3 in order to be used as variables for my web request and write?)

Thanks,

Paul

(Also, the urls return text files that when saved with the .html extension, open as html files.)

Roman Rodov22-Jul-04 15:40

Roman Rodov

22-Jul-04 15:40

Well WHAT is your data source for the Grid? You need to iterate over your data source, NOT the data grid

kloepper22-Jul-04 15:55

22-Jul-04 15:55

Sorry, it is a dataset.

The main point is that I want to take a record

then assign the value from that row, column2 to the variable that contains the url

and then assign the value from that same row and column3 to the variable that will hold the pathname.filename to save as.

I just haven't figured out exactly how to do it yet.

(I've actually got to run now, but I'll be back later tonight)

Thanks,

Paul

Colin Angus Mackay23-Jul-04 0:22

Colin Angus Mackay

23-Jul-04 0:22

Something like this:

DataTable table = theDataSet.Tables[0];
foreach(Row aRow in table.Rows)
{
    string Url = aRow[1];
    string SavePath = aRow[2];
}

You can also use the name of the column instead of the ordinal position.

Does this help?

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

kloepper23-Jul-04 4:28

23-Jul-04 4:28

Roman Doug and Colin

Thanks to all of you.

This is very cool and it works great.

Thanks for pointing me in the right direction.

Paul Big Grin | :-D

DougW4822-Jul-04 15:41

DougW48

22-Jul-04 15:41

bool keepGoing = true;<br />
for (int rowNum = 0; keepGoing; rowNum++)<br />
{<br />
try<br />
{<br />
/*<br />
Do Stuff with dataGrid[rowNum][2] and dataGrid[rowNum][3]<br />
*/<br />
}<br />
catch<br />
{<br />
keepGoing=false;<br />
}<br />
}

This will probably work, but I don't particularly like it...if you have a dataset with the information, you might want to iterate through that instead of the grid itself.

- D

kloepper22-Jul-04 16:00

22-Jul-04 16:00

So I simply designate the cell by iterating over the rows and then designating the column like this dataGrid[rowNum][2]?

That simple?

I'm using a dataset.

Thanks,

Paul

(I've got to go now...be back later tonight.)

Multiple icons compiled within an .exe

DougW4822-Jul-04 16:09

DougW48

22-Jul-04 16:09

Actually, I messed the syntax up. You can get the value of a cell with:

dataGrid[rowNum, colNum]

I agree with the other post about using the dataset instead of the grid...but if you have to, you can use the grid. Keep in mind that if you use the datagrid instead of the dataset, you will have to find a way of counting the rows. This is why I used the try/catch block of stopping the loop in my example. I'm sure there are better ways...I'm just too lazy tonight to look anything up. Also, if you use the datagrid, you may have to check the values you get from the cells to make sure they are usable. If the grid is editable, you'll (almost) always have that extra row at the bottom that will have nothing, but you'll still be able to return the value from those cells.

Good luck!

- D

cdengler22-Jul-04 14:58

cdengler

22-Jul-04 14:58

I have a C# application. This C# application also has file types associated with it (in my case, the extenion is .drb). I want to have a DIFFERENT icon compiled within my .exe that these file extensions use, however, I cannot figure out HOW to add additional icons to be compiled within my application for use by these extensions?

Am I making sense?

Re: Multiple icons compiled within an .exe

Roman Rodov22-Jul-04 15:42

Roman Rodov

22-Jul-04 15:42

Add an icon file to your project, select the file in Solution Explorer and now in the Properties pane change the Compile property to "Embedded Resource".

After that follow standard procedure for adding file associations/icons.

Re: Multiple icons compiled within an .exe

Heath Stewart23-Jul-04 5:41

Heath Stewart

23-Jul-04 5:41

That won't work. Embedded Resources != Win32 resources. The icons have to be accessible to Win32. Embedded resources are not.

See my reply to the poster if you want to know more information.

Microsoft MVP, Visual C#
My Articles

Re: Multiple icons compiled within an .exe

Heath Stewart23-Jul-04 5:49

Heath Stewart

23-Jul-04 5:49

The other reply wouldn't work. Embedded resources are stored differently than Win32 resources (in C/C++, these would be referenced in the .rc file).

There are many ways you can do this. You can use the command-line compiler (csc.exe) and specify the /win32res: switch along with the path to a .res file that contains your win32 resources. In Visual Studio 2005, you will be able to specify this in the environment, which wasn't available in Visual Studio .NET 2002 and 2003.

You can also - after compiling - open the executable (.EXE or .DLL) in Visual Studio. That will show you your resource section. You can import icons and other resources types into the PE/COFF executable (the executable format on Windows).

If you sign your assemblies (and there's no reason not to - it's easy), you should resign them to make sure the hash is correct (shouldn't be a problem, but follow along anyway). Use sn.exe -R MyApp.exe KeyPair.snk, where MyApp.exe is the assembly to be signed (of course) and KeyPair.snk is the path to the key pair you used to sign the assembly in the first place. Usually it's a good idea to enable delayed signing (using the AssemblyDelaySignAttribute) and sign it later anyway, and if you use Authenticode to sign the assembly (the PE/COFF executable, actually) then you'll definitely need to resign it after modifying it (or just don't sign it before modifying it anyway).

Again, Visual Studio 2005 will include this functionality into the IDE, which will be nice.

Alternatively, you might consider just using a native resource-only DLL with the icons you want. Create a new (unmanaged) C or C++ DLL project, add your resources (icons, bitmaps, AVIs, etc.), compile and distribute. The only problem with this approach is that Fusion (the assembly binder which can work seemlessly over the Internet) won't grab it - it only works with .NET assemblies. With installation deployments or (presumably) ClickOnce - a new touchless deployment in .NET 2.0 - this won't be a problem.

Microsoft MVP, Visual C#
My Articles

Exporting Crystal Reports to Excel

KSEI22-Jul-04 14:27

KSEI

22-Jul-04 14:27

Hi,

I want to export a report created with Crystal Reports 9 to Excel format with this condition :

I want to split the exported file into 5 files. First file for page 1 - 10, second for page 11 - 20, and so on.
What i want to know is, how can i set the number of pages exported without user interaction (by clicking export button in crystalreportviewer)?
Thanks for the help.

Searching for opponents, what do I need?

Link260022-Jul-04 13:04

22-Jul-04 13:04

I'm thinking of writing a game in C# that have a "searching for
opponents" feature, like the internet checker included in Windows XP.

What do I need to do that? Since I'm directing searching for an opponent on the internet, so I don't think I need to have a server, do I?

Okay, but how?

TalkingBabb0t22-Jul-04 16:13

TalkingBabb0t

22-Jul-04 16:13

you *could* be cheap and use the IRC protocol to make the clients go to a secluded room on a popular server, and from that point inside the room, communicate using a proprietary protocol. However, I don't think the admins of that server would smile down too kindly on you.

Dave Kreskowiak22-Jul-04 16:33

Dave Kreskowiak

22-Jul-04 16:33

In other words, yes, you need your own server to do this. How can you search the Internet for opponenets when there are some 4 BILLION addresses to look at? You need to have some central place that each game can register itself at so you can easily contact other players. That's how all the off-the-shelf games do it.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Link260022-Jul-04 16:45

22-Jul-04 16:45

Okay, my idea is very similar to an instant messenger -- Do I
need a server for the instant messenger to work? So, if I do need
it, how do I do that? What technology should I use? SQL server?
or IRC protocol? but how to enable it?

Sorry for my stupid question........

Thanks

Dave Kreskowiak22-Jul-04 16:53

Dave Kreskowiak

22-Jul-04 16:53

I would HIGHLY suggest picking up a book on remoting before you even attempt this. Otherwise your just wasting your time. For a game project like this, on a smaller scale, you don't have to use SQL server for anything. The server app can store all the session data it needs in memory.

The protocol is something you define. What does an IRC protocol know about your game? Nothing! So you have to write the rules of communication and what you want to communicate. That's the definition of a protocol...

You could use TCP/IP Sockets, .NET Remoting, WebServices, ... Like I said, pick up a book on these thing first. The best book is one YOU can understand, not the next guy on the board who's got 20 years of programming experience can could flip through the same book and in 20 minutes and call it "read".

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Link260022-Jul-04 16:58

22-Jul-04 16:58

I'm feeling so sad.......

but thank you for your reply.

Colin Angus Mackay22-Jul-04 23:56

Colin Angus Mackay

22-Jul-04 23:56

Alex Ngai wrote:
I'm feeling so sad

Why? Because you have to read a book on the subject? Because it is more challenging than you imagined?

Your bio says your a computer science major (excuse my lack of understanding on the US education system here) but doesn't that mean you are still at university? Surely you should be used to reading books. If I've misinterpreted and it means you've recently graduated then you have to realise that learning and educating yourself will not stop... EVER!

On the area of it being more challenging that you imagined then just think about what leanring the area will make of you. Imagine how much your overall understanding will improve. Think of all the extra employment opportunities that open to you when you can demonstrate knowledge in this area.

I hope this encourages you to continue with your project because I think once you understand how these technologies work you will probably find it isn't so hard.

Link260023-Jul-04 7:13

23-Jul-04 7:13

I'm feeling sad is because I need another computer
in order to do a multi-player feature in my game.
Since I don't have the money to buy another computer
for the server, that means I won't be able to do
what I wanted to do.

Yes, I'm still in University, and reading books is
part of my daily life. And because I'm still in
University, that means I'm poor.....err, yea!!

But thanks anyway, I think I will focus on other
aspect, and I'm going to cancel the multi-player
feature. By the way, if you know a way to avoid
the use of server, let me know.

Thanks