Looking for an idea here. I've got a .Net app connecting to SQL2005 where I allow users to add pictures to the database. But I don't want them adding gigantic images, so I'm looking for an idea on how to control how big of an image they might add. I'm not interested in simply saving a pointer ...more >>

Hello, I have Two Tables in a dataset (Table1 and Table2). I have created a relationship (MyRelationship) and created a View (MyView) from them. I am able to display the data the way I want but I am trying to setup a search function. I can search anything in Table1 without a problem. ...more >>

I noticed that strings don't sort correctly when they contain numbers. For example: Series: 0 Series: 100 Series: 101 Series: 101 Series: 102 Series: 11 Series: 110 Series: 112 Series: 113 Series: 128 Series: 13 Series: 130 Is there anyway to provide a custom sort? I believe string.C...more >>

Hi, I am trying to figure out if I should be using the RowChanged event of my tableAdapter or a RowUpdated event of a dataAdapter? I have used data connection to my database file to create a typed dataset and table adapters to allow me to load and save data to my database. However, since ...more >>

Hi, this was one of a numerous really annoying issues when moving from .NET 1.1 to .NET 2. After I fill my DataSet with values from the database it sets all AutoIncrementSeed values automatically to the next number in the sequence. I want to keep the AutoIncrementSeed at -1 to avoid conflic...more >>

Why does the insert command not work in a transaction? I am using OleDb with MS Access and ADO.Net and VS 2003.net I create the connection and dataadapter initially in a function and return them so I can reuse them And in one case I would like a transaction. But when I fill the datarow it f...more >>

Hi I have two different DataTables populated with rows from separate queries. They both share the same column ID. I would like to create a new DataTable where the rows in both tables match, i.e. like using an SQL inner join. What would be a good approach to solving this? Many thanks An...more >>

I have a Windows Forms Application with a DataGridView which is bound to a typed DataSet. For reasons specific to the application, I add a record to the database table when a button is clicked on the form. This button creates a record with default values so the user only has to change what they ...more >>

Hello, Does anyone know if it is possible with .NET to load an XSD file and use that as a database schema template to generate a new database? I had hoped I could load the XSD file into a System.Data.Dataset object, and then pass that to something like a System.Data.SqlClient.SqlDataAdapter ...more >>

Hi all, For various reasons I am accessing data from an access database with multiple tables. I am unable to upgrade to SQL Server (even the express edition), so I have to do this in access. At the moment, my sql statement is as follows: "SELECT * FROM software,vendors WHERE vendors.vend...more >>

I have a asp.net gridview that I want to send a single column to a stored procedure as an XML string .. the code produces an xml document with all the columns. I only want to send a column called "RatePlanId" Dim View As DataView View = CType(RateGridSource.Select(DataSour...more >>

I am really confused about TableAdapters, Datasets in general. I have added them to my Windows Form simply by dragging fields onto my form. Now, when the user presses the Cancel button, and I want to determine that something has changed, ie, If Me.MYDataSet.HasChanges = False, then MsgBox("You ...more >>

I am getting a NoNullAllowedException when I try to add a datatable to a dataset by using dataset.tables.add(datatableOld.copy()). I checked the AllowDBNull property on the column of datatableOld that was throwing the exception and it is set to "true". I am not sure why I am getting this e...more >>

Could anyone point me in the right direction for the best way to insert a record into a SQL database using ADO.NET with 150+ columns? 1. DataReader + SqlCommand.CommandText + Insert statement 2. DataReader + SqlCommand.Paramerterized Query + Stored Procedure 3. DataSet + AddNew() 4. Othe...more >>

I have the following code to open a database. Since I don't have the db as specified in the connectionString, the connection.Open() will throw an SqlException. My question is why it opens the "SqlException occured" dialog before it goes to the catch block? Is there a setting to turn the dialog...more >>

Hi, I am implementing Business object, but while implementing this I want to have DataTable or DataSet as part of Business Object. For example, I want to bind controls directly to these Business Objects. So please suggest me how can I achieve this?? Is is good to create a Property in Busin...more >>

Hi, I have a C# Desktop application that uses ODP.NET as the data provider. I want to find out if there is a way to include ODP.NET dlls along with the application MSI. Just including the Oracle.DataAccess.dll within the msi does not work. Maybe I need to include ODP.NET within a launch ...more >>

Hi, I've tried with: dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL", typeof(decimal),"Sum(Child(dsAES_aes-aes_packages).F35_GROSSWEIGHT)"); dsAESWS.Tables["aes"].Columns.Add("F35_GROSSWEIGHT_TOTAL", typeof(decimal),"Sum(Child(dsAES_aes-aes_packages.F35_GROSSWEIGHT))"); ...more >>

Hi, I am trying to be a thorough coder and create an app in layers. I can do it using the sqldatasource but I really want to try creating the app with tiers....thus.... If I use VS2005 to create a typed data set, I see that I can allow VS to automatically generate INSERT, UPDATE, DELTE, st...more >>

I found that when I fill over 10,000 records to a dataset, there will be an error "Internal Connection error". Please help. ...more >>

Hi, Im trying to develope a web application that could be used for stroing data such as formated text including pictures . the text should be inserted in word documents,html or xml. please does any one can help me ? in other words i want to develope somethings like a NEWS WEB SITE that every ...more >>

What objects and services do I use to visualize the collection of tables and the table's collections of columns in a SSCE database file. Something parallel to excelConn.GetOleDbSchemaTable() but for SSCE to allow me to see the contents very quickly. The Data Source Display inside vs2005 are...more >>

I'm trying to get the hang of using master and content pages in ASP.NET 2. I have a web page of various reports setup in a table like this: ************************************************ * * * Header * * * **************************************...more >>

I am trying to run the following method and keep getting the error "No value given for one or more required parameters". I've seen that if you have a field misspelled, that you can get this error, so I ran the query through Access and it works. Can anyone please tell me what I am doing wrong? ...more >>

hi, i wabt to insert a rich text format(*.rtf) file type with a picture into sql database. i have done this issue by converting rtf into web page and save the html code into sql server table. but the problem is when the web page has a picture, the picture could not be shown. whats the problem...more >>

Sorry - previous post has incorrect title I am using the following code which appears in slightly different versions in many articles on the web Dim excelConn As New System.Data.OleDb.OleDbConnection Dim dtXlsSchema As DataTable Dim int As Integer excelConn.ConnectionString = "Provider=M...more >>

Hi There! I'm looking into Strongly Typed DataSets in the .NET Framework. I know it can generated strongly typed tables as objects and column names as properties. However, one thing that I would like to know is if it wraps database Stored Procedures as methods and functions? For instance...more >>

I'm using datasets in vb.net to pull the data from MSDE server. I refresh the data from server every 30 seconds. Since, i refresh the data i clear the dataset using dataset.clear and then fill it again. This clear method each time seems to be increasing the delay to refresh data. My dataset has info...more >>

Hi, I would like to convert an Oracle GUID to its string representation and I don't know how I can do this. Could you help me please. I need this GUID in its string representation to execute an sql query later with it as primary key. Thanks for your help Best Regards Fred...more >>

I have a situation where I must restructure my data access, and was hoping the community could give me pointers or links to articles that would help. My situation is that I need to query data from two separate databases. One is my application's own database, and the other is a Data Mart cr...more >>

I have an ado.net based application (using BDP borland data provider actually). Everything is working fine. Up till now the connection string for my single connection object has been hard coded. set in designer. Now its time to implement login functionality using different user names and passwords. ...more >>

Hi, i have another problem yet with |-seperated values: i have my connection: connCSV = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\path;Extended Properties=""Text""") and my schema.ini: [test.txt] Format=Delimited(|) but i get one big field containin...more >>

Hi, I've read through some posts on this error but none seem to exemplify what I had happen to me and wanted to see if anyone else has seen this. I know a lot of people like to see code, it's going to be hard to show you code examples as I'm using a lot of our common code (which is large) an...more >>

Hello! I'm using the code below to import an Excel datasheet into an ado.net table. The problem is, when I get to the point where I want to iterate the recods, it always thinks that there is 999 records in the table! If the table (worksheet) is larger than that, then it returns an equally ficti...more >>

I have a dataset populated from a variety of sources, such as Access Database, SQL Database and Web services. I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE clause etc in this dataset. What's the best way to do it? Evan Camilleri ...more >>

Hi all. .Net 2.0. It seems the DataAdapter.Update Method changes the RowState of child records to 'Modified' when updating them through a Relation. If the child records' .RowState is "Added" or "Deleted," shouldn't they STAY that way? Otherwise when you try to update the child table, you...more >>

Anyone have experience with the provider from Microsoft vs. the one from Oracle? I haven't looked very much at either. One would assume that the one written by Oracle itself should perform better, since they should be able to optimize it? Any sort of feedback or experience with either of the...more >>

Hi all. Using Dot Net 2.0. I have a typed dataset generated by VS. It contains a parent and a child table with a relationship set up in the MSSQL database and showing in the dataset. _Both_ tables have new records that need to be added to database. I'm able to retrieve the server's autoin...more >>

Hi, i try to import several cvs-files into a database. These csv's are delimited by a "|". (don't ask me why it's named csv then ;-) ..Net seems to ignore my settings in the connectionstring: ....Properties=""text;HDR=Yes;FMT=Custom-Delimited(|)""" i get a table with one field like nam...more >>

Using .NET 2.0, I have a DataView with two columns: JobID (a GUID) and JobNumber (an integer). DataView.Sort = "JobID". When I perform a DataView.Find(SomeJobID), I always get a result indicating the row was found, but it's the wrong row (code below). In the code below, as long as JobID is ...more >>

...more >>

Hi all, Anyone know how to solve the datagrid onclick problem as below: i click a row in a datagrid then the row change to another color, but when i click on another row, the previous row that i clicked still red color, so now have two row that red in color. what I want is the previous row th...more >>

Is there an easy way to filter a datetime column on the year. The following does not work: YEAR(BeginDT) = 2006 Also does any one know if there is a list of valid expressions for the rowFilter? Thanks for your help. ...more >>

I am trying to test distributing a Windows application that accesses a Jet DB (.mdb) database file. On my development box running Windows XP Pro with Office Pro (and Access) installed, it runs fine. On my test machine running Windows Server 2003 without Office, it fails with Request for the ...more >>

Hi, I have a strange problem and i think the sollutions is simple, but I don't get it. I have the following piece of code Dim pCommand As New System.Data.OleDb.OleDbCommand Dim sSql As String = "" sSql = "INSERT INTO dbo.Uitgaven ( " sSql &= " UitgavenO...more >>

Hi, I am having a problem creating a connection string in DotNet. Here is an example below: "Integrated Security=SSPI;database=MyDatabase;server=MySqlServer;Connect Timeout=60" The problem is in the timeout setting. I am running a query using this connection string and it is timing ou...more >>

When looping over items in the RowDataBound event for a GridView (ASP.NET) I can access e.Row.DataItem which shows as a DataRowView. The following code allows me to access the data for that row. e.Row.DataItem, System.Data.DataRowView).Row.Item(0) Is there a better way to access that data? ...more >>

Hi Everyone, I have the project below where I'm pulling out information from 1 table "Subjects", pulling the Subjects, and SubjectCode. The Subjects are displaying in the Combo Box just fine, but I can not get the corresponding Subject Code to display in the Label. I have 2 Data adapter...more >>

Hi, My app needs support for Oracle 10 g database : reading (select ...) + updating + calling stored procedures + distributed transactions eventually. I built it in VS 2005 (ado.net 2.0). What should I use ? Microsoft Oracle .NET Managed provider or Oracle Data Provider for .NET 2.0 ? I...more >>

I think you finally got me! This is an answer i was looking for. But it just feels like a walkaround instead a straight forward, 'by the book (MSDN)' stuff. It's hard to belive that Microsoft did not provide something simpler for a common functionality. Why introducing TableAdapters when t...more >>