Tag: ado.net

sp_helptext output being dropped by ADO.NET?

I’m using the tool described here to clean up some cruft from our development DBs. I’ve encountered an odd issue with it and can’t find the cause. For certain stored procedures, the GetProcedureText method (l:47, Validator.cs) fails to return the proc text, causing the program to behave unexpectedly. When debugging and stepping into GetProcedureText it […]

Single Query returning me 4 tables, How to get all of them back into dataset?

How to fill multiple tables in a dataset. I m using a query that returns me four tables. At the frontend I am trying to fill all the four resultant table into dataset. Here is my Query. Query is not complete. But it is just a refrence for my Ques Select * from tblxyz compute […]

Have XML file need it to populatemultiple SQL Tables

I have a XML file that I need to populate multiple SQL tables, and I was wondering what the best way to do that is. I was thinking dataset, or xslt but I honestly not sure. Here is my generated XML (part of it) <?xml version=”1.0″ encoding=”utf-8″ standalone=”yes” ?> – <!– Created: 8/3/2010 12:09:15 PM […]

No MSDTC – Still getting “communication with underlying transaction manager failed”

In my project I am using Ado.Net’s DbTransaction object to manage transaction… Then why I am getting MSDTC related error – “communication with underlying transaction manager failed”. Here is my code. DbTransaction trans = Connection.BeginTransaction(); //Code if (successfull) { trans.Commit(); } else { trans.RollBack(); }

RaiseError did not raise the error enough?

Why the error does not appear at the UI layer? I am using ExecuteScaler BEGIN CATCH PRINT N’The transaction is in an uncommittable state. Rolling back transaction.’ ROLLBACK TRANSACTION; DECLARE @ErrorMessage NVARCHAR(4000); DECLARE @ErrorSeverity INT; DECLARE @ErrorState INT; SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE(); RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState); END CATCH Thanks

ADO.net how to start

For the last 3 hours I’ve been trying to figure out how ADO.NET works with no success. Could someone point me at a great tutorial or somethign similar? I am trying to build a DB from scratch and working with it in my WPF program. I have worked before with JDBC and sqlite but I […]

inserting data from a asp.net page to sqlserver database

there are two tables in database. one is ‘books’ with 4 columns pkid,title,price,writer(int) and other is ‘persons’ with columns pkid, name,value(int). one asp.net page is there with text boxes named title,price,writer and a submit button. i want that on filling that writer txtbox with some name which is available in ‘persons’ table and clicking that […]

What Happens When You Access a Shared Function From an Instance of an Object

The context of this question is that I am trying to debug performance issues (apart from the obvious ones I already know about and can find). I inherited a code base (VB.NET) for an ASP.NET app. This is an app that was developed way back in .NET 1.1 days, and was the first .NET app […]

How to Create screen Form database

We are creating a data centric application, and want create a Screen (UI) as a Table Structure. Is any one has good Idea to build the code..? I was looking the ironspeed abut it is a code generator, i want same functionality at run time, It creates the code for design time.. please show me […]

eExecuteDataSet for system.data.common.dbCommand?

I am using system.data.common.dbcommand for database communications but I couldn’t find ExecuteDataSet in it. Probably it is not supported. Please advice is there some way that I can read multiple datatable in one go (my stored procedure will return multiple selects). Thanks

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.