|
Hello everybody. I am trying to retrive data from a Access Database containing two tables.
1) tblKeyword
2) tblArea
In tblKeyword there are two attributes: a) Keyword and b) AreaName
in tblArea there are couple including AreaName which is the connection between the two tables.
I am trying to use the following code:
========================================================================
Dim strConnection As String = OleDbConnection1.ConnectionString
Dim connect As New OleDbConnection(strConnection)
Dim test As String
Dim te As String
Dim SQLString As String
connect.Open()
te = cmbKeywords.Items(cmbKeywords.SelectedIndex)
On Error Resume Next
SQLString = "SELECT tblKeywords.Keyword, tblArea.AreaName, tblArea.StartDate, tblArea.JobNumber FROM tblKeywords INNER JOINT tblArea ON tblKeywords.AreaName = tblArea.AreaName WHERE tblKeyWords.Keyword =" & "'" & te & "'"
Dim cmd As New OleDbCommand(SQLString, connect)
Dim reader As OleDbDataReader = cmd.ExecuteReader()
While reader.Read()
txtAreaName.Text = reader.GetValue(1)
End While
========================================================================
The SQL command goes through OK but the reader.Read is causing an error. How can i retrive the data from that SQL. I am lost. 
I know that the GetValue gets a value from attributes in one table. But with the inner joint I need values from both tables.
Any help would be appreaciated. Thank you..
Still trying to find the way
|
|
|
|
|
Chaos Machine wrote:
The SQL command goes through OK
What you mean is that you are able to create the SqlCommand, however no validation is done on the provided SQL string provided at this point.
Chaos Machine wrote:
but the reader.Read is causing an error
At the point of opening the datareader, the SQL provided is executed, so any syntactical errors will be thrown here.
Chaos Machine wrote:
INNER JOINT
Now, if that were my mistake it would've been freidian 
Oh, and another pointer:
Chaos Machine wrote:
I know that the GetValue gets a value from attributes in one table. But with the inner joint I need values from both tables.
By doing an join, you are effectively creating one table (albeit a virtual table that doesnt exist in the DB). Your single table will have the columns you specify in the select list:
Chaos Machine wrote:
SELECT tblKeywords.Keyword, tblArea.AreaName, tblArea.StartDate, tblArea.JobNumber
Hope it helps.
|
|
|
|
|
Hello J4amieC,
thanks for replying. I am still at a loss of what to do. Can you please show me with a bit of code how I can retrive the informations that i have collect from the SQL command? I am trying from books and online info, but still nothing. Thank you for your help.
Still trying to find the way
|
|
|
|
|
OK,
my comment was that you had a error in your SQLString (you used INNER JOINT instead of INNER JOIN) it should read:
SQLString = "SELECT tblKeywords.Keyword, tblArea.AreaName, tblArea.StartDate, tblArea.JobNumber FROM tblKeywords INNER JOIN tblArea ON tblKeywords.AreaName = tblArea.AreaName WHERE tblKeyWords.Keyword ='" & te & "'"
Now when you execute this string you will have the following columns:
0: Keyword (from tblKeywords)
1: AreaName (from tblArea)
2: StartDate (from tblArea)
3: JobNumber (from tblArea)
so if you use:
reader.GetValue(0)
you will get the Keyword column.
|
|
|
|
|
Thank you J4amieC it worked!!! Thank you so much. Now i have to expand this so when i have two areas with the same keyword a list is populated. Hmmm lets see if i can do it!! LOL
Thank you again for your help...
Still trying to find the way
|
|
|
|
|
How can I get the handle of an app that doesn't have a form?
Pablo.ar
|
|
|
|
|
No window means no hWnd either. What are you trying to do?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm trying to make a screensaver... Wait, let me rephrase that: I swear I'm trying to make a screensaver.
With this program, you'll be able to set whatever program to run when the ssvr execs (using the Shell function) or whatever file, to be loaded by the system (using the ShellExecuteEx function, that needs an hWnd to execute).
So...
Pablo.ar
|
|
|
|
|
I still don't know why you need a hWnd to a window that doesn't exist. Why are you trying to get this?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Ok I got what you're looking for.
Try using a handle to another window that is actually availible.
I mean that i.e. use the GetForgroundWindow() API to get an availible handle and pass it to ShellExecute. Or you can use the handle to the Desktop window, etc.
Hope it helps.
|
|
|
|
|
The 'desktop window' is a great idea, I'll investigate if there is such a thing, or something similar (with a handle!) that I can use.
Thanks a lot, MohammadAmiry.
Pablo.ar
|
|
|
|
|
well i want my windowform to be invisible but i want to be-able too make it visible again. u can make a message box and all, but does anyone know how to make a icon appear in the |Start ToolBar|?
thank ya
|
|
|
|
|
Can you specify how you make it invisible?
Have you setted an icon to the form?
Also, consider investigating the .ShowInTaskBar property.
Best regards,
Pablo.ar
|
|
|
|
|
well it won't be really invisible just Minimized in the start tool bar, but in the tool bar the program will still fun until u open in from the tool bar and click stop.
Ex. say A instant messager, it still runs eeven though u x-ed it out. (runs in the start toolbar, until u click "signoff".
you see what i am saying?
|
|
|
|
|
Anyone know how to convert from an Icon file to a Cursor file?
Thanks,
Tim
|
|
|
|
|
There are lots of tools dwelling on the net.
I use Conware's IconArt[^] which is freeware  .
Cheers,
Pablo.ar
|
|
|
|
|
Dim Ico As Icon = My.Resources.NomeIcona
Me.Cursor = New Cursor(Ico.Handle)
|
|
|
|
|
I have a datagrid bound to a typed dataset. I can obtain the value of the cell by setting the data set to the row and field of the datagrid. i.e.
Form1.CaseLookUpFromGrid =
Caselookds1.tblCases(DataGrid1.CurrentCell.RowNumber).CaseNumber
The problem comes when the the sort function of the datagrid us used. The dataset is not sorted so the value returned is the value that was in the datagrid cell prior to the sort.
Is there a way to obtian the value of a cell in a datagrid? This seams like somthing that should be simple.
Nick
|
|
|
|
|
the problem is that once a sort is applied to the data view in the grid, the order of the grids view is out of sync with the order in the underlying data source. this is the intended behavior.
you need to use the CurrencyManager of the datasources binding context to get at the currently selected row.
e.g.
<code>Private Sub DisplayCurrentRow()
Dim cm as CurrencyManager = me.BindingContext(myDataSource.Table1)
Dim currentRow as DataRow = ctype(cm.Current, DataRowView).Row
me.DisplayRow(currentRow)
End Sub
</code>
the currency manager keeps track of which row is currently selected in the underlying datasource, regardless of how it's being displayed.
hope this helps.
-jim
|
|
|
|
|
I have an input property class I want to validate. Any part that fails the validation should trigger a function which will add the property class to an array of that class with a description of the error. The problem is that each time the description is updated the entire array is changed. Has anyone run into this issue before and how can it be fixed. Here is a sample of my code.
<br />
Friend Function LineCheck(ByVal LineIn As Line) As Line()<br />
Dim LineOut() As Line<br />
If LineIn.Field1 = "" Then LineOut = AddError(LineIn, "Field1 Blank", LineOut)<br />
If LineIn.Field2 = "" Then LineOut = AddError(LineIn, "Field2 Blank", LineOut)<br />
If LineIn.Field3 = "" Then LineOut = AddError(LineIn, "Field3 Blank", LineOut)<br />
If LineIn.Field4 = "" Then LineOut = AddError(LineIn, "Field4 Blank", LineOut)<br />
Return LineOut<br />
End Function<br />
<br />
Friend Function AddError(ByVal LineIn As Line, ByVal LineError As String, ByVal LineOut() As Line) As Line()<br />
Dim tmp As New Line<br />
tmp = LineIn<br />
tmp.LineError = LineError<br />
If Not LineOut Is Nothing Then ReDim Preserve LineOut(LineOut.Length) Else ReDim Preserve LineOut(0)<br />
LineOut(LineOut.Length - 1) = New Line<br />
LineOut(LineOut.Length - 1) = tmp<br />
Return LineOut<br />
End Function<br />
Thank you,
Jason W.
|
|
|
|
|
Uhhh... Why are you passing the LineOut array to the AddError function and AT THE SAME TIME using it to store a return from the very same function? You're AddError function should not be returning data to the same variable using two different methods at the same time.
I have no idea what your trying to do here, but this is approximately what your AddError might look like:
Friend Function LineCheck(ByVal LineIn As Line) As Line()
Dim LineOut() As Line
If LineIn.Field1 = "" Then AddError(LineIn, "Field1 Blank", LineOut)
If LineIn.Field2 = "" Then AddError(LineIn, "Field2 Blank", LineOut)
If LineIn.Field3 = "" Then AddError(LineIn, "Field3 Blank", LineOut)
If LineIn.Field4 = "" Then AddError(LineIn, "Field4 Blank", LineOut)
Return LineOut
End Function
Friend Sub AddError(ByVal LineIn As Line, ByVal LineError As String, ByRef LineOut() As Line)
Dim tmp As New Line
tmp = LineIn
tmp.LineError = LineError
If Not LineOut Is Nothing Then ReDim Preserve LineOut(LineOut.Length) Else ReDim Preserve LineOut(0)
LineOut(LineOut.Length - 1) = New Line
LineOut(LineOut.Length - 1) = tmp
End Sub
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have an application that reads a file out of a phone and has a large string of hex data. I convert that data to ascii using the CHR command and am able to make a jpeg file and view what the picture is.
The problem I am having is that on systems that use asian language packs, the CHR function is incorrectly converting my data I think due to DBCS.
What I am looking for is a way to convert the hex data string I have to ascii that is universal and system independant.
Any idea out there? Thanks very much.
Jim Theisen
|
|
|
|
|
Since your code is getting the hex data completely unencoded, you'll have to detect for the existance of double byte characters yourself. Then provide alternate conversion code to handle this situation.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi all,
I am trying to fix teh col width of my datagrid but I get an error
@ dbgrd.GridColumnStyles(0).Width = 50
The error Msg is :
An unhadled exception of type 'System.ArgumentOutOfRangeEception'
Occured in mscorlib.dll.
Addional Information: Index was out of range. Must be non negative and less than the size of the collection.
Code:
With ds.Tables("Ord1")
Dim iCount As Integer
Dim nRow As Data.DataRow
For iCount = 0 To .Rows.Count - 1
nRow = objDT.NewRow()
nRow(0) = CType(.Rows(iCount).Item(0), String)
nRow(1) = CType(.Rows(iCount).Item(1), String)
nRow(2) = CType(.Rows.Item(iCount).Item(2), Long)
objDT.Rows.Add(nRow)
Next
Dim dbgrd1 As DataGridTableStyle = New DataGridTableStyle()
dbGrid1.DataSource = objDT
dbGrid1.ReadOnly = True
Dim dbgrd As DataGridTableStyle = New DataGridTableStyle()
dbgrd.MappingName = "Ord1"
dbGrid1.TableStyles.Add(dbgrd)
dbgrd.GridColumnStyles(0).Width = 50
dbgrd.GridColumnStyles(1).Width = 500
dbgrd.GridColumnStyles(2).Width = 500
can some one help.
Tnx
|
|
|
|
|
hi paps,
you're not actually instantiating any GridColumnStyles in your code. you're just trying to set the width of empty array elements. (GridColumnStyles(0), GridColumnStyles(1), GridColumnStyles(2) etc.) this is the raeson for the exception.
you can try doing this with the vs.net designer as well. just look at the TableStyles property of the datagrid from the properties window. you can set this up so that it's created in the initialization routine of the form rather than manually writing the code for it. take advantage of the code generation module and save yourself a case of carpal tunnels syndrome. 
hope this helps.
-jim
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
