C# Discussion Boards - CodeProject

Give name to table from stored procedure

16-Jan-04 19:22

You shouldn't be trying to display encrypted blocks in a TextBox - it's always binary until encoded in base64 or something else (base64 is most common, though).

See the ToBase64Transform and FromBase64Transform classes in the .NET base class library. The class documentation also includes a couple of good samples for how to use these two classes. You should then have no problems displaying cipher text.

Just as examples, consider PGP (http://www.pgp.com[^]): in order to send plain-text cipher text as email (it's primary use is for communications) it must be encoded. This is currently done using base64. Or when you sign-up for an SSL certificate your request must be sent using a base64 encoded public key.

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----

laphijia16-Jan-04 8:29

laphijia

16-Jan-04 8:29

I've built a fairly complex stored procedure that has a couple of selects in it that are only functional while I'm only interested in reading the resultset from the last select.

Now when I fill my dataset, apart from retrieving useless data from the database, I have to acess my data doing something like ds.Tables[2].Rows

I have thought of two possible solutions even though I don't know how to implement any of them.

1. Have the stored procedure return only the last recordset. If this is possible I'm missing some T-SQL command. Anybody on this?

2. Give a name to the table that I'm interested in reading so that I could access it disregarding it's index like ds.Tables["MyRecordset"].Rows
This is much more elegant than accessing with numeric index bacause if I change the stored procedure I don't have to change my code.
Anyway how does one give a name to a table from a stored procedure?

Thanks

Edd

Re: Give name to table from stored procedure

Rocky Moore16-Jan-04 8:44

Rocky Moore

16-Jan-04 8:44

If you are using a DataAdapter to fill you dataset you can always create a strong typed dataset which allows you to access the data as:

myDs.MyTableName[row].MyField;

or

dsMyStrongType.MyStrongTypeRow dr = myDs.MyTableName[row];
dr.MyField = something

Makes life a lot easier and less apt to have typos on field names (plus you get Intellesense). Just build your DataAdapter in the editor and the right click on it to generate a dataset. If your stored procedure returns multiple results it will build a table by name for each. You can also select the table mapping property to call the tables anything you like.

Really cool stuff.

Rocky <><
www.HintsAndTips.com

Re: Give name to table from stored procedure

Guillermo Rivero16-Jan-04 12:51

Guillermo Rivero

16-Jan-04 12:51

Add an output parameter to the stored procedure and send the Table using it.

Send me the query.

Free your mind...

Re: Give name to table from stored procedure

Heath Stewart16-Jan-04 19:18

Re: Learned something new..

16-Jan-04 19:18

When using DataSets, try designing a strongly-typed DataSet by using the DataSet designer in VS.NET (there are other ways and tools, too, but I present the way in VS.NET). Right-click on your project or subfolder and select Add New Item. Find DataSet, give it a name, and click OK.

You'll see a component designer screen. Right-click to add elements (tables) and each element has rows and their types (the columns). You can even add relationships and primary keys. Just play around with it a little.

You can even use the Server Explorer if you have a database connection to drag-n-drop tables or stored procedures which returns tables to generate these automatically.

When you fill the strongly-typed DataSet, your DbDataAdapter derivative (like SqlDataAdapter) has to be configured to map the tables. This is done through DbDataAdapter.TableMappings and can easily be configured by using the data adapter designer in VS.NET as well.

Finally, you don't even need to use strongly-typed if you use the TableMappings property mentioned above. When selecting multiple result sets, the sequence of table names is "Table", "Table1", "Table2", etc. If you map these to other names, you can use DataSet.Tables["nameOfTable"].

I recommend using strongly-typed DataSets, though. You can easily refer to columns by name and don't have to worry about casting since those named rows return the appropriate Type.

Learned something new..

Rocky Moore16-Jan-04 8:14

Rocky Moore

16-Jan-04 8:14

I must have just skipped by it, but when I was checking out the 'switch' keyword, I noticed that C# has a "goto case" fucntionality inside of a switch block to go to another case statement. Not that I would have a need for it often, but if I do it is there Wink | ;)

Funny thing is though, since moving to .NET I seldom use switch. Just have not had a lot of need for it.

Rocky <><
www.HintsAndTips.com

Mazdak16-Jan-04 8:22

Mazdak

16-Jan-04 8:22

I didn't know it too. Smile | :)

Mazy

No sig. available now.

Re: Learned something new..

leppie16-Jan-04 9:01

leppie

16-Jan-04 9:01

You can get quite complex with goto and <name>: labels as long as they in scope Smile | :)

leppie ::AllocCPArticle("Zee blog");
Seen on my Campus BBS: Linux is free...coz no-one wants to pay for it.

How to test Microphone,

Shahin7716-Jan-04 6:57

Shahin77

16-Jan-04 6:57

Hi everybody,

Im looking for a code snippet about how can create a small program, something like that one which exist in the msn chat program for testing microphone(Ahdio/Video tuning wizard).

Any help's appreciated. Confused | :confused:

Hauptman(n)16-Jan-04 7:25

Hauptman(n)

16-Jan-04 7:25

there is afaik no possibility to get acess to the audio hardware via the classes stored in the System Namespace

Anyway you should use nBass: http://nbass.sourceforge.net/

and the nBass DLL gives you a class called [i]record[/i]

scio me nihil scire
My OpenSource(zlib/libpng License) Engine:
http://sourceforge.net/projects/rendertech
Its incurable, its a Pentium division failure.

eggie516-Jan-04 11:39

eggie5

16-Jan-04 11:39

what is "afaik"?

/\ |_ E X E GG

Guillermo Rivero16-Jan-04 12:09

Guillermo Rivero

16-Jan-04 12:09

As
Far
As
I
Know

Smile | :)

Free your mind...

seting focus on a control

Hauptman(n)17-Jan-04 0:47

Hauptman(n)

17-Jan-04 0:47

as far as I know

scio me nihil scire
My OpenSource(zlib/libpng License) Engine:
http://sourceforge.net/projects/rendertech
Its incurable, its a Pentium division failure.

elena1234516-Jan-04 6:54

elena12345

16-Jan-04 6:54

how do you default the focus to be on a certain control when a dialog comes up?

the following line in the constructor is not doing it.
this.m_OkButton.Focus();

Elena

Re: seting focus on a control

Heath Stewart16-Jan-04 7:11

16-Jan-04 7:11

Set the TabIndex of the control you want to have initial focus to 0, adjusting the other controls with TabStop enabled. You can do this easily in VS.NET by click the View->Tab Order when a form is open in the designer.

The Focus method only works when a control (including a form) is already open.

.NET Bug or bad code ?

Guinness4Strength16-Jan-04 5:11

Guinness4Strength

16-Jan-04 5:11

Can anyone tell me why Adj get assigned the value of -1 in this code ?

string Line ="$ID\\SITE\\\\\\AG";<br />
			int Index =8;<br />
			int Adj = Line.LastIndexOf("\\\\",Index);

It LastIndexOf method works fine if I do not specify as start position, but even if the start position is 1 Adj gets assigned -1.

Daniel Turini16-Jan-04 5:20

Daniel Turini

16-Jan-04 5:20

Change the code for this and it'll be easier to understand:

string Line = @"$ID\SITE\\\AG";
//---------------------^ Position 8 = First '\'
int Index =8;
int Adj = Line.LastIndexOf(@"\\",Index);

What's happening is that each pair of '\' only really generates a single '\'.

Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier

By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn

Guinness4Strength16-Jan-04 5:29

Guinness4Strength

16-Jan-04 5:29

right but I'm search then searching for the last index of "\\\\" or \\, which should give me the value of 9 in adj right ?

string Line ="$ID\\SITE\\\\\\AG";
int Index =8;
int Adj = Line.LastIndexOf("\\\\",Index);

Heath Stewart16-Jan-04 5:42

16-Jan-04 5:42

But you're starting your backward search at character position 8, so 9 and higher isn't even evaluated. See my other post (which I must've been typing while Daniel posted his) for more information.

Heath Stewart16-Jan-04 5:38

16-Jan-04 5:38

By setting Index equal to 8, you're starting your backward search at index 8 and working backward, so there is no instance of @"\\". String.LastIndexOf - if provided a start index - will begin searching from there and search backward. See the documentation for String.LastIndexOf in the .NET Framework SDK for more details and pretty thorough example.