Attachment 99251
Hello,Code:Dim sqlcmd As String = "StoredProcedure" Dim conn As New SqlConnection("ConnectionString") Dim find As New SqlCommand(sqlcmd, conn) find.CommandType = CommandType.StoredProcedure find.Parameters.Add("@id", SqlDbType.Int).Value = txtid.Text Dim da As New SqlDataAdapter(find) Dim ds As New DataSet Try conn.Open() da.Fill(ds) conn.Close() DataGridView1.DataSource = ds.Tables(0) DataGridView1.Columns(0).HeaderText = "Name" DataGridView1.Columns(1).HeaderText = "Status" Catch ex As Exception MsgBox("Error: " & Ex.Message, MsgBoxStyle.Information, "ERROR!") End Try
This example "Status" is "Bit" (True/False) and program shown in Checkbox but i wanna show only image.
Eg: True.bmp or False.gif
Thanks.




Reply With Quote