I noticed that if I have mdac 2.7 on my server, installed together with Visual Studio .Net installation, everytime I refer to a unique ID, it returns me the ID without the curly braces. Any idea how to retain the curly braces? Thanks and regards, subi...more >>

I am trying to format a textbox (to display it as percentage) using the following code (taken from the help sample), but it doesn't work and I found the faulty line but don't know what to do with it. private BindDiscount() { Binding b = new Binding("Text", this.dsInventory1, "Table.Discount")...more >>

Hi all. I have a DataTable populated and binded to a multiple controls. When i change a value in any control, that value is refleted into DataTable. But there's a bug: the property RowState for the current Row is "Unchanged". The value would be "Modified." Any one can help me PLEASE ! Thanks...more >>

Hi, When I retrieve a table from database to Dataset, Is there anyway to know what is the table name,its name originaly in the database, through any DataSet property, or form Bindingcontext ones? MTIA, Grawsha...more >>

Hi, I was wondering if I could create a DataColumn that can contain images and add it to a DataTable. It appears there is no System.Image datatype to choose from. How do I go about doing this? (I want to store images in the database, not just a string indicating where they are located) T...more >>

hi friends I am developing web application in .NET using c#. I encounter a problem in binding the results to the datagrid. I have a storeprocedure that produce 2 results set. I need to read the results and bind it in a datagrid control. But i am able to bind only one result set eventhough i am us...more >>

I am writing a "generic" routine which will return to the "calling" procedure a list of all of the parameters and the parameter types. The intent is the calling program will read the "Parm names and Types" and build a HashTable of the values which will then be passed back to actually build ...more >>

Hi, Using C# and I need to instantiate an object and then serialize it and save it to a database. I have declared my class and used the [Serializable] tags etc. I am using FileStream and BinaryFormatter to serialize ok but when I come to save to the db I get an error saying I need ...more >>

I've got a simple SQL Server 2000 table with an ntext field defined and I'm having a heck of a time inserting html into it. Everytime I try, I get an ADO.NET error complaining about invalid syntax because its trying to parse out the various HTML tags (>,<,+, =) and it's puking. Is there a way t...more >>

Check this out. I try to execute a stored procedure on SQL Server 2000 like this: cmdA = New SqlClient.SqlCommand("NP", cnnMain) With cmdA .CommandType = CommandType.StoredProcedure .Parameters.Add(New SqlClient.SqlParameter("@Name", strName)) .Parameters....more >>

Hi, I've got a small C# application that connects to my database via the ..NET OLE DB managed provider and it targets the 1.0 version of the ..NET framework. Pooling seems to be working fine, and I'm not seeing multiple connections fired up during a run through the app. However, when I targ...more >>

Hello I'm trying to delete a row from a dataset with the following code: public void Update() { oleDbDataAdapter3.Update(dataSetGen11) ; } public void Delete(int iIndx) { dataSetGen11.Tables["Stam"].Rows.RemoveAt(iIndx) ; Update() ; dataSetGen11.Tables["Stam"].AcceptC...more >>

Hi, I am using SQLTransaction. I just wonder if it is possible to use the same transaction over multiple command object. I would like to have 3 commands object in my code (3 inserts or updates) and put them in the same transactions. Somehow in the .NET framework reference, it is using a sing...more >>

Hello, I have a dataset with just one row and an existing open connection. The datarow contains some changes. Would someone know an efficient way in terms of performance to do this? Thanks!! ...more >>

I am looking for an elegant way to have a calculated field in a DataTable. Using the Column.Expression property appears to be limited to simple expressions. An example of where this might be necessary follows: Suppose we have 2 tables - Order and OrderStatus. In Order we have a field called S...more >>

I'm trying to call a stored procedure adding parameters by specifying their names. I used to do this in VB with the NamedParameters option on a recordset I believe. If someone could tell me how to do this i would be very gratefull. Anyway while I was trying some stuff out to get this to work...more >>

I am using typed datasets and I am getting "does not allow nulls" errors when I add new datarows. Where in the schema (xsd file) does asp.net know that a column is required? I do not want to add default values for each column. Karim...more >>

Hello: Firebird .NET Data Provider 1.5 Release Candidate 1 available for download. Release Changes: - Bug fixes. - Better fit to ADO.NET. - Improved blob reads. - Improved character sets handling. - Performance improvements. - Added support for Firebird-like connection stri...more >>

Anybody know how to connect to a SQL server with a port installed on a port other than 1433? Thanks, Jim ...more >>

I have a SQLConnection object, DataAdapter, and Dataset on my form. I am able to connect to the SQL 2000 server and retrieve data into my dataset. When I bind a textbox to a dataset column which contains a date, I see both the date and time displayed in the box. How can I only display just the da...more >>

I used to have the following code in VB/ADO when using a FOR XML clause in SQL Server. Is there a .Net/ADO.Net counterpart? ' Set strm = New ADODB.Stream ' With strm ' .LineSeparator = adCRLF ' .Mode = adModeRead ' .Type = adTypeText ' .Open ' End W...more >>

Hi, I have a little problem with the Dataview Rowfilter. I use the following syntax to filter my datas VueMarge.RowFilter="idbonf<>0 and dcdef>=#" & tDate1.value.ToUniversalTime & "# and dcdef<=#" & tDate2.value.ToUniversalTime & "#" But it doesn't work. I can't retreive any datas from m...more >>

Hello,friends I've got this error now after user tries to connect to AS400 ("Ordinal=1 Status=UnsupportedConversion) Can someone shed light on the problem? Public Const CONNECTION_STRING As String = "Provider=IBMDA400;Data Source=00000.1;User ID=KK;Password=RR" Private Sub Form1_Load(ByVal s...more >>

I am trying to pull data out of a data reader by column name from a cmd that joins to tables. Both tables have an "ID" column. How do I access by column name and include the table to access from? All of my code and sql is below I want to access the data this way to that I don't have to alias ...more >>

Greetings, I would like to know of a way to reflect changes to dataset from data-bound form without the need to move forward? MTIA, Grawsha...more >>

Greetings, Thank you for your kind attensition... I have an app, one MDI form,frmMDI and one childe frmData. I did databinding,using frmMDI bindingcontext property, to a table in the dataset (dsEmployees). I use frmData to enter and search data. I use dsEmployees to to get records from t...more >>

Hi, I've got following problem: I'm filling a DataGrid with a data retrieved from a join statement. The user can insert new lines into the grid or manipulate existing ones. My question is how can i write that changements back into the database if I have to insert values into several pages? Inse...more >>

Here's the basic problem pertaining to the question to come. Using Access Database with the following tables Customers -CustomerID (primary key) -Customer name,address,phone Orders -OrderID (primary key) -CustomerID (referential key) -Order Data OrderDetails -OrderDetailID (Prima...more >>

hi all I have a dataset generated by an oleDbDataAdapter, there are about 20 columns in the dataset, but it seems like it takes a long time to initialize the dataset, e.g. if I fill the dataset on a button click, it will take 2 to 3 seconds to return the first fetch, but all clicks onward wil...more >>

Hi! does anyone knows how can i put an image column inside a typed dataset. i read that it's possible but couldnt find how. thanks, Uzi ...more >>

Hi, I am using .NET 1.1 and SQLServer 2000. I have a table with some strings with new line chars. E.g.: "This is line1.\nThis is line2.". When I read this using a DataReader into a string, it is reading as @"This is line1.\nThis is line2.". So, when I display it using a MessageBox.Show(myMe...more >>

Hi, I got around Excel omitting certain cells when its type is numeric by providing Extended Property IMEX=1. Now the problem is the numeric values aren't really numeric at all -- it's a symbol that happens to be numeric. Excel is returning these symbols in scientific notation and in ...more >>

The location of my Access database is "c:\lora\lora.mdb". I'd like to declare a Common Variable that can store the Connection String values for a Database. But, I'm not sure about the code to be written in the App.Config. Also, how do I bind it at run time using code? Thanks!...more >>

I have a datatable . My requirement is to sort the table rows in ascending and descending order basing on the columns which I give it. I've used the following expression ds.Tables[0].DefaultView.Sort="au_fname"; but it's sorting in ascending order but not in descending. How to speci...more >>

I'm sure this has been done before but I can't seem to locate anything on this subject so... I am looking to write a management component using VB.NET and ADO.NET that returns a list of the 'active' users against a specific named database in SQL Server 2000. The key point here is 'active'...more >>