Hi there, are there any good reference examples for using a bindingsource object ? I new to ado.net and trying to create a simple maintenance app on an sql mobile database. I created a datasource and then dragged a table onto my form (Detail mode). Where to go from there ? thanx in advan...more >>

I have a collection of objects that can be bound directly as a data source into a DataViewGrid... works great, but now I can't figure out how to get the columns sorted in the order that I want, or how to hide certain columns. Is this possible? Paul ...more >>

Hi all, I am trying to figure out how to retrieve the number of records resulting from a select. I tried executereader but the object does not contain the number iof records retrieved. Any suggestions? Thanks, Carlos ...more >>

In VS 2005, I created a dataset with the dataset designer that has two tables that have a parent-child relationship (which I also added in the designer). Each table gets data from a stored procedure. I want to populate the dataset at runtime, passing in a parameter from another control on th...more >>

Hi, C# / .NET Framework 1.1 I would like to query extended stored procedure like stored procedure... However, I found that CommandType property does not have Extended Stored Procedure value..... I tried something like.. SqlConnection con = new SqlConnection(....); SqlCommand command ...more >>

Hello. I have two databases, both of which store an objectGUID (from a contact object) in a UniqueIdentifier Column. How can I search a value picked up in one (using sqlreader) to a value in the other table? For example, using the following: "SELECT * FROM table1 Where objectGUID = '" & sq...more >>

Hi, I am using the enterprise DAL that I downloaded from Microsoft. I am trying to create a data table based SP with a passed parameter but I keep getting a null exception error. I thought it was set-up correctly but it doesn't appear data table is being populated. The code below is what I ha...more >>

I am using Informix ODBC to connect to my POS database. It works fine and shows all the tables in Excel but when I connect to the ODBC in Visual Web Developer it says Test Successed but doesn't show any tables or other information. Any help on getting Informix working with Visual Web Developer. ...more >>

Hello, Sorry for posting this in more than one place, I meant to put it in this newsgroup, not m.p.d.f.aspnet... I have a VB.NET subroutine similar to the following: Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal UpdateConn As SqlConnection) Dim trnDedupe...more >>

I need to retrieve records just as they are and enforce case-sensitivy. For example, my query return 'E1234' in place of 'e1234'. I want to return exactly what is in the table. How do I do that? Thnaks mo ...more >>

Hi! All, How can i validate data filling into a typed dataset? e.g. Say I am importing data from a flat file into a typed dataset. I want to validate that each data entering into the dataset are in match with the dataset Schema and if any error i want to log the same row and move to execut...more >>

Hi there! I'm very new to dot net envirnoment and have little bit understanding. Due to some reason, I need to work straight forward on datasets and webservices and xml. I don't have much hold on the same but would appreciate if someone put lights on the given questions: a) How datasets whi...more >>

I have searched and searched and searched and sear.. anyway, you get the idea. I am trying desperately to figure out how, in "C++/CLI" (Managed C++/2005) to handle the RowUpdated event in my code but can not find an answer that works. I either get the always fun "error C3767: 'FrameWorks::ec...more >>

Hello, I'm getting the a "There is already an open DataReader associated with this Command which must be closed first" error message in the following scenario. The message seems misleading, since the command isn't associated with the datareader, but the connection is. Is there any way to g...more >>

Hi, I have a strongly typed dataset with 2 tables: Orders and OrdersDetails, that have a parent-child relationship by OrderId. I want to be able to work sequentually on each row in Orders and in OrderDetails in the following manner: foreach (TableRow HeadRow in Orders.Rows) { ... fo...more >>

I want to have a a set of "records" (i.e. would have used a Recordset in the VB6 world) that contains a list of say 500 short string values to lookup and then 500 short strings to replace them with when found. What I'm going to use this record set for is to lookup the parts of a street address a...more >>

I am trying to get to terms with the use of updating through a data adaptor in VS 2005. The application allows the user to create forms and add fields and tables to the database and so the code has to be generic. In ADO, one can read the record,change the value and simply update: RecordSet....more >>

Hello, I have Visual C# Express 2005 and Oracle 10g installed. After some problems with different versions of Oracle including a restoring of a system restore-point I now have the following problem: When I try to add a data source to my project I can only select Access-File via OLEDB or L...more >>

Hello, We have migrated a sql server 2000 database to sql server 2005, this was done through scripts (table, stored procedures and data). To access this database we are using an ASP.Net 2.0 application which uses the sqlhelper Aplication Block to connect to the database. Everything work...more >>

Hi, I have 2 ways of selecting data from my table "Membre". 1- By permit number (memNoPermis) 2- By lastname, firstname (memNom AND memPrenom) SAMPLE DATA: memNoPermis: 1 memNom: Walter memPrenom: Gregory memNoPermis: 2 memNom: Wick memPrenom: Timothee memNoPermis: 3 memNom: ...more >>

I am updating an xml column in SQLServer 2005, but it always gives me an error "XML parsing: line 1, character 38, unable to switch the encoding" my csharp is like the following cmd.Parameters.Add("@xml", SqlDbType.Xml); cmd.Parameters["@xml"].Value =xmldata; My xml have ...more >>

Hi all, I have the following scenario: App1: Asp.Net Application that shows reports from some SQL DB App2: Asp.Net WebService with two services exposed for clients, and a single “Checker” in the Application object that checks every some time (normally 2 or 3 minutes) for conditions in...more >>

Hello, With a fairly complete and detailed example, how do I use the DataDirectory keyword? What I ultimately want to do is place my database in the same folder as the executable and have my application find it there. Thank you, Christopher Lusardi ...more >>

Hi, I have some code like this : DBTransaction = DBConnection.BeginTransaction() Assuming I don't book keep the return from this call , How do I 1) determine if there is a DBTransaction pending on this DBConnection and 2 ) if there is , what is the DBTransaction . th...more >>

First off I'll explain why I need something similar to ContinueUpdateOnError feature that a data adapter has, and why I can't just use a data adapter. Basically I'm updating a Large amount of data using BCP to copy the data to a temp table in order to quickly move the mass amount of data from...more >>

Hi Friends, I have created a tableadapter (using wizard of VS2005) with some SQL query statement. But I want to write SQL query such a way that it returns table with one more fields, i.e. Row number. I have tried this SQL query in SQL server 2005: select ordernumber, row_number() over( ord...more >>

I am using Visual Studio with a MS Access Database I just can not work out how to create my parameter for the following Select Fld1, Fld2 from myTable where Fld1 in (?) The value I wish to add to the parameter collection for Fld1 is '2, 3, 17, 9, 235' to add a single Parameter I would d...more >>

Hi, I'm new to ADO.Net and I want to DataViews containing different columns of the same database table. Is it possible without creating 2 dataadpaters? Thank you, Scott...more >>

I want to use SqlCommand.ExecuteNonQuery to execute a Sql which is read from a text file. I want to sql to update a record in myTable, and alter a procedure. The text file is like: -------------------------------------------------------------------------------- UPDATE myTable set Col1='text'...more >>

I have lots of old data files, which I am adding to an Access Database. I read somewhere, that you can select directly on a CSV file or XML by changing the Connection String - Extended Property - or I could have been dreaming. So to save a lot of coding and before I break everything, is it ...more >>

Hi, The gridview linked to this datasource shows nothing. The problem is the value of the variable 'a' which is not passed, i'm afraid ... The code-behind contains the value to be passed: public a As String Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles ...more >>

Hi, I have to develop a Client Server application. What I want is that the server will listen on a specific port and client will connect to the server and then send a request to retrieve/insert some data from/into the database. Database is placed on server side. What is the best way to s...more >>

Hi, The environment is .NET 1.1, VS2003. (can also be .NET 2.0 +VS2005) Suppose I have downloaded a DataSet from the server to the client machine. Now I want to create a *.cub file from this DataSet and save it to disk. I tried using ADOMD.NET but dodn't know how to connect to a DataSet. Is...more >>

Hi, I saw three different syntaxes in command lines: UpdateCommand="UPDATE [mytable] SET [name] = @name ... UpdateCommand="Update `mytable` set `name`=? ... UpdateCommand="UPDATE [mytable] SET [name] = ? ... Does the three do the same? Why those differences? Thanks Phil ...more >>

Hello, This is a compactframework windows app. Iam trying read from a DataRow. myTextBox.Text=myDataRow("MyColumn") If there is a value for the myDataRow("MyColumn") then the statement executes. But if the column is empty I get invalidCastException, When casting from number etc.. ...more >>

I'm using MySql and ADO.net I find myself in a situation where I need to execute many different types of queries. Basically they are all getting the same type of data, but with different WHERE clauses and different levels of required data. For example, one query "GetAllTest" will return A...more >>

Using VS2005 Pro and dotnet 2.0 I am trying to add parameters in the query builder tool while configuring my data adapter using the data adapter configuration wizard. I right-click somewhere on the builder pane and then select properties. At the bottom of the properties window, there is a line...more >>

I am use the new feature of TableAdapter to develop a web application. I use a ObjectDataSouce to link to a TableAdapter The TableAdapter have two constrains. How can I disable one of the contrain when the ObjectDataSouce get data? ...more >>

I mm developping a winforms application. I use a form do include, alter and delete data. I created a connection using the wizard. I would like that each user uses their own password to log in the SQL Server. I noticed the the connection string is in a file named APPNAME.EXE.CONFIG, and the X...more >>

hi everybody I have an assembly that contain Datasets, this DataSets connect to one SQL server 2000 database and retrive information to be use for a web Service. The problem is that when the Datasets (TableDataAdapter) connect to the database this leave one connection open (for each user),...more >>

Hi, How to put conbobox column or any other column into datagridview. please provide me with code in c#. Thanks in advanc -- mahimam_200 ----------------------------------------------------------------------- mahimam_2004's Profile: http://www.hightechtalks.com/m1 View this thread: http:/...more >>

I'm currently trying to run queries in an Access database using ADO.NET. My code works when executing a query whose name has no spaces but errors out if I try to run a query whose name has spaces in it. Example: When running a query named: "My Query" I receive an error message saying ...more >>

I have an arbitrary number of values in the WHERE clause: select foo from bar where foobar = '1' and foobar = '2' ... and foobar = 'n-1' and foobar = 'n' What's the best way to program this? Thank you. ...more >>

HI All, i have a problem accessing a DBF file from c#. this is the code i have specified string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mmyyyy.dbf;Extended Properties=DBASE IV;"; OleDbConnection objConnn = new OleDbConnection(); objConnn.ConnectionString...more >>