Search:
Type: Posts; User: coolwater
Search:
Search took 0.08 seconds.
-
Thanks for the reply. My dilema is my UnitPrice column (readonly) is dependent on the combobox column. Everytime the combobox selected value is changed the UnitPrice column is also updated. Somehow...
-
My GetOtherFeeAmount Code:
Private Function GetOtherFeeAmount(intSLID As Long, intSYID As Long, intSemesterID As Long) As Decimal
Using con As SqlConnection = New SqlConnection(CS)...
-
BTW: I edited my post above. I noticed I can add new rows with no errors. The error will only occur if I go back to a combobox and change the selection or cancel a new row.
-
Thanks for the reply. I got this error. Unable to cast object of type 'System.Int64' to type 'System.Data.DataRowView',
-
Need Help. I have a Datagridview that have the following columns.
ID
Products
Qty
UnitPrice
Total
-
I'm still lost. To my understanding to initialize a connectionstring is to open a connection. This is what I did.
'Set the query filter.
Using con As SqlConnection = New...
-
I modified the 'Set the query filter
'Set the query filter.
daChild.SelectCommand.Parameters.Add("@UserID", SqlDbType.BigInt, 8, "UserID")
...
-
Tnx for replying. I got this error: An SqlParameter with ParameterName 'UserID' is not contained by this SqlParameterCollection.
This is my GetDataSet Code:
Private Function GetDataSet()...
-
jmcilhinney tnx for replying. Hmmm my user transactions (tblUsers_OR) have a LastUpdate (datetime) and TStamp (timestamp) columns. I don't have a isActive column. I guess I'll go with the 1st...
-
I have two datagridviews (parentDatagridview and childDatagridView). The parentDatagridview datasource is Bindingsource1 and childDatagridview datasource is Bindingsource2. Thanks to jmcilhinney for...
-
-
@jmcilhinney I used your code above by using two datagridviews. It worked perfectly. Thanks.
Question: I would like to put a refresh button to see if there are changes in the child...
-
I also had the same error. I followed the MSDN tutorial to the letter. I got the solution when I read wes4dbt advice to open the rdlc file with the xml editor. In the xml editor I found the xml tag...
-
-
Hi jmcilhinney. tnx for replying.
BTW I'm using your code. It helped me a lot. Thank you very much.
I would like the transaction to rollback if errors are detected and commit if there are no...
-
How can I trap errors by using "Using Statement".
I would like to use System.Transactions namespace to commit (if no errors) and rollback transactions (if there are errors).
What is the best...
-
Thanks Kaliman79912 for the tutorial. Your help is greatly appreciated.
-
thanks kaliman79912. It took me awhile to get it to work.
My code:
Private Function FindItems(ByVal strSearchString As String) As Boolean
dgvDisbursements.SelectionMode =...
-
Again tnx Kaliman79912 for helping me out. I will try this later. Need to go to sleep (1:30 am).
-
Is there a way to search all columns and rows in a datagridview? My goal is to have a Search Textbox and Find button. User will enter search string in the textbox and press the find button to search....
-
Thanks kaliman79912 for pointing me the solution.
Updated code:
Dim isTrue As Boolean
If cboisCleared.SelectedIndex = 0 Then
For Each row As DataGridViewRow...
-
Thaks for replying Kaliman79912. Ok I think I got what you mean. I'll try that.
-
Those are comments. sorry
-
cboisCleared list items
0 = Uncleared
1 = Cleared
This is my code:
-
Tnx kaliman79912 for replying. I've updated my post above. What I meant was I want to loop to the datagridview and check if the checkbox column is true or false and update the database. Right now my...
-
I have this Datagridview that has a Checkbox column. I also have a button to update the database. What I want to accomplish is to loop all rows that has a checkbox column value will be submitted to...
-
Thanks IanRyder. I like your solution. It's better.
-
I got it. I read a solution from this link http://geekswithblogs.net/FrostRed/archive/2008/09/07/125001.aspx
-
Hello. Please bear with me I'm new to vb.net.
I have this datagridview problem.
Scenario:
My Database columns.
-isCleared (boolean)
-DateCleared (DateTime)
-
I got it. Stupid of me. I found the error. It's in my update storedproc. I failed to put the original ID parameter.
Original SP:
USE [SimpleAcctg]
GO
/****** Object: StoredProcedure...
-
I read this article http://www.kebabshopblues.co.uk/2007/03/24/datagridviewcomboboxcell-errors-in-visual-studio-2005/comment-page-1/. I have the exact problem. I followed the author's solution but...
-
Sorry for the late reply. Yes I have checked the size of the fields in my tables. Again it is weird my sqladapter commands are working. Insert, delete and update commands are successfully executed....
-
Yes the user simply go to any cell and edit the values. My DGV is bound to a datatable. To save the data is use sqladapter.update(table). Inserting and deleting data is not a problem. The editing...
-
The combobox is a lookup. User can only select from the list. User cannot add a new item on the combobox. Weird if I delete the row that I want to edit and then add a new row, I get no errors. But if...
-
I have a datagridview (bound to a DataTable) that has a combobox column (bound to bindingsource). Inserting data is not a problem. The problem occurs when I edit a row the datagridview throws an...
-
I think I got it. I removed the using statement on my myownSqlCommandBuilderCode sub. Thanks @jmcilhinney for the tutorials.
-
I 'm trying to duplicate the SQLCOMMANDBUILDER by creating my own insert, update, delete commands using storedprocedures. I'm stuck with this error on buttonSave_Click: sqladapter.Update(dtable)...
-
I'm sorry I'm quite slow. When will I call the sub InitialiseDataAdapter()? On Form Load?
-
Thanks for replying. I read your thread. Question: The code InitializeDataAdapter how can I implement this on a Datagridview? Sorry I'm new to .NET. How can I supply the parameters using datagridview...
-
I think I kinda found a solution: (But I really don't understand the side effects on the database side.) Since SQLCommandBuilder made the insert, update, delete commands for me, does it mean I no...
|
Click Here to Expand Forum to Full Width
|