Thanks for the reply. What I want is to insert multiple records. This is very small data but if data is huge then how can I do this. ike in SQL we can send XML to stroed procedure and then parse it in the stored procedure and insert the records. Can you please tell me how to do this in MYSQL? Thanks again.

why not you use LINQ To SQL to do this. use this http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx article. Abhishek Sur My Latest Articles Basics on LINQ and Lambda Expressions Create .NET Templates

Yes Even i am getting the same error given below. "The communication channel with ASP.NET could not be configured. Requested Service not found"

hi, Well based on your last post I have more clear your situation. It seems that you dont have increament column in table and i make fast solution,maybe is not the best solution but it will work. here is code down below,just copy-modify-paste and use in your real data create table #TempTable ( IdentValue int IDENTITY(1,1), Name1 varchar(255), Name2 varchar(255), ID Int ) insert into #TempTable select name1,name2,id from tabela declare @i as int set @i=0 declare @startValue as int set @startValue =2200 declare @endValue as int set @endValue=3200 while @i<(select count(*) from #temptable) begin set @i=@i+1 set @startValue=@startValue+1 update #tempTable set ID=@startValue where identValue=@i end delete from tabela insert into tabela select name1,name2,id from #temptable drop table #temptable select * from tabela I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

The designer does try to analyse a SPROC to determine the output type but it's very limited, and in this case you're returning from a temp table based on constructed SQL - it would be difficult to determine what this is. Your best bet is to create a class manually that can hold the results and specify in the designer that it returns that type. Try reading "Handling Multiple Result Shapes from SPROCs" in http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx[^] 'Howard

I'm new on LINQ, but maybe you should use something like this : List yp = from q in _datacontext where ( your condition) orderby q.Year ascending select new { q.Year, q.PeriodIdentifier };

Thanks Christian, I used Javascript and its working fine. :)

Thanks for the reply. I have remove the try catch but its not working ... I dont know why... Please help me... Thanks again ...

Thanks for the reply. Would u pls give me a start for the same... Thanks again...

hello SimulationofSai, Thanks for the reply. Its working now. File contains almost 104411 rows. I did this : BULK INSERT dbo.tb_DEMO FROM 'C:\DEMO08Q1.TXT' WITH ( FIRSTROW = 2 ,FIELDTERMINATOR ='$' ,ROWTERMINATOR = '$\n' ) FirstRow = 2 solved my first problem and ur suggestion helped me to solve my 2nd problem. Thanks again... :)

DECLARE @value AS VARCHAR(255) SET @value='78,567,9' SELECT REPLACE(@value,',','') I see you have already soultion but I hope you don't mind for my answer. Regards. I Love T-SQL "Don't torture yourself,let the life to do it for you."

Hi, I tried your code, I get the error even in my local dev machine. The error when executing the line "ObjExcel.ThisWorkbook.Save();" is : "Exception from HRESULT: 0x800A03EC". If you find the solution for the above, pls help me out to solve. Thanks Priya

IE have its in-build mechanism for opening an excel file.You no need to worry about how to open it. Only give proper path in browser. User gets option for "Open" or "Save". If user opts for save that excel file is saved to user's system and if users opts for "open" the its opened into browser automatically!!! Thanks, Arindam D Tewary

Please edit your question using proper pre code tags ♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

If you want them side by side, a repeater is the best way to do that. Christian Graus Please read this if you don't understand the answer I've given you "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 )