Solved

varbinary in datagridview, from data set

Posted on 2009-05-10
4
893 Views
Last Modified: 2013-11-26
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

0
Comment
Question by:hainansyndrome
  • 2
4 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24353532
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
 
LVL 96

Accepted Solution

by:
Bob Learned earned 125 total points
ID: 24353552
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
 

Author Comment

by:hainansyndrome
ID: 24357667
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
 

Author Closing Comment

by:hainansyndrome
ID: 31579924
works like a champ
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now