all groups > dotnet ado.net > april 2004 > threads for monday april 5
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
Copying a Row in a datagrid
Posted by Dean Landry at 4/5/2004 10:26:55 PM
Hello,
I am trying to duplicate a row in my datagrid. Below is my code. After I
duplicate the row I manually change one of the primary key fields so that
there isn't a problem with duplicate rows. But from time to time, after
using the function below, I get the "The Changes you requested t... more >>
When mergint dataset, edited rows getting added once again.
Posted by Bibin at 4/5/2004 6:18:02 PM
Dear All,
I am developing an application in .Net. I put one Business Logic Layer and
one Database Layer.
In the user interface I will be picking all the records, will be editing.
then I will pass the edited dataset to the business Layer.
In the Business Layer, It will be taking the change... more >>
Stored Proc using MS Application Blocs
Posted by Schoo at 4/5/2004 5:04:05 PM
I have an ASP app that works but I am trying to make a change that is not
working.
The app uses MS Application Data Blocks to call a stored procedure. The way
I originally designed it, the user opens the first screen, selects an item
from a list and the program calls an object I created which... more >>
Nothing showing in results
Posted by dazza at 4/5/2004 3:16:03 PM
I've been having probs for weeks with VS.NET / ASP.NET and just established that even a simple form doesn't work. Please help; its put a hold on my project for weeks
Just ran a simple exercise from a sample chapter in this book
ran this real simple exercise: http://www.programmersheaven.com/other... more >>
hierarchical data headache
Posted by sklett at 4/5/2004 2:35:00 PM
** repost with more info **
I am not very good at SQL queries. I just can't get it. With that said, I
need some help really bad figuring out a way to get some data to present
hierarchically.
Here is the sitch'
I want to display product FAQs like this:
PRODUCT
FAQ CATEGORY
F... more >>
GetOleDbSchemaTable question
Posted by burak.gunay NO[at]SPAM xpandcorp.com at 4/5/2004 2:27:53 PM
Hello,
I am trying to retrieve the list of tables in local oracle database,
"SKILLS".
When I use the following set of commands
strsql = "select TABLE_NAME from user_tables"
objconnection = New OleDbConnection(strConnection)
da = New OleDbDataAdapter(strsql, objconnection)
da.Fill(ds, ... more >>
Invalid attempt to Read when reader is closed
Posted by joyce_stansell NO[at]SPAM norampac.com at 4/5/2004 1:59:11 PM
Help. I am new to VB.NET 2003. I have written an application for SQL
CE (also new at) and I am very frustrated. This is the code:
strSQL = "INSERT INTO ROLL(RNO, SPCD, UPDATES, CONTIME, STCD,
PSCD, LOCD) " & _
"VALUES('" & strPrevRoll & "', '" & strSpeed & "', 0, '" &
datCurre... more >>
Datagrid columns using AutoGenerate via the autoGenColumnsArray private member array collection (reflection)
Posted by googlegroups-gaijin42 NO[at]SPAM sneakemail.com at 4/5/2004 1:45:28 PM
I have seen several people looking for a way to access the Columns
collection when using the AutoGenerate = true option. Some
people have gotten so far as to find the private autoGenColumnsArray
that has the information, but we as developers have no way to access
this information.
I have com... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Update Question
Posted by ion at 4/5/2004 1:25:38 PM
In my application I use typed datasets as my data container classes (data
persistence). My db structure has many table relations (mostly one to one).
I have main table that maps to 4 different tables using an ID which is auto
incremental. So, when I persist this info while the user inputs it, ... more >>
ODBCDataReader dBase IV
Posted by Kevin ghantous at 4/5/2004 11:56:03 AM
Hey
I am attempting to read data from a dBase IV database. After hours of struggling, I finally got my connection string working -- so I felt I was pretty well off. I was wrong
The problem I'm having is when I perform an ExecuteReader, I get back a ODBCDataReader, which is fine. I can call th... more >>
update problem in dataset....
Posted by Raphaël Désalbres at 4/5/2004 11:52:15 AM
Hello,
I've the following problem:
A simple table (Users) with 2 fields, UserID (Primary key) and UserName
The code:
dim cnn as new oledbconnection
cnn.connectionstring="Provider=Microsoft.JET.OLEDB.4.0;Data Source=" &
server.mappath("bd1.mdb")
cnn.open
dim da as new oledbdataadapter... more >>
Typed Dataset: Stetting DataColumn-values
Posted by Michael Maes at 4/5/2004 11:14:51 AM
Hi,
How do you set the settings (like MaxLength, ReadOnly, DefaultValue, =
....) in a DataColumn of a Typed Dataset.
I know you can do this in Run-Time (eg: =
dataset.datatable.datacolumn.MaxLength =3D 4) but I want to do this in =
the XSD Schema-Designer (or XML-file)
Thanks for any hint,... more >>
getting back a data row with a PK
Posted by Brian Henry at 4/5/2004 11:07:47 AM
Hi,
I have a dataset with a table, the table has its primary key set. How can i
get back a specific data row from that table by using the primary key only?
thanks
... more >>
Reading a lot of rows, how to get better performance without GetRows() ?
Posted by Thomas Jensen at 4/5/2004 9:35:41 AM
Hi,
I'm replacing a VB application with a .NET application written in C#.
Previously I have been using the GetRows() function of ADO recordsets
quite extensively, because in the case of the old application it would
lower data retrival time several times.
I think the problem is that my dat... more >>
FileStream GURU Help - Filestream and Icon files .NET SQL2000
Posted by rcl58 NO[at]SPAM iglou.com at 4/5/2004 9:27:55 AM
The code below gives me an "Out of Memory" exeption when the
PictureBox1 is assigned. If I use the same code but relpace the
CIRC.ICO with a Test.JPG file it works! Is there something special
about .ico files? Suggestions?
Thank
Bob
Dim fs As New FileStream("c:\CIRC.ICO", FileMode.Open,
... more >>
Data Adapter Wizard
Posted by Parveen at 4/5/2004 9:11:04 AM
I want the data adapter wizard to automatically generate update, insert,
and delete statements from a given select statement if the select statement
is a multiple table query. I know this works with single table select statements.
Does anyone know how to make this possible with multiple table s... more >>
Error with OracleParameterCollection after 1.0 to 1.1 upgrade
Posted by hilary321 NO[at]SPAM yahoo.com at 4/5/2004 7:20:07 AM
Probably been asked before but I cannot find a resolution:
I receive the following error when calling a stored proc in Oracle but
this works with v1.0 of the framework:
The OracleParameter with ParameterName 'p_Subscriber_ID' is already
contained by another OracleParameterCollection.
Any ... more >>
dataviewmanager problem
Posted by jpribele NO[at]SPAM bglgroup.com at 4/5/2004 5:33:21 AM
sorry for the repost i just want this to be its one thread.
Please tell me what I am doing wrong.
I have the following DataTables
Establishments (Id, <other stuff>.... )
Bookings ( estabId, <blah>.... )
I created a DataSet with a relationship between id and estabid. This
all works great... more >>
|