I am binding a dataset to a datagridview
in it there is a varbinary field which dsplays as a picture
if the field is null not problem but if It is not null then it crashed the datagrid
I want to edit teh dataset before i bind it,
if it is NULL then i want to show ""
if it is not null i want to just show"Encrypted Password"
I am ne to dotnet so I am relatively clueless where to start
where is what I have this far
Dim da As SqlDataAdapter = New SqlDataAdapter("Select * from security whereofficerid='" & ComboBox1.SelectedValue.ToString() & "'" & _
" and pmrespersonid = '" & TextBox2.Text & "'", cn)
Dim DS As DataSet = New DataSet
DataGridView1.DataSource = DS.Tables(0)