Solved

varbinary in datagridview, from data set

Posted on 2009-05-10
4
888 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 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

18 Experts available now in Live!

Get 1:1 Help Now