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...
"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...
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
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...
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...
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 = ?????
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...
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...
hey, i have an idea here but i dunno how to put it into picture
i'm thinking of creating a WINFORM APPS to extrct files from my database in my local machine (msde) and transfer it to a remote server online (sql2000). so wat are the options i can use to do this?
what i've thought so far is...
hey, i have an idea here but i dunno how to put it into picture
i'm thinking of creating a webapplication to extrct files from my database in my local machine (msde) and transfer it to a remote server online (sql2000). so wat are the options i can use to do this?
what i've thought so far is...
neway got it fix...
using regex. here's the code
Imports System.Text.RegularExpressions
Dim regexEmail As Regex
IfNot regexEmail.IsMatch(txtEmail.Text, "\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*") Then
ErrorProvider.SetError(txtEmail, "Invalid Email!")
ReturnFalse
ExitFunction
EndIf
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.