Re: Get many values in a variable from database. - C# Discussion Boards

22-Feb-07 23:35

I have a function to display a popup in a form:

taskbarNotifier1.Show("HostName: \n\n SiteHit: \n\n Survey: \n\n TAF: \n\n ATO: ", strQuery, 300, 2000, 300);

Now these hostname,survey,taf,ato i have to get from database :

strQuery = "select url,sitehit,survey,tellafriend,addtooutlook from tblsummary where datetime = now";
i.e. the last/current entry of database and store all these data in string 'strQuery' and call this variable 'strQuery' in above function taskbarNotifier1.Show in different lines ie one after other like this :
|------------------------------------
| Hostname : nekshan@yahoo.com |
|
| Sitehit : 1
|
| Survey : 0
|
| tellafriend : 1
|_______________________________|

These in bold are data to be displayed by the query.
How to get all this data in one variable to put it in my function n display data in this format.
Can i get many fields from a record of a table and store it in a variable or i have to use some other way.
i dont know whether i can get many fields from a record of a table and store it in a variable.
Hope to get some response.
thank you
nekshan.

Hope u r getting my Point.
Thanx
nekshan.

Harini N K22-Feb-07 23:57

Harini N K

22-Feb-07 23:57

Hi,

1. For concatenating Strings, use StringBuilder. Append data in a
StringBuilder variable.

2. For retrieve data from the database.
a.Connect to database
b.Fill data in Dataset using SQL Adapter or ExecuteDataSet.
c.Save this result in a Dataset variable. (Assume variable as 'ds')

3. To get value of each column --->
ds.Tables[0].Rows[0]["url"].ToString() and so on for other columns..

4. Append those values in a StringBuilder variable.

5. Use that variable in this line
(Note : Replace strQuery -> StringBuilder variable)

taskbarNotifier1.Show("HostName: \n\n SiteHit: \n\n Survey: \n\n TAF: \n\n ATO: ", SB, 300, 2000, 300);

Hope this is what you wanted.

-Harini

virendra patel23-Feb-07 1:11

23-Feb-07 1:11

i have soln but if u know how to create stored procedure then i send u ok. reply me u know or not.

Nekshan25-Feb-07 19:32

25-Feb-07 19:32

Without stored procedure the solution won't work or what?
No, I donno how to create storedprocedures. But i'll learn. Is it too complex or hard to learn?
Today i m not feeling well, so i may work on it 2mrw, but u can send i'll study it, just explain in a bit detail.
Thanx n Regards
Nekshan.

virendra patel25-Feb-07 19:49

25-Feb-07 19:49

' I ALLREADY SENT U THIS ANSWER WITHOUT STORED PROCEDURE IN ONE QUESTION REPLAY SO REFERE IT.OK.BYE.TC.

Nekshan25-Feb-07 20:00

25-Feb-07 20:00

hi!!
Function can only return one value so if u want all three then u have to concat all in one variable like
str = str1 + "#" + str2 + "#" + str3 then return str from function
now on form u've to seperate all 3 from str by using mid(str,"#",1) like dis not exactly dis function is.
u have to seperate like this all in different variable then use it.

U r talking abt this answer?
Y do i separate it using 'mid(str,"#",1)' on form? -- bcoz i have to display it one by one in a line?

virendra patel25-Feb-07 20:04

25-Feb-07 20:04

' no i sent 1 fun which return dataset so use any variable directly as u like i think in prev question of this.on saturday.

virendra patel25-Feb-07 21:19

25-Feb-07 21:19

U GET IN or i will send the code to seperate value from string. replay me.

Nekshan25-Feb-07 21:27

25-Feb-07 21:27

I m not feeling well 2day, so i m going.
I'll surely test it 2mrw.
Thanx yar.
Sorry! tari jode bou mehnat karau chu.
Aje bau weaknes lageche.so...
Bye
thanx
cu.tc.
nekshan.

virendra patel25-Feb-07 21:28

Recognize sounds from midi

25-Feb-07 21:28

ok bye.tc

Get all namespaces

iqueiroz22-Feb-07 23:15

iqueiroz

22-Feb-07 23:15

I writing a component designer and I need to get all Namespaces in my Solution, or all assemblys.
The keyword global have all namespaces, exists any method or property to get this list?

Thanks!

sharpiesharpie22-Feb-07 23:12

sharpiesharpie

22-Feb-07 23:12

how can i recognize the sounds from a midi file with C#? like, the frequency etc.? is there a way to do it?

Re: Recognize sounds from midi

Christian Graus23-Feb-07 0:00

Re: Recognize sounds from midi

23-Feb-07 0:00

C# has no MIDI support that I know of. DirectSound does. Given that a MIDI file is not a wave, you can surely get the pitch out of it, it's encoded in there. Your sound card decides what the notes sound like, the MIDI file contains their values and durations.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Leslie Sanford24-Feb-07 9:28

Leslie Sanford

24-Feb-07 9:28

sharpiesharpie wrote:
how can i recognize the sounds from a midi file with C#? like, the frequency etc.? is there a way to do it?

I have a MIDI toolkit[^] in C# that might help. There's a class in there somewhere for converting to and from frequencies based on the MIDI note. As far as recognizing sounds, most MIDI file tracks have a program change message at the beginning of the track to indicate which instrument to use.

Search binary string?

Monk11122-Feb-07 22:45

Monk111

22-Feb-07 22:45

I want to search a binary number and take a certain action whenever I come across a 1. How do I iterate through the binary number? Do I need to convert it into some kind of array first?

Thanks,

Monk

Re: Search binary string?

Stefan Troschuetz22-Feb-07 23:08

Stefan Troschuetz

22-Feb-07 23:08

Monk111 wrote:
How do I iterate through the binary number? Do I need to convert it into some kind of array first?

Of which data type is the binary number? [edit]Forget that question. Should have read the subject more thoroughly.[/edit] If it's a string, you can use simple array syntax to iterate over the single chars:

String binary = "00101011100";
for (int i = 0; i < binary.length; i++)
{
  if (binary[i] == '1')
  {
    // Take your certain action.
  }
}

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: Search binary string?

Christian Graus22-Feb-07 23:11

predifined array of structures in C#?

22-Feb-07 23:11

If it's a string, then use the search functions build in to the string class to find the index of the 1s.

If it's a number, then it's just a number, but you want to use it as a bit mask. Use the && operator. If x && 1 = true, then the first bit is set, x && 2 checks the second, x && 4, x && 8, etc.

bouli22-Feb-07 22:22

bouli

22-Feb-07 22:22

Hello gurus,

I'd like to know how is it possible to declare a predefined array of structure in C#?

The C declaration is like this:

typedef struct st_move_def {<br />
	int byte;<br />
	int bit;<br />
} MOVE_DEF ;<br />
<br />
static MOVE_DEF move_tab [8][8] = {<br />
	{ {5, 8}, {3, 4}, {7, 6}, {4, 7}, {6, 3}, {2, 8}, {1, 5}, {8, 3} },	/*1*/<br />
	{ {8, 4}, {4, 5}, {2, 4}, {7, 8}, {1, 3}, {6, 5}, {5, 1}, {3, 2} },	/*2*/<br />
	{ {4, 1}, {2, 2}, {3, 3}, {1, 7}, {5, 2}, {7, 7}, {8, 6}, {6, 6} },	/*3*/<br />
	{ {7, 5}, {5, 6}, {1, 4}, {8, 2}, {2, 7}, {6, 1}, {4, 8}, {3, 1} },	/*4*/<br />
	{ {8, 8}, {1, 6}, {2, 1}, {6, 7}, {4, 2}, {7, 1}, {3, 5}, {5, 4} },	/*5*/<br />
	{ {3, 7}, {5, 7}, {6, 2}, {1, 2}, {7, 3}, {2, 6}, {4, 6}, {8, 1} },	/*6*/<br />
	{ {6, 4}, {8, 5}, {7, 2}, {5, 3}, {1, 1}, {3, 8}, {2, 5}, {4, 4} },	/*7*/<br />
	{ {3, 6}, {4, 3}, {6, 8}, {2, 3}, {8, 7}, {1, 8}, {5, 5}, {7, 4} }	/*8*/<br />
};

and I need to translate it into C#.

How can I do this please?

Best regards.

Fred.

There is no spoon.

Christian Graus22-Feb-07 22:27

22-Feb-07 22:27

I think you need to do this:

{ new MOVE_DEF(5,8), new MOVE_DEF (7,6, etc

bouli22-Feb-07 22:45

bouli

22-Feb-07 22:45

Hi,

Thanks for your answer.

Is there a "static" way to initialize the members like in C/C++?

Best regards.

There is no spoon.

Christian Graus22-Feb-07 23:38

22-Feb-07 23:38

Not that I know of

bouli22-Feb-07 23:39

bouli

22-Feb-07 23:39

ok,
thanks.

I have done a class and made some "new" on it. it seems to work Smile | :)

Best regards.

There is no spoon.