| Thread | Last Post | Replies |
|
| Deployable SQL Server authentication for ASP.NET | 31 Mar 2007 17:10 GMT | 3 |
We have an ASP.NET application that connects to a SQL Server database. Historically we have used a trusted connection, and during our database creation, created granted database access to the system account <SQLSERVERNAME>\ASPNET.
|
| How to handle concurrency issue with better performance? | 31 Mar 2007 13:32 GMT | 10 |
I am now thinking a method to handle the concurrency issue in my program. In .Net, the Command Builder Class will generate SQL automatically in which it compares all the fields' original version with the version in
|
| SELECT query | 31 Mar 2007 03:20 GMT | 1 |
I have a table: column: A | B ---------------- row: a | 1
|
| Loading ado.net table from datatableReader - wont update table on | 30 Mar 2007 17:44 GMT | 2 |
I have to read data from an external file into a ado.net table ds.tblExternal.ReadXml(...) and I want to load this data into a table that resides in a sql server (2000) DB. I can do this if I loop through ds.tblExternal and add new rows
|
| Adding identity column to an existing DataTable | 30 Mar 2007 17:30 GMT | 1 |
I'm trying to add an identity like column into an existing table of a DataSet: DataSet ds = ... ...
|
| Concurrency Violation | 30 Mar 2007 15:01 GMT | 2 |
My VB .NET 2003 application communicates with an Access database. So far everything has been working just swell. I have a menu selection in my main form that when clicked launches a "customer data" form that folks fill personal information into and the
|
| My ADO.NET 2.0 Provider doesn't work in SSIS Import Export Wizard? | 30 Mar 2007 14:48 GMT | 1 |
I've written an ADO.NET 2.0 provider for our company's database and a Visual Studio DDEX design time support proivder. Everything works well and the documentation supplied on MSDN and samples were excellent. However I can not figure out how to get the SQL Server Integration ...
|
| SqlNotificationInfo | 30 Mar 2007 05:55 GMT | 12 |
To capture changes in the database I am using SQLDependency. When the change is notified I update my UI. In the handler for OnChangeEvent I checked what type of info is passed to the method argument. I find out it is "Error"
|
| Parameterized query problem using Access Database in VS.NET2005 | 30 Mar 2007 04:23 GMT | 7 |
New to the VS.NET 2005 and I am writing a program using an access database as the datasource in visual studio.NET 2005 The problem I have is I am trying to write a parameterized query where a wildcard can be used to pull a complete name from only one or two characters entered. If ...
|
| Can not update text with Polish characters. | 29 Mar 2007 20:58 GMT | 3 |
I have a table where there are translations of various strings into different languages. I need to load this strings and allow some users to modify and update the strings back into the table. When I load a text written in polish, the application loads the data
|
| How do you programmatically create a file in the App_Data folder? | 29 Mar 2007 20:28 GMT | 6 |
Developing a web site in VS2005, SP1, VB, .NET 2.0, ASP.NET 2.0 on XP Pro, SP2. I'm trying to write a file to the App_Data folder in my project using: Dim docPath As String = "~\App_Data\Trips.xml"
|
| Oracle 10g and OracleClient .Net 1.0/1.1 | 29 Mar 2007 08:38 GMT | 6 |
We're currently upgrading to Oracle 10g client and we've hit an issue with .NET 1.0 and 1.1 applications that use OracleClient to connect to Oracle. Basically any .NET 1.0 or 1.1 application that tried to open a connection to Oracle would get a "System.Data.OracleClient requires ...
|
| Loading a stored procedure based on index? | 28 Mar 2007 16:03 GMT | 5 |
I have a few sprocs and I want to create a generic handler for them. Basically, I want to call any sproc and leave it up to the developer to know the parameters. To keep it simple, I would like to do it so that the only thing that the developer has to know is the appropriate
|
| Parent-Child-Relation and DataView - .net 2.0 | 28 Mar 2007 13:29 GMT | 3 |
I have the following problem: I have tableA, tableB A relation between tableA and TableB. So table B is the child of table A.
|
| Problem with Data Readers and connections | 28 Mar 2007 08:26 GMT | 1 |
I am doing maintenance work for a ASP .net application which uses ADO .net to access the data from database (SQL Server 2000).The functionality is something like that it uses SQL Data Reader to fetch the data and always open a new connection to do the same since only one
|