I'm going through several books on ASP.NET database programming. They all make it look so easy. But it just never seems to work for me. So I created a new ASP.NET application. I right click on Data Connections in Server Explorer and select 'Create New SQL Server Database...' The Server na...more >>

Hi I am having some problems retrieving the last inserted id from the DB, I really want to chuck this into a variable so I can use it anywhere. The following is what I have got so far :- string connStr = ConfigurationManager.ConnectionStrings["dataConn"].ConnectionString; SqlConnection o...more >>

I'm trying to upgrade old code in .NET 1.0 to use the data access application block (June 2005 version). I'm trying to do this: SqlCommand custCMD = new SqlCommand(sql, conn); conn.Open(); XmlTextReader rdr = (XmlTextReader)custCMD.ExecuteXmlReader(); But guess what, there is no ExecuteXm...more >>

I've got a datatable with 3 columns: -A string -A datetime -An expression-based column I want the expression based column to be a representation of both of the other columns. The expression looks like: ColString + ' ' + ColDate The only problem is that the datetime format is very verbo...more >>

I'm new to SQL Server and seem to have a lot of problems with my connection string not working. I finally got it working on one system but then it stopped working when I moved to another system. Can anyone give me some ideas as to why? IMPORTANT: This is not on the final Web-hosting machine...more >>

I am new to ADO.Net. I'm currently attempting to prototype an ASP.Net Solution for a customer. I have the following scenario and I'm not sure what the "best" direction is... We have two tables that have a 1 to 1 relationship. We have decided to use strongly-typed datasets for a variety of r...more >>

I'm interested in creating a database that retrieves MP3 Extended attributes also allows me to edit and save them back to their resptive files, Does anyone know of an ocx control or even some sample code? Have a class that does everthing I want but seems impossible to convert to Dot net from VB6...more >>

I have names in a data collection the include apostrophes like O'Hare. When I use a simple VC#/ADO.NET approach with an SQL INSERT statement and cmd.ExecuteNonQuery, it always hangs up on the apostrophe saying that there is an unterminated string. When I try using a DataAdapter and SqlCom...more >>

I've see references to this utility, but have been unable to find it in either my SQL Express installation or my VC# ORCAS installation. Where does it hide? TIA Carl ...more >>

I have setup a .dbml file from an SQL table. I have inserted a new column and deleted an old column from the database table that the .dbml file is associated with. How do I refresh the .dbml file to take into consideration the database changes? Thanks, C ...more >>

Hi, I am trying to execute an INSERT INTO query, but the debugger says me that there is a syntax error, which I cannot figure out: Public Shared Function project_add(ByVal title As String, ByVal desc As String, ByVal isActive As Boolean, ByVal isSystem As Boolean) As Boolean Dim c...more >>

I get this error while trying to run report on SQL Report Server "System.Data.OracleClient requires Oracle client software version 8.1.7" I checked the DataClient and it is installed. The report runs fine on development machine but not when I moved it to Test mahcine. Any help? ...more >>

I'm making a OLE DB connection in code and was wondering if anyone could identify what the syntax errors would be in this just as it is pasted (I tried putting & _ at the end of the first line and that only brought up other errors): New OleDbConnection("Provider=Microsoft.Jet.OLEDB....more >>

My Web application will eventually be hosted on someplace like GoDaddy.com. NOTE: I am not asking anything about hosting my application on the Internet. Rather, I'm asking about testing the application here on my desktop during development. On a new Vista system with Visual Studio 2005 insta...more >>

Is there anyway to add rows to a dataset/datatable without having to populate the object with rows from the source table???? It seems to be pretty daunting in terms of memory/processing requirements to have to fill the dataset with all rows from a source and then make additions. ...more >>

Hello, using ADO.NET 2.0, VS.NET 2005, SQL2005 I need to execute several Stored Procedures under one transaction. Can I use just one transaction or have to use multiple ( then commit or rollback all ) How does it work with ADO.NET Ado.Tran SP1 Called loop SP2 Called ...more >>

All, I'm trying to write some code that will detect changes in a database table (like a record value modified) in SQL Server 2000. I've tried to pull all records and place them in a dataset and merge against existing records every few seconds but the DS Merge does not seem to work. Any s...more >>

Hi, How to set up dependency so that it will never expire? If time-out = 0, it indicates that the server's time-out should be used. What is it? How can I set up server's time out? All I want it is, that SQLDependency will not expire while my application is running. Thanks, Lubomir...more >>

As I recall, data readers are much more efficient than DataAdapters. Unfortunately, the code I am refactoring could really benefit from a VS generated strongly bound DataRow but it is using a data reader. Is there a way to make VS 2003 generate a strongly typed DataRow, DataTable or DataSet ...more >>

Hi, I'm working with the dataset designer, which, via its wizard can generate both a fill method and one to return a datatable. So I can use these to get a specific datatable back, but I can't traverse a relationship, because the other table doesn't exist! So I assume I need to maybe manual...more >>

Hi, We are developing one web application using .Net frame work 2.0 and Oracle 9i. Operating System is windows server 2003 standard edition service pack 1. We try to retrive the data to oracle database.But the System Display the following error message. System.Data.OracleClient require...more >>

Hi, I am using .Net 1.1 and ODP.net. When I use OracleDataAdapter.Fill method, it is not returning any rows, but when I query in TOAD I see results. Has anyone experienced this problem before ? Thanks, - Kishore...more >>