Re: How to display a column value from database to label [modified] - C# Discussion Boards

Re: Receive emails using POP3

29-May-09 23:15

Yes, it's possible.

http://www.faqs.org/rfcs/rfc1939.html[^]

Nick

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

Mycroft Holmes30-May-09 0:11

Mycroft Holmes

30-May-09 0:11

Where do you get these things?

Category: Standards Track                                       May 1996

Never underestimate the power of human stupidity
RAH

How to display a column value from database to label

Mads11529-May-09 21:23

Mads115

29-May-09 21:23

HI
In my windows application i am creating a registration form..
after registration i want to display the register number in Label Cntrl from database(MSSQL2005)...
i tried this but not working

SqlConnection con = new SqlConnection("server=AAB;database=ab;uid=sa;pwd=pass");
con.Open();

SqlCommand cmd = new SqlCommand("insert into myTable values ('"+textBox1.Text+"') ", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
label1.Text= dr["id"].ToString();
}
dr.Close();

Thankx in advance

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

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

Nicholas Butler29-May-09 23:21

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 | :)

Hamed Musavi29-May-09 23:32

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

Hamed Musavi29-May-09 23:42

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

Nicholas Butler30-May-09 1:25

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 | :)

Hamed Musavi30-May-09 4:08

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

Hamed Musavi30-May-09 23:43

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

Nicholas Butler30-May-09 23:45