I suppose I could simply use a SQL command with a data adapter to add a new column to a database table. Where can I find an example of how to do this? Regards Paul...more >>

I am in the middle of a large (many forms, many tables) database project - my first using C# and ADO.NET. As I code up each form, I find myself bouncing around considerably between instantiating data objects and data bindings entirely in code at runtime and using the data components from the t...more >>

index was outside the bounds of the array 2003 I added two tables to my access database. When I try to add them to datasources through configure dataset with wizard, I get the error index was outside the bounds of the array I have a total of 31 tables in the database. It is ultra-norma...more >>

Good evening, In VB 6.0, Delphi & VC++, the basic database connection technique is to connect at startup, disconnect at shutdown. In ASP.NET (regardless of language), the technique is to connect on demand. When developing client/server applications in .NET, which database connection tec...more >>

I have and application that I would like to reset the IDENTITY VALUE. Is there a way to change it in C# .NET? My application uses SQL Server 2000. Thanks in Advance. -- Norm Bohana...more >>

Is there a way to check which version of SQL Server is running using the SQLClient Managed Provider in dot_net 1.1? TIA, Joel ...more >>

I have a .Net application that references the IBM.Data.DB2.dll. The version of this dll I have is from UDB 8.1 FixPak3. In my application I have some code like below: m_Da = new DB2DataAdapter(); m_Da.SelectCommand = new DB2Command(); m_Da.SelectCommand.Connection = connectio...more >>

In VB .NET 1.1 I have created an oledbcommand object that queries the xp_cmdshell in the Master database. This part works fine. But when I try to access the Return_Value parameter's value there is nothing there. IsNothing() returns True; IsDBNull() returns False. Shouldn't the xp_cmdshell...more >>

Every table in my db has these 3 fields: Created, Modified, and Expired. 3 of my tables are Person, Business, and Employment. So Person.Created and Person.Expired store when a person is born and dies. Employment.Created and Employment.Expired store when a person starts and quits a job. ...more >>

Hello, I'm looking for a documentation that is easy readable for the Data Access Application Block. Does any one know where I can download a pdf version (or the ISBN of a book I can buy)? Unless I'm blind, it sounds not obvious to find such a reference..... Thanks, José ...more >>

I am trying to deploy an ASP.NET solution using ODP.NET to a server and receive the error: File or assembly name Oracle.DataAccess, or one of its dependencies, was not found. I see the Oracle.DataAccess.dll in the Oracle_Home\bin directory and Other OLE access to Oracle is working just f...more >>

Hi all. I 'm playing with parent/child relationship columns and I've tried AGGREGATE functions. My test is simple: I've created a table "C" with 2 columns: "Price" and "P_ID" and a table "P" with 2 columns "P_ID" as primary key and "SumPrice" to contain computed values. I've created a rel...more >>

How do you check if a value returned by a DataReader is null or not? For instance, here's what I wish to check: If Not Reader.HasRows Then mPreviousArchivalDate = Nothing Reader.Close() Exit Sub End If Reader.Read()...more >>

Is it possible to have a dropdown box in a datagrid record in the same way you can have it in an Access table? E.g.: When I populate my child table, I have a field which lookup a value in the parent table. Access allow this and makes it easy to ensure that the user can't enter anything else...more >>

I have a table in Oracle that I want to transfer directly to SQL. What's the best way of doing this? I don't really want to use a DTS package, and would rather use ADO.net. ...more >>

I have a strongly typed dataset. It seems as though all of my sql chars and varchar fields come through from mssql server padded out to the length of the field. Anything I can do about it in Ado.net? Thanks, jeff ...more >>

Using VS 2003 (VB), what's the best way to us the DataLinks object in your application. Is it by including oledb32.dll in your references? -- Michael Hockstein...more >>

I have a memory stream that i would like to save to an sql2000 database and then retreave it later on. I currently have the field set as an sql2000 -> VarBinary type of field. Any suggestions in vb.net??? When i run the current code i get an: "An unhandled exception of type 'System.Inva...more >>

Hi everybody I try to copy a row into another row. trying this will cause an error : "The row already belongs to another table" this is my code: dsnotSent.Tables(0).Rows.Add(ds.tables(0).rows(0)) How to handle this? Thanks alot Nijazi Halimaji ...more >>

Hi everybody How can I udpate a colum? I like to update a column with a date. Every row in this column should have the same value that i set. Thanks alot Nijazi Halimaji ...more >>

Does anyone know how multiple resultset stored procedures are executed when using data readers? It appears that the sp is paused after each select until the client requests the next resultset. Also, does the command timeout apply to the intial query time or for the time it takes to start r...more >>

Hi I want to process an ASP.Net datagrid and send all rows to the database in one roundtrip, rather than do the process of new, save, new, save or edit, save, edit save etc. Does anyone know how I can pass an array or other structure of rows to an Oracle stored procedure for inserting or up...more >>

Hi there, I have a class library that I am using to connect to an ODBC data source. If I consume this class library within a standard windows forms app the connection succeeds. If I consume it in an asp.net web service it fails. Would this be down to the assembly being run with diffe...more >>

This is my code I am using (see bottom for my questions) Public Sub SendAllSMS() Dim myODBC As New clsODBCDataSMSVers Dim ds As New Data.DataSet ds = myODBC.GetAllSMStoSend Dim dsnotSent As DataSet dsnotSent = ds.Clone Dim mySMSWebService As New SendSMSbyService mySMSWebS...more >>

Hi We currently store a central database in C:\Documents And Settings\All Users\Application Data\<Company Name>\ This database needs to be written to by anyone that logs into the computer and runs our app. The problem is that Restricted Users only have Read access to this folder (overlooked...more >>

I'm accessing a DataRow through a DataView using "dv[i]", how can I find which index this dataRow has in it's DataTable's Rows collection? -NorCan...more >>

Hi, I've tried the SQL Server newsgroups and it seems nobody did it there, I got no replies, or those that did it don't want to tell. I have VS2005 Beta 2 installed with VS2003 and everything works good enough with an occasional Beta hick-up but nothing serious. On the same computer I have S...more >>

Hi; We have a case where it is virtually impossible to know when to close a connection because we may be about to make another query. So... 1) By any chance does SqlConnection implement pooling under the covers so multiple calls to new SqlConnection()/sc.Close() are fast? 2) If I just h...more >>

I'm trying to use a typed dataset and ObjectDataSource binding to a SQLX db using a foreign key to filter the returned result set to display in a GridView. The error message in the subject line is generated when I try to bind the following GridView to the ObjectSource that follows and the c...more >>

Hello There, Im recently implementing some app that provides connectivity with asp.net and unify dataserver, these transactions reports sintax errors, so I wanna see these error verbose, the connectivity is only possible throw odbc im using ado.net objects for odbc, I put the odbc tracer on...more >>

Hi I am trying to access a row of data from an Access database based on info entered into a textbox. I "int.Parse" the textbox name so that I could use it in the "WHERE" criteria, but I keep getting this error msg: "Data type mismatch in criteria expression". All the fields in the dat...more >>

Hi! To get a XmlNode from an untyped DataSet with Path is no problem at all. It works fine and gives you the expected node a long you use the rigth XPath exprssion with SelectSingleNode. I've done that in many projekts succesfully with untyped DataSets! But now I am working with strongl...more >>

I found another issue with this same heading, but mine is different so please read on... I have the following table: CREATE TABLE [UsersSF] ( [UserId] [tinyint] NOT NULL , [SFId] [tinyint] NOT NULL , [SFTypeId] [tinyint] NOT NULL , [Description] [varchar] (30) NOT NULL , [Sort] [text...more >>

Hello, I am creating a ODBC Connection to the SQL Server and I want the listing of tables and columns. How can I acheive this? I dont want to use a OLEDB Connection, Regards, Rohit. ...more >>

Hi, I have a bit of a mystery with merging updates into dataset. Here's what I do (roughly): DataSet dsDelta; dsDelta = dsOriginal.GetChanges(); dsDelta = FunctionThatCallsAdaptersUpdates( dsDelta ); dsOriginal.Merge( dsDelta ); After merge, I get a very puzzling "Failed to enable ...more >>

I am emulating the old connected recordset of the ado days using a static connection to the db and a cursor in my vb.net application. The cursor is opened as a "scroll keyset" because I need to be able to jump around to any record at any time and the "cursor threshold" is set to 5000. Unfortun...more >>

I wonder if someone can help me. I have created a stored procedure that contains a UDF in the SELECT statement. i.e. SELECT Table1.*, dbo.SomeFunction (Table1.Cost) AS SomeFunctionValue FROM Table1 When this SP is executed through the query analyser, the expected results are returned. B...more >>

Hi there - I'm sure there is a simple answer to this ?!? - I just don't know it... I have several text boxes on an asp.NET web page that are used to gather information from the user and then sent to a SQL database - they are basically editing new or existing records. When any text is ent...more >>

Hi, I have a doubt I'd like to solve. We are making an app, in which we use many sql queries in order to return datatables. But today someone has told us not to use sql queries, but stored procedures, because he says that s.p. execute directly in the sql server and queries execute in the client...more >>

I'm working on a VB.NET app which uses ADO.NET to interact with a database. Currently I have a problem with concurrent updates due to the optimistic locking used by ADO.NET. I wish to be able to modify the data updates so that they only check the Primary Key columns when updating the database...more >>

I am trying to retrieve the child rows of a given DataRow using a relationship, but sort them in the process. There are three ways I can think of to do this: 1. Use the child table's Select() method to select rows for which the parent column matches my row's ID, and pass in a sort expressio...more >>

Hallo Newsgroup Ich habe ein kleines logisches problem das ich nicht allzu kompliziert lösen möchte, deshalb wende ich mich an Euch. Ich habe einen Dataset der alle Daten enthält. Ich verarbeite den Dataset (wie auch immer) und habe am Ende einen Arry mit Schlüsselwerten aus dem Datase...more >>

Hi newsgroup I have allready posted this problem, but in german... So I try again in english I have a little logical problem with dataset. I have a main dataset which includes all data. After working with the data I have an array which includes the key values of a column in my data...more >>

Can someone explain why DateTime value are not save correctly. Here is what happen: I put DateTime.Now in a column Read it back and compare the Ticks values and they are off a bit. UnitTest.TestSaveDateTime : expected:<632621000979676250> but was:<632621000979670000> Larry ...more >>

Hi, I am looking for a reliable alternatives for Visual Studio Typed DataSet generator. Do I have options other than VS2005 IDE for generating Typed DataSets? I know that CodeSmith might the immediate answer, but could you referee me to a specific and reliable code generator? A...more >>

Hi, Can I change my default schema in oracle connection string ? Thank you, Alan ...more >>

Ok, I am done with commandBuilder. It causes more problem than it solves: 1. Adds unecessary events, that i don't really need. 2. Can't get back AutoIncrement ID of new records. 3. Creates more commands than i need. I am building my own dataset update method using custom command builder...more >>

Hi, I am getting following error in production for a background process: Failed to fill Order Data Set : Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reach...more >>

Hi All I am fresh college graduate who has done C and C++ during college times.After that i had done a C# course from one of our local computer institute.The course is BCM which ran for 1 year.But now when i am looking for job the questions asked in interview are really very very weird and does...more >>

Hi, I use a parameter to do a sql-update command. But the field in mysql is of type varbinary and the vb.net is a string. I get it back from the database with reader.getstring and it looks the same. Is this a good method? I wanted to read it back trough reader.getsqlbinary but the method i...more >>

I'm getting a login error from SQL when I try to run my asp.net form. The error reads : Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Now I was under the impression that aspx pages ran under the username of "machine\ASPUSER" ...more >>

I need to fill a DataSet with Parent/Child data. I will use Northwind as an example. The DS needs to have 2 data tables (Customers and Orders) and a data relation to link them. The Select Command of the data adapter for the Customer table has a complex WHERE clause. I now need to fill the ...more >>

The C# & vb.net examples presented in the MS Help below are good examples. Unfortunately, I am using a CommandBuilder as such, I do not have access to the InsertCommand. the CB creates those behind the scene. How do i then use examples below to get AutoIncrement ID? I do not want to use Store...more >>

Hi, I need to put information from variables (not only strings) to a mysql database using update. But no I found out that stored procedures are not there in mysql 4. Please help, Gert ...more >>

Experts: Please don't suggest @@Identity to anyone without understanding and explaining the implications of this advice. While JET is stuck with @@Identity, it's relatively safe, but the continued use of @@Identity with SQL Server is questionable at best. While there are some special circums...more >>

Hi, I need to have a array() of byte stored in a varbinary field in mysql. (and get it back). But how to pass it from VB to MYSQL in a update statement. Saw samples with @variables but i cannot get it working. Please help, Gert ...more >>

I am inserting a record into a sql table and get two (2) indentical records each time. I am using a stored procedure. What am I doing to cause this to happen. In the stored procedure I have the line 'SELECT SCOPE_IDENTITY()'. The code that I use to execute the stored procedure is here: t...more >>

cmd.Connection = conn cmd.CommandText = "CREATE PROCEDURE gert (OUT param1 INT) BEGIN SELECT * FROM tabel1; END" cmd.ExecuteScalar() Please help, whatever sql statement I use I allways get this error Error 1064 #42000You have an error in your SQL syntax; check the manual that cor...more >>

Storing images I've read the documentation, but I'm in a quandry as to the best way of storing images. Is it in a blob field? blob fields seem to lack necessary information like titles and keywords. I've read elsewhere - I cannot find the source - that it is better to store images -...more >>

Hi, I wanted to insert a record in to a database and then get the autonumber of the row that is inserted using AdoDotnet. this can be easily done in ADO like below. TCHAR* szSQL = { _T( "select processid,identifier,emailid,statusmsg from backgroundprocess where 1=2" ) }; /*open a record...more >>

I have a business rule that says if a user selects the value 20 for item A that item B must have a value of 0. I am looking for the best way to implement this rule. TIA I have a sql structure like this Main Table (PK) MainID as int Description as varchar(255) Child Ta...more >>

I am getting a SQL Server Error: 8629 "The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time." I turned the clustering option off for this key and that worked but ha...more >>

Hi, First for the setup: I work for a museum, we have an exhibit hall that has a number of interactiv es that all store their data in a dbaseIII db. All of the exhibits are earl y to mid 1990's technology. We are in the process of replacing the exhibits (all the new exhibits are windo...more >>

Hi, I am using executescalar to update a table. When testing the sql statement, I am sending a value that does not exist in the condition. However, the command is successful. Is there any way to know that in reality no records were affected by the update? (i..e I already tested for null, but...more >>

Hi Newsgroup I am making a selection with a ODBC-Dataadapter into a Dataset. Then I create Parameters for Updating the Data with Dataadapter. When I create the Parameters then I cannot update because I have set the value of the parameters a fixes value... My question now is: How must th...more >>

Hello, I need to build a treeview in a winforms application. The datasource is a dataset. I've the following tables products(prodGUID, name) categorys(catGUID, name, prodGUID, parentcatGUID) So a tree might look like this: rootnode | - product 1 - cate...more >>

Hi, I'm making an App in which a form is bounded to a table in a database, and with some arrow keys, you can move through the rows of the database. At the moment I do a request to the database each time an arrow is clicked, but my idea is to load an entire dataset when the form is loaded and n...more >>

I have a method in WebServcie, which retrun a DataTable: [WebMethod] public DataTable GetSchoolList() { string sSql = "Select ...."; DataTable dt ; ......... return dt; } In the consume application, I have add the reference to that web service, and use the codes to get the da...more >>

How do I call the stored procedure ...more >>

Hi, I am a newbie in ADO.NET. I use MYSQL in combination with ASP.NET VB. To make it more perfect I like to do a SQL Update command with variables. Please help. I found a lot of samples, most of them returning no errors at all. But the record isn´t changed. Please help I need a `update...more >>

We have a legacy C++ app that has two worker threads. Each will separately instantiate .NET objects using COM interop. One thread does simple SQL statements and the other does larger SQL inquires. Both use the same connection string to create their OracleConnection. Both connect as late as possi...more >>

Hi ALL! I have questions on connection pooling.. 1) Is a connection pool for a DB, Application or a machine? I am using .net 1.1 and sql server 2k if that matters.. Parez ...more >>

I have a stored procedure that insert data into a sql table. I need to get the record identity for another process. When I execute the program I get this message " System.FormException: Input string was not in a correct format". The line with *** is where the proglem crashed, Please tell me ...more >>

Hi I need some tips on the best/most efficient way of determining the order in which tables should be updated. I have a dataset that loads relational data from XML files, including the table structures and relations. There may be several levels of relations (parent -> child -> "grandchil...more >>

Hi all! Is the connection pool associated with database server or an application or a machine? parez ...more >>

Hi everybody I am using a ODBC-Driver in .NET. For reading and writing data I use normal SQLCommands. Reading an writing integer and string fields is no problem. But when I try to read or write Date / Time fields I always get exeptions: Trying to update with following code: Dim comm As...more >>

Hi! I have to convert a untyped DataSet object to an strongly typed DataSet object. The method DataSet.Merge seen to be a good opportunity to convert the DataSet. But I am not successfull with this method. Even when I rename the property DataSetName and Table[0].TableName to exactly th...more >>

Hi, my class is in enterprise services and "supports" transactions , but i want that certain function will use transaction. if there is no transaction - open a new one, and if there is - use the current. how can this be achived? TIA! ...more >>

I want to show a row number in each row of a datalist. How can I do that? ...more >>

Hi, I have a long running transaction that gets started by calling a stored procedure using the OpenXML functionality. While this transaction is running all other reads from the tables used in the transaction are blocked and results in a timeout. The isolation level is set to "Read Uncomm...more >>

can we add parameter in the view of SQLServer? like Select * from Employee where gender=@myGender ...more >>