|
Where do you get these things?
Category: Standards Track May 1996
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Thank you Prasanth it works 
|
|
|
|
|
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
|
|
|
|
|
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 ...
|
|
|
|
|
hi ..
is there any way to encrpt a image n .docx file using c#
thnks
|
|
|
|
|
Here is an example for this on MSDN[^]
You could have saved a lot of time by using Google. 
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
yeah i m using google bt nt getting the rite stuff...
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 
|
|
|
|
|
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.
"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
|
|
|
|
|
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. 
"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
|
|
|
|
|
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
|
|
|
|
|
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]](https://www.codeproject.com/script/Forums/Images/rose.gif)
"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
|
|
|
|
|
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.
"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
|
|
|
|
|
Thanks
Nick
----------------------------------
Be excellent to each other
|
|
|
|
|
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 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[ ^]-
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Thank God for he isn't an Indian.
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
|
|
|
|
|
I am SO glad!
Cheers,
Vikram. Recent activities:
TV series: Friends, season 6
Books: Freakonomics, by Steven Levitt and Stephen J Dubner.
Carpe Diem.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
