Hi I am getting the System.IndexOutOfRangeException was unhandled error on the last line of below code; Cmd = New OleDb.OleDbCommand("SELECT [Last Staff Update From Site] FROM [Update Control]", LocalConn) Reader = Cmd.ExecuteReader() Console.WriteLine("{0}", Reader.GetOrdinal("[Last Sta...more >>

I have an application where a limited amount of Unicode data is being inserted into a long data type field by an AIX program. I have written a dotnet program that copies the data from one domain to another with parameterized data. Everything works except for the Unicode data in the long field. ...more >>

Hi My app is running on a windows 2000 server with isa 2000 installed. How can it access an external sql server (using its ip) from within the isa 2000 firewall/proxy via code? Thanks Regards ...more >>

I realize that Microsoft not intend to fix problems of Commandbuilder: +not deal with SQL calculated fields +not deal with Identity field to retrieve it and also cannot be inherit! there someone wrote Alternative? ...more >>

If I have a field in MS SQL 2005 called "data" with type VarChar(MAX), how do I add a parameter using the syntax below if SqlDbType doesn't have a VarChar(MAX) type. If I use SqlDbType.VarChar will the value get truncated or is that what I should use? SqlCommand cmd = new SqlCommand(query, con...more >>

I have an array of an array of doubles and need to save this as a single byte array. Then save this byte array as a BLOB to an SQL 2005 database. Array allocation code shown below: Array myArray = Array.CreateInstance(System.Type.GetType("System.Double[]"), 3); Double[] dblArray1 = n...more >>

Hi, I need to add array of rows to datatable. Have I use for cycle? Because Datatable can add only one row into collection. Thanks. ...more >>

Hi, I need concatenate values of two fields in select command, but if I use this select command in Query builder in VS I get error. I concatenate two string values using SQL concatenation operator (||). It's a bug in Query builder? I think.... ...more >>

Hi! I have a couple of questions about TransactionScope... What exactly is the scope of a transaction? Is it only connections that are created in the actual code block where the TransactionScope is defined, or is it all connections created on the same thread as the TransactionScope? What i...more >>

I have a Sql2000 Stored Proc. that returns the result in the form of XML. I am calling this SP in my .NET application(webservice) using ADO.net. Can you please suggest me if I should be using the ExecuteReader or ExecureXMLreader method? Also, what are the advantages of using ExecureXMLreade...more >>

Hi all, this was driving me crazy! I've a datatable its related sqlDataAdapter, if I call the .Update method of the adapter everything is ok, but if I add a compute column to the DataTable (a columns computed via a DataRelation) I receive the "There is no Original data to access" ...more >>

VS 2005 designing a WinForm. I have a typical CUSTOMER, ORDERS, ORDERDETAIL database. I want to show these related items on a winform with either textboxes or datagridview controls. If I use the dataset designer to create a strongly-typed DS it will bring into memory ALL the records in ...more >>

i have 3 dropdown lists.from this dropdown list to { }{day[first dropdown list],month[second dropdown list],year [third dropdown list]. how insert the day,month,year to sql server databse EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

Hello to all. I have simple form with DataGrid binded to DataTable. DataTable has foreign key to itself. When I'm deleting one row it's child rows stay in Table. (It deletes only parent row, not child). Here is code: DataTable TestTable = new DataTable("Test"); TestTable.Columns.Add("...more >>

VS 2005 pro. I have a strongly typed dataset which I generate using the designer. From the xsd file I set the relations between the CONTACTS table to the ORDERS table to the ORDERITEMS table. Then I put some DataGridViews on the form and open. In the Load event of the form the Fill met...more >>

Hi all, Our database contains daily data going back for years, which I need aggregated into weekly averages. I came up with the code below to get it, but I don't like it - mostly because hitting the the database with a couple thousand queries feels wrong somehow. Is there a way to somehow s...more >>

VS.NET 2005 I'm not having an intuative experience trying to get the hang of how to setup a strongly typed master/detail relationshipe between tables. I have two tables CONTACTS with PK=IDNUM and ORDERS with a field CUSTNUM. Both tables have CommandStrings like "Select <field list> from T...more >>

I created a form, a datasource (Product table from AdventureWorks) from the Data Sources tab, and dragged the Product table from the Data Source tab to the form's designer surface. This created a dataset, bindingsource, tableadapter and bindingnavigator. I placed the following code in the c...more >>

I'm fairly new to ado.net, using SQL Server stored procedures, asp.net, and all that entails, so I'm sure I'm missing something simple and fundamental. Hopefully you can point it out to me. Ultimately the problem is I am getting an error: "There is no Original data to access." when trying to ...more >>

The OleDbException.ErrorCode is supposed to be an HRESULT. What scope of errors this HRESULT maps to. I tried: catch (OleDbException ex) { string test = ex.Errors[ex.ErrorCode].Message; } However, ErrorCode is a negative int and the indexer expects a...more >>

Hi I need to run a simple select query like below; select field1 from mytable where id = 123 and assign the returned value of field1 to a variable. What is an easy way to do this? Thanks Regards ...more >>

I installed the August CTP, after the LINQ Preview. Everything installs correctly. I opened the solution in VS2005 and built it, everything compiled. I mapped a virtual directory to the installation folder of the webapp sample (on my machine - 'C:\Program Files\Microsoft SDKs\ADO.NET vNext CT...more >>

Hi, i am writing a small interface to import some data from one database to an other database. unfortunately is the data in the source not very "nice". you have boolean-columns and those boolean-columns have as a default value DBNULL. it wouldn't be a problem if there was one boolean field, i...more >>

I have a Visual Studio Solution that contains multiple ASP.NET Projects. I do not want to put all of the pages (*.aspx files) in the root directory of my site, because that would be very disorganized. However, I am having trouble getting any projects other than the one that I place in the root...more >>

Hi, I dont know how to get the orginal DB column size from the dataset. Can anyone please show me the code for this? Many thanks Doug. ...more >>

I have GridView1 attached to a SqlDataSource1 (everything done automatically via VS2005). The problem occurs after launching the page because timeout is risen. The question is how to increase the timeout limit using properties of SqlDataSource1 or GridView1 objects? Best Regards Dariusz To...more >>

Hi I can't figure this one out. I'm using TableAdapters quite successfully with the rest of my app but I have one where the insert just doesn't work when the TableAdapter.Update(TypedDataTable) is called. When I set the break point on the method I can see that it initializes the adapter ...more >>

I'm fairly new to ADO.NET, I've written a couple client/server applications that use the factory pattern in ADO.NET to work with MSSQL and Oracle databases. Beyond that I'm fairly green. My quest is to create a new community opensource project that consists of an ADO.NET dataprovider to comm...more >>

I'm working with SS2000 on Server2003, Visual Studio 03 on XP and getting a timeout issue that I cannot identify the source of. The specific message is "General error getting subscriptions" (or other table) "Timeout expired. The timeout period elapsed prior to obtaining a connection f...more >>

Hello all, I am a bit puzzled about the data type of the type of a System.Data.DataColumn in ADO.NET. When I try to Add a column to a data table, there are 5 overloads and one of them has the following hint: 2 of 5 Add(ColumnName As String, type As System.Type, expression As String) As Sys...more >>

Hi I am using the below code to run a sql on an underlying access table; insStr = "INSERT INTO [Web Site Action Queue] ( Action, [Client ID], [Operator], Request_Date ) " & _ "VALUES (""Modify Client"", 93, ""Administrator"", Now())" Dim insCmd As New OleDbCommand(insStr, dbConContacts)...more >>

Hi All, I have a SQL Server stored procedure that return the results of two select statements e.g. SELECT * FROM first_table SELECT * FROM second_table The first_table has lots and lots of rows, so I only want to return the first 100 from any start point. However, in the second ta...more >>

Hi, I defined in my Sql Server db a table with 2 int columns that don't allow null values + their default values are set to 0. I'm using a DataAdapter to read data, but it doesn't bring the default setting : using (SqlConnection conn = new SqlConnection("MyConnectionString")) { ...more >>