Search a database for a record (Visual Studio 2010)?

[SUPERMAN89]

Anyone know a simply way to just enter a name into a textbox and search a database for that name and return in a msgbox if that name is in the database. the internet and msdn just doesnt have what im looking for!

 

[iblade]

Pseudo code:

SQLCommand command = new SQLCommand("SELECT [Name] FROM

WHERE [Name] LIKE '%" & TextBox1.Text & "%'", new SQLConnection("SQL Connection String"));
SQLDataReader reader;
reader = command.ExecuteReader();

if (reader.HasRows()){ //Single Record
reader.Read();
MessageBox.Show(reader[0].ToString());
}

//Or records >= 1
While (reader.Read()){
MessageBox.Show(reader[0].ToString());
}

reader.Close();
reader.Dispose();
command.Dispose();

 

[SUPERMAN89]

THANK YOU!! So much!!got it to work with sql

 

[stevenv]

reader.Close();
reader.Dispose();
command.Dispose();

http://msdn.microsoft.com/en-us/library/yh598w02.aspx

 

[Fulmine]

YUK inline SQL Sucks

 

[FarligOpptreden]

http://msdn.microsoft.com/en-us/library/yh598w02.aspx

Hahaha! Thought exactly the same when I saw all those "Disposes"...

 

[iblade]

Sure, make use of using statement if you love try..catch..finally in your actual code. I don't therefore I don't use them.

Effectively I see this alot:

try{
using (...){
...
}
}catch (Exception ex){

}

effectively your code now read like this in the compiler
try{
try{
...
}
catch(){

}
finally{

}
}
}catch (Exception ex){

}

se excuse me for trying to optimise my Psuedo code.

 

[UnUnOctium]

Sure, make use of using statement if you love try..catch..finally in your actual code. I don't therefore I don't use them.

Effectively I see this alot:

try{
using (...){
...
}
}catch (Exception ex){

}

effectively your code now read like this in the compiler
try{
try{
...
}
catch(){

}
finally{

}
}
}catch (Exception ex){

}

se excuse me for trying to optimise my Psuedo code.

With you on that one. Also, as far as I remember, SqlCommand gets automatically disposed if you close SqlConnection.

 

[Raithlin]

I'm not sure I'm with you regarding the using statement.

http://www.w3enterprises.com/articles/using.aspx
http://geekswithblogs.net/BlackRabb...e-little-wonders-that-make-code-better-2.aspx (point 3)

Looks to me like the code is cleaner, easier to read, and quicker to type in - all the while having the same benefits as your pseudocode and more...

 

[stevenv]

@iblade: so can I interpret your reply as you promoting this:

try
{
  //Do
  //Dispose
}catch(...)
{
  //Handle
}

as opposed to

try
{
  //Do  
}
catch(...)
{
  //Handle
}
finally
{
  //Dispose
}

If so, in your scenario what happens to unmanaged resources when an exception is thrown in the "do" section?