Please correct the this code

in your sqlcommand you write select something=anotherthing that is incorrect this is the reason of syntax error near the key work from!
you select one,or a group, or set alias to them but select x=y is totally wrong!

are you sure you are wanting to select i think you want to update data. if yes than write update query in place of select query.
like that

SqlCommand cmd = new SqlCommand("update other_source_income  set osi_int_from_bank='" + txtOSIInterstFromBank.Text + "' WHERE em_id=" + tb.Text + "", con);

if not than write like this

SqlCommand cmd = new SqlCommand("select osi_int_from_bank from other_source_income  WHERE em_id=" + tb.Text + "", con);

and in select command don't use cmd.ExecuteNonQuery()

Use SqlDataReader ....


<pre lang="cs">rdr = cmd.ExecuteReader();

SqlDataReader rdr = null;
lbFound.Items.Clear();
while(rdr.Read())
{
//your code here

}</pre>

also try this :

protected void btn_View_Click(object sender, EventArgs e)
{
TextBox tb = (TextBox)Master.FindControl("txtEmployee_code");
 
comm.Connection = con;
 
con.Open();
{
SqlDataAdapater ad = new SqlDataAdapter("select osi_int_from_bank=" + txtOSIInterstFromBank.Text + " from other_source_income WHERE em_id='" + tb.Text + "'", con);
Dataset ds=new Dataset();
ad.fill(ds); 

if(ds.Tables[0].rows.count!=0)
{
         //Do Something 
}
else
{
          // No Record Found
}


con.Close();
}
 

}

Hope this help You..