| DataGrid RowColChange (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I need to catch row change in recordset or dataGRID But I don't find any event. in Basic it was grid.RowColChange. Thanks for advise. |
|
| data i vs.net (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello all, How can I populate a datagrid with data from a MS Access database in VS.NET... Step by step please : ) newbie. /Treg |
|
| How to bind DataSource to a server control? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am trying to mimic the following link in VB.NET: http://support.microsoft.com/default.aspx?scid kb;EN US;q306154#references I'm not having any luck binding the child repeater to a datasource: asp:repeater id "child" datasource ' %# ((DataRowView)Container.DataItem) .Row.GetChildRows("myrelation") % ' runat "server" How would this same task be accomplished in VB? Of course, I need to be able to d... |
|
| Generate DataRelations from SQL Server (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Anyone know of a quick way to generate DataRelations from SQL Server? Perhaps some way of querying that would return table names and PK/FK column names? I know that you can get table names by querying INFORMATION SCHEMA.TABLES, but can't find any more information along this line. Using DataAdapter.FillSchema doesn't appear to pass down the information that I need. I am trying to create an in memor... |
|
| Clob datatypes within Oracle Stored Procedures (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a stored procedure that has an output parameter of type Clob. I need to execute this procedure and obtain the output. I'm currently trying to use the ORAOleDB.Oracle provider and getting nowhere. Can this be done using this provider? If not what provider should I be using? Does anyone have any examples of doing this successfully. Thanks Scott |
|
| SqlTransaction - question on documentation and behavior (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hallo, the online documentation of SqlConnection.BeginnTransaction() states .. avoid using other transaction management models, such as the one provided by SQL Server. How do I avoid other transaction management models? Does this only apply to stored procedures? What are other transaction management models I might use? Do I have to make special adjustments to my SqlServer? Why does SqlTransaction ... |
|
| Constraints not being checked on update (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| When I insert a new record, or update an existing record, the dataset is not checking constraints. I checked the option, and constraint checking is enabled. Any ideas? Scott Richardson COPIC Companies Denver, Colorado |
|
| Receiving this error...ADODB.Fields error '800a0cc1' (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Attached is my ASP page where I am trying to create an excel worksheet report using ASP technology. The error I continue to receive is as follows: ADODB.Fields error '800a0cc1'. Any help is greatly appreciated. |
|
| Reading all rows (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a program in which I want to check every row in a database to make sure the row that I am adding is not in the database already. Each row contains 8 fields. In VB 6, I could use a recordset, and use a NextRecord statement after checking a record until I reached the end of the recordset. Please help. |
|
| How do I query a Dataset (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have created a dataset and filled it with a number of tables and also created relationships between these tables. What I want to do is be able to cache all of the data that a user would use while visiting our web site. So, I grab all of the information about a user based on their id and throw it into a dataset. Now, I want certain information from that dataset based on other search criteria that... |
|
| Failed to enable contraints error? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Can someone give me some idea what this error means? Failed to enable constraints. One or more rows contain values violating non null, unique, or foreign key constraints. I have exactly one row in my database table. The table is as follows: Column Type Size Allows Nulls userId int 4 bytes F Key Field userName char 10 bytes T userPassword char 10 bytes T Since there is only one row in the table I'm... |
|
| ADO Interop accepting a late-bound recordset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am writing a .net object that needs to work with legacy ado recordsets passed from ASP applications. so i have the following function in my .net assembly public function RS REFRESH(byval rs as object) as adodb.recordset try rs.activeconnection getConnection 'function declared above rs.updatebatch() ' this works, that database gets updated '** here i get a type mismatch trying to disconnect rs.ac... |
|
| source code of connect to data sources: Oracle, mySQL,...? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| May May I have some source code which demonstrates how to connect and retrieve data from Oracle database, mySQL, and excell work sheet. Thanks in advance! Sincerely, Hugepig. |
|
| Howto: Create the autogen value for the DateTime element in the XML Schema? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello everyone! If to use the XML schema to create a dataset, what would I put on the right side of the autogen value codegen:nullValue "?" for the DateTime element? Whole element descriptions looks like xs:element name "date produced" codegen:nullValue "?" type "xs:dateTime" minOccurs "0" / Whatever I put there always gives me DBNull exception. Thanks. Julia |
|
| Adding Variables to Datarow (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm computing a bunch of totals by looping through a datareader. Is it possible, and I'm sure it must be, to create a datarow and populate it with those calculated variables and add that toa datatable and then to a dataset? Thanks, Jason |
|
| connection string for access database with dsn URGENT!1 (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| i have an access database Building, and i made a dsn "tower". i need the connection string(in c#) to connect to the database via this dsn. Actually, anyone can acces this databse even without knowing his path. and i need to know if it will be with oledb or odbc? |
|
| winforms datagrid paging? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I 'm using a datagrid to show a large amount of records. Is it possible to make some paging mechanism? Load the firts chunk of records, and load the rest whil scrolling? The preoblem with that is sorting. In my opinion it would be impossible to sort by clicking a column header if I do not prefetch all records. Any ideas? |
|
| Is there a max # of recs the OdbcDataReader can hold? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have an OdbcDataReader that should contain over 15000 records when I execute: dr cmd.ExecuteReader() The above command completes without issue. However if I do the following: Do While dr.Read() 'with no other code in the loop loop As soon as it gets to record 6080 this error is returned: An unhandled exception of type 'Microsoft.Data.Odbc.OdbcException' occurred in microsoft.data.odbc.dll Additi... |
|
| Concurrency violation (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am trying to update a row in a table, but I receive a 'Concurrency violation' error. I am filling a 'disconnected' DataRow using data from a Web Form. The data in the Web Form already existings in the database, I am simply trying to edit and save the changes. I am not using persistance of any sort. What am I missing? Thanks, Craig Buchanan Here's the code .... DS.table(0).row(0).NewRow DS.table(... |
|
| I cant connect via ODBC DSN. Help! (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| THIS IS A BIT LENGTHY BUT I SURE HOPE SOMEONE IS WILLING TO READ ALL OF THIS POST AND OFFER SOME ADVICE. THANKS IN ADVANCE. I created a little "Library" database in SQL Server 2000 for my ASP.NET web application, and I uploaded the *.MDF file to my web host's /db folder. The problem is that whenever I try to query something, I get this error message: ERROR [28000] [Microsoft][ODBC SQL Server Drive... |
|
| Please Help! Urgent...DataBinding and Modified Rows Not Working (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm down to the last minute on a deadline and this is driving me crazy. I have a dialog box with things like name, address, etc. If you edit anything in the main dialog, it doesn't mark the row as Modified. If you change anything in a "Name Details" dialog, it sets the row as modified. However, once the row is set to modified, everything set from the main dialog saves. Which makes no freaking sens... |
|
| error when updating the dataset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I am getting this error when trying to update my datasource from my dataset and I don't know why... Missing the DataColumn 'questionCategory' in the DataTable 'Answer' for the SourceColumn 'questionCategory'. SqlCommandBuilder scb new SqlCommandBuilder(cmd); cmd.Update(ds, "Answer"); I have three tables in my DataSet and they all have the correct columns in them when I fill the dataset. Questi... |
|
| Dynamically created DataSet/DataTable… now what? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm in the process of learning ADO.NET and have 2 questions I would like to ask. I am building a small utility in C# that will parse an ASCII text file and build a brand new Access database. For this problem/solution, when I get a new text file, I make a new database and kill the old one. I use Access because it's very convenient to work with and I'm comfortable with it. Plus, my projects just don... |
|
| Shape Append command in ADO.NET ? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is Shape Append command for getting Hierarchical Rowsets in ADO valid in ADO.NET for getting Hierarchical DataSets ??? SHAPE {SELECT au id, au lname, au fname FROM authors} APPEND ({SELECT au id, title FROM titleauthor TA, titles TS WHERE TA.title id TS.title id} AS title chap RELATE au id TO au id) This doesn't work for me in ADO.NET ?? Any insight will be very helpful. Thanks Biswajit |
|
| Multiple table with relationship. (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm a newbie to ADO.Net. I have 3 tables i.e. Employee, Employee History and Employee History Details. All are linked with relationships. Currently Employee has been bind to DataGrid. Questions: 1. How to load the data to show 1 employee that I clicked to another form with all the history and the history details. I've tried to use 3 DataAdapters with 3 seperated command text to fill the data s... |
|
