| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 December 2007 January 2008 February 2008 March 2008 April 2008 |
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 OleDB Select Scope_Identity() after insert ERROR Posted by Richard at 7/21/2004 11:52:50 PM It gives an error saying there is 2 much text after the SQL command.
with MSSQL i just placed, "; SELECT SCOPE_IDENTITY()" after the insert
statement and i would get the current ID,
but when i use OleDB it gives me the error each time, anyone know if there
is someother syntax for an MS Access ...more >>
how to change a integer of 0 into null when insert db Posted by Joe at 7/21/2004 9:26:02 PM how to change a integer of 0 into null when insert db
joe...more >>
How to insert a integer = 0 into database to be null Posted by Joe at 7/21/2004 9:24:01 PM when i passed a integer = 0 to a sqlparameter, how to change to null into db...more >>
can't isolate changes to bound datatable Posted by John Mas at 7/21/2004 8:42:46 PM I have a dataview on a datatable as part of a dataset. I have bound the
controls on my form to the columns in the dataview and when i modify the
fields in the form the datatable gets updated. I know that this is true
because i can repopulate the form from the datatable and i get the new
values...more >>
Best Method for DataSet Posted by Vivek at 7/21/2004 7:22:31 PM Hi all,
I have used a DataGrid in my ASP.Net, C# WebPage and Binded DataSet to
DataGrid in
"not IsPostBack".
I have Three DropDownList OutSide DataGrid Which act as Filters For Data in
DataGrid, When user Changes the selected item in DropDownList the data in
grid should change.
example : One ...more >>
Connection Timeout Posted by JDupont at 7/21/2004 5:45:05 PM I am trying to run as stored procedure in vb.net. When I try to execute the sp I keep getting a Connection timeout error. I have increased my timeout property but it continues to timeout. This sp may take quite a long time to run.
Can someone help?
...more >>
time and dates? Posted by Kabouter Smal at 7/21/2004 4:50:17 PM Hi!
Is there a sample or some classes to deal with time and date
calculations?
I have records that i need to calculate, the difference between the
time the clocked in and out and the time they have worked on a order
through out the day.
Please...give me some advice?
regards,
Jake.
...more >>
How do I release a DataAdapter. Posted by Manuel Canas at 7/21/2004 3:47:35 PM Hi All,
After I call a data adapter for a straight insert on the DB, if I call the
same data adapter for an update on the same record, it throws an concurency
error saying that the update command updated 0 rows.
Now, how do I release and initialize it again so I can update that record
right...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Typed Dataset v/s Untyped dataset Posted by Rajesh at 7/21/2004 3:25:50 PM Hi,
Are "typed dataset" good for enterprise level "web" application. (from
performance point of view)
Regards,
Rajesh
...more >>
Connect to a Sybase11.9.2 database Posted by microsoft at 7/21/2004 3:24:11 PM I want to access a Sybase11.9.2 database by ADO.net.
Then I create an OleDbConnection named oConn,and the connection string is
"Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial
Catalog=myDBname;User Id=username;Password=password", it can be opened
succeeded . But when I use ...more >>
Fun and excitement updating related data Posted by Earl at 7/21/2004 2:46:22 PM Ideally, what I would like to do is to populate a datagrid with the
information from 2 tables. Man, does that sound simple ... if so, please
join me on this expedition ...
Begin by using two dataAdapters, filling one from the main database table
and another from the foreign-keyed table and set...more >>
DataRowView Question Posted by Roshawn at 7/21/2004 1:29:56 PM Hi,
I am binding to a DataRowView object which contains approximately one row.
However, one of the columns of the row contains an array of author names. I
bind to it like this:
Me.lblAuthors.Text = row("Authors") 'row being the DataRowView object
When I run the code, I get no errors ...more >>
Microsoft Data Access Block for .NET and the "like" statement Posted by pwolpe NO[at]SPAM gmail.com at 7/21/2004 12:45:39 PM Is there a way to use a like statement with a SqlParameter and the
Microsoft Data Access Block?
I would like to be able to do this:
int CustomerID = (int) SqlHelper.ExecuteScalar(
ConfigurationSettings.AppSettings["connectionString"],
CommandType.Text,
@"select CustomerId
...more >>
BindingManager detecting new row Posted by PeterZ at 7/21/2004 11:24:43 AM Hi,
I have two tables and a dataRelation (win forms project). The dataRelation
is bound to a dataGrid. I'm trying to detect when a user navigates to a new
row in the datagrid so I can obtain a new record ID number from the db.
Screenshot:
http://www.insightgis.com.au/web/stuff/new_row_det...more >>
hiding the datagrid header? Posted by Moe Sizlak at 7/21/2004 10:50:30 AM Hi,
Could someone post the syntax for hiding a datagrid header please?
Moe
...more >>
Debuging Scalar-Valued Function in Visual Studio with date parameters Posted by Shannon Broskie at 7/21/2004 9:37:08 AM Hello,
I couldn't find a better newsgroup to put this post in. If there is one,
feel free to respond with that group.
I'm running VS .NET 2003 Ent Arch., tapping into a MS SQL 2000 database.
I am trying to debug a function that I wrote on the SQL Server. The
function has three parameter...more >>
Databinding Posted by Henry at 7/21/2004 8:02:58 AM Hi
I am new to ADO.NET and would like to know which method is better, using the
databinding feature of window forms controls or simply using code?
...more >>
typed vs strong typed dataset Posted by Brad Allison at 7/21/2004 7:30:52 AM I have been given guidance to create a typed dataset instead of a strongly
typed dataset to be used for a Crystal Report. My strongly-typed dataset is
being filled with the proper information and I need to copy this information
to my typed dataset. I guess maybe I feel stupid, but how do I refe...more >>
Create new DB in code Posted by joejohnsonwall NO[at]SPAM medscape-dot-com.no-spam.invalid at 7/21/2004 6:03:26 AM When opening a connection object, the connection string must name a
Database file that already exists to open. If I want to create a new
database file that does not already exist, how do I code ADO.NET to
create and open the connection object so I can issue an SQL "CREATE
DATABASE" non-query co...more >>
Prepared statement '(@ID int...,' expects parameter @ID, which was not supplied Posted by golanh NO[at]SPAM sqlink.com at 7/21/2004 4:52:45 AM i'm trying to use an sqlCommand as an UpdateCommand for a dataAdapter
which contains a changd Dataset.
Whenever i try to upadte - i generat a command with an Update
Statement from the original Select Command of the DataAdapter (using
DataReader which supplies the meta data = ColumnName, BaseT...more >>
call oracle ref cursor in vb.net to grid or any bound controls Posted by (rbutch NO[at]SPAM coair.com) at 7/21/2004 4:34:00 AM guys, im missing one little thing here and i just thought someone might be able to tell where that is.
im using an Input parameter, to retrieve a Ref Cursor from an Oracle stored procedure, and trying to display the information in a DataGrid object.
i'll include the ref cursor, but i know that's...more >>
Unable to update access database Posted by William Gower at 7/21/2004 3:29:24 AM I am trying to update an access database in a subdirectory to my asp app. I
keep getting an error saying that I need to have an updateable query. I
went into the directory where the database is located and opened the
database, it gave me the message that it was read only. I never set it to
re...more >>
ADO.NET Step by Step & Northwind Posted by Rob Nelder at 7/21/2004 3:21:04 AM I'm trying to work my way through this book, but keep having trouble
with the example programs.
The trouble is my version of Northwind seems to have a similar, but
different schema to that used for the examples.
I've been working around this, often by creating data views within my
Northwind...more >>
Server.MapPath Posted by William Gower at 7/21/2004 1:45:55 AM I am trying to run the following in my connection string
"Data Source = Server.MapPath('private\Union.mdb')"
The asp application is in c:\inetpub\wwwroot\Unit12 and the database is one
directory lower in private.
It keeps trying to map it to
'C:\WINDOWS\system32\private\Union.mdb'
Ho...more >>
Maintenance Rouitne Posted by jlapenta NO[at]SPAM entelsys.com at 7/21/2004 1:29:13 AM We are in the process of creating an Windows Forms application which
contains more than 100 tables. Many of these require “maintenance routines”
to update the information in the tables. I would think that many
applications require similar capability. I've worked my way through a
number of ...more >>
Connection String Posted by William Gower at 7/21/2004 12:21:43 AM How do I set up the connection string for an access database? I don't want
to access the physical location. I want to access the database in the
private directory of the Unit12 location on the server.
Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnection += "Data ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |