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/Q_23088811.html
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/Programming/Editors_IDEs/.NET/Q_23384775.html
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 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 Rating: 8.2 Views: 42
I am new to ADO.NET. Please can someone help me with the following problem:
I have a main form (conventional controls not a datagrid) which is bound to an Access database (effectively a single...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_CSharp/Q_24667316.html
Hello experts,
I am populating the customer object as shown below. How do I write condtions as shown below in
for eg. If isdbNull(.age) then
.age=10
else
...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_24678507.htm...
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/Q_23380404.html
