How You Check Data In DataSet?
-
Hello, I have a SQL query,and i want to check if i get a information from the query,BUT not to show the result for user. I'm using on DataSet/DataTable. Someone know how i do that? thanks.
-
If the dataset has tables with rows, then your query returned some values from database. You can check this right after you execute the SQL command.
जय हिंद
-
Like This? That not work.
int CheckValue=da.Fill(ds); if (CheckValue ==0) { cb1.Checked = false; } else { cb1.Checked = true; }Wow. Read the documentation instead of wildly guessing. You can call ExecuteNonQuery if you wrote your own SQL code, and if your SQL returns a single result.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
-
Wow. Read the documentation instead of wildly guessing. You can call ExecuteNonQuery if you wrote your own SQL code, and if your SQL returns a single result.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
-
Wow. Read the documentation instead of wildly guessing. You can call ExecuteNonQuery if you wrote your own SQL code, and if your SQL returns a single result.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
You saw that reply? He cannot read the docs. How possibly can you deal with an idiot of this order?! Morons like this are the reason why I asked Chris to appoint a moderator or two for each forum. I've voted to remove his message. I'll remember never ever to attempt to help him.
It is a crappy thing, but it's life -^ Carlo Pallini
-
You saw that reply? He cannot read the docs. How possibly can you deal with an idiot of this order?! Morons like this are the reason why I asked Chris to appoint a moderator or two for each forum. I've voted to remove his message. I'll remember never ever to attempt to help him.
It is a crappy thing, but it's life -^ Carlo Pallini
<sarcasm> With respects sir, he clearly said "cant not", which is a double negative. That clearly means he can. Some people... </sarcasm>
Check out the CodeProject forum Guidelines[^] The original soapbox 1.0 is back![^]