| InvalidOperationException - Cannot create file mapping error (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| When connecting to one of my Sql Server 2000 databases running locally using SqlConnection, I get the following error: InvalidOperationException Cannot create file mapping This is thrown during a call to SqlConnection.Open(); After this exception occurs, I can continue to use the connection without any further (apparent) problems, running multiple queries against it. This is only happening on one ... |
|
| Sorting Dataset (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| How do you move rows up and down the order of the dataset and how do you insert a row in a specific row and make all the rows after it go up one. Is there an easy way of doing this or are we talking about something more complicated like creating another dataset and reading one to the other and designing an algorithm to do do the sorting. Regards, Chris. |
|
| checking for null parameter values (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| HI There, How can I check to see if the parameter is returning null? I have tried many other legacy asp ways of doing things but nothing is working. Could smeone help me out with my code. Sean if myCommand.Parameters("@errmsg1").value "" Then do something else do something else end if |
|
| Caching problem? (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have a problem and I am not sure but it may be related to the way the system caches information. I have a web service that retrieves data from a database. The select statement is quite simple and I will include it below: SELECT departments.department, employees.clockedin, employees.FName, [time].ireason, [time].oreason, [time].oDate FROM ((departments INNER JOIN employees ON departments.d... |
|
| Dataset question (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have a listbox that is bound to a dataset with 1 table that has 4 fields. The first field is displayed in the listbox. When I click on an item in the listbox I want to fill in a text box with the info found in the 3rd field of the "current" row. What is the best way to do this? Thanks! |
|
| What is a "strongly typed dataset"? (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have seen this mentioned several times, but I have not yet found a comprehensive definition for the term. One reference that I saw indicated that intellisense would work better with such a beast, but with no explanation of how or why. Ken |
|
| Sybase.Data.AseClient.dll (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| How do I get this installed, so I can use this assembly against an ASE? |
|
| SqlTransaction and Dispose (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have looked in the documentation and I have looked in Google, but I cannot seem to find an answer: If a transaction has been opened and the transaction is disposed before calling Commit or Rollback, am I guarenteed that the transaction will be rolled back? For example: try { sqlConnection.Open(); using(sqlTransaction sqlConnection.BeginTransaction()) { /// do stuff but do not call sqlTransaction... |
|
| No Smart Device Choice (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| How come My VB.Net environment does not contain the Smart Device Application Template to open the Smart Device Application Wizard. Any Ideas? Thanks Paul |
|
| Child Table (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| In ado.net cannot have table as child of more than one parent. Is there a way around this? |
|
| MS Oracle Data Provider - Null password (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, My machine has an Oracle 9i client that uses OS authentication to log in, so we use a / for the user name and a blank password. I am having trouble logging into the database with the following connection string: this.MSConnection.ConnectionString "user id /;data source devd;password "; I get an ORA 01005: null password error. This connection string works fine with Oracle's ODP.NET driver. I ha... |
|
| Sub query using parameters with OleDb Data adapter problem (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I am trying to display the results in a form from a complex query that uses parameters. Both the outside and the inside query use parameters. I can get the outside query to run but when I use a subquery with parameters for a condition in the main query I keep getting DB E BADORDINAL error. Any help or suggestions are greatly appreciated. Jean |
|
| Creating a login function in ASP.NET using XML (visual basic) (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi. I'm trying to create a login page in asp.net using information from an XML document. (in visual basic) I've tried Rowfilter to find a cell with the 'username' and then match this with the 'Password' cell on the same row.... allow page to redirect if these match: If 'username' match 'password' then "redirect to next page" else "Error message" Does anyone know how to create this login function? ... |
|
| Is there a .NET version of ADOX. (9 replies) |
| microsoft.public.dotnet.framework.adonet |
| ADOX is the extension ADO. And I wonder if there is any extension for ADO.NET? I need a object model in C#, with which I could easily access the schema of a database. |
|
| Obtain a list of available SQL Servers (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| HELP! Can anybody help me how to optain a list of all available sql serves in my Network using only ado.net libraries? |
|
| Iterating through a datarelation's rows (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| This is what I get for trying to do things the ADO.NET way instead of using plain ol ADO.. Anyway, I have two related tables. I've finally hooked em up so that they're in synch, but now I need to be able to iterate through the child table's rows, and I can't figure out how. For instance, with a single table I can do thus (adding rows to a treeview): For i 0 To DsEnt1.R Relations.Count 1 nd tvClien... |
|
| MDAC Dependency (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I understand that ADO.Net has some dependency on MDAC 2.6 or later (from MSDN documentation). Please correct me for the following: "If I am going to use either System.Data.SqlClient OR System.Data.OracleClient namespaces for data access, as they directly communicate with database (without the support of respective OLE DB drivers), MDAC dependency can be avoided" Rao TRN |
|
| dataset tables (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Please help with this problem: I have a sql DB table which I can load into a dataset and a XML file I load into a seperate dataset. I need to compare these two datasets and get a list off records that match a certain column. the SQL table and the xml have the same db columns. couple of questions: 1) Is this the best way? 2) If I need to use 2 tables in a dataset for this, how do I load an XML doc ... |
|
| Oracle Provider (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have been having problems with connecting to Oracle and I am wondering if it might possibly be the drivers that I am using. I believe I had a number of people tell me that they did not have any luck with the Oracle OLEDB Provider, that they used instead the Microsoft OLEDB Drivers for Oracle. My problem is that I create an connection object, which succeeds. When I then go to open the conn... |
|
| dataAdapter.Update() sql transactions (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, When I try to dataAdapter.Update() I always get a "Syntax error in INSERT INTO statement". If i take a look at the InsertCommand or cmdInsert property of the dataAdapter, it's just fine: "INSERT INTO NEMT REPORTS (PLANT ID, ACCOUNTABLE, SUBMITED, YEAR, KPI ENERGY, KPI WATER, KPI WASTEWATER, KPI GWP, KPI ENERGYTCOP, KPI ENERGYCOST) values (@PLANT ID, @ACCOUNTABLE, @SUBMITED, @YEAR, @KPI ENERGY,... |
|
| Select one row from a xml file (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a xml file which is created by myDataSet.WriteXml(). myDataSet contains one datatable which in turn contains several thousands rows. Now I want to select one row (that can be done by a simple select in sql) from the xml file. Do I need to restore the dataset first from the xml file? Or I can work on the xml file directly? Thanks. Michael Posted Via Usenet.com Premium Usenet Newsgroup Se... |
|
| :cry: Saving datatables into database (5 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, What i'm trying to do is as follows: 1) 3 txtboxes, 1 Add button, 1 Submit button, 1 datagrid 2) when the page loads, the user will be able to type in texts in all 3 textboxes. 3) Then the user clicks on add button, the data that the user just type will be shown in the datagrid. 4) the items will add on whenever user clicks on add. 5) then after which the user has finished with the adding ... |
|
| Sorting datagrid-dataview-datatable (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| datagrid is bound to dataview.. the rows will sort when clicking on datagrid column headers... however, selecting a row after sort reveals that the datatable still maintains original order. rows were not sorted. how do i ensure underlying datatable gets sorted with datagrid sort? thanks |
|
| Checking Return Codes from SQL Server (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I am calling an SQL Server 2000 stored procedure in my VB.NET code, where I am inserting rows into a table. How do I pass back the value of @@ERROR, that is set in my stored procedure, to my VB .NET code so I can test whether the update was successful? |
|
| Import dbase 5 (.dbf) file into MS SQL2000 tables (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have hard time trying to import some dbase 5 (.dbf) files into MSSQL 2000 tables using ASP.Net/VB.Net. Can anyone please point me to the right direction? Many thanks, |
|
