More about Database Independence
(3 messages)
Date: Wed, 15 Aug 2007 07:12:05 -0700
In a new system based on .Net 2.0 I have some tech goal like database
independence and the use of typed datasets. So I'm looking for some material
on web but I did not found anything interesting.
My scenario:
I had ...
|
Still More Database Connection Problems
(3 messages)
Date: Tue, 14 Aug 2007 16:45:37 -0600
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 ...
|
KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on databases with failover partner
(1 messages)
Date: Tue, 14 Aug 2007 19:06:52 -0300
Hello,
I work at a Hosting Company in Brazil and we have been experiencing issues
with managed applications using .NET Framework 2.0 that connect to SQL
Server 2005 databases with a failover partner. These issues started
happening ...
|
Format date in datacolumn?
(6 messages)
Date: Tue, 14 Aug 2007 13:16:03 -0700
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 + ...
|
ExecuteXmlReader not available in .net 1.1 Enterprise Library Data Access Block ??
(2 messages)
Date: Tue, 14 Aug 2007 14:47:40 -0500
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 ...
|
Database Connection Problems
(3 messages)
Date: Tue, 14 Aug 2007 10:20:02 -0600
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 ...
|
Retrieving Last inserted ID
(3 messages)
Date: Tue, 14 Aug 2007 14:56:49 -0000
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 ...
|
Export SQL or DataSet to... something?
(1 messages)
Date: Tue, 14 Aug 2007 07:06:03 -0700
Hi guys,
I have some data stored in a SQL server I want to export using ASP.NET.
Which would be the best way to do it? I guess there is no way to make a SQL
backup, so I think of retrieving the DataSet and exporting to ...
|
BindingList(Of T) : Filter
(1 messages)
Date: Tue, 14 Aug 2007 13:13:44 +0200
Hi,
Im' using a custom list Inherited from BindingList(Of T). I would like to
add a Filter to be able to filter on different column values.
Offcourse this must exist already, and after some google-search I found 2
nice ...
|
XML, SQL, and Stored Procedures
(1 messages)
Date: Mon, 13 Aug 2007 19:57:17 -0500
I'm trying to apply techniques I'd normally use to pull data from SQL/Server
to pull XML from SQL/Server, and I'm running into a problem. Here's what
I'm doing:
1. I've built a stored procedure that pulls my data, and ...
|
|
Newbie DataAdapter Questions
(2 messages)
Date: Mon, 13 Aug 2007 11:48:57 -0700
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 ...
|
GridViews and sp_executeSQL?
(1 messages)
Date: Mon, 13 Aug 2007 07:16:04 -0700
Hi all,
I built a stored procedure that needed to use dynamic sql for a search
window. I used sp_executeSQL to accomplish this. I tried to create a dataset
in the designer by dragging and dropping the stored procedure ...
|
Req: Help! Editing MP3 Extended Attributes
(1 messages)
Date: Sun, 12 Aug 2007 12:37:51 GMT
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 ...
|
Data with Apostrophes
(14 messages)
Date: Sat, 11 Aug 2007 12:02:02 -0400
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 ...
|
sqlmetal
(4 messages)
Date: Sat, 11 Aug 2007 11:57:51 -0400
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
...
|
Linq to Sql and database changes
(2 messages)
Date: Sat, 11 Aug 2007 07:51:10 -0700
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 ...
|
Comparing dataset schemas?
(1 messages)
Date: Sat, 11 Aug 2007 08:25:30 +0330
dataset1.table1 is filled from a table in a database
dataset2.table1 is filled from a table in a database
How can I programatically compare the two tables to see if their schemas are
compatible (Same column definitions ...
|
Access "INSERT INTO" query syntax error
(11 messages)
Date: Fri, 10 Aug 2007 17:13:48 -0700
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 ...
|
System.Data.OracleClient requires Oracle client software version 8.1.7
(2 messages)
Date: Fri, 10 Aug 2007 09:42:22 -0700
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 ...
|
DataGridView, BindingSource and Custom object
(1 messages)
Date: Fri, 10 Aug 2007 13:08:34 -0000
Hi all,
I have a question on how to write directly to the database the new,
the edit or the deleted records. I try to explain:
I have created a business object that hinerit form
INotifyPropertyChanged, and bind it to a DataGridView ...
|
