Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vipinkrshamra

    How to pass multipe value to SP from Crystal

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

    Reading line from txt with special charater problem

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

    Violation of UNIQUE KEY

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

    How to use transaction

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

Part and Inventory Search

Back
Top