Hi I have created a dataset by dragging tables over it from server explorer. How can I get the standard select/update/insert/delete sqls generated from here? Thanks Regards ...more >>

Ok, i will try this again. i have a form that has a dataset. on this form is textboxes bound to specific fields. if i issue this code and only this code. something that i find odd, but maybe normal happens. FormName.BindingContext(DataSetName, DataMember).Position += 1 it seems t...more >>

Okay how would I do this? I want to query an access databases and then display a graphic based on the value of a field in the query. For example the data base would be something like this: Name: Password: Rating Steve password ...more >>

Hi I am using the following code to populate my list box. How can I now have multiple columns in the list box? At the moment there is only one column company that's displayed. Thanks Regards Private dv As DataView dv = New DataView(ds.tblClients) lstLocate.DataSource = dv ls...more >>

Hi, I try in the Application Block to send the sqlCommand (object visual) parameters to the SqlHelperParameterCache.CacheParameterSet(). Some code is: SqlHelperParameterCache.CacheParameterSet(CONN_STRING, spName, sqlInsertComm.Parameters); Where spName is the StoreProcedure (the sqlComma...more >>

I have a question using Application Blocks for .NET. Wich is the better way: A) Create the objects manually, creat the DataSet, Parameters, SqlCommands, etc. Like: DataSet ds = new DataSet(); or B) Create the objects visually, because I have all there: DataSet, SqlCommands, the paramete...more >>

Can anyone definitevly tell me if I can encrypt a password using TripleDESCryptoServiceProvider with output as a stream in a byte[] 1-dimensional array and save it as varbinary in SQL Server 2000? I have read that a dataset will not support this and that a datareader might? My code works...more >>

Hai All, I need some help. I am calling a stored procedure using ExecuteNonQuery (I am not expecting any results back from the stored procedure). When there is something wrong with the stored procedure execution, the procedure returns different error codes ( I call the RETURN() method ). How...more >>

Hi, does anybody know where I can find any example about how to insert, delete and update records using datagrid. I want to bind a dataset in the datagrid and after that perform those operations. Tks, Marco ...more >>

Hi, Im sorry, but i have never really used a database from VB. Im showing data from a database via a datagrid and i want the user to be able to update the records by writing on the datagrid. Could someone help me with this code Dim cn2 As OleDbConnection Dim strSelect2 As String Dim dscmd...more >>

Hello Newsgroup! I want to write a little WebService and an Application for a mobile Device (Pocket PC 2002), which gets Data (a DataSet) from the WebService, which reads the Data out of a SQL 2000 Server. My little Application gets the DataSet and shows the Data in a DataGrid. That works. ...more >>

Hello, I have an Excel Add-in that is using an assembly that I coded using VB.Net. The assembly has forms in it. If I make the TextBox controls Public I can add handlers, in my excel add-in, to the public TextBox events. The problem is that I don't want to make my TextBox controls public. I...more >>

Hey all, quick question, whats the proper way to build a subtable? I have two datasets; DataSet dsDetails=new DataSet(); then I do; daParent.Fill(dsDetails); // Fills table Parent daChild.Fill(dsDetails); // Fills table Child The parent/child have a one to many relationship on two fields...more >>

I was hoping that someone could help me out with this. I am using an access database and I have a table with an autonumber column. I have this autonumber column set to Long Integer and after the insert i used SELECT @@Identity to retrieve the id of the record that was inserted. However, I now ...more >>

I have a test program that connects to SQL server. All this test program does is create a connection and then closes the connection. The following code is a function to create N connections and then close them... testing the use of the pool which i find it does work as stated in the docs. Now,...more >>

Comming from ADO using SQL, I thought it would be simple to select a record and thereafter updating it. But the examples I have seen so far in C# looks no good to me. Has anybody seen a nice, clear example somewhere? flemming ...more >>

Hello, I am getting this error "General network error. Check your network documentation." inconsistently. It is happening in some of the stored procs but not all the time. This is always accompanied by "Procedure: ConnectionRead (recv())." in the stack. I am wondering is this due t...more >>

I am recieving a error when I call dataadapter.update after deleting a row from the dataset. Does anyone have any ideas? The error is: Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information. strSQL = "Selec...more >>

Hi I am using this (below) code for update. The problem is that when I use update I get the error 'Parameter ?_2 has no default value.' . What is the problem? Thanks. Regards updcomCompanies.Connection = dbConContacts updcomCompanies.CommandText = "UPDATE tblClients SET Address_1 = ?...more >>

While using a Dataview to modify the underlying Table, I ran into an instance where I can modify a value in a row and verify using the QuickWatch that the value has changed, but the rowstate = UnChanged. This causes the DataSet.HasChanges to be false and the DataSet.GetChanges () to be null...more >>

Dear All I'm having a problem while calling a report in the CrystalReportViewer. The error message comming is "Invalid Report Source". The code I written is here below. conReport = New OleDb.OleDbConnection(sConnectionString) conReport.Open() daReport = New OleDb.OleDbDataAdapter("se...more >>

What is the best way to handle this situation: You have a very simple phonelist ASP.NET application where users can view the phone list (dynamic) and they can also update or delete items in the phone list. So, you would have 3 pages -- one that views the info, one that updates the info and on...more >>

Hello - this might be more of sql syntax question but I hope to an answer in this newsgroup. If I write a string that contains char ' ado.net throws exception. At this point I filter for " ' < > (these cause conflict in my asp page). My question is what is the complete list of characters...more >>

Hey all, I'm at a new programming gig, and my team here likes to use the "IDb" data objects instead of "Sql" data objects. Such as: IDbCommand command = conn.CreateCommand(); ... IDbDataParameter param = command.CreateParameter(); ... IDbDataAdapter myDA = conn.CreateD...more >>

Hi, I have a typed dataset with a bunch of tables and many to many relations. While updating I am having problems. That is the exception messages "You cannot add or change a record because a related record is required in table 'tblRoles'." But the related record DOES EXIST! I even tried turn...more >>

When SqlDataReader reads records returned by a query, is there any way to check if the query returned any rows or not? Thanks for your help....more >>

I would be grateful if someone could explain why oledb parameters must be added to the Parameters collection in the order matching the order of the counterpart columns in the CommandText sql statement -- even when the source column name is provided? TIA Timo ...more >>

Hi I try to use the Expression property of the DataColumn in the following way ..Expression = "Convert(colString, Type.GetType('System.Int32')" just as the MSDN samples show colString is a String type column with numeric values In return I get some syntax error exception. Does someone ...more >>

I have a bizarre error I can't figure out. If I open a connection in a subroutine, it returns as error: Here is the subroutine. Friend Sub NewTopic() 'As Boolean 'Return False Dim cn As New OleDbConnection(gstrConn) cn.Open() Dim cmd As New OleD...more >>

Hi I want to call database function using ADO.Net. If anyone have idea.Pls help me. Thanks Ravi...more >>

What could be causing sudden slow performance calling a stored procedure that normally runs okay? Thanks....more >>

Hi, I have two existing tables in a dataset the two tables are in the usuall parent and child format the program first fill in the tables and then I create the relation the problem is that the parent table is missing some of the relation values normally a deleted primary key may cascade ...more >>

Hi, I'm pretty new to ADO.NET and SQL and want to read in data from an Access database. The problem is that the table I want to read data from has some column names that contain a '-' charcter, f.e. 'Online-Kompass'. When executing a SELECT command like SELECT Online-Kompass FROM TheTable I ...more >>