Recent content by dec21st

  1. D

    Duplicating Row in a Dataset

    i'm having problem trying to copy a row from a dataset table and inserting it back on the same table. the reason why i'm doing this is to paste the new row and edit 2 columns. i tried using dataset.clone .copy .merge and to no avail, i've given up. using these method disallow me to copy because...
  2. D

    Error when Generating Typed Dataset

    anyone can help me?
  3. D

    Error when Generating Typed Dataset

    "Custom tool error: Unable to convert input xml file content to a DataSet. The same table (table_name) cannot be the child table in two nested relations." i'm trying to convert an .xsd file into a typed dataset this is the error message i got from it from wat i understand its because it...
  4. D

    problem with declaring tooltip at System.ComponentModel.IContainer

    Coding 1 Private components As System.ComponentModel.IContainer ' ' ' 'optRepaymtOpt1 ' Me.optRepaymtOpt1.BackColor = System.Drawing.Color.LightSteelBlue Me.optRepaymtOpt1.Checked = True Me.optRepaymtOpt1.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25...
  5. D

    setting radio box to transparent!

    i've tried changing it on the Form Load event i've even tried testing on the click event but all doesn't seem to work it doesn't invoke the event at all.. not too sure why
  6. D

    setting radio box to transparent!

    i've attached the img below as how the interface is --see attached jpeg before continuing. thanks i've tried setting my back color to transparent but it doesn't seem to work. The other labels (Year of Manufacture and etc.) are set to transparent and it seem to work out fine. i suspect it's...
  7. D

    get result from a few table with same fields

    say i have these few fields in these tables table:Rest fields i)id ii)name iii)contact iv)restaurant v)manager table:Mgmt fields i)id ii)name iii)contact iv)department v)manager table:Admin fields i)id ii)name iii)contact can i query to get one result showing id,name and contact from all...
  8. D

    dropDownMonth.DataTextFormatString: from integer to month

    dropDownMonth.DataTextField = "month" let's say the value i retrieve from the db is 2,3,4,5 what i want it to show in my text field is february, march, april, may instead of number can i change it? wat's the format string ? dropDownMonth.DataTextFormatString = ?????
  9. D

    sql problem: sum()

    thanks.. got it working edi
  10. D

    sql problem: sum()

    sorry but i don't quite see the connection from ur post with my question
  11. D

    sql problem: sum()

    i'm having a problem with my sql below SELECT sum((discounttype.percentage/100)*totalsales.subtotal) FROM totalsales INNER JOIN discounttype ON totalsales.discounttype = discounttype.discounttypeid WHERE totalsales.invno = 62 the discounttype.percentage is supplse to be 25 and the...
  12. D

    adding bulk of records into database

    anyone can help me in this?
  13. D

    adding bulk of records into database

    i have a piece of vb codes that i want to use it in vb.net //declare 2 recordset of different database while rs1.eof rs1.addnew rs1.fields("id1") = rs2.fields("id2") rs1.fields("abc1") = rs2.fields("abc2") rs1.fields("type") = "abc" rs2.movenext end while how do i do this using...
Top Bottom