We have a custom vb.net application that interacts with SQL Server with moderate writing/pulling data.
Is it advisable to open a connection (i.e. at Login) and set a Connection variable. Then,...
http://www.experts-exchange.com/Programming/Languages/.NET/Class_Libraries/ADO.NET/Q_23088...
I am trying to make a .NET application that turns off the "Enforce password policy" and "Enforce password expiration" options for a SQL user in SQL Server 2005. This script works in my application...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23141224.htm...
I am accessing the existing database table in Pervasive PSQL system. The encoding setting in PSQL can be set at the server level or database level at creation time and changed later.
I am accessi...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23356274.html
In VB6 using MDAC 2.8 I could do a single select statement that would act as either an Insert or an update. Is there a way to do this in ADO.net?
My old VB6 code
Dim dbData As New ADODB.Connectio...
http://www.experts-exchange.com/Microsoft/Development/.NET/Q_23384775.html
I have two datatables and want to merge in one datatable called FINAL using INNER, LEFT or right join. Following is partial code. Can somebody tell me what is next step? I would also like to dump r...
http://www.experts-exchange.com/Programming/Languages/.NET/Class_Libraries/ADO.NET/Q_23594...
Zones:
.NETDate Answered: 08/15/2008 Grade: A Views: 202
I am in the process of creating an ASP.NET web application where I would like to keep all the data access encapsulated in a single object. I am trying to find examples of best practices which deal...
http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/Q_23792025.h...
I konw the stored procedure works, becuase I have test it on the SQL Server 2005. But, when I execute the code the dr returns -1 (no records). Not sure what I am missing.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2346...
I have a form with a datagridview, this view if filled from a query that is a joining two tables.
I was trying to use the dataadapter,dataset... to fill and allow the user to edit the DGV.
but th...
http://www.experts-exchange.com/Programming/Languages/.NET/Class_Libraries/ADO.NET/Q_23380...
whenever i am trying to save excel sheet into ms access database 2003.it is throwing exception i dont know why?kindly help here.
using System;
using System.Data;
using System.Configuration;
usi...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23249491.html
There is some kind of a bug where occasionally, VS2005 will not automatically generate an update and delete statement when creating datasources at design time. VS2005 uses tableAdapters, not DataAd...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23440...
