Hi, I am trying to run a SP that takes about 90 seconds to complete. If i run it from SQL Server, it completes ok but if I run it from my .NET application, I get a timeout error after about 40 seconds. I set the Connection timeout in the connection string builder to 180 but it still time out...more >>

Hi I have a SQL string on the lines; "SELECT a,b, c FROM MyTable WHERE MyTable.d = '" & Me.MyField.text & "'" The value of Me.MyField is provided at runtime by user. I need to assign the resultset of this SQL to an UltraGrid for view only i.e. no editing just display. My questions are; ...more >>

Hi all, How I can use the ADO.net 2.0 , asyn sql command execution ? Murali...more >>

Hi, In ADO I could read the property .DefinedSize of a field of a recordset to determine the max size of the field. This is very usefull to set the maxlength property of a textbox. How can this value be determined in the ADONET- Dataset or datatable. thanks for a reply Ton ...more >>

Hi Gang, I'm curious if this is a bug in Studio or not. Here's the background: Our system has SQL Server installed and our DBA's all create our databases. We are not DBOs in any of those databases. We do have rights to create stored procs, they all show up as our name in the owner field. ...more >>

c#2008 / sql server 2005 I have a stored proc that takes 2 parameters if run it through management studio either with pramaeters x,y or a,b it correctly returns the same set of data (about 100 rows) in about 1 (one) second if i run it through my c# test harness (using a dataadapter fill) ...more >>

When using VB.Net, what type do you choose for a TIMESTAMP parameter? SqlDbType.Timestamp OR SqlDbType.VarBinary And what size do you enter? 8? Regards TR...more >>

I was testing a method that updates several stronglytyped tables with a sqltransaction and noticed that the number of connections never returned to zero until I exited my application. (It ended with 1 connection) My code had made use of the "using" statement so that the connection would b...more >>

Hi Is it possible to create a datasource for dataview control for an sql string? Thanks Regards ...more >>

I'm writing an application that needs to store data locally (in C#). This will be deployed on end-user machines (XP, Vista and 2003 Server). I want to store the data in a database. The volume of data is not huge (about 1 to 5 megs). My question is what database to I use? I can only assume t...more >>

I am at this point (<<<) in my Insert logic against a SQL2000 back-end: Try .... MyDataset.Tables(0).DefaultView.RowStateFilter = DataViewRowState.Added If MyDataset.Tables(0).DefaultView.Count > 0 Then Adapter.Update(MyDataset.Tables(0)) End If Catch ex as Exception RaiseEve...more >>

Hi all, I have a SQLCommand object that has been set with a Stored Proc & the required parameters. I would like to somehow retrieve the sql text that is sent to sql server as a result of execution of this command object. Is that possible? So basically I want to extrapolate the text that ult...more >>

Hi What is the purpose of exception.GetType and what are the possible values returned by it? Can it for example tell me if the exception is of type DBConcurrencyException? Thanks Regards ...more >>

Hi I am trying to do a 1 to many relationship using dynamic textboxes, binding navigator and a filter. It works on form_load but when i change to the next row on the bindingNavigator I get. "Object reference not set to an instance of an object." Here is the code: DataRowView...more >>

I need to copy an entire row of a typed DataSet so that I can place it into a different instance of the same type of typed DataSet. I don't see a clone or copy method on the DataRow. Do I have to create and populate the row manually? -Scott ...more >>

Hi I am updating a datatable in a dataset as below; daMyAdpater.Update(MyDataSet.MyTable) How can I trap various different exceptions that may occur during this update process? Thanks Regards ...more >>

Hi How can I save all values in a system.data.datarow to a string? I need this for error logging purposes. Thanks Regards ...more >>