Search results

  1. black zero

    Question Why do I always get an error when VS 2005 and VB 6 are installed in one machine?

    Seems to me they don't agree with each others. Although I can just ignore the error notification, yet it's annoying. The error is saying something about Visual source safe whatever.... It doesn't show up when I have one uninstalled (be it 2005 or 6). What can I do to rectify the problem? Is...
  2. black zero

    Question Need help about Paramaterized query...

    Like.. I recently started to learn about it, having been using archaic sql syntax for a long time. Apologize too if this sub forum isn't the most appropriate place for this thread, kindly move it if it is. Firstly, I've reread this topic...
  3. black zero

    Question What's wrong with this formula?

    CrystalReportViewer1.SelectionFormula = "{solardata.transaction_date} >= CDateTime('" & Tgl_awal.Text & "') And {solardata.transaction_date} <= CDateTime('" & Tgl_akhir.Text & "')" Any pointer? EDIT: The error is as follow, sorry for pasting the wrong code... 'A Date time is required here...
  4. black zero

    Question How do I check for a string length?

    Here's my code: Private Sub CmbLabour1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles CmbLabour1.KeyPress If Char.IsDigit(e.KeyChar) = False And Char.IsControl(e.KeyChar) = False Then e.Handled = True End If...
  5. black zero

    Question How to print data listed on datagrid?

    http://www.vbdotnetforums.com/vb-net-general-discussion/31837-how-do-i-select-range-date-datagrid.html That link above contains my previous question, that's related to this one. Basically, after I finish selecting data on Datagrid, I want it to be printed, ALL data on a already processed...
  6. black zero

    Question Text box question... grrrrr~

    I have a 3 textboxes. If I write anything (example: char '1') on the first box, the char would appear on the third box. Then if I add char '2' on second textbox, the first char would appear at the first line on the third box, and char '2' would appear on the second line, below that '1'. I am...
  7. black zero

    Question CR select range of date?

    on Crystalreportviewer? This is my code, and is working good to display transactions on a certain date, that's picked on Tgl_awal (datepicker). However, I'd like to pick 'range of date' e/g 1 jan until 31 jan. Private Sub tampilkan_laporan_rate() CrystalReportViewer1.ReportSource =...
  8. black zero

    Question How to find INTEGER type column on a datagrid?

    Might be a little bit hard to explain, I have this code run on form load event: Try Module1.OpenCon2() da = New SqlDataAdapter("select * from kelancaran", Module1.xcon) da.Fill(ds, "edit") da.Dispose() For i As Integer = 0...
  9. black zero

    Question Why do I always need to log in again after certain time of inactivity?

    topic. Can't I stay logged in?
  10. black zero

    Question How do I select range of date from datagrid?

    Here's the scenario: I would like to select transaction id based from its creation date. All transactions are displayed on form load event on a datagrid. The select function should be executed on 2 datetimepicker (the first should be the start date, the last should be the end date). So there...
  11. black zero

    Question Syntax serror? (insert)

    cmd4 = New SqlCommand("insert into kelancaran " & _ "(no_transaction, transaction_date, ID_sopir, Nama_sopir, Shift, ATM_rp, " & _ " Kantor_rp, Dropping_rp, nama_details) values('" & labeltransaction.Text & "'," & _ " '" & datetimepckr.Text & "' , '" &...
  12. black zero

    Question Square, rectangular shapes and line control

    - There is no shape control in Visual Basic 2005. Square and rectangular shapes will be upgraded to labels, while ovals and circles cannot be upgraded. You should avoid using these in your applications. - There is no line control in Visual Basic 2005. Horizontal and vertical lines are upgraded...
  13. black zero

    Question How do I display the line number on code editor?

    topic. I just want to point and navigate on my code easily.
  14. black zero

    Question How do I parse value from one form to another?

    Here's the scenario: I have a table 'userdata' that contains 'username' and 'id'. I have a form called kelancaran1 and kelancaran2. The first form has a link to kelancaran2, kelancaran2's form load event will query all value from userdata to datagrid and display it for a user to pick. On a...
  15. black zero

    Question How to get last record from certain column from SQL Server?

    I have a code like this: Dim counter2 As Integer cmdT = New SqlCommand("select * from Kelancaran", con) drT = cmdT.ExecuteReader() Do While drT.Read tempcounter = Val(drT.Item(0)) Loop drT.Close() cmdT.Dispose() counter2 =...
Top Bottom