Jump to content
Xtreme .Net Talk

Robby

Moderators
 View Profile  See their activity

  • Posts

    3848

  • Joined

  • Last visited

 Content Type 

Everything posted by Robby

  1. Robby
    Here's an example of a dynamic connection string... Dim strSQL As String = "SELECT * FROM SomeTable" Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" & Application.StartupPath & "\myDatabase.mdb") Dim cmd As New OleDbCommand(strSQL, cn) Dim da As New OleDbDataAdapter(cmd) Dim ds As New DataSet() da.Fill(ds, "SomeTable") With DataGrid1 .DataSource = ds.Tables(0) .Visible = True End With
  2. Robby
    What does your dynamic connection string look like?
  3. Robby
    Is this a rhetorical question, are you just making an observation?
  4. Robby
    You got it exactly.
  5. Robby
    Use a member boolean variable (form level) and and set it to true once the DG has been clicked for the first time. All this is because CurrentCellChanged and Click (or Enter) will all fire each time you click the grid, so you need to determine the very first time it's clicked.
  6. Robby
    You can use ... ComboBox1.SelectedText = "xxx" ' visible text 'or ComboBox1.SelectedValue = "xxx" 'item that bound it, usualy ID column
  7. Robby
    You can use the Enter or Click event of the DG to check for the first time you click it. You will need to set a flag to determine this.
  8. Robby
    Happy Birthday Nerseus We almost forgot. :D :eek: :D :eek:
  9. Robby
    yup
  10. Robby
    Initialize them to -1
  11. Robby
    Does custDS contain the corect table name?
  12. Robby
    Have you attempted the same thing without the 30 minute delay?
  13. Robby
    Fadi, that's exactly what Cassio has in his first post.
  14. Robby
    place this in the CurrentCellChanged event of the dg... dim myCellValue as string= CType(myDatagrid.Item(myDatagrid.CurrentRowIndex, 0), String) 0 is the column number
  15. Robby
    Nope.
  16. Robby
    Are you in Debug mode when this happens? Either way the first time you run a .NET app it is always slower.
  17. Robby
    Same if you start a new sentence in lower case.
  18. Robby
    Is it firing? If it is then do this dg.EditItemIndex = e.Item.ItemIndex OR DirectCast(source, DataGrid).EditItemIndex = e.Item.ItemIndex
  19. Robby
    It's supernatural!
  20. Robby
    Actualy it can be done.... You can even soft-code the table or column names if needed. declare @MyTop as int set @MyTop=20 declare @Sql varchar(1000) DECLARE @Crlf NCHAR(2) SET @Crlf = CHAR(13) + CHAR(10) set @Sql = 'BEGIN TRANSACTION' + @Crlf + 'select top ' + @MyTop + ' * from MyTable' + @Crlf + 'COMMIT TRANSACTION' + @Crlf Begin transaction exec (@Sql) commit transaction
  21. Robby
    If your process is in a loop you can place an Application.DoEvents, this will allow the cancel to be clicked, be careful because all the controls are clickeable during this time so you should disable them until the process completes. There are two ways of handling the above approach... 1) Set a flag before going into the function and check the status of the flag on each iteration. The cancel button would change flag status so the next time it loops you would be able to cancel. 2) Use Threading
  22. Robby
    It's cheaper to buy a new keyboard then paying to develop a silly program like that. :)
  23. Robby
    samsmithnz, the point of the link I provided was to show you that there is a known issue!
  24. Robby

    msgbox

    Robby replied to papa_k's topic in ASP.NET

    Tate, since this is in the ASP.NET section and everyone is suggesting options using Javascript, my bet is that MessageBox will not work.
  25. Robby
    you would have to remove the Like and the single quotes. sb.Append(dc.DataField + " = " + dc.FilterText )
×
×
  • Create New...