varbinary in datagridview, from data set

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
            da.Fill(DS)
 
            DataGridView1.DataSource = DS.Tables(0)
            DS.Dispose()
            cn.Close()

Open in new window

hainansyndromeAsked:
Who is Participating?
 
Bob LearnedConnect With a Mentor Commented:
I would think that you could do some query magic, like this:


        ' Add a reference to System.Configuration to the project.
        ' Add Imports System.Configuration at the top of the code module, to use System.Configuration.ConfigurationManager.
        ' Store the connection string in an app.config file:
        '    <?xml version="1.0" encoding="utf-8" ?>
        '    <configuration>
        '      <connectionStrings>
        '       <add name="MyDatabase" connectionString="Connection string goes here" />
        '      </connectionStrings>
        '    </configuration>
 
        Dim connectionString As String = ConfigurationManager.ConnectionStrings("MyDatabase").ConnectionString
        Dim commandText As String = String.Format("Select Field1, Field2, Case When BinaryField IS NOT NULL THEN 'Encrypted Password' ELSE '' END " & _
            "From security where officerid='{0}' " & _
                    " and pmrespersonid = '{0}' ", ComboBox1.SelectedValue.ToString(), TextBox2.Text)
        Using da As New SqlDataAdapter(commandText, connectionString)
 
            ' Create a single DataTable
            Dim dt As New DataTable()
 
            ' Fill the DataTable with the query data.
            da.Fill(dt)
 
            ' Bind the data to the grid.
            DataGridView1.DataSource = dt
        End Using
  

Open in new window

0
 
CodeCruiserCommented:
You can do that with this statement

iif(isdbnull(field), "", "Encrypt Password")

Now you need to write this code in an event so that this code executes for each row.
0
 
hainansyndromeAuthor Commented:
yes i had thought about editing the query problem is i want to show every field in the table and did not want to have to write each field


CodeCruiser

can you give me an example of what you man to use that
i am not sure where to place it
before i write the dataset to a databridview?
0
 
hainansyndromeAuthor Commented:
works like a champ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.