selecting one row from datagrid

[rcoco]

I want to select one Row from a datagrid so I create a
textBbox(txtnam e) and Button for the user to write the name in textBox
and By the click of the button it select the corresponding row. But
it's not selecting the row neighther I'm getting any mistake message
I'm I missng some thing? I wrote the code on Button_Click sqlCommand as
follows:
SqlCommand myCommand = new SqlCommand("SEL ECT * from employee where
fullname Like %+txtname+%" ,con);
Thank you.

[Rastko Soskic]

Well, I'm not quite sure if you made mistake when you wrote this post, but,
according to
what you wrote here, mistake is in string concatenation. You should write:
SqlCommand myCommand = new SqlCommand("SEL ECT * from employee where
fullname Like %" + txtname + "%" ,con); // Note opening and closing quotes

Furthermore, if txtname is id of textbox (and not the string) then you
should write txtname.Text
This much I could write, because you haven't supplied much info...

"rcoco" <nc******@yahoo .cawrote in message
news:11******** **************@ 77g2000hsv.goog legroups.com...

>I want to select one Row from a datagrid so I create a
textBbox(txtnam e) and Button for the user to write the name in textBox
and By the click of the button it select the corresponding row. But
it's not selecting the row neighther I'm getting any mistake message
I'm I missng some thing? I wrote the code on Button_Click sqlCommand as
follows:
SqlCommand myCommand = new SqlCommand("SEL ECT * from employee where
fullname Like %+txtname+%" ,con);
Thank you.

[rcoco]

Thanks,
the whole code actually goes like this as per now hope you could hlp
me:

try
{
con.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="SELECT * from employee where fullname Like
%"[e-mail] t+"%";
SqlDataAdapter myAdapter=new SqlDataAdapter( myCommand);
DataSet ds = new DataSet();
myAdapter.Fill( ds,"isp_email.s taff");
con.Open();
myCommand.Execu teNonQuery();
dgupdate.DataSo urce=ds;
dgupdate.DataBi nd();
con.Close();
}
catch(Exception err)
{
Console.WriteLi ne(err.Message) ;
}
finally
{
con.Close();
}
Thank you

[bpd]

I believe you just need to remove the @ in front of txtname.text.

rcoco wrote:

Thanks,
the whole code actually goes like this as per now hope you could hlp
me:

try
{
con.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="SELECT * from employee where fullname Like
%"[e-mail] t+"%";
SqlDataAdapter myAdapter=new SqlDataAdapter( myCommand);
DataSet ds = new DataSet();
myAdapter.Fill( ds,"isp_email.s taff");
con.Open();
myCommand.Execu teNonQuery();
dgupdate.DataSo urce=ds;
dgupdate.DataBi nd();
con.Close();
}
catch(Exception err)
{
Console.WriteLi ne(err.Message) ;
}
finally
{
con.Close();
}
Thank you

[Rastko Soskic]

Well, as bpd said, first you should remove @.
Then, after line: "myAdapter.Fill ..." ...
there is no need to perform opening con, executing command and closing con
again,
(unless you are trying to do something else with that?)
adapter should do it for you, but there is nothing wrong if you are opening
and closing manually.

So, your try block should be something like this...
try
{
con.Open(); // Assuming that con object is properly created with correct
connection string
SqlCommand myCommand = new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="SELECT * from employee where fullname Like %" +
txtname.Text + "%";
SqlDataAdapter myAdapter=new SqlDataAdapter( myCommand);
DataSet ds = new DataSet();
myAdapter.Fill( ds,"isp_email.s taff");
con.Close();
dgupdate.DataSo urce=ds;
dgupdate.DataBi nd();
}

"bpd" <br*********@ro llcoater.comwro te in message
news:11******** **************@ i56g2000hsf.goo glegroups.com.. .

>I believe you just need to remove the @ in front of txtname.text.

rcoco wrote:

>Thanks,
the whole code actually goes like this as per now hope you could hlp
me:

try
{
con.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.Conn ection=con;
myCommand.Comm andText="SELECT * from employee where fullname Like
%"[e-mail] xt+"%";
SqlDataAdapt er myAdapter=new SqlDataAdapter( myCommand);
DataSet ds = new DataSet();
myAdapter.Fill (ds,"isp_email. staff");
con.Open();
myCommand.Exec uteNonQuery();
dgupdate.DataS ource=ds;
dgupdate.DataB ind();
con.Close();
}
catch(Exceptio n err)
{
Console.WriteL ine(err.Message );
}
finally
{
con.Close();
}
Thank you