|
I have a VB.Net windows app that retrieves data from 3 different tables. The SQL command uses a 3 table join. The results from the query is filled into a datatable and later populated into a combobox.
The SQL uses the values from a date field inside a text field, for example, 01-15-2005. So, each time I submit the subroutine it executes the SQL command and VB.Net code to retrieve the required data. The date field changes according to the user’s needs.
There’s no consistency when the error pops up.
The error message I’m getting when it executes, da.Fill(dataTable), “There’s no row at position 0”,. The information I’m on the stack track is as follow: Calling SQLDisconnect --- OleDB UnInitialize not called!!!
Connection Object destroyed
If I copy the sql into a sql query tool it does retrieve the required data according to the date field.
Here’s a sample of the subroutine:
cmdQueryINVOICE = _
"SELECT PAYITEM.TRANSACT_NUMBER, " _
& "PAYITEM.ACCOUNT_NUMBER, " _
& "PAYITEM.PAY_DATE, " _
& "LSEINVH.INVOICE_NUMBER " _
& "FROM LSEINVH, PAYITEM, TRANSHDR " _
& "WHERE " _
& " LSEINVH.INVOICE_NUMBER > '" & 75000 _
& "' AND LSEINVH.STATUS <> '" & sStatus _
& "' AND LSEINVH.INVOICE_NUMBER = TRANSHDR.INVOICE_NUMBER " _
& " AND PAYITEM.PAY_DATE > '" & InvoiceDates.StartDate _
& "' AND PAYITEM.PAY_DATE < '" & InvoiceDates.EndDate _
& "' AND PAYITEM.COMPANY = '" & sCompany _
& "' AND PAYITEM.TRANSACT_NUMBER = TRANSHDR.TRANS_NUMBER order by PAYITEM.PAY_DATE desc "
Dim sqlQuery As OleDbCommand = connDf.CreateCommand
Dim dtInvDate As New DataTable()
Dim iInvCnt, x As Integer
Dim sUnitQuery As String
Dim daInv As New OleDbDataAdapter()
Try
daInv = New OleDbDataAdapter(cmdQueryINVOICE, connDf)
daInv.Fill(dtInvDate)
Dim LoopRow As Data.DataRow
Dim test As String = dtInvDate.Rows.Item(0).ToString
For Each LoopRow In dtInvDate.Rows
cboInvoice.Items.Add(LoopRow.Item("INVOICE_NUMBER").ToString + " " + LoopRow.Item("PAY_DATE"))
Next
Catch e As Exception
Dim errMsg As String = e.Message
Finally
connDf.Close()
End Try
Thanks, any help would be grateful.
|
|
|
|
|
I don't know if this will make any difference, but you would be better off using the SQLDataAdaptor, SQLCommand and SQLConnection objects to access SQL. They work better.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
|
|
|
|
|
Thanks for your reply. I'll using OleDb is because I'm connecting to a dataflex table and not SQL Server. I did find a solution to the problem. Thanks again.
|
|
|
|
|
I assume connDF is valid somewhere else And you are not even using sqlQuery.
I believe that the table needs to be part of a dataset for the adapter to fill.
<br />
Dim ds As new DataSet<br />
Dim dt As DataTable<br />
dt.TableName="InvDate"<br />
ds.Tables.Add(dt)<br />
<br />
Dim connection as string = "Whatever your connection string"<br />
Dim conn As New OleDbConnection(connection)<br />
Dim adapter As New OleDbDataAdapter()<br />
adapter.SelectCommand = new OleDbCommand(CmdqueryInvoice, conn)<br />
adapter.Fill(ds.tables("InvDate"))<br />
<br />
Dim LoopRow As Data.DataRow<br />
<br />
For Each LoopRow In ds.tables("InvDate")Rows<br />
.....<br />
Next<br />
If that does not work look at how the dataadapter processes joins. It may be the adapter will create the joined tables in the dataset but it will not automatically set the primary keys for the relationship. You may need to create the table schemas in the dataset then fill it. too much trouble? return a datareader and create your own columns and insert the data. Or just loop thru the reader.
|
|
|
|
|
Thanks for your suggestion. I tried your recommendation, but I was getting the same results. I decided to set the date range higher in the sql query and placing the larger results into the dataset. It takes longer to load, but the overall results are much better. Thanks again for your suggestion.
|
|
|
|
|
Hi i am trying to create a new toolbar for IE to change proxies, i keep getting an error that says: "Attribute Specifier is not a complete Statement. Use a line continuation to apply the attribute to the following statement." this is my code:
<guid ("e08554f2-3571-45e5-9a18-13d4dfccdd61")=""> _
' Create new BandObject
<bandobject("ie proxy="" manager,="" cb:="" omar="" ",="" bandobjectstyle.horizontal,="" _
="" bandobjectstyle.explorertoolbar,="" helptext="IE Proxy Manager to change Proxies" )=""> _
how could i fix this?
|
|
|
|
|
You might want to post your question and make sure you check the box down at the bottom of the message window that says "Do not treat <'s as HTML tags".
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Why am i not able to create a word application from vb.net web forms.
I am adding a reference to Word Object Library 10.0
I am doing the following.
Dim objWord As New Word.Application
Dim objDoc As Word.Document
objDoc = objWord.Documents.Open("c:\aa\t.doc")
objWord.Visible = True
All it does is hangs at the open .it doesn't even throw an error message.
thanks for your help
|
|
|
|
|
Hi,
I am opening a word document in my vb.net webform.
when the user clicks on a link, it opens a new window with the document.
He edits that document and when closes the browser, it is showing a Save as dialog box. I want to suppress this and save it a default location i specify.
After that I wish to upload it to the server. The users don't want an additional step of upload. So i should be able to save the file somehow on the server behind the scenes
Please give me some clues.
Thanks
|
|
|
|
|
I have a listbox that is bound to a SQLDataAdapter-filled DataTable. I am using unbound textboxes to edit the data when a row is selected for editing, then using a SQLCommand to update the database and refreshing the datatable and listbox.
The problem I am experiencing is that the listbox will duplicate the displaymember of the following item for the item just edited. Clicking the entry correctly populates the textboxes, so the problem appears to be with the listbox itself.
To clarify:
When I first populate the listbox, it may show:
item1
item2
item3
item4
...
I click on item2, which populates a set of text boxes which I then edit and save via a SQLCommand. When the data and listbox are refreshed, the listbox will display:
item1
item3
item3
item4
...
Clicking the first 'item3' still populates the textboxes with the correct 'item2' information.
Does anyone have any idea what might be going on?
Thanks.
|
|
|
|
|
I have a program in which I have to round a decial to the tenth place, what would be the code to do this???
sir - thax - a - lot
|
|
|
|
|
|
Hi. I am creating a Master/Detail DataGrid page and have run into a problem that I just haven't been able to work through. I have successfully created the Master and Detail DataGrids and they display correctly, however, I need to be able to access Checkboxes that I have added to the Detail datagrid.
The layout is as follows. The page is for selecting Training classes that you would like to register for. The DataGrids are both populated using SQL queries and the data is pulled from an Access database. The Master datagrid contains the months for the training schedule. The Detail datagrid contains the schedule of classes. Next to each Class name in teh Detail DataGrid is a checkbox. The Datagrids are enclosed in a Form with a Register button at the bottom.
The user needs to be able to check the boxes of the classes they would like to take and click the Register button.
Now, I had the site working before I created the Master and Detail grids. It was originally one Datagrid. Clicking Register checks to see which checkboxes are checked using a For...Each loop and finding the checkbox controlls in the current DataGrid. It then populates a Datatable with the data from that row (Declared in a Public Property) and passes it to a second page using Server.Transfer to allow the user to enter registration information and confirm selected classes.
The problem came when I created the Detail datagrid. I can no longer iterate through the checkbox controls in the detail datagrid. I am receiving errors when trying to access the internal datagrid. Here is the error
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 112: Dim inDataGridItem As DataGridItem
Line 113: Dim chkClassSelect As System.Web.UI.WebControls.CheckBox
Line 114: Dim dgNestedSchedule As DataGrid = CType(oDataGridItem.FindControl("dgSchedule"), DataGrid)
I don't get the error until the Register button is actually clicked. The Detail Datagrid is being created using ITemplate from a UserControl file so it is being dynamically added to the first cell of the Master grid.
I have tried resolving in a number of different ways, including trying with and without casting. I am using the FindControls method to locate dgSchedule (the detail grid) within the current cell of dgClasses (the master grid displaying the months). But I still receive this error. How do I go about iterating through checkboxes in the nested grid?
Thanks,
Dustin Horne
|
|
|
|
|
I have developed a windows service application that I want to deploy on another machine. The machine does not have Visual Studio installed, it does have the framework redistributable installed. When I try to install the service I am receiving the following error: “Installutil” is not recognized as an internal or external command, operable program or batch file. How do I get the Installutil on the machine?
|
|
|
|
|
|
|
hai, 
 Everyone who know that sending the command from Server to Client to execute .exe file. thus, Client can perform installation! 
Thanks for ur reply!!! 
|
|
|
|
|
What server? What client? Are these applications you have written?
Or are you talking about just sending a call to the remote Windows workstation and telling it to run something? BTW: This is a HUGE security violation and unless the account your application is running under has Admin rights to the target machine, forget it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I am trying to insert items in VB List View control from VC++ dll using SendMessage API. its in the same process and even the handle of list view is proper. I am using this code.. but it does not insert the item ...
TCHAR msgString[512];
TCHAR tempString[128];
wsprintf(tempString, _TEXT(" MsgId: %03d "), message->buffer[8] );
_tcscpy(msgString, tempString );
_tcscat(msgString, _T("sadsadsdsad "));
LVITEMW LvItem;
LvItem.mask=LVIF_TEXT; // Text Style
LvItem.cchTextMax = 256; // Max size of test
LvItem.iItem=0; // choose item
LvItem.iSubItem=0; // Put in first coluom
LvItem.pszText=msgString; // Text to display (can be from a char variable) (Items)
SendMessage(hwndMsgRqst,LVM_INSERTITEM,0,(LPARAM)&LvItem); // Send info to the Listview
I am able to get the item count using LVM_GETITEMCOUNT
Any help is really appreciated
Jaffar
|
|
|
|
|
Your question has nothing to do with VB/VB.NET and would be better handled in the C++ Forum.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave Kreskowiak wrote:
Your question has nothing to do with VB/VB.NET and would be better handled in the C++ Forum.
Brilliant!
If you cannot get the ListView to work directly, you can do it indirectly.
This is sort of a hack, but the APIs are much simpler.
Create a textbox in your VB app - hidden of course. Send the information from the C++ DLL to the hidden textbox instead of trying to put it directly into the listview. The Textbox Change event will fire like it normally would. Then you can get the text out of the textbox and put it in your list view. Or cache it, have the C++ DLL send some special message to signal the last list item has been sent, then populate your listview all at once.
Either way, synchronization is not a problem. You can do it in a loop in your c++ DLL with no fear of losing items. SendMessage is a synchronous call and it will not return to the C++ dll until the VB textbox Change event fires, executes any code it calls and finally exits.
Good Luck,
Robert
|
|
|
|
|
And why are you telling me this? Tell the original poster!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Oh my. A thousand pardons for not placing my post exactly in the thread tree in the manner you required.
|
|
|
|
|
The point is that when you reply to the original poster, he/she gets an email that says you replied to their message. All you did was send me a message that you replied to his post. Reply to his message so that he can get a notification that you answered his question.
BTW: It's not me who required it...  May the fleas of a thousand camels infest your ... nevermind! 
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi All,
Currently I'm using mshmtl.HTMLdocument. What I'm currently working is update the page when I do a mouse rollover. Like when I go to the Table Definition on the webpage I should change the style of the border for that table. I was able to do that by saving the file to the temp and updating it.
Is there anyway to do this. Any help is really appreciated.
Pachhu
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
