Search results

  1. Y

    Error when committing the row to the original data store

    Dear All, I want to customize error msg of my own in place of the following. "Error when committing the row to the original data store" This error msg appears when we set DataColumn to AllowDbnull = False and try to update the DataTable with a null value. Any one has the solution to this...
  2. Y

    DataColumn Expression Serial No Generating

    Your code is so big in its clevernessss.... Thanks a lot cjard, The code is so small, But So big in its clevernesssssss... I wanted to give u some roses instead of this thumpsup. But unfortunately our forum does not have Roses ( emoticons) Special thanks for your explaination and video demo...
  3. Y

    DataColumn Expression Serial No Generating

    Thanks cjard, I have googled for it long before posting into the forum. But all I have found was related with Database (sql server , oracle....) and answered with identity column of sql server, sequence of oracle or Autonumber field of Access DB. not with my problem of TempDataTable. This...
  4. Y

    DataColumn Expression Serial No Generating

    Thanks for your reply cjard, This autonumber in my app. won't be sent to the server(or database) this datagrid and its autonumber is used just for display purpose only. once displayed and printed this tempdatatable will be disposed. This ItemNo column is just to identify to the user how many...
  5. Y

    DataColumn Expression Error with LookUp

    Thank you very much cjard, I will try to code it and post it if I succeeded for the benefit of others who use older version. thanks for your advise for upgrade. I will try my best to upgrade to VS2005 in near future.
  6. Y

    DataColumn Expression Error with LookUp

    Thank you very much cjard, My problem is not Concating two columns. the problem is LookUp with expression.(if I enter CustomerID into TempCustomer DataTable then CustomerName column is filled automatically with first & last name) So, there is no Lookup with DataColumn Expression? Or otherwise...
  7. Y

    DataColumn Expression Serial No Generating

    Yes, I hope cjard will give some of his valuable time for this problem.:D :confused:
  8. Y

    DataColumn Expression Error with LookUp

    Thank you very much cjard, So, I should use "IsNull" to Evaluate? I tried IsNull But it is not giving error or fetching data (I don't know whether my syntax is correct:confused:). How could we assign values from 1st DataTable into the Second DataTable Expression column? If anybody know the...
  9. Y

    DataColumn Expression Serial No Generating

    Thanks cjard, I have tried all options those I know to generate itemNo column to autoincrement. then I come up with this. Also I tried to put this into DataTable instead of putting into form directly as below but it does not update values as I add rows to the datatable. If you can figureout...
  10. Y

    DataColumn Expression Serial No Generating

    Thank you very much everybody. Now it is solved. Here I provide the code in order to help others who have similar problem. Private Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click Dim nrows As Integer = tblTempInvoice.Rows.Count Dim AutoNum(nrows...
  11. Y

    DataColumn Expression Serial No Generating

    Thank you very much JohnH & JuggaloBrotha, Now it is OK. I was stuck with this for more than a week.
  12. Y

    DataColumn Expression Error with LookUp

    Dear all, I have error " There is no row at position 0" at DataColumn Expression. Can any one help me please?? First Table :- Public Function GetCustomerDetail(ByVal CustomerID As String) As DataTable Dim techConnection As OleDbConnection = New OleDbConnection(strConn) Dim...
  13. Y

    DataColumn Expression Serial No Generating

    For Next Error. Dear All, I have following error in For Next statement. An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in system.windows.forms.dll Additional information: Specified argument was out of the range of valid values. Private Sub...
  14. Y

    DataColumn Expression Serial No Generating

    Thank you very much Arg81. Many of the methods in your code unavailable to me. I have tried all as here. but so far I have not succeeded. Can any one help me please???:confused: Private Sub dataGrid1_Navigate(ByVal sender As Object, ByVal ne As System.Windows.Forms.NavigateEventArgs)...
  15. Y

    DataColumn Expression Serial No Generating

    Thanks Arg81 I'm also using DataGrid only You are .Net 3.0. I'm using VS2003 and .Net 1.1 only. So some of commands (like "Me.grdRevision.MoveLast()" and "grdRevision.VisibleRows" ) in your syntax unavailable to me and I'm unable to use your code. I think DataColumn.Expression can do this...
  16. Y

    DataColumn Expression Serial No Generating

    Thank you very much cjard, Arg81, Sorry for misquoting. Actually sno is "ItemNo" DataTable has "ItemNo", "ProdId", "prodName" Columns and it is bound with a DataGrid. Now the "ItemNo" is Row Number ( Rowindex 0 is ItemNo 1, Rowindex 1 isItemNo 2, and so on. If we set "ItemNo" column to...
  17. Y

    DataColumn Expression Serial No Generating

    Autoincrement also won't work because if we click DG every time it will give a new number. if we delete a row it won't update 'sno' column bound with DG. any help pls.. Thanks in advance
  18. Y

    DataColumn Expression Serial No Generating

    Dear All, I have datatable with a Column as "Sno". This DataTable is bound with DataGrid Now I want to generate Row Numbers for 'Sno' DataColumn through expression Public Function Tempinvoice(ByVal DataTableName As String) As DataTable dt = New DataTable(DataTableName) Dim dcsno As...
  19. Y

    How can we get Sum of a column

    Thank you verymuch cjard, It is OK with this code:- dcnoNull.Expression = "IsNull(Amount, -1)"
  20. Y

    How can we get Sum of a column

    Thank you verymuch cjard, Now I changed the code as:- dc.Expression = "SUM(IIf(ISNULL(Amount), 0, (Amount)))" But I have error at the start of application as:- An unhandled exception of type 'System.Data.SyntaxErrorException' occurred in system.data.dll Additional information: Syntax...
Top Bottom