all groups > dotnet ado.net > october 2003 > threads for friday october 24
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
where are the wrong codes??? I can't find.
Posted by Tao Lei at 10/24/2003 9:32:33 PM
Please:
I wrote these lines of codes of ASP.Net. But it goes wrong.
Why??? Who can help me?
Thank you very much!!!
<% @Page Language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<html>
<head>
<Script runat="server">
void page_Load(Object So... more >>
Cannot Add Row To Access 2000 DB using insert into command
Posted by Tom Ashcroft at 10/24/2003 5:53:29 PM
All
I have the following function
public void AddItem(string cartID, int productID, int quantity)
{
string SQL = "INSERT INTO ShoppingCart ( [CartID], [Quantity],
[ProductID] ) VALUES('" + cartID + "', " + quantity.ToString() + ", " +
productID.ToString() + ")";
try
{... more >>
DataView.Sort not sorting
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 10/24/2003 5:31:23 PM
Hello,
Can anyone tell me what is wrong with the following? I am
trying to sort a table, then return it as the dataset.
The dataset ds1 is returned, but is the same as the
orignal, meaning that the sort did not take place.
Thanks,
David
(existing dataset ds passed in to method)
... more >>
how to speedup ado.net in 98?
Posted by Jin-Yu at 10/24/2003 4:42:58 PM
Hi all,
I write a c/s program, client receive data by web server from server,
but is very slowly in 98 client, how to speedup?
thanks.
yujin
2003.10.24
... more >>
DataSet
Posted by itsme at 10/24/2003 2:37:34 PM
Hello All,
How can one convert an XmlDocument object into a DataSet?
Thanks
... more >>
access to sql -- synch process with ado.net
Posted by JM at 10/24/2003 2:28:43 PM
i have an Access app with about 15k rows that will slowly grow (this is
about a two years of data so far) indefnitely. The table structure is
horrible in the access design (can not be changed, its a third party
app) so on the sql side the table structure is totally different. What
i need to do... more >>
is it possible to get ...
Posted by haiwen at 10/24/2003 1:42:58 PM
Hello, everyone:
I have three tables like below:
class
{classID,int;
cbtHour, int;
ojtHour, int;
}
schedule
{
scheduleID, int;
classID, int;
}
date
{
scheduleID,int;
startTime, DateTime;
endTime, DateTime;
}
the requirement is I need to set up schedule's date so
that their tota... more >>
Failed to enable constraints error...
Posted by Robb Sadler at 10/24/2003 11:24:33 AM
I have created a dataset which contains a parent child
relationship based on a date, machine and batch number.
After creating the batch (parent) record,
pseudo:
new dataset
new parentdataadapter
new childdataadapter
select stmt for parent for one record
I am able to successfully ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Best practice for data insert
Posted by Greif at 10/24/2003 11:21:24 AM
I am creating some methods for disconected data
maniuplations. I have came up with the following method to
insert a single row into the DB:
public virtual int singleInsert(string tableName, params
IDbDataParameter[] values)
{
if(ConnectionString == "" ||
ConnectionString.Length == 0)
... more >>
Creating an exchange account. How to create mailbox?
Posted by Jeremy Chapman at 10/24/2003 11:21:05 AM
I'm trying to create an exchange account and mailbox using LDAP. So far I've
created the exchange account, and it looks good when viewing it in Exchange
administrator (Exchange 5.5).
How do I associate it to an active directory?
How do I create the mailbox for the account? (I tried to add the ... more >>
problem with multiple table datset updates
Posted by shiv at 10/24/2003 10:02:19 AM
Hi all,
my code looks something like this
connection = createconnection() // creates connection
SqlDataAdapter ad=new sqlAdatpter("select * from
EMP",connection);
SqlDataAdapter ad1=new sqlAdatpter("select * from
DEPT",connection);
DataSet ds=new Dataset();
ad.fill(ds... more >>
connection Pool
Posted by VBM at 10/24/2003 10:00:35 AM
I am using ASP.NET, SQL Server and ADO.NET, when I debug my web application
I get connection pool error...connections exceeded....But when I run it as a
released version I dont get the connetion pool errors....I am explicitely
closing the connections by calling My own Dispose method and not waiti... more >>
"GetOleDBSchema"
Posted by chak at 10/24/2003 9:59:31 AM
When i use "GetOleDbSchemaTable" to get the schema information of an Oracle
table, it gets us numbers, in place of data types, when we connect to an
Oracle 8 database, using the OleDB data provider from Microsoft. Any ideas
on why it is in numbers ? Besides the numbers are not consistent with the... more >>
DataBinding could not find a row in the list ... ?
Posted by ghanchi NO[at]SPAM bigfoot.com at 10/24/2003 7:32:53 AM
I get the following exception message when I try to reopn a form
window after closing it down (while the main MDI window
is still running)
"An unhandled exception of type 'System.Exception' occurred in
system.windows.forms.dll
Additional information: DataBinding could not find a row in the ... more >>
error about ReturnPooledConnection
Posted by Marc Jannes at 10/24/2003 12:15:18 AM
Hello,
from time to time I get this error:
System.NullReferenceException: Object reference not set to
an instance of an object.
at
System.Data.SqlClient.SqlConnectionPoolManager.ReturnPooled
Connection(SqlInt
ernalConnection pooledConnection)
at System.Data.SqlClient.SqlConnection.Op... more >>
|