| Source of a DataGrid : DataTable vs DataView (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I post this question to the [aspngdatagridrepeaterdatalist] list some days ago but I haven't got any answer, probably somebody here could help... thanks, Rolando Is there any diference between assigning a DataTable or it's DefaultView as the DataSource of a DataGrid ??? 1) MyDataGrid.DataSource MyDataTable; 2) MyDataGrid.DataSource MyDataTable.DefaultView; or they're just the same thing... thanks,... |
|
| Adding Columns to a Dataset Table (4 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Marcie Jones marciejones@yahoo.com HI all, I am trying to build a Dataset Table on the fly and I have used the following code: (Stolen from Programming Data Driven Web Applications with ASP.NET) Dim myDataset As New DataSet() Dim myRow As DataRow Dim myTable As DataTable myDataset.Tables.Add(New DataTable("Report")) myTable 3D myDataset.Tables(0) myTa... |
|
| Looping throught a Dataset Table (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Marcie Jones marciejones@yahoo.com Hi all, This is hopefully my last question about dataset tables. Here's the deal, I'm converting an Old VB 6 dll to a .NET class. What it used to do was : 1. Create an Adodb.Recordset (out of scratch because that's what it was returning) it would create a recordset of about 60 rows. Then the calling program would tre... |
|
| Dataset Question (12 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi What would happen to a dataset where, first off, I fill it from a db like so "select * from addresses" to get the whole table, then subsequently did a "select * from addresses where lastname 'SMITH'" assuming of course 'SMITH' was already in the dataset. would the table be replaced with just instances of SMITH or would SMITH be updated, or nothing? What about if I initially did a "select * from... |
|
| Using parameters with ADO.Net (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by Mitch Denny mitch.denny@warbyte.com I have an ASP.NET subroutine that calls an MS Access database query. The query takes one parameter and is as follows: SELECT BOOKS.Title 46ROM BOOKS WHERE BOOKS.Title Like [enter string]; This query works within MS Access but not within the ASP.NET. Can anyone see anything wrong with the subroutine? The aim of the s... |
|
| DateTime (5 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I am trying to insert the DateTime.now but I'm getting a "Syntax error converting datetime from character string" here is the code:: strInsert "Insert Into html ( ID , BroadcastName, html, timestamp) VALUES ( '" & n & "', 'PB TP NN OP lists 3/5/02', 'Y', 'DateTime.now()' )" cmdInsert New SqlCommand( strInsert, conPrimedia ) conPrimedia.Open() cmdInsert.ExecuteNonQuery() conPrimedia.Close() Respons... |
|
| Option Strict settings (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Instead of changing this at the project level, is there anyway to default this to ON for all projects, especially new ones? Patrick Logan, MCSD Original Message From: William (Bill) Vaughn [ mailto:billva@nwlink.com mailto:billva@nwlink.com ] Sent: Wednesday, March 06, 2002 10:59 AM To: aspngdata Subject: [aspngdata] RE: DateTime Did you have Option Strict On ? This might have helped eliminate thi... |
|
| Sorting a Dataview (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi, I have a column in a dataview that is being sorted and I am getting unexpected results. The column has the following values mixed up in 4 datarows: TA TZ T\ T When this column is sorted, the rows are changed to: T\ T TA TZ It seems like this doesn't conform to what the ASCII values of these characters are. Anyone have any ideas? Bill |
|
| Using DSNs (3 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi all, I had been using data source names (DSNs) in my ADO connection strings before the .NET days, but it looks like I cannot use DSNs with the new .NET Data Provider. How are people getting around this? I can't imagine that everyone is hard coding database names directly into the connection string. Any ideas? Thanks much, Muk Get your FREE download of MSN Explorer at http://explorer.msn.com/int... |
|
| Connection to DataBase via ODBC problem... (2 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspngfreeforall] to [aspngdata] by alotofmail@tripleasp.net alotofmail@tripleasp.net Hi all, I'm trying hard to make database connection works and it seems either to bug or malfunction. I explain myself... I have a Microsoft Access 2000 simple (i mean SIMPLE :) ) database which i want to use in an asp.net application. So, as i read, i want to made a oleDbConnection object that connect ... |
|
| using a connection in a webservice! (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Moved from [aspsqlhowto] to [aspngdata] by Dana Coffey denigma@bellsouth.net I am trying to use a connection in a webservice. I can open the connection but next time I call a function that is supposed to use this open connection the object is nothing? What can I do to keep this object alive? David Everything in this e mail and any attachments relating to the official business of Isonet ZA is propr... |
|
| Master/Detail Forms (4 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| I got this funny error when building a Master/Detail form, anyone know what this means and how to fix it? BC30456: 'DataItem' is not a member of 'System.Web.UI.Control'. Source Error: Line 73: Line 74: ItemTemplate Line 75: li %# Container.DataItem( "BroadcastName" ) % Line 76: %# String.Format( "{0:c}", Container.DataItem( "sent" ) ) % Line 77: /ItemTemplate Sam Cromer Web Developer Bellevue Data... |
|
| dataset (10 replies) |
| ASPFriends.com 'aspngdata' list |
| This might be a silly question. I'm build an ASP.NET application that is going the be doing a lot of reporting. I'm building a generic reporting system the will build disconnected DataSets, bind them to a data grid and allow the user to edit, sort, find record and filter. My question is what rules should I use to kill the recordset. I figure they will timeout at some point or I could have somethin... |
|
| Queries against DataSet (5 replies) |
| ASPFriends.com 'aspngdata' list |
| Is it possible to execute a query against a DataSet. I'm interested in getting statistics on a database table and would prefer not to have to use ExecuteScalar() in order to retrieve counts on records. Is there a way I could execute a SELECT COUNT() statement against a DataSet? Thanks, Sean ************************* Sean Bytnar MCSE, MCP I Illinois State University Technology Specialist Campus Box... |
|
| Using a Component for Data Access (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hey all, I went to the local VS.NET launch Wednesday, and one of the demos used a component for data access. He made it look very easy, and he had it return a strongly typed dataset, which I thought was really cool. So today I've been playing around with it and getting somewhat frustrated. First of all, is anyone else using a component for data access in ASP.NET? If so, do you have any general rec... |
|
| Database Locking (8 replies) |
| ASPFriends.com 'aspngdata' list |
| Hey all, We're in the midst of rewriting a classic ASP application that requires very strict locking of the data while in use by a process. In the past, with ADO, we had the ability to set Optimistic and Pessimistic locking on data so that access to data while in use by another user/process would be restricted. My question is, in ADO.Net, what are the strategies that we can employ to mimic the sam... |
|
| NOT ANSWERED BEFORE: Using a Component for Data Access (3 replies) |
| ASPFriends.com 'aspngdata' list |
| I posted this a couple days ago w/ no response. I know this isn't a mission critical thing, but I'd really appreciate someone who has used the component functionality for data access tier to share your thoughts/experiences. Hey all, I went to the local VS.NET launch Wednesday, and one of the demos used a component for data access. He made it look very easy, and he had it return a strongly typed da... |
|
| Jet/Access Problem... (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hello All, I am currently developing a simple ASP.NET App that uses a Access 97 Database as a data store. I am connecting to this database via Jet OLEDB 4.0 Provider, and in this very early stage of development, I've got stuck in a problem. When I connect on the database (in the app) everything goes fine in the 1st time. But when I try to reconnect on the 2nd time, the OLEDB provider claims that t... |
|
| RDO Doesn't work (4 replies) |
| ASPFriends.com 'aspngdata' list |
| RDO doesn't work after I installed the release version of Dot Net. How do I do to fix it? |
|
| finding out storedProc return schema at runtime? (3 replies, VIP) |
| ASPFriends.com 'aspngdata' list |
| Have done this trick in ad hoc queries to get a DB schema: SELECT * FROM TABLE NAME WHERE 1 3D0; So it returns a result set with no records, and I can go against that to figure out the schema. The question is, how can I do this for stored procs? Like when you create a typed DataSet, and drag a stored proc onto it, and it creates the schema. I have a need to do this at runtime, for a development su... |
|
| oledb connectionstring in a external .vb file (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Hi I want to have the connection string to my db in a seperate class.vb file, so I dont have to change the link to the db in all the files when I change path or db. Conn string.vb Namespace nspUniOleDB Public Class conn string Public ReadOnly Property OLEDBConnectionString() As String Get '***************************************************************** Return "Provider Microsoft.Jet.OLEDB.4.0;Da... |
|
| Question About Datasets (2 replies) |
| ASPFriends.com 'aspngdata' list |
| I have a question about datasets... If I were to create a schema from a Database table structure, would I be able to do the following: 1. Create an XML file that adheres to that schema. 2. Create a new dataset by reading in the XML file and schema. 3. Create a DataAdapter and call the update method, passing the DataSet to it and have the SQL tables populate? Seems like I should be able to do this,... |
|
| Does .Fill close the connection? (9 replies) |
| ASPFriends.com 'aspngdata' list |
| I have a function where I want to use an open connection to 1) retrieve a DataSet then with the same open connection 2) retrieve a DataReader What I'm finding is that after I "Fill" my DataSet: ds new DataSet(); dtaAdptr.Fill(ds,TABLE NAME); that when I go to use the same connection that was open when I played with the DataSet on another task that it tells me: ExecuteReader requires an open and av... |
|
| ListView and binding (2 replies) |
| ASPFriends.com 'aspngdata' list |
| Does anyone have a decent sample to show how to bind a datareader's resultset to a listview control. There are plenty of samples for grid, combo etc. but the listview doesn't seem to work the same way. Any help would be appreciated. Outgoing mail is certified Virus Free. Checked by AVG anti virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 Release Date: 2/28/2002 |
|
| SV: Binding DropDownList to multiple database columns (2 replies) |
| ASPFriends.com 'aspngdata' list |
| If you have these values in one table (dataset), one way would be to iterate throught the table with a loop. 20 Dim RowsCount As Integer 3D dstYourSet.Tables( "tblItems" ).Rows.Count Dim i As Integer For i 3D 0 To RowsCount Dim myId 3D dstYourSet.Tables( "tblItems" ).Row( i ).Item( index of your id col ) Dim myItem 3D dstYourSet.Tables( "tblItems" ).Row( i ).Item( index of your item col ) mydropdo... |
|
