Search results for query: *

I am creating an employee database... this will be used by two different companies the first table is employee and second table is departments is it better to create a autonumber field as primary key and link it departments table or use the esixting employeeidid as primary key? if i use the...

how can i get the path from a string c="c:\prodcuts\newone\bestones\values.zip" i need to get hut the path from this "c:\prodcuts\newone\bestones\" is there a way to do this?

how can i find the size of file on the remote server .i am using ftpputfile in wininet.dll..please help urgent

I am using FTPPUtFILE and FTP_TRANSFER_TYPE_BINARY to upload the files...When i use put command on command prompt o manually upload fiels it gives me number of bytes tranferred..Is it possible to get number of bytes tranferred when using ftpputfile in my vb.net program. thanks

hi friends.. i am currently using command file arguments to upload files to a server manually..i would like to do it in vb.net program..please help C:\upload\>Ftp FTP> open <ipaddress> username:<username> password:<password> ftp>binary ftp> put <filename> <filename> --please let me know how i...

I have a folder called c:\input..i need to loop through this folder and get the anmes of all the files..note there are no sub folders in the input folder...please help. thanks

Hi, I need your help .I am trying to write a program to send a network message from my vb.net message..As i my program is running if the process is successful,i want to send console netwrok message to theconcerned person on network.Can anyone guide me in the right direction as how to do it.i...

I am using the below code for waiting for the process to finish before i get to next process Dim myProcess As Process = System.Diagnostics.Process.Start("main.exe") myProcess.WaitForExit() myProcess.Close() Dim myProcess1 As Process =...

Hi would appreciate if some one could help me with fatest way to search for a string "asf0798" in my text file data.dat and return a yes or no value(i.e the string exists or not..Some one please help with the fatest way to do this. thanks

hello, i am trying to write a program that calls many exe's I want to wait till one exe has finished executing and then go the next step.the order is very impotant as one exe loads the data nad next exe processes that data.So my questions is how can i wait till the process has competed and to to...

i have a table that have record numbers,but record numbers are zero i want to query that table,get all the records that have a record number as zero then look at thehighest rec number and start increamenting and give the next numbers to the records with recno as zero's.Any help will be...

i am trying to write zip code and state validation checks in a vb6 form.. here i found a script to do zip chekc but i guess its in a different language any help appreciated string REGEX_US_POSTCODE = @"\b[A-Z][A-Z]\s{1,4}\d{5,5}\s?\-?\s?(\d{4,4})?\b"; Regex rx = new...

I have a stored procedure and there have been some isuues recarginf the dates and i have to hordcode some dates ..can any one please let me know how i can accomplish times here is my stored proc.can i write a conditional if.. @startdate datetime @enddate datetime select number1,name from log...

i have stored procedure that enters the time stamp.but it getting the timestamp of i server blos when i inserted a record here it was 12:59 pm here and the the timestamp in the database shows 11:59pm.I am usinga stored procedure.what is the best way to fix this.i guess this is happening bcos of...

hello, I am trying to update update a crunk of data from one table to another.The table have same fields(names and types).I want to update the data in newtable with the data in old table for classid=24.how can i do this.please help

i have atble with three fields date1 amount of datetime and money 10/2/2006 11:00 am $4 10/3/2006 12:01 pm $5 10/2/2006 5:02 pm $6 10/5/2006 12:20 am $7 10/6/2006 12:01 pm $7 10/3/2006 9:00 am $3 10/2/2006 6:00 pm $9 now i want to count the number of days that have a...

hi, here is what i am trying to do that .I want to hide the text boxes and diaplay only when the page has finished loading(loading everything even java applet,My understanding is onload is called after everything is done). below is my code so far.. any help appreciated...

I need to write a regular expression in vb.net i have field whose vlue is stored in variable var1 i want to make sure that the value is in the format <text>.<text>ex:address.086 the regular expression must make sure that the value is in this format that is check that the first part is a...

i have stored orocedure select amount, desc,count(desc) as cnt from emp group by desc but some of the values in desc is null.. so i guess its not getting counted i am getting like amount desc cnt 1000 aaj 22 500 0 HOW CAN I COUNT THE NUMBER OF RECORDS WITH NULL THAT made up the...

I am using sql server 7 i have afield called input in the table getinfo, the "input field has data like 112e|wee|rer3 112e|wee|rer3 wede|weee|null null|null|null NULL null|wesa|dssew I want a help with writing a query all the first parts second parts and thrid parts for eg:first part should...