Search results for query: *

Hi everybody I need help in resolving an issue, as below. After installing Visual Studio 2005, with SQL Server Express, on my PC; when I try to add a new connection, using Add Connection dialogbox, it reports the following error: "An error has occurred while establishing a connection to the...

When I type in any column of an unbound DataGridView, the data wipes off on leaving the cell. I am using VB.NET 2.0. Please help in finding the remedy.

THOUSANDS OF PARDONS to all the friends who tried to help. The problem was somewhere else. As a matter of fact, all the changes I had been making were commencing in the LOCAL COPY of my database. For this reason, my changes did not reflect in the result set. I again aplogize everybody. With...

Hi everybody I am a beginner and facing the problem in calling a Stored Procedure from within my VB.NET 2005, as below: MY Stored Procedure goes like; ALTER PROCEDURE ByRoyalty @percentage int, @avgprice float Output AS SELECT @avgprice= AVG(price) FROM titles SELECT au_id FROM titleauthor...

Thanks you very much JohnH for the help.

Contrary to DataAdapter used in VB.NET 2003, VB 2005 uses TableAdapter instead. I found the properties & methods of the two objects differ quite a lot. Hope someone will kindly explain the difference in using the two objects. If there is any diagram available depicting the TableAdapter in...

I am stuck with the problem of reading a BMP or GIF image, into a PictureBox control, from the SQL Server database.Once reading problem solved, I will need to load a picture into the PictureBox and then save it into the database. Requesting for help.

I need to include a column in an SQL Server table, which can hyperlink to some text stored somewhere inside or outside the same database. Please help.

When I try to view the Database Diagrams for the sample Northwind.mdf database (which accompanied SQL Server 2000), the SQL Server 2005 reports the following error: "Database diagram support object can not be installed because this database does not have a valid owner" I tried to change the...

How can I enforce Referential Integrity between 2 or more of my DataTables in VB.NET. Please help with some sample code and oblige. R. A. Abbasi

After installing Microsoft .NET Framework 2.0 on top of Microsoft .NET Framework 1.1, how can I use the later Framework version, with my already installed, VB.NET 2003 programs instead of the earlier one? Any advice will be appreciated. R. A. Abbasi

Thank you very much Sevenhalo. Regards R. A. Abbasi

I tried the expected GetUpdateCommand method of the CommandBuilder object to retrieve the Update Query generated by the object. But, it just returns the fully qualified name of the object ("System.Data.OleDb.OleDbCommand"). I could not find any other way. If anyone can let me know, how can I get...

The following procedure does not Update the record(s). '------------------------------------------------------------------ Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Dim dadapter As OleDbDataAdapter = New OleDbDataAdapter Dim...

The following revised procedure still does not commence the InsertCommand property to physically insert a row into the DataSet. '------------------------------------------------------------------ Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

I retrieved the following function from VB.NET help and added a few statements for updating the datasource. But, it does not actually commence the InsertCommand property of the DataAdapter in order to physically insert a row into the DataSet. Please help...

I trieved the following function from VB.NET help, which does not guide how to commence the InsertCommand property of the DataAdapter in order to physically insert a row into the DataSet. Please help! ------------------------------------------------------------------ Public Function...