Help with viewing binary image in sql DB with ASP.net RSS

• • Reply
  

  devananddhag...

  Member

  222 Points

  31 Posts

  Re: Help with viewing binary image in sql DB with ASP.net

  Nov 08, 2012 05:00 PM|LINK

  public DataTable GetData(string strQuery)
  {
  	DataTable dt = new DataTable();
  	string strConnString = System.Configuration.ConfigurationManager.ConnectionStrings("conString").ConnectionString;
  
  	SqlConnection con = new SqlConnection(strConnString);
  	SqlCommand cmd = new SqlCommand(strQuery, con);
  	SqlDataAdapter sda = new SqlDataAdapter();
  
  	cmd.CommandType = CommandType.Text;
  
  	try {
  		con.Open();
  		sda.SelectCommand = cmd;
  		sda.Fill(dt);
  	} catch (Exception ex) {
  		return dt;
  	} finally {
  		con.Close();
  		cmd.Dispose();
  		sda.Dispose();
  	}
  	return dt;
  }

  --
  
  Deva
  
  Please remember to click "Mark as Answer" on the post that helps you
  • Marked as answer by Angie xu - MSFT on Nov 11, 2012 10:56 PM