| Update just quit working (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have some code in a button that has been working but just all of a sudden stopped. Don't know why yet. Anybody have anything obvious to check? The code in the button looks like this: SqlDataAdapter1.Update(DsInvHrsPaid1, "Invoices") SqlDataAdapter2.Update(DsInvHrsPaid1, "Hours") SqlDataAdapter3.Update(DsInvHrsPaid1, "Paid") If I enter values into the Hours or Paid table and press Update and then... |
|
| Access Catalog Table Names Using ADO.NET (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Can someone tell me how to access MS Access table name from ADO.NET? In the old way, I'd use ADODB for connection, then use ADOX for catalog to get to those table names. How do I do this in ADO.NET? Your advice is appreciated. |
|
| Deploy .NET Framework with ADODB (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I've developed an application that uses .NET SQLClient to get data from an SQL Server and ADODB to get data from a Sybase server. All work fine on my development machine. I tried to deploy the application on a production machine that has .NET Framework SP2, MDAC 2.7 SP1 as well as the ODBC driver for Sybase installed. Apparently the server is missing the ADODB.dll that .NET Framework uses to commu... |
|
| How do I use DataColumn.Expression to sum a subset of child rows? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have two tables like so: Table1 columns: Company, Bank1, Bank2 sample rows: ABC, 100, 200 XYZ, 430, 245 Table2 columns: Company, Bank, Balances sample rows: ABC, Bank1, 100 ABC, Bank2, 200 I also have a data relation between Table1, and Table2 on the Company column. My question is can I use the DataColumn.Expression property for Table1's Bank1, and Bank2 columns to calculate the totals autom... |
|
| Adding a Record to SQLServer through ADO.NET DataSet and Managed C++ (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I was wondering what are the steps involved in adding a record to SQLServer through ADO.NET DataSet. What I am doing currently is as follows: DataRow gc* pNewRow pInsertTbl NewRow(); pNewRow set Item(S"TestColumn", S"TestValue"); pInsertTbl Rows Add(pNewRow); pDBAdapter Update(m pP2PDBDataSet); pInsertTbl AcceptChanges(); While this adds a record to the dataset, it does not reflect in the data... |
|
| non-busy waiting for an external INSERT (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I would like my .NET program to stay in sleep state (i.e. no consumption of CPU cycles) until some external program inserts a record in a specific table of a specific SQL 2000 database. Then my .NET program should wake up and execute an handler. The best would be if my program also received an ID of the inserted record. Anyone has suggestions on the best way of doing this in the .NET platf... |
|
| Proper way to delete a DataView (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| All, I created a expression based column in a table: tbl.Columns.Add("FullName", some expression)"); I then created a DataView: DataView dv new DataView(tbl); dv.Sort "FullName"; At a later time I decided to delete the expression based column from the table: tbl.Columns.Remove("FullName"); tbl.AcceptChanges(); // causes error When the AcceptChanges() executes an exception (IndexOutOfRange Exceptio... |
|
| Datasets - best practices? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I've learned an incredible amount about .NET data access in the last few weeks, thanks in part to the generous people who watch this newsgroup, but a few lingering questions remain. One is this: My application, for various reasons, needs access to various tables in my database at different times. Currently, I have a few different strongly typed datasets defined, and when I need a dataset I ... |
|
| Newbie (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Sorry, but can i know what is a 'typed' dataset ? (I have only heard of datasets, not typed datasets). |
|
| DataSet and SQL Database engine. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am sure I am missing something, if so please point out my misunderstanding. I have taken the trouble to define tables and relationships using Enterprise Manager. Now I would like to star adding data to those tables. My tables have a simple relationship (there are four tables each has one key relationship with another). A: aid (PK) a bid | B: | bid (PK) a b cid | C: | cid (PK) a b c did | D: | di... |
|
| RegEX Problem/Bug (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi All, I discovered somehow a bug in the Regex.replace. Look at the following MyText @" body background "http://www.personalromance4you.com/%FOLDERNAME%/background.gif"" MyOutput Regex.Replace(MyText,@"%FOLDERNAME%","German/images"); The Output will be body background "http://www.personalromance4you.com/German/images/backgroundgif" Notice how the dot got stripped off from the filename "background... |
|
| DataAdapters, SQL Server, and Oracle (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is it possible to join two queries, one from Oracle, the other from SQL Server, into the same DataSet object so I can relate them? Ive tried a few different ways and they all fail. Oracle has a native DataAdapter object; so does SQL Server. How can I marry them into a generic DataAdapter object so I can add another table, then use my DataRelation object? Thanks |
|
| How to Transfer Data from One Database to another (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| VB.NET ASP.NET ADO.NET Please Help !!!!!! Hallo ! To concentrate data from our companies, I have to transfer Data from our Pervasive Databases (Data Sources) to ONE central Database (SQL Server 2000/MSDE) To Read Data I am using ODBC (PervasiveOLEDB to slow) and OLEDB to connect to the Target Base. Reading Data works. My problem is how to write the data in to SQL Server with ADO.NET !! I need this... |
|
| Oracle Access on Remote Web Server (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I'm having a problem accessing a remote oracle database on a ASP.NET web server. The web server is configured as an Oracle Client (V8.1.6) and has the Oracle OLE objects installed. The Server is running Windows 2000 with just the .NET components installed (as per the .NET setup CD for remote servers). I'm running an ASp.NET app that works on my local development computer (Win2000 with VS.NET i... |
|
| Storage of Connection String in .config file (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| In my brand new VB Application called TTS I've created a TTS.exe.config file. The file looks like this: ?xml version "1.0" encoding "utf 8" ? configuration appSettings add key "ConnectionString" value "InsertConnectionStringDataHere"/ /appSettings /configuration I have then tried to fetch the value by using the following code behind a button on my main form. The code looks like this: **** Start of... |
|
| SqlCommandBuilder.DeriveParameters and multiple sp owners (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I am having a problem with the DeriveParameters method of SqlCommandBuilder. I have two stored procedures with the same name, but with different owners. SqlCommandBuilder.DeriveParameters appears to use the stored procedure sp procedure params rowset. In particular, it appears to use the default value for the @procedure schema parameter, regardless of whether or not an owner is specified a... |
|
| Generate DataSet does not work? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is it true that the Data | Generate DataSet wizard will not work with any managed providers except the SQL Server and OLE DB providers? Thanks, Bill |
|
| A typed dataset can be filled from a web service ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| The webservice returns a dataset with the same tables (same schema) like the typed dataset. But when I try to do this: DataSet wsDataSet myWebService.GetDataset(); typedDataSet (typedDataSet)wsDataSet; I get an InvalidCastException. Thanks for any advice. |
|
| How use Parameters.Remove (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have two buttons on a form. These buttons call code that changes the command.text for the query that retrieves records for a grid on my form. Button one's command.text is completely different from button two, in that, they each define different @variables for the selction. I am sure there is a way, prior to running each new selection, to remove old parameters but I don't know how. I have tried a... |
|
| Empty Dates, not NULL dates (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am pulling records from sqlserver by stored procs into a sqldatareader. From this datareader I am populating my custom object like so: Employee.Name (string)myDataReader["Name"].ToString(); Now for my DateTime type fields/properties of my class I am having trouble loading up a value when my dates are returning null. Cusomer.QuitDate Convert.ToDateTime(myDataReader["QuitDate"]); I need to populat... |
|
| How to retrieve identity column with GetOleDbSchemaTable (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I'm trying to find identity columns for a given database in SQL Server 2000. Which OleDbSchemaGuid should I use? Is there any other ways to do that? Thank you for you help. Jean Baptiste. |
|
| SqlCommand is currently busy (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am getting the following error: SqlCommand is currently busy open or fetching This happens in a form that the user uses to accept payments on account. The DB is updated and/or inserted. If the user tries to immediatly take a payment this error occurs. If a few seconds elapse the error does not occur. Has anyone encountered this? If so, where or how did you find the solution? TIA, Roy |
|
| Q about ADOX (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I made a tool i VB6 that uses ADOX to get hold of the database definition and the automatically create all CRUD procedures in the DB. With ADO.NET i can t really find the substitute for ADOX, any suggestions /John |
|
| DataRow Question (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| The following code compiles and works: DataRow aDataRow aDataSet.Tables[0].NewRow(); but isn't there any way to replace the [0] with the name of the table eg aDataSet.Tables["tableName"].NewRow() thanks grs |
|
| Adding temporary colums to a DataSet in an XmlDataDocument (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I want to add temporary colums to a DataSet in an XmlDataDocument. I have found no way to do this. The idea is to add some data for an filter, but I don t want to store this data in the xml File. Has anyone an idea? Thanks and regards, Christian |
|
