all groups > dotnet ado.net > july 2004 > threads for tuesday july 27
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
DataView RowFilter
Posted by Mike at 7/27/2004 11:31:23 PM
Hi,
I have the following code, which should allow me to only show a certain =
number of items in a listbox:
DataView dv =3D new DataView(dataSet1.Tables[ISSUE_TYPE_TABLE], =
"IssueAreaDesc=3D'" + txt + "'","",DataViewRowState.ModifiedCurrent);
types.DataSource =3D dv.Table;
t... more >>
Use Ado.net to update individual cells in Excel
Posted by Lisa at 7/27/2004 7:24:23 PM
Hi!!
Can any one help me get this info -
Update individual cells in Excel using ADO.NET
I keep getting error in the update statement.
Thanks for any help in advance!!
Here is my code -
Dim connString As String
connString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
... more >>
Build new Access database from .NET application.
Posted by Rich Wallace at 7/27/2004 3:02:45 PM
Hi all,
I'm currently working on a new solution that entails extracting key data
from MS SQL Server (2000) and essentially export a dataset to an Access
database. I may have been overthinking this but here's what I'd like to do:
I have an XML representation of the MDB structure I need to bu... more >>
Determining Field Size
Posted by Bob Avallone at 7/27/2004 2:51:06 PM
I am trying to find a simple way to determine the field size of a field in an Access table. I am writing in VB.NET Windows application. I would like a code snippet that I can get to work. I found some example on the Web but I couldn’t get them to work. I will be grateful if you can help me with th... more >>
Strange new concurrency issue
Posted by Earl at 7/27/2004 1:42:55 PM
My Update logic worked .. and now it doesn't. I went back, examined the
stored procedure carefully, examined the table structure carefully, and
examined the parameters collection carefully. All names, datatypes, and
sizes match up. In this particular table, all values can be set to Null
except f... more >>
data relations question
Posted by Brad Allison at 7/27/2004 1:09:41 PM
I have three tables: clubListing, clubCollection and eventDetails. Being a
newbie I am having problems in setting the relations.
The clubListing table contains the fields clubID (primary key) and clubName.
clubCollection contains no primary keys. It contains two columns, clubID
(there can be... more >>
Data Access Block and Identity Column Return...
Posted by Mark Essex at 7/27/2004 9:18:39 AM
I am using the SqlHelper class from the Microsoft Data Application Block and
had a question about returning an Identity Column.
Basically, I have a form with a grid bound to a DataSet. The user can, for
example, Add a new record. When they do this, and press Save, I call the
ExecuteDataSet m... more >>
|