Hi. I have some problems debugging stored procedure that have '.' (dot) in the name. If I choose to step into such a procedure, Visual Studio stops responding before showing me the dialog with the parameters. Is there any workaround? Thanks. - Pedja....more >>

HI, When using a datareader, will the Connection remain until the datareader is closed or the connection is made everytime when the 'Read' method is called? Sample code. While dr.Read ' Manipulations .... .. .. End While dr.Close() My friend says, here the connection is ma...more >>

Hi, The datatype property of a datacolumn tells me about its type, but how can i have the size of a datacolumn. Thanks for your help. ...more >>

Hi, We want different row types at the same time in a DataTable. The idea behind this is to support a kind of inheritance in a table. To do this, we had overridden the NewRowFromBuilder method. Then we select the row type construction using a special column that contains the type of the databa...more >>

I have a Dataview that I read from a Dataset. I am trying to sort the items in the Dataview and read the sorted items, but it does not display the sorted items. Here is the code: DataView myDataView = oDS.Tables[0].DefaultView; // By default, the first column sorted ascending. myD...more >>

Hi! I am trying to open a connection to a SQL Server database using just the Framework, Notepad and the browser. I keep getting the error message "SQL Server does not exist or access is denied." I am using the following for the connection: Dim conPubs As SqlConnection ConPubs = New ...more >>

Hi, I would like to retrieve the names of the parameters of a strored procedure without execute it... Any idea ? ...more >>

System: XP Pro, IIS, Access 2000, Visual Studio .NET I'm accessing an access database from a webpage. I have no trouble using select to access the information, but I receive errors when I try and UPDATE, DELETE or INSERT. If i use Access 2000 directly I can. Any ideas on how I can figur...more >>

Hi: Im trying to store a byte array on an access database, I selected "Ole object" as the column type, but it seems not to be the correct way.. Is there any way to store long byte arrays in a table on an access database? ...more >>

I've got a bug that I'd like to report regarding the OracleClient, but can't see any way to do so on the Microsoft Support site. Since Microsoft reps listen here, I'll post the bug and it's workaround here. Thanks... -dave --- Bug Report Follows --- PROBLEM: In the Microsoft OracleCl...more >>

I would like to be able to run a batch sql script from inside my application on a SQL Server 2K database. The script has all sorts of commands (inserts, updates, deletes, creating indexes, etc.). It's the sort of thing that I could copy into a window of Query Analyzer and run. It could be pretty...more >>

Hi, I have two question regarding retrieving results from a DataSet. First, what is the best way to retrieve results from a dataset with a filter? Right now I am using the DataView class. I also have a question regarding the DataView class. Using the code below how do I cast the data return...more >>

I have a table with close to 100 columns in it. When I try to create a data adapter for it in VB.NET using all columns, I get an error when it generates the SELECT statement that just says "There were errors configuring the data adapter". It does not matter whether I choose to use SQL Qu...more >>

Hi, I have two question regarding retrieving results from a DataSet. First, what is the best way to retrieve results from a dataset with a filter? Right now I am using the DataView class. I also have a question regarding the DataView class. Using the code below how do I cast the data return...more >>

Hello all, My aim is to populate a sql server table from an Excel spreadsheet. I have opened a dataset from excel. I have also opened a data set from a sql server table(purposely requesting the first line only to save space). I have then merged the two. I now need to insert the new (merg...more >>

Hi All, Is there a way that I can bind a certain range of rows in a DataSet to an ASP.NET repeater? I want to add paging to the repeater, so only want to display 10 rows of the dataset on each page. I did manage to do this by creating a DataView of the DataSet and deleting all rows th...more >>

Hi, I'm having some difficulties updating a Dataset. The problem is the Dataset does not get updated when I modify a bound textbox. Although I see the changes whene I move next or previous in the form, however, when I check the HasChanges flage of Dataset, it returns False. This clearly ca...more >>

Hi there! Everyone has no problem with OleDbCommandBuilder but I fighting with it for quite long time... Nothing special, SQL Server 2000, simple program in VB.NET that causes no error. When I debug I see that everything is correct, data in dataset is changed but, no changes in database. ...more >>

I have a VIEW as follows: CREATE VIEW dbo.System_Data_Dictionary_Tables AS SELECT INFORMATION_SCHEMA.TABLES.TABLE_NAME AS Table_Name, (SELECT REPLACE(CAST (sysproperties.value AS NVARCHAR(255)), ',', ';') FROM sysproperties WHERE ((sysobjects.id = sysproperties.id) AND (sysp...more >>

I declared a variable as IDbDataAdapter and instanciated it via the Activator (Activator.CreateInstance, where the string value was read from an ini-file). The Problem is that the variable only accepts DataSets for Fill and Update, I would like to pass DataTables (and DataRows) like when th...more >>

Hi all, Can anyone explain me how to use the Dataadapter methods like insertcommand,updatecommand and deletecommand with some clear samples. What I wanna know is how will you add a new record or edit an existing record and so on via these methods. Any help appreciated. Thanks Bha...more >>

There are many examples out there of how to do SQL or REF CUR's for ODP.NET. I can't for the life of me find an ASP/VB example of a straight procedure call, nothing fancy. I think I'm close, but I can't figure out how to get the values from the output parameters. Anybody have a working exampl...more >>