Click here to Skip to main content

C#

Re: Get Data From OLEDBDataReader

pmarfleet7-Dec-07 3:49

7-Dec-07 3:49

Your query only returns 1 column. How can you reference a second column?

BTW, DataReader column indexers are zero-based. dr[2] actually returns the 3rd column.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Get Data From OLEDBDataReader

Dr. Emmett Brown7-Dec-07 3:57

Dr. Emmett Brown

7-Dec-07 3:57

Have you tried dr[1] ?
I don't remember how it was in C# but I think datareader's indexes begin in 0.

Hope it helps

rotter

Re: Get Data From OLEDBDataReader

tr_thorn8-Dec-07 2:53

8-Dec-07 2:53

i think i wrote something wrong.I dont mean to i want 2 Coloumn from data reader. I want SECOND Coloumn's data from data reader than write it with MessageBox.But i am getting an error like Data Type conflict.

how to use "bgcolor"?

Imran Adam7-Dec-07 3:24

7-Dec-07 3:24

Hi,

I have just switched from VS2003 to VS2008. I am using a repeater control on a web form.

When i try to personalise the control in HTML using
. I am getting a error for bgcolor!!

I think bgcolor has been superseded with something else? Can someone please tell me what i would need to do.....

Cheers

Smile | :)

Re: how to use "bgcolor"?

Ennis Ray Lynch, Jr.7-Dec-07 3:27

Ennis Ray Lynch, Jr.

7-Dec-07 3:27

It is replaced by background-color css attribute

Need a C# Consultant? I'm available.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Re: how to use "bgcolor"?

Imran Adam7-Dec-07 3:30

7-Dec-07 3:30

Thanks Ennis Ray Lynch, Jr.

how would i use a css attribute?

e.g. if i wanted to have a blue background on a field name. Id use something like bgcolor=blue.

How to you do that with a css attribute??

Cheers

Smile | :)

Re: how to use "bgcolor"?

Pete O'Hanlon7-Dec-07 3:46

7-Dec-07 3:46

style="background-color:blue;"

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: how to use "bgcolor"?

Imran Adam7-Dec-07 8:28

7-Dec-07 8:28

Thanks Pete!

Cheers

Smile | :)

Re: how to use "bgcolor"?

Skippums7-Dec-07 3:53

7-Dec-07 3:53

I usually go to http://www.w3schools.com/xhtml/default.asp[^] when I need a reference for any sort of website useful languages. They also have very usable tutorials for things like perl, javascript, css, etc. Hope this helps you in the future!

-Jeff

Re: how to use "bgcolor"?

Imran Adam7-Dec-07 8:28

7-Dec-07 8:28

thanks!

Cheers

Smile | :)

query check field which has a _

eyeseetee7-Dec-07 2:57

7-Dec-07 2:57

Hi How can i run a query which will check that there is _ in the field name?

cheers

Re: query check field which has a _

Imran Adam7-Dec-07 3:27

7-Dec-07 3:27

You could try and use the IsPunctuation method to check for a '_'.

Cheers

Smile | :)

Re: query check field which has a _

pmarfleet7-Dec-07 3:40

7-Dec-07 3:40

hustler2005 wrote:
You could try and use the IsPunctuation method to check for a '_'.

How does that answer the question Confused | :confused:

Confused | :confused:

Read my response[^].

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: query check field which has a _

pmarfleet7-Dec-07 3:31

7-Dec-07 3:31

Read the documentation[^] under the section 'Using Wildcards as Literals'.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: query check field which has a _

eyeseetee7-Dec-07 3:37

7-Dec-07 3:37

hi
i need it to work when running it in c# e.g.
string test0002 = "Select room_code from room_types where room_code like '_'";

but this doesnt work it seems to only look for a field called _ not containing this character??
any suggestions?
cheers

Re: query check field which has a _

pmarfleet7-Dec-07 3:44

7-Dec-07 3:44

Did you read the documentation under the section I mentioned?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Windows Service Application

Chandan_Kr7-Dec-07 2:31

7-Dec-07 2:31

Hi,

I want to create a Reminder application (windows application using C#.net)which need to be started as soon as system gets boot up. To acheive this task I need to use windows service application but I think windows service application doesn't support GUI application So can any one plz help me out to find the solution.

My main requirement is:-
1. Application needs to be started as soon as computer started.
2. It should have a GUI.

If you know the solution then plz let me know ASAP.

Best Regards,
Chandan Kumar Gupta

Re: Windows Service Application

Pete O'Hanlon7-Dec-07 2:38

7-Dec-07 2:38

Chandan_Kr wrote:
I think windows service application doesn't support GUI application

It can. It's not good practice, but it can.

You could always put something in the startup folder to autostart.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: Windows Service Application

Matthew Butler7-Dec-07 2:42

7-Dec-07 2:42

I agree, you can get the path using this:

C#

Environment.GetFolderPath(Environment.SpecialFolder.Startup);

The first time you start the program (manually) you could make a shortcut to the application in this folder.

Matthew Butler

Member 30793837-Dec-07 2:17

7-Dec-07 2:17

I have a string as
loadplaylist "playlistname=xyz";instancename=abc"

I have written regex as
[^\p{Cc}\\r\\n\\a\\e\\b\\t][\S]*[a-zA-Z0-9\p{Po}\s\p{Sm}]*[^\p{Cc}\\r\\n\\a\\e\\b\\t]
which will remove tabs, backspaces.......and many more from the leading and trailing sides of string.

But, how I can remove the tab and backspace if it is in middle of string as

loadplaylist "playlistname=\txyz";instancename\b=abc" -----\t and \b are included which is to be removed.

Please do help........

Thanks & Regards
Kapil

Re: Regex problem

Matthew Butler7-Dec-07 2:29

7-Dec-07 2:29

I've never used Regex before...

However why not use:

C#

string s = "  some thing  ";
s = s.Replace(" ", "");
s = s.Replace("\t", "");
// ...etc

Is there any reason why you are using Regex?

Matthew Butler

Re: Regex problem

Skippums7-Dec-07 4:06

7-Dec-07 4:06

First of all, why are you matching the above characters instead of just using the \w (word characters) and \s (whitespace characters) character classes? It appears you are trying to do something like the following (with slightly more control)

myString = myString.Trim();

Second, if you really want to remove things in the middle, instead of a regex do the following:

myString = myString.Replace("\t", string.Empty);
myString = myString.Replace("\b", string.Empty);

-Jeff

Regex problem [modified]

t4ure4n7-Dec-07 1:42

7-Dec-07 1:42

I have a method which uses regex.... shown below

<b>string pattern = "(?<before>.*)(?<junk><table class="MyTable" cellspacing="2" cellpadding="1" width="144" border="0">.*</table>)(?<after>.*)";
string matchEvaluator = "${before} ${after}";
try
{
local_string = Regex.Replace(local_source, pattern, matchEvaluator);
}
catch (Exception er)
{
string g = er.Message;
}

string wr = HTMLWriter.htmlWriter.WriteHTMLFile(@"C:\trimExtras.html",
local_string);</after></junk></before></b>

I want to remove certain part of html page with this regex
the problem is it does not work... it takes a long time i.e hangs the app and when i write it to html file its still the same i.e does not replace any thing

<div class="ForumMod">modified on Friday, December 07, 2007 7:52:14 AM</div>

Re: Regex problem

J4amieC7-Dec-07 1:46

7-Dec-07 1:46

Question: A curiosity, doubt, or statement inquiring about something.

Did you forget something?

query displaying data

eyeseetee7-Dec-07 1:32

7-Dec-07 1:32

string test0002 = "Select room_code from room_types where room_code = '" + room_code + "'";

int max2;
SqlCommand cmd17 = new SqlCommand();
cmd17.Connection = con2;
cmd17.CommandText = test0002;
max2 = (int)cmd17.ExecuteNonQuery();
lbtest1.Text = max2.ToString();

hey is there a problem with the code above as its not displaying the data it is meant to, is there another way t display data from a query quickly/
cheers

General News Suggestion Question Bug Answer Joke Praise Rant Admin

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