Hi, I am recently using SQL for a project of my own. I came across this post and thought I might be able to offer some input. For example, in my team group is creating a database. There is a way to insert multiple rows into a table in SQL without having to insert them individually. You could formulate the data to be inserted as select statements for multiple list row entries, but I believe for this to be accomplished you may have to do two stages: 1)Put the data into a temporary table 2)Insert from that table. Live Support Software for Business April Comm100 - Leading Live Chat Software Provider

try if DirectCast(row.FindControl("Label1"), Textbox).Text is Nothing then 'Skip here End If Catch ex as exception 'It's Empty move to another control end try Hope this helps the idea is to check for a value before trying to use it.

i know my code sucks bcoz this is my 2nd time doing a prgm n b4 this i dont even know how to use vb or vb.net at all. it would be great if u give me any related article regarding issues 1 n 2. as i said b4 in my previous post (not this one but the same problem) my english r not that good, so whenever i try to google my problem, i cannot find any related article to my problem. i know u dont have time to entertain my stupid question, but if u can pls give the related link. im quite confused why it run ok n suddenly it cannot bcoz i didnt do any editing on ds.table part and it can retrieve data from table b4 this. tq

i dont have any problems with my substring.. i can read data from file using that code.. as u can see my reply at Christian answers, the problem start if i choose directory that have thousands of folder n files. but if a choose a directory that have just a few folder n files.. it can run and can get output from the prgm..

thanks a lot.. actually im not use to programming.. and my english r not quite good.. so when i try to google to find doc related to my problem, most of it r not.. maybe bcoz i put the wrong words.. the problem solve but how i can retrieve the value from portal that is inside the function to be call in other private sub.. bcoz im calling the function inside the other private sub called SEMAK. how can i get the latest value of portal inside that sub? or can u give me link to any doc related to my question.. thank you for helping me..

got it.. thanks a lot :-D

i dont think its bcoz of sql server does not allow remote connection.. iv been copied this coding from my previous web app.. but the one that im doing currently is windows form.. will it cause a problem? bcoz in web app i will put the connection inside the web.config but in this windows form i put in the coding area as i posted b4. if there's no problem using the coding from my web app, that's why im confused.. my web app can connect to the database, can add, update.. :sigh:

Hi, I'm not familiar with FolderBrowserDialog, but you seem to violate the following MSDN remark: "If the SelectedPath property is set before showing the dialog box, the folder with this path will be the selected folder, as long as SelectedPath is set to an absolute path that is a subfolder of RootFolder (or more accurately, points to a subfolder of the shell namespace represented by RootFolder)." C:\Document is not inside SpecialFolder.Desktop (which is located much deeper, its exact position depends on you Windows version). :) Luc Pattyn [Forum Guidelines] [My Articles] I use ListBoxes for line-oriented text, and PictureBoxes for pictures, not drawings.

zaimah wrote: put what? pls explain more. TQ. This is silly, We are giving you basic answers, I cant blieve so many people are giving programming tasks and have little knowledge of programming!

If you happened to use the Database Wizard to configure any part of your application, then Visual Studio may haved added code throughout your project making reference to the local copy of the database. An easy way to locate local pointers to your database is to open up Visual Studio and then open the find dialog and search for the filename of the database in the entire solution. Regards, Thomas Stockwell Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Visit my homepage Oracle Studios[^]

thank you. i have found the problem. the article really help.

thanks a lot for ur explaination. i'm really new in this, so many people that r expert in this usually don't entertain a beginner like me. thanks a lot. i will buy the book that u have suggested. one more thing, i'm confuse about one thing, what is the different between vb.net and asp.net? I'm using visual studio. if i see the html view, i can see the word , so i know it is an asp coding. but if see in the aspx.vb, which is the one that r asp? i'm still confuse in that.

Isn't MSDN accessible? http://msdn2.microsoft.com/en-us/library/ms178329.aspx[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Have u tried this thing.. function Close_Window() { window.opener="something"; window.close(); } just call the function on the button click <div class="ForumSig">When you fail to plan, you are planning to fail.</div>

i'm doing a program using microsoft visual studio. each time i submit my data, it will generate a doc number that is in . My formula docNo = System.DateTime.Now + kod + . kod is the value from a text box. for running number, i have a function GetRunNo that will update a table in my sql database each time i submit a data. in the table there r 2 field that is run_no and date. Each time i click add button it will update the running number base on date, it will add the data in the database, and each data will have a doc number for our reference. how can i call the values in that table to put in the doc number?

No worries - you should find there's plenty of examples online. Ask again if you get stuck. Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

zaimah wrote: i try to create the docNo but it didnt work. The description "didn't work" is a rather useless. What did you do to try to create the docNo, and what happened specifically when you tried this? Are you using a database? In that case the easiest way to create a unique id is to set up an automaitcally incremented field in the table. How that is done depends on what brand of database you are using. Experience is the sum of all the mistakes you have done.

hi, i have used the formula that u gave. it works, but there's one problem. i use docNo = System.DateTime.Now.ToString("yyyyMMdd") + Kod.Text + (values from field 'run_no' from 'table runNo') how to add values from other table?

You can try following Now.date 'To print current date also Format function is useful to print date in any format