Expression error
(2 messages)
Date: Sat, 18 Aug 2007 17:23:21 +0200
I use this for selecting rows that match a specific case:
DataRow[] foundRows =
dSet.Tables["MY_TABLE"].Select(IIF("column1="+DBNull.Value, "column2",
"column3"));
Compiling error, because IIF is not valid in this context ...
|
Differant between Sqlcommand object and datasource object
(3 messages)
Date: Fri, 17 Aug 2007 23:34:06 -0700
Hi EveryBody:
Whey when I use the following code trying to inser my data to database it
did not work:
Dim mydatasource As New SqlDataSource
mydatasource.ConnectionString =
ConfigurationManager.ConnectionStrings("LocalSqlServer" ...
|
DataTable.Compute() question
(11 messages)
Date: Fri, 17 Aug 2007 16:04:18 -0700
hello,
i have a big datable of a bunch of stuff. i am interested in getting
row counts that match certain criteria.
currently i do this by creating a new DataView for each criteria, and
getting its .RowCount. like so:
dv ...
|
Trying to call a stored procedure from C# (and failing)
(8 messages)
Date: Fri, 17 Aug 2007 14:47:00 -0700
Hi;
This is using the Microsoft Oracle ADO.NET classes.
Two questions on this. The first is - is there a way to call a stored
procedure, including passing paramaters, where the entire request is in a
single string ...
|
Is TableAsapter thread safe?
(4 messages)
Date: Fri, 17 Aug 2007 13:38:18 -0400
Hi,
In our ASP.NET application We use strongly typed datasets and TableAdapters.
Is it a good idea to use a static TableAdpater to share the static instance
among all sessions?
My business logic components are like ...
|
What sort of dataset is it?
(4 messages)
Date: Fri, 17 Aug 2007 08:36:01 -0700
I have an application that saves a bunch of data in XML files that come from
typed datasets.
So, I have something like this:
MyTypedDs myds;
//.... When the user wants to save the data
myds.WriteXML(thefilename ...
|
Connect to remote Excel
(2 messages)
Date: Fri, 17 Aug 2007 05:35:12 -0700
Hi all, we need to be able to connect to an Excel in a remote server
via ADO.NET.
We have a component that makes queries to that excel a retrieves the
data requested, but when we are trying to get the data from the remote
excel ...
|
dataview.sort not working in framework 1.1
(3 messages)
Date: Fri, 17 Aug 2007 04:18:28 -0700
Hi all,
I am having table containing 2 columns and 3 rows.
Col1 contains interger valye. I have records with record1 having 2 in
col1, record2 having 5 in col1 and record3 having again 2 in col1.
I am trying to sort ...
|
Problem in oleDB and the double-quote character (")
(1 messages)
Date: Fri, 17 Aug 2007 02:49:23 -0700
Hi,
I'm running into a problem with the double-quote character while i'm
reading a delimited text file. I've set the file delimiter to the @
character, but it seems the oledb provider is also delimiting my text
when it ...
|
Problem while filling the dataset where the data source is a .CSV file
(3 messages)
Date: Thu, 16 Aug 2007 22:29:47 -0700
HI,
I am trying to reading a .csv file from a remote desktop.
the connection string that i am using is as follows:
strConn = "Provider=MS Remote;"+"Remote Server=//<ComputerName>/
<FolederName>;" + " Remote Provider=Microsoft ...
|
|
SqlConnection.InfoMessage - SqlError.Class wrong value ?
(1 messages)
Date: Fri, 17 Aug 2007 15:07:38 +1000
Hi,
Using VS2005, SQL Server 2005.
The SqlError.Class property always seems to be 0 when retrieving
informational messages via the SqlConnection.InfoMessage event. Sample code
to reproduce :
==
private ...
|
new Child/parent parent record in typed dataset.
(1 messages)
Date: Thu, 16 Aug 2007 18:23:37 -0700
I've followed the wizard to create a dataset. This datset has two tables, one
master, and one child. I've also had the wizard create stored procedres for
select, insert, etc.
I am not binding the data. Instead I've taken ...
|
setting up for calling a stored procedure
(2 messages)
Date: Thu, 16 Aug 2007 17:59:18 -0700
Hi,
I am using vs .net 2005, .net frameworks v3.0, vc++ 2005, on vista
I am trying to write a c++ app to call a sql stored procedure.
the following code genrates an error trap and I don't know why:
String ^myConnectionString ...
|
Strongly-Typed Datasets and Inheritance
(1 messages)
Date: Thu, 16 Aug 2007 17:55:21 -0700
I tried to create a new strongly-typed dataset that inherited from an
existing one, but I was not able to. There were methods that were created for
the new strongly-typed dataset that had the same name as methods in the ...
|
How does VS2005 generate the dataset class when dataset is created
(1 messages)
Date: Thu, 16 Aug 2007 17:52:47 -0700
Does VS2005 create the dataset.xsd first and then use MSDataSetGenerator to
create the dataset.designer.vb or a portion of the dataset.designer.vb? ...
|
(BUG) I hate ADO.Net 1.1 - inserting a record into SQL Server
(1 messages)
Date: Thu, 16 Aug 2007 13:37:27 -0700
OK here is my experience of trying to write some code to do something
really basic - insert a record into SQL server.
For various reasons I want to insert my row via a command rather than
using a dataadaptor. Part of the ...
|
Copying tables in SQLEXPRESS
(4 messages)
Date: Thu, 16 Aug 2007 15:13:54 +0200
Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database ...
|
OleDb DataReader Close is hanging
(3 messages)
Date: Wed, 15 Aug 2007 17:32:04 -0700
Hi - i'm using an OleDBDataReader to get results from a stored procedure and
it is hanging on the Close() call on the Data Reader. When I do a Sql trace I
see a SQL_NO_DATA_FOUND error but i'm not sure what it means or how ...
|
TransactionScope Transactions not commiting
(1 messages)
Date: Wed, 15 Aug 2007 11:06:03 -0700
I'm trying to implement something here that seems like it aught to work, but
is not. I've done some extensive searching around the web, and have not
found anything directly relavant. I am trying to solve two basic issues ...
|
TableAdapter. Not all constraints from database table configured
(1 messages)
Date: Wed, 15 Aug 2007 10:28:01 -0700
Hi,
I have a table in SQL Server 2005 that has a primary key along with unique
constraint on two columns. When I create a TableAdapter for the table the
primary key is created but the unique constraint for the two columns ...
|
