| 'sa' is not defined as a remote login at the server (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| My web form is getting the following error when trying to read from my SQL Svr 2000 db (on db server): "Could not connect to server 'MyServer' because 'sa' is not defined as a remote login at the server." And the documentation is confusing me re: what i should do to resolve it. Do i need to set up a linked server or a remote login? I only have the sa user set up, and i didnt see a property for set... |
|
| Alphabetizing (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Can anyone show me some code that alphabetizes a DataTable (within a DataSet)? I know that you're supposed to be able to use the .SELECT method...but I cannot figure out how to use it to alphabetize a DataTable. This code creates a NEW alphabetized DataTable, it does not alphabetize the actual (dt) original DataTable, it creates a new datarow collection that is alphabetized: Dim dt As DataTable Di... |
|
| Bining Context Question (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I hope you can inform a confused developer... What (functionally) is the difference between the two statements below? If I execute the first and check it in a quickview the value IS 3, however, it does not move the binding on the form. Also the quickview of the second method still equates to 0(zero). If I then execute the second line the form binding is altered. this.BindingContext[ this.dsBooking... |
|
| URGENT! Nullable dataset columns and missing column tags in the generated XML (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am constructing a XmlDataDocument out of a dataset which has certain columns with NULL values. The XmlDataDocument shows no column elements for the ones which have null values. Instead of this behavior, the desire is that the XmlDocument keeps the elements but carries no values. If some body can explain how to achieve this. I have already tried to remove the minOccurs '0' attribute in the datase... |
|
| Data Providers - Additional? (9 replies) |
| microsoft.public.dotnet.framework.adonet |
| There are two types of Data providers: 1.) OLE DB Data Provider 2.) SQL Server Data Provider First of all do we still refer to these as managed providers or data providers now? My main question, did Microsoft provide the capability for me or other software vendors to create a new type of Data Provider such as System.Data.OracleClient for example in which the common model can be used? The SQL Data ... |
|
| Best way to insert multiple records (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| Greetings, I need to insert multiple records into a single table. What is the best way to do that using .NET? I read the sample on MSDN that uses automatically generated commands using CommandBuilder and DataAdapter. That does not serve my purpose because all I need to do is bulk insert several records. What are the options? Also, is there a way it can be done using T SQL (SQL Server 2000). I woul... |
|
| Returning decimal(28,9) as an OUTPUT parameter (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a stored proc that returns a decimal(28,9), for some reason I don't get the digits on the right of the decimal point ??? I wrote another stored proc that returns the same data as a result set (in this case you don't specify the return type) and I access the data via a Reader, it works just fine. I have the SqlParameter set up as a Decimal with the same length as SQL 2000 shows in design vie... |
|
| DataSet/Table Update and Transactions (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| SQL Server commits *every* updated row from within a dataset or datatable individually. e.g. I changed 10 rows in a dataset and hand it over to the SqlDataAdapter. If row 5 fails, the first 4 rows are already commited and written to the database. So it is impossible to make 1 single transaction with my changes. Does anybody know if there is a good reason for this behaviour? Is it possible to chang... |
|
| Connecting to IBM DB2? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, We're about to do a project that unfortunately needs to connect to a DB2 backend. I don't know what version, but it is at least a few years (5 or so) old. Are there any known problems doing this? Will ODBC for .NET work just fine in this case? Thanks, Michael |
|
| Auto-increment fields (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I'm trying to add a row to my table, but I'm having a devil of a time with it. I have an Access database with a 2 field table used for lookup (UID is auto increment; Desc is text). This table has been added to my DataSet via the Fill method of my DataAdapter. I set up an array dim rowvals(1) as object rowvals(0) Nothing rowvals(1) "lookup desc" and call the Add method of the DataSet.Table.Rows col... |
|
| typed dataset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Basically i'm attempting to write a Data Access Component that can accept any valid T SQL statement. At the moment, i'm returning a normal dataset. Is it possible to return a strongly typed when the query provided is dynamic? |
|
| Writing a long raw > 8000 bytes to an Oracle Database (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am trying to write a byte array that has a size greater than 8000 bytes to an Oracle database. I can insert a row just fine if the byte array is 8000 bytes, but if it's 8000 I get a SystemException that says "byte array truncation to length 8000." Does anyone know how this can be done with Oracle and .Net? |
|
| Simple update question (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Doc changes are killing me.. can someone enlighten me as to how to perform a simple update using a DataSet. My questions are in the comments below. Here is a snippet of what I'm trying to do.. ... connect ... fill ... etc. DataRow dr ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["port"] "2112"; dr.EndEdit (); // do I do a merge or getChanges or what?? ds.Merge (dr); // whats the order here.. is accept ... |
|
| udl files (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have mostly used udl or dsn files in the past to connect to any data source, with the connection string looking something like this: "File Name \\fs01\syst\datalinks\northwind.udl" Or in the past I used: "File DSN " etc. These methods worked fine with ADO and gave a thin connection to my data that was easy for support to alter if a server went down. Is there any way of doing the same with ADO.Ne... |
|
| Null database fields causing InvalidCastExceptions (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi all, I'm using the IBuySpy store code as a reference while developing my first ASP.NET project. I was having some problems with null SQL fields and invalid cast exceptions, so I looked to see how IBS solved them and it doesn't :( In a nutshell, how do you deal with a database that allows null fields? The IBS Store Products table allows null values for several fields. If you manually add a row t... |
|
| How to get the Database Catalog (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| How can I get a Database Catalog ( metadata of a Database ) in ADO .NET????? I appreciate your help??? Thanks J.F. |
|
| Row count from SqlDataAdapter? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a storedproc, which fills a datagrid. If there's no records I want to show a message, but I can't figure out how to get row count. Here's my code: Dim ACon As New SqlConnection(...stuff...) Dim ADs As New DataSet() Dim AAdp As New SqlDataAdapter() Try AAdp.SelectCommand New SqlCommand("MyStoredProc", ACon) AAdp.SelectCommand.CommandType CommandType.StoredProcedure AAdp.Fill(ADs) MyDataG... |
|
| Fill DataSet without a DataBind? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is it possible to fill a DataSet from a MS Access Database while not displaying it on the ASPX page? That is, I want to only manipulate it and not hook it up and make it the datasource of some asp control like the datagrid. Actually, I want to feed it into an ArrayList, but I can't make an instance of my dataset object without making that Databind() command. Thanks. |
|
| Manualy create a new Recordset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have to bind a datagrid, using a Dataset. To insert data into the DataSet, I use a recordset, using OLEDB Fill. But the original ADODB Recordset that I have as some values that I want to change with other values, kind like, change a code for it's description, so I have to create this new Recordset replacing the fields I want. I've tryed to create a new Recordset but I can't insert values on ... |
|
| guru ques: DataSets in an n-tier environment (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| I don't see how it is possible to use DataSets in an n tier environment if they are so closely tied to DataAdaptors. Does .Net expect the middle tier to maintain state for any/all DataSets sent to clients with a backend DataAdaptor? Wouldn't that mean that I cannot create a generic DataSet handling class and would have to create unique DataSet handlers for each and every DataSet sent out? |
|
| SQL Svr RETURN value (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I execute my SQL server stored procedure with an loSQLCommand.ExecuteNonQuery() I cannot figure out how to read the RETURN value. Anyone know how to retrieve the RETURN value? Thanks in advance, Chris |
|
| Getting column names (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I want to get column names. I only see a reference to a column collection in the DataTable object model. Can I get the column name from any other object model or do I have to create a DataTable whenever I want to get column information? |
|
| What's Wrong in This DataReader Code (7 replies) |
| microsoft.public.dotnet.framework.adonet |
| using System.Data.SqlClient; private void Page Load(object sender, System.EventArgs e) { // Put user code to initialize the page here string cnn "driver {mysql};server localhost;database db1" ; string cmd "select * from nm" ; SQLConnection ocnn new SQLConnection(cnn) ; SQLCommand ocmd new SQLCommand(cmd,ocnn) ; ocnn.Open() ; SQLDataReader dReader ; ocmd.Execute(out dReader) ; while (dReader.Read()... |
|
| ADO.Net not very efficient(?) (13 replies) |
| microsoft.public.dotnet.framework.adonet |
| Why does it require 2 objects to handle a result set? (or is there a better way) Using Oracle I have to create an OleDataAdaptor and a DataSet to process my query then I need the services of BOTH objects to process an update. In Java I can process a query and get back a CachedRowSet object (much like a DataSet) however, this object can be updated back to the database from any db connection makes i... |
|
| ODBC, .NET , Velocis and controls (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Does anyone have or know about documentation which gives a in depth recipe on how to connect a ODBC database(velocis) with a ..NET control like a listbox or table? thanks jay widman |
|
