|
hi all,
i have problem that i m unable to use ExecuteNonQuery() and "EXISTS" of sql
i want to check in my table that the required row is exists or not
i used ExecuteNonQuery() but it always returns -1
codes
dataCommand.CommandText = "select * from tabel1 where id = '" + label1.Text + "'";
int check = dataCommand.ExecuteNonQuery();
if (check > 0)
{
MessageBox.Show("this is already exists");
return;
}
for temporary i m using SQLDataReader's HasRows bool
can someone have another best solution?
Becoming Programmer...
|
|
|
|
|
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT COUNT(*) FROM table1 WHERE id = @id";
cmd.Parameters.AddWithValue("@id", label1.Text);
cmd.Connection = myConnection;
int count = cmd.ExecuteScalar();
if (count > 0)
{
}
Please also note that the above uses a parameterised query thus reducing the posibility of a SQL Injection attack. You may also like to read SQL Injection Attacks and Tips on How To Prevent Them[^]
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
yeah it will work but why microsoft made "EXISTS" function in sql ...??
Becoming Programmer...
|
|
|
|
|
xmen_xwk wrote: yeah it will work but why microsoft made "EXISTS" function in sql ...??
So you can do this:
IF EXISTS (SELECT * FROM MyTable WHERE SomeColumn = @SomeValue)
BEGIN
-- Do stuff here based on whether any rows exist.
END
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
oh yeah, i tried this and in body i tried to return 0 or 1
but it gave errors, but now i have a good way that you told
thanks CAM
Becoming Programmer...
|
|
|
|
|
Hi All/Luc,
Is there a Big Integer package in C#? I don't want to jump through API hoops to do big math (nothing like the suffering of attaching an image list to a tree view ). Next, is there a Bas64 Encoder/Decoder available in C#?
I seem to be pulling lower quality suggestions from Google. So rather than jump into it, I'll wait for the advice.
Thanks,
Jeff
|
|
|
|
|
Hi Jeff/All,
1.
there are several big integer packages publicly available. Maybe the most acclaimed one is
GMP (GNU Multi-Precision). IIRC its written in C++, I haven't seen a .NET wrapper for it though.
And there are some articles on CodeProject[^] covering this (with different capabilities and
qualities). Much depends on what it is you want to achieve.
2.
Not sure what you mean, maybe Convert.FromBase64String() and its sibblings will help you.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use PRE tags to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Luc Pattyn wrote: And there are some articles on CodeProject[^]
I wrote the first article.... I'll get a port together to C#. Do you want to coauthor? I'll have problems with the Managed/Unmanaged thunk. (This is my third day on C#.)
Luc Pattyn wrote: Maybe the most acclaimed one is GMP (GNU Multi-Precision).
I'm a Crypto++ man myself. Years ago (circa 1998), I was never able to get a clean port of GMP to Windows.
Luc Pattyn wrote: Not sure what you mean, maybe Convert.FromBase64String()
Perhaps - I'll have to look at it.
Luc Pattyn wrote: Much depends on what it is you want to achieve.
This is going to be an article on Crypo++ interoperability with other Crypto Libraries and standards. The first article in this series is (somewhat out of order) is ASN.1 Object Identifier Encoding and Decoding[^]. It became such a large topic, it was spun off. In reality, it was supposed to be part of a Cryptographic Certificate Parser (*.CER, *.P7B, etc).
The TreeView is used for displaying results of the parser - the icons are a UI element aiding in vidualization of the message structure.
Jeff
|
|
|
|
|
Jeffrey Walton wrote: I'll get a port together to C#. Do you want to coauthor? I'll have problems with the Mnanaged/Unmanaged thunk
Hi Jeff, that's something we can look into. I'll send you an e-mail...
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use PRE tags to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Hi,when i run my project in C# it dosen't define ReportViewer1.BorderStyle="solid" code that i have wrote in my ReportForm.Cs source file.How can i write code like this with out using ReportViewer Toolbar before running the project to define my Report Page setup as like as Border Style seting ,page setup setting for example my papaer size to be A4 and margin setting and other properties of my Report without defining these properties at running time or design time only with writing code in source file in my report from ?
thanks
D.Riazi
-- modified at 8:40 Sunday 18th November, 2007
D.Riazi
|
|
|
|
|
Hi,
I am trying to run the exe file that was generated by vs.net in another computer, but it posts an error message and I can not run it. How can I do this please. Thanks.
Hawari
hawari
|
|
|
|
|
What is the error message?
My current favourite word is: PIE!
Good ol' pie, it's been a while.
|
|
|
|
|
Hi,
This is the error message "The application failed to initialize property (0xc0000135)". Thanks
hawari
hawari
|
|
|
|
|
That is the cryptic message Microsoft has designed to tell you you don't have
(the right version of) the .NET Framework. So decide which version you need,
look for the download site and install it.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use PRE tags to preserve formatting when showing multi-line code snippets
|
|
|
|
|
The Undefeated wrote: What is the error message?
Someone voted you a 3 for that perfectly reasonable, logical and understandable question. Someone is obviously a moron.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
lol, i want to know that person
Becoming Programmer...
|
|
|
|
|
xmen_xwk wrote: i want to know that person
Why would anybody want to know a moron?
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
because anybody must know that person and aware too
Becoming Programmer...
|
|
|
|
|
Simple way to run Exe is.
Process process = new Process();
process.StartInfo.FileName = "notepad.exe";
process.Start();
thats all i know.
Thanks
"Good Thing Goes With Good People..."
|
|
|
|
|
Well i was working on a very simple project , In windows application form1 i want set a password to modify, there are two buttons in the form which can be activated if user enters correct password.
Notice forms controls are: label, textbox1, button1 and button2.
who can send me code snippet for above would be great indeed!
thanks pls help me!!
so much of happy ending...
|
|
|
|
|
Have you made an attempt to solve the problem yourself?
This site is for people who want to learn, not for people who want their (home)work done for them.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi.
I have the follow:
1. System.Data.DataTable dt = new System.Data.DataTable();
2. dt = dal.Search(findfile.Text); // I receive the data correctly
3. dt.WriteXML(YourSearch);// I'm trying to create a xml file from the datatable
4. Response.TransmitFile(YourSearch);//download xml file
In the thirth row, when i run (compile ok) I receive
"Cannot serialize the DataTable. DataTable name is not set"
What that mean?
thanks.
|
|
|
|
|
It means what it says. Set the TableName property for your DataTable.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi, I'am have similar problem,but I resolved it
the trick is set the TableName between DataTable is transmited and DataTable is received have a same name
|
|
|
|
|
hi, i want to change system language (language bar) to second language(FA) while one of my textbox in the form has the focus.and again back to normal (EN) when going to next textbox.
so how can i do that?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
