I create a dataview on table. the dataview filter rows, which ID is between 1 and 10. What happens if i add a new row with ID= 5 to table after rowfilter method is called? Will this row be in my dataview automatically or i have to call rowfilter again in order that new row be in my datav...more >>

I was wondering how you can pull the description of the column item? http://users.adelphia.net/~micromause/oledb.png Thanks! ...more >>

How can set nothing value to a textbox binding to a decimal dataset column that allow null values? If I enter nothing in the textbox, it doesn't accept the new value and it goes back to the previous value. ¿How I can set again to Null? Regards. ...more >>

I am about to embark on the road of VB.NET and Oracle. What data providers are there? Robert ...more >>

I have a datagrid bound to a child table in an ADO datarelation. If I add a single entry and do a DataAdapter.Update, it will not save the row. If I either 1) add two rows or 2) select the second, empty row (resulting in an asterisk "New Row" row) then it will save the first successfully. I'...more >>

Why, from VB.Net, can I not return an identity column value? It requires the use of a stored procedure. Why? What am I missing? Not being able to return and Identity value from a table defeats the purpose of relational database programming and design. So here I am, code all written and at...more >>

How do I set my DataGrid to not allow new row additions in Visual Studio ..net 2003? I just want the users to be able to edit records already placed in the database previously, not to allow them to add new records. ...more >>

I am using VB.net Ent Arch 2003. I have a dataset that was made through the wizard to create a Windows Data Form I have a DataGrid to show/edit the table from my DataSet. I want to: Be able to choose the subset of data from the table and then have that presented in the grid while still...more >>

I have built a customized ADO recordset. I would now like to put the data into a data grid, but the OleDbDataAdapter fill method wants a table name. Is there a way to put a customized recordset into a data grid without using a table name? or is there a default table name give to the recordset? ...more >>

Hi, Is there any real performance benefit to having 1 dataset with 15 tables, rather than 15 different datasets with 1 table? Thanks Dave ...more >>

To all of the VB expert, Can anyone kindly answer my following questions: 1. In a text file, the content is just "abc", and then i press "enter" key, and save it. But if i use the fileLen(), the function will return the value of 5. But if i don't press the "enter" key, straight away...more >>

I want to edit the source of a Dataset I have set up using the Data Forms wizard. Is there a way to either filter the data to get the subset I want or to change the recordsource of the Dataset all together? btw this is in VB in VS.net 2003 ...more >>

Any ideas on how to do this correctly so I can set the tablestyles and not have the table show up as a child? I keep getting stuck, so if anyone can help, it would be greatly appreciated! ...more >>

Hi, I'need information and examples on Multithreading programming in VB.NET. Please send information to federico@gazum.com Thanks and Regards, Federico ...more >>

Hi all, Is there a way to get database schema info via ADO.Net? I have two databases (one is a Jet database, the other is an Oracle database). I want to enumerate the tables in the Jet database, and, for tables whose name meets a certain criteria, compare the table's field properties against...more >>

Hi Needs some help with data view i have the following cod I have a class called DataClass see belo 'Option Explicit On Imports System.Dat Imports System.Data.SqlClien Public Class DataClas 'Private Shared strConnectionString As String = ("Provider=sqloledb;Data Source=(local);Initia...more >>

I am trying to create a very simple app that could potentially be used at many workstations in our company. I would like the app to access an access db that resides on one of the pc's on the lan. what I would like to do is check for a connection to the db and if it does not exist open one usin...more >>

I have a grid that is getting it's data from a stored procedure (Sql 2000). Anyway, the column is a datetime in sql.. but when vb grabs it and puts it in the datagrid, it only shows the mm/dd/yyyy. I want the time displayed as well. How do I do that... If I'm using a dataset.. please include th...more >>

i have create ,using vs.net, typed dataset with relations. I would like to ask if it exists a tool,which can take the xml schema of typed dataset and generate equivalent SQL queries with relations so that i can create tables in my sql database. Thanks u ...more >>

I've tried every possible combination of commands to insert a new record into an Access table, and it just won't happen. Does anyone know if Access has problems working with .NET? Check out this link: http://www.dotnetextreme.com/code/BasicAdo.asp This is the simplest code sample I've se...more >>

Can someone tell me specifically what's missing in this code so that it won't write the record into the database? Please, no references to lengthy, bloated, meandering articles telling me how to make a watch when I'm merely asking what time it is. Dim thisDataAdapter As OleDb.OleDbDataAda...more >>

Hi, I am about to develop a VB.NET app with MS-Access. Could anyone help me to decide choosing the provide. Whats the advantage of using ODBC provider? Will there be a potential risk of using OLEDB provider with Access. Please share me your thoughts, any articles realted with this. Sel...more >>

Hi , I have a Stored Procedure that return an xml (by using the xml auto or explicit) in to some XmlReader and i m getting the following error . Invalid attempt to GetBytes on column ''. The GetBytes function can only be used on columns of type Text, NText, or Image. pleas note that ...more >>

I'm trying to insert a new record into an MS Access table. The code below compiles and runs, but it doesn't write a record into the table. Can someone tell me why? Dim thisSelectCommand As New OleDb.OleDbCommand("SELECT * FROM Sessions", Me.OleDbConnection1) Dim thisDataAdapter As New Ol...more >>

Greeting all I have a form that has a combobox. I populate it with a datareader and it works like i want it to.. BUT.( always the but huh).... I now want to reference a field in the row that does not appear in the combobox.. Im stumped thanks ...more >>

I have a List Box that is Binded to a DataSource to hold a list of invoices. However, it dosen't seem to be populating. Is there any (known) reason for this? (I have cleared the DataSet and Filled it using the DataAdapter)....more >>

Hello. I have some problem. I'm reading some data from MS-SQL Table, there are some Null value fields (VARCHAR Type). Now when I want to test if the field is empty (Null) there is error: (in VB.NET or C#.NET) I write : ------------------------- If Not SupplierDS.SUPPLIERS(i).ADDRESS Is DBN...more >>

Hello. How can I check if DataSet field value is Null? ...more >>

Hello. How can I check if DataSet field value is Null? ...more >>

In the Code Below I need to add a node to my DataSet Currently the XML is Returned in this Format <NewDataSet> <Orders> <OrderID>10248</OrderID> <CustomerID>VINET</CustomerID> </Orders> <Orders> <OrderID>10278</OrderID> <CustomerID>ZINET</CustomerID> </Orders> </NewDataSet> ...more >>

I'm trying to insert a new record into an Access table based on values in the controls on a web form. I've tried a combination of techniques, none of which seem to work. Does anyone have any sample code that does this? All my books assume I'll be using stored procs, which I am not. ...more >>

Hi, I have a datareader obj that returns a variable list of records. I would like to get a count of the number of records that were returned. I need that value to set a JavaScript array size. Is there a method or propery I can call on the datareader oject to obtain that value? I have not b...more >>

Hello. How can I set input mask for TextBox in Windows Form? For example I want to mask (format) TextBox for inputing phone number like (999) 999-99-99. The TextBox must first show something like this: (___) ___-__-__ Or is there any free component for this? How can I do this? ...more >>

Ok this is an issue that kept me searching for days now, and I think I'm almost turning mad, cause I really can't find the solution. Ok so i have an application that uses a special treeview control, the xmltreeview. You can see it here: http://www.devx.com/dotnet/Article/17829 This treeview...more >>

I have an Oracle table where I would like the queried data to go into text boxes. This is where I am at so far, and I am having a hard time finding examples to accomplish this. Should I use Oledb or ADO (this is a standard windows form)? How do I put each field in its own text box? How can I ...more >>

Hi All, I have a typed data set that I that two tables joined in a one-to-many relationship. I have added the relationship to the dataset schema and all seems to be working well. The parent table is displayed in a datagrid. However, since a realtionship exists the datagrid insists on sh...more >>