Hello, I am trying to learn how to use stored procedures within the .Net environment. I have been successful in calling a stored procedure with a "REFCursor", and NO input parameters, but when I attempt to call a stored procedure with a single input parameter and an output parameter with a ...more >>

I was reading Oracle Documentation about the need to set the PLSQLRSet property to "TRUE" if you will be returning a recordset. To do this it indicates that you should use the Command.Properties["PropertyName"] = TRUE. I find no such property for the .Net environment. Perhaps these instruct...more >>

If I have a variable described in Oracle as NUMBER(6) or NUMBER(4) what datatype does this translate into when I am building a parameter? There is no "Number" data type to select from when I am populating "Oracle.DataAccess.Client.OracleDataType". When does the number become INT16 vs. INT...more >>

This might be almost impossible, but I thought I might ask anyways. I have a value stored in my Config file or a property in the same Namespace (DataLayer) I want to see if there is a way that I can specify in the XML of the Typed DataSet to use this value. For example: <xs:element nam...more >>

Hi, I am writing a module which will update 2 tables (Master/Detail) in SQL database. There's a foreign key protection among those tables so that I have to add a record in Master table prior to add record in Detail table. What I want to do is I want to create a SqlTansaction to rollba...more >>

Hi guys, I have a datagrid bound to a datatable. How can I delete a row from the datagrid without pressing the key delete. I was looking for some datagrid method that can delete de current row, but I didn't find it. Thanks a lot for your help, ...more >>

Happy Birthday William. --=20 ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com Please reply only to the newsgroup so that others can benefit.=20 This posting is provided "AS IS" with no warranties, and confers no = rights. ...more >>

hi, i'm getting this error when updating a datarow and have no idea what's causing it... appreciate any help See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Data.VersionNotF...more >>

(Type your message here) Hi, What is better way to use ADO.Net in applications with much transactionality? SProcedure?, Command?, DataAdapter?, DataSet? What is the best? Sorry for my English. -------------------------------- From: ruben barzallo ----------------------- Posted by a ...more >>

If I have a stored procedure in which one of the input Parameters secifies a Default value, do I still have to create the parameter anyway? I tried not providing and it says that I a missing a parameter...so it seems heavily waited in the direction of I have to provide, but I wanted to check ...more >>

Hi, I am writing a control that needs to respond to changes in the DataSet that it is bound to. Is there an event raised that I can catch to check every time the DataAdapter performs a fill. TIA Steve ...more >>

I wan to execute an update command that will insert many new rows into a database table. I loop through my dataset running the update command on each datable. The problem is that the update commangd fails. I want to map the parameters used in the insert command to the columns of the datatab...more >>

Hi, I have 2 comboboxes, both bound to a different DataView, but thoe DataViews are bound to 1 DataTable in 1 DataSet. Like this: Dim dvwList2 As New DataView dvwList2 = MyDataSet.Tables("tblAccounts").DefaultView dvwList2.Sort = "Account ASC" cmbAccount.Da...more >>

Hi,everybody, I'm a newbie of .net, I've programed some database code with VB6 and Access .. Now,I'm turning to vb.net and can't decide which database tool to use, Access or SQL Server? Could somebody give me suggestions? Any suggestions will be appreciated ? ...more >>

Hi, I've a question about monitoring OleDbConnection pool in performace counter. Am I able to do this ? I know I'm able to monitor SqlConnection pool through ..NET CLR Data performance object, but I really need use OLE Db provider for many reasons. Thank you...more >>

I need some help on inserting records from vb.net into Visual FoxPro. In VFP8 we (finally) got primary key type fields. That solved some issues with the oledb driver, the driver is now able to determine which field the primary key field is. Unfortunately I still cannot find a property like (for ...more >>

Hi What is the easiest way to get a bunch of records from an access table based on a where condition? I don't need to write back anything, just want to check if any records matching a certain condition exist in the table. Thanks Regards ...more >>

hi,=20 i've started playing with the VS strongly typed datasets and i'm doing = an experiment to see if they will be a viable replacement for my = business objects.=20 the typed dataset contains a class for each of my row types, and i want = to add 2 variables to this class (it's simulating f...more >>

I'm just evaluation typed dataset's, and can't find much information how to use them with a database. The things I'd need to know are: - What will happen if the database and the dataset do not match? How can I catch this? - When I will need new fields in my dataset and database, I can change ...more >>

Hi I am using VS NET Enterise Architect and generate SQL stored procedures for data access. Should I (can I) use Data Access Applications Blocks (DAABs) to refer to these? And what about Autosproc to create wrappers? Does it / should it use DAABs. Or are DAABs out of favour? Any guidanc...more >>

I am encountering a strange performance issue with DataRelation which I am hoping someone can cast some light on. I have two tables related to each other by a single field (of type varchar, about 60 characters long on average). Now I load a single row from the first table to a DataTable and abou...more >>

I have 2 developemnt machines here, an XP Pro and 2000 pro. The following code works on both: Dim connS As String Dim tmpConnection As System.Data.OleDb.OleDbConnection Dim da As System.Data.OleDb.OleDbDataAdapter Dim ds As DataSet Dim dt As DataTable ...more >>

Hi guys, I understand that a dataview is kind of a collection of indexes to the records of the table. So, if I have an index of a record in the dataview I should be able to know the position of that record on the table. see the code .......... .......... dt=this.dsCM1.clients; S...more >>

Hi! My DataSet contains DataTable named as 'CurrencyRates', and it contains fields: 'Currency' (like 'USD'), 'Rate' (like 1.1983) and 'Updated' (date when updated). My application contains 'Update Currencies'-button, and pressing it application should update 'Currencies'- DataTable (or insert ...more >>

Hi all, We have a situation where we are using an DataSet object to store/load a = file (e.g. there is no database), and have the need to be able to bind a = subset of the dataset to a grid control. =20 The problem is that we need to be able to filter across two of the = tables to determine...more >>

hi, I have a Stored Procedure in the SQL Server, called prCustomers it is "select * from customers" - very simple How am I able to execute the stored procedure get a result set and put the first record of the result into a single textbox called last name e.g. objConnection = ...more >>

Help Me please, I'm in the process of putting together an application that will= stream video into WMP (SDK version 9), based on a a user= selection via a Winform datagrid=2E I'm using the= SqlHelper=2EFillDataset fuction to fill a strongly typed dataset=2E= However the problem has arrise...more >>

(Type your message here) dim myStrArray() as string While objReader.Read() Dim tempObj() As Object objReader.GetValues(tempObj) myStrArray(row) = tempObj row = row + 1 End While the above code i...more >>

I keep telling myself I am thinking of ways to implement things that could help make my application more efficient, but really just having fun with ADO.NET and SQL Server. I use DataSets to keep track of work users have done, until they are ready to save their work and I need to call a stor...more >>

Hello! I have a problem when updating the value of a primary key column in the parent table. After the update which works fine against the database and all its childrows - I get a constraint error when doing merge on the dataset. Can someone explain why the update against the database works ...more >>

Hi, here is my problem: I'd like to display data in a grid-like control on a form. The data is fetched from an SQL DB using the SqlDataReader. Problem is, the user must have the chance to set his/her preferences as of what columns (fields) he/she will see and the order of them as well. (Like i...more >>

Hi Actually I need Technical Support I finished a Great project using .Net and SQL Server and .Net Mobile Control My Business case is to implement this Program to accept about 1 Million concurrent users So I designed the project as master Node that has all administration project and about 10...more >>

I have an Access-type database (actually created by ado.net via Jet 4.0 etc) with one column storing date/time information as DateTime type. I need to retrieve this particular date/time column (along with others) into a dataset or datareader but in the older OA format (ie as a double type) for ...more >>

Hi guys, I have a form with many controls bound to a table. To find some especific record in that table I use a dataview. The find method give a index of the record on the view not in the table, so now I want to find that record in the table because I want that record to be show in the ...more >>

I have this code in my btnclick event. Dim cnn As New SqlConnection(Constants.SQLConnectionString) Dim cmd As New SqlCommand Dim cmd As New SqlCommand("spAverage", cnn) cnn.Open() cmd.CommandType = CommandType.StoredProcedure Dim prm1...more >>

Hi How to remove identity from column in SQL Server on unempty table? Is it possible with MSQDMO? Thanks Konrad ...more >>

Hello: I have an application in .NET. I need to show the parameters have been passed through the WEB page, like for example: http://login.passport.net/uilogin.srf?id=2 Where and what instruction I have to use for this. Thanks Gina ...more >>

With VB 6 I used this piece of code: dim adoCmd as new Adodb.Command dim adoParm as new Adodb.Parameter with adoCmd .commandText = "OurComp.SaveWidget" .commandType = adCmdStoredProc Set adoParm = .CreateParameter("FirstParam", adChar, adParmInput, Len(pStrFirst), pStrFirst) ...more >>

Hi, I have a DataSet that contains one DataTable and holds data pertaining to books. This table has a primary key column based on the ISBN of books and is loaded with data. Suppose I add other books to the table and one of them is a book that is already in the table. Will the table now have...more >>

Greetings, I have a SQL Statement that runs fine in Access: SELECT [PACONTNUMBER] & [PAcontname] AS Expr1 FROM dbo_PA01101 (It basically is a single row that concatenates PACONTNUMBER and PAcontname) When I try to use this statement in asp.net, I am getting an error. Are expressions a...more >>

I'm seeing some behaviour which seems utterly bizarre to me. I'd expect that a DataView should automatically track the changes in the table, so that if rows are deleted etc, existing DataRowViews sort themselves out. Here's a test program I'd expect to work just fine: using System; using S...more >>

If I have a DataSet with a table and I add a row and subsequently delete it prior to a database update, is the row and added and deleted at the DB level or ignored? TIA ...more >>

When using Server Explorer in VS.Net, I can query tables, create stored procedures and even design objects in the database. Another very important feature is the ability to drag a stored procedure to your application generating all the code for the command. Anybody knows if all of these works fo...more >>

I need to filter a view on values from parent table, this works fine e.g. "Parent.Name='MyFathersName'" However, I also need to filter on grandparent and grand-grand parents (a.s.o.) columns as well, syntax "Parent.Parent.Name='MyGrandFathersName'" does not work (exception is thrown), any one ...more >>

Now I got my report form to load without a licensing error, thanks to Bill (William Vaughn). But I keep getting the error "can't load data" when I start the form. In my delvelopment system it mostly all worked from day one, but moving it to another machine involved installing MDAC, MSDE, the...more >>

Hi All I am getting the following exception: General network error. Check your network documentation System.Data.SqlClient.SqlException From within my web application I connect to database on my local machine and have a For Each loop round code that calls a stored procedure: Dim sqlC...more >>

With ADOX, or DAO, I can have all information I need on Access databases, including all properties of the fields of all the tables. For example, I Can get informations about 2 properties: - AllowZeroLength - Required With ADO.NET the property 'Required' is available with GetSchemaTable, but...more >>

Hello there, I am building a web system with a 3 tiered design (DAL / BLL and pres layer). I have all my objects (ie... USER object for example) and collection objects that build up collection of my objects.(ie ...userCollection object.) This is all well and good but when I come to binding a ...more >>

Generally in programming we use DataConnection and called dc.Open() We Give DbCommand various parameters and result sets. But, All this commands/ procedure to retrive data from Database is predefined or mechanical one. Actually,I want ot know what actually happens when you connect to database o...more >>

I've created a windows application with the follwoing code, and it works just fine: string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + System.AppDomain.CurrentDomain.BaseDirectory + "//XL//my.xls;" + "Extended Properties=Excel 8.0;"; Ol...more >>

When i use the SqlConnection class to establish a connection to a= sql server, i get the following error=2E But when i verify the= connection using a =2Eudl file, it succeeds=2E Further it also works= through an =2Easp file (Server=2ECreateObject("ADODB=2EConnection"))= !!! [SqlException:...more >>

Hi, I have done a bit of programming against the System.Data.SqlClient classes but in order to maintain some prospect of database portability in my code I would prefer to use the more general IDbConnection, IDbCommand etc. However, I notice there is no corresponding IDbException, and the do...more >>

Hi, Is there a way to add, delete, select and update multiple DataTables in a Dataset using a Single SQL String and a single DataAdapter object. I read somewhere that we could fill multiple tables in a dataset by sepearting the two queries by a ; like SELECT * FROM TABLE1 ; SELECT * FROM TABLE...more >>

Hi! How can I check that file exists in the internet, because for example the following is NOT working ... blnExist = System.IO.File.Exists("http://www.suomenpankki.fi/ohi/fin/0_new/0.1_valuutta k/fix-rec.txt") .... and how do You recommend to import/update file of the net into DataSet ...more >>

An application contains two forms FormA and FormB Form A contains a DataGrid bound to the DataSet ORDERS Form B contains a ListBox bound to the DataSet ORDERS How can I get the selection in FormA.DataGrid to reposition both 1) the DataSet ORDERS 2) and change the ListItem index in FormB...more >>

Hi, Is there any way that I can add multiple columns with the _same name_ into the Fields collection of an ADO recordset? I am fetching data into an OracleDataReader through the usage of ODP.NET, and I want to create and populate a Recordset from it to be returned to my COM clients. At pres...more >>

Hi I'm trying to get an idea straight in my head and I hope somebody can help me. I have a DataTable, called Books (and whose table name is Books), which I'm adding to a dataset as follows: myDataSet.Merge(Books) This works fine. I can do things like: DataGrid1.DataSource = myDataSe...more >>

Is it possible to bind multiple datatable in one SQL statement? Some thing like this stored procedure for example that returns three results: select * from table1 select * from table2 select * from table3 This syntax is not working like it is on access. Is there a way to get the same j...more >>

I have an employee table in a SQL Server database I know how to bind data into a drop down list for a Field Name called State. strSQL = "Select StateAbbreviation + ' - ' + StateName as StateInfo, StateAbbreviation From US_State" objAdapter = New SqlDataAdapter(strSQL, objConne...more >>

Not sure where best to ask this, but maybe I could start here: Looking for a commercial vb.Net compatible chart control for use in WinForms that can natively (ie without iterating through a complete dataset doing type conversions) bind to a DataSet or DataReader where one column, which will be...more >>

Hi, I am upgrading my database componenet from VB6.0 to VB.net but would like to use ADO for database operation. Am trying to retrieve no of tables in a database using connection.openschema method of ADODB. It works fine in VB6.0 but blows of in VB.net. The code looks like rsReadOnly = New ADODB.R...more >>

When I tried to retrieve the data from SQL Server database and assign it to a field, it generates an error since the data in SQL Server is "NULL" how am i able to solve that problem? thanks, Ed Source=datasourcename;Database=databasename;User ID=;Password=;") Conn.open() myadapter=new ...more >>

Hi, I have a dataset which has one datatable which has one datacolumn, is there a way to convert it to a String[]? TIA ...more >>

I am using the following code below to update a simple Access database with historical stock prices: -------------------code snippet---------------------------------------- 'Open connection to update data Dim myConn As New OleDbConnection(ConnectString) myConn.Open() 'Create the S...more >>

I have databind a textbox to a datacolumn that happen to be an expression. Strangely enough, when the calculated expression value changed, it does not seems to update the textbox. Is it bug ? I have tried to trap the changed event on the column but because it is an expression, I never receiv...more >>

Hi, I created a dataset with 2 tables and a relation in a module. Now, I have a form with datagrid that suppose to show only the parent table. :?: How can I hide the symbol (+) from the parent datagrid without deleting the relation. :?: Thanks Roy. ...more >>

I was perusing groups.Google.com and found a couple of articles for parsing out a CSV file into an ADO.Net dataset. Although I haven't tried it yet, the following example seems the most straight forward: Dim TextConnectionString As String TextConnectionString = "Provider=Micro...more >>

Hi, It seems that this code does not work, what's wrong ?? dim s as string = "SELECT * FROM sometable WHERE somefield IN (@stuff)" ' where somefield is an int dim cmd as new command dim arr() as integer [...] if arr.length > 0 then cmd.parameters.add(new sqlparam("@stuff", arr)) [.....more >>

All, I've spent all day trying to find simple examples of how ADO.NET works but I'm still out of luck. I'm trying to do one simple thing add a new row to an Access Database. I've adapted the code below from a number of sources but I'm getting an error on the last line "daVisitors.Update(drVisito...more >>

Hi Can anybody tell me how to change the datatype of a field in a database using VB.net code? For example, suppose that the database has a field initially specified as Text, how do I change it to DateTime from within VB.net? Geoff ...more >>

Hi, I tried to get a value from dataset. Here is my code: int intCustomerID = (int)(dsCustomer.Tables[0].Rows[0].ItemArray[0]); I keep getting "Specified cast is not valid", I know for a fact that the value is an integer. So how do I cast it? TIA ...more >>

I got my data to work in the form on the other machine, finally. But now Crystal reports won't show the report I designed. It says "keycodev2.dll not found, or invalid key code" I can't find any file named keycodev2.dll on my development box or anywhere. What's the deal? I went to Crystal repo...more >>

This is the first time I've tried to convert my .asp ado connection to the ..NET framework and I'm totally lost. Most of the examples I've seen are incompliant or more complicated then I can comprehend. I was wondering If someone could point me to a referance that showes an entire example of con...more >>

Hi, I have a strange problem. Most probably I am not seeing something huge, so... please help. Here's the problem: I have a typed DataSet: MPDataSet I must update a Row on the DB table Product, and the values of this Row are passed to me through a Web Service, so I do not have the original ...more >>

Hello, I am having problems with connecting to sybase using visual studio. I have installed Sybase Open Client and now have the drivers to create a sybase connection. In visual studio I have successfully created a connection to 1 sybase database on a server (Server1) using tool --> Connect ...more >>

Hi all, I have an app that contains the following code.... ---------------------------------------------------------------------------- ------------------------------ Public Sub CreateNewDatabase(ByVal DbFile As String, ByVal sLots As String) Dim catNewDB As New ADOX.Catalog ...more >>

I have a generic question regarding ADO.net and how the CommandBuilder works. I have a datagrid/dataset that is partially populated from pre exisiting records in a database table as well as NEW records/rows which are being added to the same dataset by a user via a simple textbox/form. My que...more >>

Hi, I have a question about connection. I want to trap when the internet connection is down. For example, I fill in a Invoice row and lock it up. Now somehow, the client has a internect connection failure so that it loose connection to SQL server. How can I trap this in my application? I tr...more >>

How to set Value property of OleDbParameter class to database NULL value? TIA ...more >>

Hey folks, Since in the windows form world, you can't bind a SqlDataReader to a DataGrid, but you can bind a DataSet, would it be quicker to: a) Return data to a SqlDataReader. Then loop through it and add the data to the DataGrid manually 1 row at a time. b) Return data to a DataSet and b...more >>

Hi all, I want your opinion about a thing... i'm going to develop a website in ASP.Net and I'm questionning myself if i should a DataSet (.xsd) for all my Site (Like load on the Session_Start and use it during all the navigation) Or if I should create a new DataSet on some page, when i need...more >>

Back about 3 years ago when I took an Oracle class, I recall that when I created an used a stored procedure in Oracle, that I was taught to create a column in my output which contained the "return" code which I would manually populated in the procedure. Then I would loop through reading those recor...more >>

Hi , How can I add the prefix value to an DataColumn ? For example: I have one table called Employee in that EmpID is Column.To this column i want to add "SRIT" as a prefix value , like " SRIT- XXXX". Any ideas regarding this. Thanks, Satish ...more >>

I am having a problem with my ASP.Net project using an Oracle database. The error I am receiving is below: 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 >>

I have a comma delimited export file with 10 columns. I want to display the first 5 and the last 2 columns in a datagrid or table. Is there any way to do this automatically? If not, does anyone have any ideas how I can do this? Can I just feed it to a dataset and use it with normal ADO.NET? ...more >>

Can anybody help me in steps of finding up my ADO.NET version , is it using some set of commands or can I do it in VB.NET Application also -Aftab ...more >>

Hi, I would like to have my web connect to a SQL Server and display data on a web form. My question is if a Social Security Number is not is the database, error occurs... what should i do... thanks <%@ Page Language="VB" debug="true" ContentType="text/html" ResponseEncoding="iso-8859-1" %> ...more >>

Hi There, I am wanting to format a datalist into columns, so do I need to use a table rows & columns? or can I use templates and a property at the top of the list itself ? It seems that when I try to format the datalist I can't get it to look like a normal html table. Moe col1 col2 col3 ...more >>

Hi There, I'm having this problem with a DateTimePicker and I just can't figure it out. I'm using binding on a form. I'm binding all the object on the graphical properties, I have created a data adapter and dataset as well, all that has been done with working ok. New I call the AddNew() ...more >>

Hi, OK, guys and gals. This one has been troubling me for some time now, and I've yet to come up with a viable solution. Here goes. I am consuming a web service that returns product information for books (title, publisher, price, etc). I'm using ADO.NET on the client side to save this da...more >>

hi.. when i choose add new item in visual studio i see i can add a dataset or an xml schema. both appear to create typed datasets, so what's the diffrerence between them? btw off topic did anyone manage to work FileSystemWatcher in a windows service? i once tried somethign simial with file...more >>

Hi. How should I correctly install ByteFX in VS.NET IDE? I just used Tools-> Add/Remove Toolbox Items.. and add ByteFX.MySqlClient.dll to Toolbox. What should I do with ByteFX.MySqlClient.Design.dll? I asked because once I read in microsoft.public.dotnet.framework.adonet mail like this: ‘(…)By...more >>