Search results for query: *

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...

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...

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...

is this possible? i want to delete a few record from a few tables i tried using these 2 statement but it can't seem to work on mssql2000 code 1 @item = 10 //this is the eg param sent in delete supplier, inventItem, quantity from supplier, inventItem, quantity where inventitem.supplier =...

hey, i need to know whether this is possible? say i create a stored procedure to send in this parameters -poid and i have 2 table to manipulate TABLE Restock has -po -item -qty TABLE Quantity has -id -qty i wanna select part of the restock select item from restock where po = @poid...

just like how it can be done in asp.net, can i use regular expression to validate a vb.net application? wat are the common or usual way to validate textbox?

Dim strSQL As String = "select inventItem.id as 'id', inventItem.name as 'name', inventItem.description as 'desc', restock.qty as 'qty', inventItem.priceQuantity as 'price', restock.qty*inventItem.priceQuantity as 'total' from inventItem inner join restock on inventItem.id = restock.item where...

say i have 2 form, form1 and form2. when i start the app, form1 will load. then when i click a button i want to send a value to form2 and open form2 but i don't want to close form1(it'll be at the back of form1). then when i close form2, i want to send another value to form1 and reload the form...

in asp.net when i wanna create a listbox with text n values i do it like this: Dim objCommand As New SqlCommand(sqlStatement, sqlConn) Dim objReader As SqlDataReader = Nothing sqlConn.Open() objReader = objCommand.ExecuteReader() Dim DS As DataSet Dim MyCommand As...

i have a problem here i'm not sure on how to show forms issue 1 if i use form.showdialog() me.close() the app will still be in my taskbar when i open a few forms... the program won't close properly issue 2 if i use form.show() me.hide() i will still have my files runnin in the...

say i want to extract a few rows from table 1 and insert it into table 2... how do i do it?? one method is to create an sql reader to extract data from table 1 then use stored proc to insert into table 2 i'm thinking of the performance whether will it lag when i execute the command one...

as mention above.. how do i validate a textbox to accept currency? i can't seem to find it to work .... i've seen ppl using instr and double.tryparse. can anyone be kind enough to explain wht those 2 thing does?

say i got a string with a value "12 (22)" i wanna seperate the 12 n 22 into two different integer variable. how do i do it? note that the integer's length on the string can be 1 or 2 e.g the string value can be "2 (22)" or "22 (2)"