Hi All, I am new in .net world. few of my friend told me that internal data format of DataSet/DataReader is XML only not the Binary format is that true ? Thanks Mr.Bug ...more >>

Hi. I want to execute a stored procedure. I am using sql server 2000 and vb.net. I need to retrieve the data in a dataset, not in a DataReader. how can I do? Thanks. ...more >>

I'm inserting the value of richTextBox.RTF into a new row in a DataSet. The update works with no problem but it's only storing a fraction of the RTF value. The SQL2k datatype is set to varchar and MaxValue of 8000. But it's not even storing more than 500 characters if a 1000 character variable...more >>

Hello, I have two tables that I am needed to generate reports from, one has 10 million rows+ and the other has less than 200,000. These number of rows will be increasing fairly steadily over time. I have some queries that do counts and group bys along with some sums on these two tables and...more >>

Hi to all, I want to save any object in an SQL Server Image field. Currently I'm trying to save an retrieve a DataRow object in an Image SQL Server field. Can anyone help me? Thanks to all. Javier Álvarez. Madrid. SPAIN. ...more >>

I am trying to return a clob from a stored procedure. Specfically, I am trying to call Oracle Intermedia's CTX_DOC.MARKUP procedure. I get the error "ORA-20000: interMedia Text error: ORA-22275: invalid LOB locator specified." I have not much luck finding helpful information from OracleClien...more >>

Hi All I have followed the MSDN example for setting up a master/child windows form, using textboxes and a datagrid. The textboxes display values from a single record (the master) and the datagrid shows the related records. For calrity I'm using two dataadpaters one dataset and I have a relat...more >>

Hi I am trying to fix a concurrency related problem. Could someone please tell me what happens when the addnew() method of a concurrent manager is called? Thanks Regards ...more >>

Hi: I'm new in ado.net. I saw quite number of method used to insert/update record to sql server. Which one is the best for my senerio. I only insert/update data (properly single row only) to sql only without returning any value. It will run as window service or webservice. 1. Using Data...more >>

Hi, I'm using ReadUncommited level so that others can do a dirty read. But it seems not to be working. What am I doing wrong here. Below is my test code:- Thanks. SqlConnection myConnection = new SqlConnection("Initial Catalog=TEST;UID=sa;PWD=;Data Source=TEST;Connection Timeout=50;Connecti...more >>

Hi all, I am trying to upload file (>500 MB in size) from my webform. Bandwidth is not a issue as the asp.net application would be used in the Intranet environment. Can someone plz suggest any asynchronus way of inserting records into database from a dataset ? Also, is there any ansync...more >>

I have one application at the moment that's behaving oddly. When I run it in debug mode after a few SQL statements have been issued, I get an "Illegal operation exception in System.Data" with a further note that it's likely to be the connection pool being full. A few points... 1. If I ...more >>

Hi There, Could someone tell me how I could initialise my dataset for entry of a new record, so that the data bound text boxes would be cleared? Josh ...more >>

Hi There, I've created a form with several databound textboxes. One of the textbox's text is filled in programatically (through code). The problem is that if i change the value of this text box say txt1 and then tab through the other textboxes, the original value of txt1 will appear in txt1 ...more >>