Search results for query: *

Hi Dave, Thx for input. Yes I am usign dynamic parameters. If you dont mind could you share your workaround. I am using Crystal Enpterprise to publish the report for users and dont have any .Net/VB application at present to display report. I know how to pass parameters from application and also...

Hi!!, I have SP as follows ************SP**************** CREATE proc dbo.Test ( @Emp as varchar(8000) ) as Select EmpId,Emp from tblEmp Where Emp in ( Select * from SplitString(@Emp,':::')) ************SP**************** I can execute above SP as follows from...

thx a lot earthandfire .. that will do :-)

thx a lot earthandfire and keeping this thread alive. I can use any of these methods. One last question in your opinion, which would be faster and efficient way of tackling this problem and what could be possible pros and cons of each technique

Yes I also had this solution in my mind but since my txt file could be 10 mb or some time even bigger. This solution could have memory issue and also may be little slower. I was expecting while opening file-using StreamReader there must be way to ignore special characters like ASCII(10). As I...

Ok the character which is causing problem is ASCII(10). Now is there any stream to open txt file to ignore ASCII(10) character. I guess it should be possible since NOTEPAD and many other text editor like Edit Plus are able to ignore this character and are displaying complete line as single...

thx Earhandfire, I have two concern with your suggestion #1 How will I differentiate between that special character and actual line feed. As I mention there are 1000s of line in txt file, only one or two line may have that special character and I need to maintain original line sequence as I...

Thx a lot Chiph for help. I do understand what you are saying but kind of stuck to fins the solution. As I mentioned I need to process each line separately and this line feed character is creating extra line with Readline. Since notepad is able to ignore these characters and could show that...

Hi!, I am trying to read txt file from .Net app using following code. *****code**** Dim myReader As New System.IO.StreamReader(FileName, System.Text.Encoding.Default) While myReader.Peek <> -1 mystring = myReader.ReadLine End While *****code**** This txt file is created by some 3rd party...

I would like to clear one thing that I get error only for few records. For example if I isnert 300 records in database, I may get error for let say 10/12 records. And I am very sure data whcih is breaking the Unique constraint is not there in database.

Let me give you more information about my problem. I am parsing some txt files with 1000's of line into database. If the file from which I am getting error is inserting in blank table then I dont get error but if the file is processed into table with existing data then I get this exception. I...

Is it possible that actuall error is different but during scanning the errorrows I am getting wrong error message Here is function I am uisng to scan through rows having error *********Function Start******** Private Sub HandleSQlError(ByVal ErrorTable As DataTable) 'Dim myTable As...

Yes. I am sure about it. There are no duplicate recrods either my Datatable or database table.

I am using adapter.update method to insert a datatable. One of the field in database table to which datatable ois referring is UNIQUE key. here is complete error message : Error : Violation of UNIQUE KEY constraint 'IX_tblJunk'. Cannot insert duplicate key in object 'tblJunk'. The statement has...

Thanks a lot jebenson for pointing out my mistake. That was the problem. I appreciate your time as well as of SMURF75.

Thanks a lot for helping me on this issue. In my code "bldr1" is object of "SqlCommandBuilder". I could not find "Transaction " property for "SqlCommandBuilder". I may be missing something. Please advice.

I have wasted lots of time to troubleshoot this problem but with no result. I would appreciate if anyone could help me on this.

Hi , I am trying to use use dataadapter.update with in trascantion. But it is failing with following exception. "System.InvalidOperationException: Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The...