I've got to read a talbe that contains the following data into a datagrid:
What I'd like to do is read just the name of the job into the datagrid as opposed to the entire string such as:
How could this be done?
Public strConnection As String = ConfigurationSettings.AppSettings("ConnectionString")
Public objConnection As New SqlConnection(strConnection)
Public strSQL As String
strSQL = "Select Distinct JobEXE From JbExe"
Dim objCommand As New SqlCommand(strSQL, objConnection)
dgJobExe.DataSource = objCommand.ExecuteReader()