C# Discussion Boards - CodeProject

First Prev Next

Re: How to display a column value from database to label [modified]

Prasanth MS29-May-09 21:56

Prasanth MS

29-May-09 21:56

Problem I traced is
1) The SQL Command is "INSERT" instead of select command. Insert Command insert data into tables and return the number of records inserted.

2) DataReader returns object. You have to convert the same into the data type you want eg. code
{
object obj = dr.read();
Convert.ToString(obj);
}

SO YOUR REQUIRED CODE SHALL BE LIKE FOLLOWS
----
SqlConnection con = new SqlConnection("server=AAB;database=ab;uid=sa;pwd=pass");
con.Open();

SqlCommand cmd = new SqlCommand("SELECT * FROM myTable", con);
SqlDataReader dr = cmd.ExecuteReader();

while (!dr.IsDbNull())
{
Object obj = dr.Read();
label1.Text= obj.ToSring();
}
dr.Close();

---

try and reply.

modified on Saturday, May 30, 2009 4:09 AM

Re: How to display a column value from database to label

Mads11529-May-09 22:28

Mads115

29-May-09 22:28

Thank you Prasanth it works Smile | :)

print job

hassannikoo29-May-09 21:13

hassannikoo

29-May-09 21:13

hi i want to code a project that can view all available printers (physical or not) or network printers and can show all print jobs and any information that can be show like number of copies users name printer name and .. i search for it but some cases the program info wrong information please help me any information can be helpful thanks a lot HN Smile | :)

Re: print job

I Believe In GOD30-May-09 5:26

I Believe In GOD

30-May-09 5:26

public static ArrayList EnumPrinters()<br />
        {<br />
            ArrayList ArrPrinters = new ArrayList();<br />
            ObjectQuery oQuery = new ObjectQuery("SELECT * FROM Win32_Printer");<br />
            ManagementObjectSearcher oSearcher = new ManagementObjectSearcher(oQuery);<br />
            ManagementObjectCollection oReturnCollection = oSearcher.Get();<br />
            foreach (ManagementObject oReturn in oReturnCollection)<br />
            {<br />
                if (oReturn["Name"] != null)<br />
                {<br />
                    ArrPrinters.Add(oReturn["Name"].ToString().Trim());<br />
                }<br />
            }<br />
            return ArrPrinters;<br />
        }

I know nothing , I know nothing ...

Image Encrypton

saadtahir29-May-09 21:01

saadtahir

29-May-09 21:01

hi ..
is there any way to encrpt a image n .docx file using c#
thnks

Re: Image Encrypton

Manas Bhardwaj29-May-09 23:33

Manas Bhardwaj

29-May-09 23:33

Here is an example for this on MSDN[^]

You could have saved a lot of time by using Google. Wink | ;)

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Image Encrypton

saadtahir30-May-09 18:56

saadtahir

30-May-09 18:56

yeah i m using google bt nt getting the rite stuff...

Re: Image Encrypton

Rajesh R Subramanian30-May-09 0:19

Rajesh R Subramanian

30-May-09 0:19

Encrypting the docx file as a whole does not look like an idea to you? (Unless of course you are willing to write your own app to display the encrypted docx file).

Search Google for C# AES.

It is a crappy thing, but it's life -^ Carlo Pallini

IPC

Hamed Musavi29-May-09 20:07

Hamed Musavi

29-May-09 20:07

Hi.

I have a windows service. I want to write an (C# .net) application that users run to communicate with the service. There is no restriction on .net version but security is important. What solution do you suggest?

I did a bit of research and found out named pipes and LRPC are good choices among other technologies. However it looks like in .net we'd better use WCF which, for IPC, supports named pipes. But WCF seems to have a steep learning curve. So I decided to ask you before I start to learn it.

Thank you very much for you help in advanced.

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Re: IPC

Nicholas Butler29-May-09 23:21

Nicholas Butler

29-May-09 23:21

I used WCF for exactly this purpose. There is a learning curve - mostly because of the number of configurable options exposed. I recommend "Programming WCF Services" by Juval Lowy - it's on Safari.

Nick

----------------------------------
Be excellent to each other Smile | :)

Re: IPC

Hamed Musavi29-May-09 23:32

Hamed Musavi

29-May-09 23:32

Nick Butler wrote:
I recommend "Programming WCF Services" by Juval Lowy

Thanks. I found it here[^].

Thank you so much for your great help. I'll start reading in a few minutes. Smile | :)

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Re: IPC

Hamed Musavi29-May-09 23:42

Hamed Musavi

29-May-09 23:42

By the way, How was the performance? Does it support only named pipes for IPC?

I think there must be these information in the book but I can't wait to know them! Sorry. Blush | :O

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Re: IPC

Nicholas Butler30-May-09 1:25

Nicholas Butler

30-May-09 1:25

Performance was fine. It supports everything from named pipes to https.

You need the ABCs: Address, Binding, Contract. You can mostly mix and match these - I think I used a tcp binding as I needed to support remote access.

Nick

----------------------------------
Be excellent to each other Smile | :)

Re: IPC

Hamed Musavi30-May-09 4:08

Hamed Musavi

30-May-09 4:08

Thank you so much Nick. Your help is really appreciated. And thank you again for the book recommendation. It's a nice book. I hope to be ready to code the communication part within a few weeks (or less maybe.)

Thanks for all the help. Rose | [Rose]

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Re: IPC

Hamed Musavi30-May-09 23:43

Hamed Musavi

30-May-09 23:43

Hi. I just wanted to thank you again for the book recommendation. What a nice book. I enjoy reading every line. Such books can't be found easily these days. It has been kind of you. Thank you very much. Smile | :)

"I hope you live a life you're proud of. If you find that you're not, I hope you have the strength to start all over again."
- I wish I knew who is this quote from

Re: IPC

Nicholas Butler30-May-09 23:45

Nicholas Butler

30-May-09 23:45

Thanks

Nick

----------------------------------
Be excellent to each other Smile | :)

Rajdeep.net, a new low

EliottA29-May-09 11:18

EliottA

29-May-09 11:18

Ok, utterly sick and tired of this, his latest stunt is to falsely claim to be an "MVP (Microsoft Corporation)".

Surely, many if not all of you must have had enough of him as I. So I sent an email to Chris, and would ask that you do the same. Typically, I wouldn't mind as much, his stupidity has become all but to common on the forum, but the claim to be MVP (Microsoft Corporation) combined with completely false and erroneous (and potentially damaging) "responses" to other users threads can't be ignored. He has suggested everything from editing the registry IIRC, along with uninstalling the .NET Framework altogether.

This is obviously something we wouldn't want this user to say to potentially serious beginners, especially under the false pretenses of being an MVP (Microsoft Corporation).

Check out the CodeProject forum Guidelines[^]

Re: Rajdeep.net, a new low

Anthony Mushrow29-May-09 15:43

Anthony Mushrow

29-May-09 15:43

Check out the sig "Always ready to be helped and be helped...." Nice.

Although I don't appreciate the extra topic in the forum about the guy. It's more than he deserves.
Truly, if you have a serious problem with a member of the forums you should just e-mail Chris. There's no need to make a spectacle of it.

Even if the person in question deserves it.

My current favourite word is: Delicious!

-SK Genius

Game Programming articles start -here[^]-

Re: Rajdeep.net, a new low

Rajesh R Subramanian30-May-09 0:05

Rajesh R Subramanian

30-May-09 0:05

I cannot believe he claimed something of that sort. For the love of God, I'm going to take this forward to the MVP lead of South Asia (this Rajdeep dimwit seems to be living in India). I'm taking this personally and see if I can have MS to rig his filthy arse legally.

It is a crappy thing, but it's life -^ Carlo Pallini

No you are wrong.....

dan!sh 30-May-09 2:33

dan!sh

30-May-09 2:33

Either he is too bad with geography or some multiple personality disorder problem.

Rajesh R Subramanian wrote:
this Rajdeep dimwit seems to be living in India)

Check my sig.

जय हिंद

Rajdeep.Net[^] is NOT from India. Proof.[^]

Re: No you are wrong.....

Rajesh R Subramanian30-May-09 21:56

Rajesh R Subramanian

30-May-09 21:56

Thank God for he isn't an Indian. Smile | :)

Bangladesh still comes under the South Asia MVP province and hence the South Asia MVP lead can do something better than the other MVP leads.

It is a crappy thing, but it's life -^ Carlo Pallini

Re: No you are wrong.....

Vikram A Punathambekar5-Jun-09 7:11

Vikram A Punathambekar

5-Jun-09 7:11

I am SO glad!

Cheers,
Vikram.

Recent activities:
TV series: Friends, season 6
Books: Freakonomics, by Steven Levitt and Stephen J Dubner.

Carpe Diem.

Re: Rajdeep.net, a new low

Vasudevan Deepak Kumar1-Jun-09 2:57

Vasudevan Deepak Kumar

1-Jun-09 2:57

And there he goes with a site TOS violation too:

http://www.codeproject.com/info/TermsOfUse.aspx[^]

Point number 12 (subpoint 26) which reads as "Impersonate any person, including an employee, contractor, forum leader, guide or host of The Code Project, or falsely state or otherwise misrepresent your affiliation with a person or entity.". I had to use the following editor http://www.dynamicdrive.com/dynamicindex16/richtexteditor/index.htm[^] to get the unordered bullets as bulleted list.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

Date check

Rajdeep.NET is BACK29-May-09 9:36

Rajdeep.NET is BACK

29-May-09 9:36

Hi Bros,

I have noticed in certain trial applications, that after a specific amount of use, the app. just fails to process requests any further since the trial period gets expired.

However, in my application, I want that if the date of executing the application is 15 /* just for instance */ then, something like this should happen:

//This is pseudo code. Got nothing to do with original C# code// Just for logic//

if (current.date=15)
{
//set of statements to be executed
}
else
{
//process task as usual
}

Any ideas how to do this in C#? Help will truly be appreciated! Smile | :)

Rajdeep Bhattacharjee,
MVP (Microsoft Corporation)
Always ready to be helped and be helped....

Re: Date check

Manas Bhardwaj29-May-09 10:00

Manas Bhardwaj

29-May-09 10:00

If (DateTime.Now.Date == 15)
{
  //Do whatever you want to...
}

you need to execute this at the application startup.(i.e. the Main() method)

Rajdeep.NET is BACK wrote:
Rajdeep Bhattacharjee,
MVP (Microsoft Corporation)

Well, MVP is symbol of appreciation which is given to people for the expertise and community work.
Please do not degrade it. Its no fun. OMG | :OMG:

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Last Visit: 31-Dec-99 18:00 Last Update: 19-May-24 23:11

Refresh

ᐊ Prev 1...4977 4978 4979 498049814982 4983 4984 4985 4986 Next ᐅ

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