C# Discussion Boards - CodeProject

Get many values in a variable from database.

Nekshan22-Feb-07 23:35

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.

Re: Get many values in a variable from database.

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

Re: Get many values in a variable from database.

virendra patel23-Feb-07 1:11

virendra patel

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.

Re: Get many values in a variable from database.

Nekshan25-Feb-07 19:32

Nekshan

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.

Re: Get many values in a variable from database.

virendra patel25-Feb-07 19:49

virendra patel

25-Feb-07 19:49

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

Re: Get many values in a variable from database.

Nekshan25-Feb-07 20:00

Nekshan

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?

Re: Get many values in a variable from database.

virendra patel25-Feb-07 20:04

virendra patel

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.

Re: Get many values in a variable from database.

virendra patel25-Feb-07 21:19

virendra patel

25-Feb-07 21:19

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

Re: Get many values in a variable from database.

Nekshan25-Feb-07 21:27

Nekshan

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.

Re: Get many values in a variable from database.

virendra patel25-Feb-07 21:28

virendra patel

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!

Recognize sounds from midi

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

Christian Graus

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 )

Re: Recognize sounds from midi

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

Christian Graus

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.

predifined array of structures in C#?

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.

Re: predifined array of structures in C#?

Christian Graus22-Feb-07 22:27

Christian Graus

22-Feb-07 22:27

I think you need to do this:

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

Re: predifined array of structures in C#?

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.

Re: predifined array of structures in C#?

Christian Graus22-Feb-07 23:38

Christian Graus

22-Feb-07 23:38

Not that I know of

Re: predifined array of structures in C#?

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.

Re: predifined array of structures in C#?

Luc Pattyn23-Feb-07 10:13

Luc Pattyn

23-Feb-07 10:13

Hi,

you can have a "static constructor" containing code to initialize static members (including
const).

AFAIK you must be careful when a static constructor calls onto another class that also
has a static constructor, I think there is some unwanted behavior then. But it works well
in simple cases.

Smile | :)

Luc Pattyn

[My Articles]

Referencing a dll or ActiveX Control in .net

salon22-Feb-07 22:06

salon

22-Feb-07 22:06

I have to make an ActiveX control so tht I can use it in other applications.I referred following link

http://www.c-sharpcorner.com/UploadFile/dsandor/ActiveXInNet11102005040748AM/ActiveXInNet.aspx

Followed exactly same steps.
i made a class library and referenced its dll in another webform where i m using the members of
the class library through Javascript.but the members are not accessible in Javascript.i.e.

function doScript()
{
myControl1.UserText = Form1.txt.value;
}
in this javascript function the UserText member is not getting called.
What's the mistake i m making?

Re: Referencing a dll or ActiveX Control in .net

Christian Graus22-Feb-07 22:30

Christian Graus

22-Feb-07 22:30

If you have to use ActiveX ( for VB6 or something ), you should use C++. Using C# means you still need .NET, what's the point in that ?

Last Visit: 31-Dec-99 18:00 Last Update: 30-Apr-24 0:44

Refresh

ᐊ Prev 1...9822 9823 9824 982598269827 9828 9829 9830 9831 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.