I have a report that create on WEB FORM. The report will have a datagrid with 6 fix row. When on each of the report, there will some time need to trigger to second page when there have more than 6 row of records. The datagrid can be see through paging, but when need to print out, it impossible to print out the datagrid all pages. Can anyone help on some method that allow me to print out all pages on datagrid on my report, please? Thank You.:confused:

I am not using Crystal Report in my report generation. I just design the report on the web form and those datagrid will show on the web form. Unfortunately, when the datagrid exceed more that a page, than i need to let it automatically show continue on the another web form with the same report format. Will it be done just on the web form without using Crystal Report? Any advice and suggestion? Thank You.;)

I set 'NONE' for the authenticate mode in my web config file of my ASP.NET application. For the SQL Server, i put NT AUTHORITY/Authenticated Users for the user for database that use by the application as well as dbo. So, are you sure that not problem i using directory browser in my application? Thank for advice.

You are right on the issue of 1, 2 and 3. But how about the issue 4th that you are mean by? FYI, i put my code some thing as this: Dim filetoread As String filetoread = File1.Value where the filetoread is the textbox text value after i browse for the file to be import to the server ay my place. IS this the problem that cause the network path not found issue from my directory browser? If this the matter, how can i solve this problem using the web browser as you mentioned? How the web browser code will look like? Any code exmaple or reference? Thank You, David.

I have a textbox with browse function in my web application. This will able user from the web to import or upload their data in CSV file into my SQL Server place at my factory. The problem is user in my factory office domain can import the file through the directory browse from My Network Place and proceed to import the csv file into the server. But, user not in my domain but from outside country or other location cannot import the CSV through the textbox with directory browse function. They alwasy get the error with "network path not found". How can i solve this problem to enable user around the internet to proceed import their csv file into my server using this textbox with directory browsing function? I give every user the bulk insert right for this system. Thank you for advice.

Excuse me, can you mention more detail and how it to be done such as give some simple example? Thank you for you response.

While i am use bulk insert to import the csv file into my SQL SERVER through my system develop using ASP.NET by VB script, it able to import all csv data into my database. Unfortunately, some data such as those decimal or money data type already change to vchar for all the data type after import in my database and cause them to be close by double quote ("1,111.00"). This unable let me to total up those data while i do it with my system. As i research, there have CONVERT and CAST function to convert the data type, can i use them while i import the csv file into my database through the BULK INSERT? Thanks.

I am developing a system using ASP.NET with VB script. I have a function to import CSV file into my SQL server database. As i found out the comma will effect my data placement in my tables, so i think of to develop a function to convert the CSV file to Tab Delimiter file. Is it possible to develop the function? As i found out, there are many converter outside that need to buy for the converter, it is not convenient for me to buy it. Please give me any suggestion or solution, thank you.

While i use the bulk insert to import the csv file into my SQL server database, i am facing problem as the csv file have column with money data such as 1,111,111.00. As i set the FIELDTERMINATOR =',', it will separate out the value 1,111,111.00 to few of columns as the value have comma in it. Any suggestion to solve this problem? Thank You.

Let say i will not import all the data from the CSV file selected by the user as while importing the data i will perform some checking to pick up those related CSV data to be store into my table in my SQL server database. I am stuck in the coding how will it be for the code as after user click the import button on my system, the importing and filtering will be take action. After successful importing and filtering, the data will store in the database. Please advice.

Through the system i develop, i need to bind all related data onto the datagrid after getting related search data from previous page from user. After bind the search result on the datagrid from my MS SQL SERVER 2000 databse, i will keep checking and assiging the sequence number to each row of data from the datagrid. The sequenced number in format (PB1-000000). The first 3 character is category group, then the following 6 digit will generate sequencely row by row. Any idea for me, please? Thank for response.

The case like this. User can create their CSV data file from their SAP application & SAP server. For my side, i am developing a system which will let user browse to the CSV data file which user save to their thumb drive, floopy disk even their local pc. when they select their prefer CSV file, user can click on a button to import the CSV data into my database on my SQL server. Any idea for me to perform this import action including while importing i can checking and filtering out those unnecessary CVS data. Thank for response!!!