all groups > dotnet ado.net > september 2003 > threads for monday september 1
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
System.Data.RowNotInTableException - Why?
Posted by Sasha at 9/1/2003 8:32:10 PM
Hi everybody,
I am having the following problem. While running my program I create a
DataRow (State - Detached). Then I add it to the DataTable (State - Added),
and delete it (State - Detached). Later I try to update the db by doing this
DataAdapter.Update(DataTable.Select("", "", DataVi... more >>
BUG: Object reference not set to an instance of an object.
Posted by Ather Ali Shaikh at 9/1/2003 5:12:15 PM
Hi,
I found this error message, when trying to login to my database,
i have tow text boxes 'userid' and 'password' and a button 'login'
it is working perfectly but some time it generates the error messsage=20
Object reference not set to an instance of an object.=20
What is it mean?
I am u... more >>
Accessing RETURN values from a Stored Procedure
Posted by peteZ at 9/1/2003 2:04:49 PM
(meant to post this SQL ADO message here instead of the C# Group)
Using C#, I can access results returned from a stored procedure call OK, my
question
is how do you access the value from a RETURN statement in a stored procedure
?
eg. In the Example below - how can I check on the Value -... more >>
Null and Stored Procedure
Posted by arne at 9/1/2003 12:49:21 PM
How do I pass a null to a stored procedure from VB.Net.
I have tried to pass nothing but that throws an exception.
Here is my parameter
command.Parameters.Add(New SqlParameter("@DLExpiration",
SqlDbType.SmallDateTime, 4, ParameterDirection.Input,
False, 16, 0, _
"DLExpiratio... more >>
distinct selection in a dataview
Posted by Diego Rojas at 9/1/2003 8:29:44 AM
How can i get a dataview of a table, saiyng that i want
to select the rows by a column y a distinct way
for example i want to create a dataview of el the
countries in a table, so a wna t to get yous the distinc
value for the field country?
txs... more >>
SP resulting in Timeout expired
Posted by Grace at 9/1/2003 5:38:19 AM
Hello,
From a VB .net application I'm calling an SQL stored
procedure and filling the results in an SQLDataReader,
whose results are returned to an ASP .Net page.
The procedure was running fine and all of a sudden it
started giving this error:
System.Data.SqlClient.SqlException: Timeout e... more >>
Excel Transfert
Posted by lukas at 9/1/2003 4:39:11 AM
When i try to import excel data with Oledb. The column
who have number value and blank value is not im my
dataset.
For the importation i do
OleDbDataAdapter oCmd=new OleDbDataAdapter("SELECT * FROM
[sheet1$]",strCn);
DataSet oDS=new DataSet();
try
{
oCmd.Fil(oDS,"ExcelInfo");
dataGri... more >>
|