Distinct Values from a Datatable

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Saving a dataview to a new dataset in C# Hi, I am hoping I can get some help with a small problem I have run into using C#. U have an XML file that I load into a Dataset and then display this in a Datagrid. No problems doing this at all. I then use a Dataview to filter this view using a keyword and I have no problems with this either. What I would like to do is to save this Dataview to a new Dataset so I can save the reslts to a new file but here is where I am having the problem. A Dataview is typically not written back to a Dataset so I'm not sure what would be the best way to do this. I found a code snippet after looking for a day but I have errors with it and I do not know why. I have created my main Dataset called 'ds' and after filtering it and displaying it I clone 'ds' to a new Dataset and then try to import the rows back into my new data set. The code I am using to do this is posted below.... //*************************************************** DataSet ds2 = ds.Clone(); for(int iTable = 0; iTable < ds.Tables.Count; iTable++) { for(int iRow = 0; iRow < ds.Tables[iTable].DefaultView.Count; Row++) { ds2.Tables[iTable].ImportRow(ds.Tables[iTable].DefaultView[iRow].Row); } } ds2.WriteXml(@"c:\data.xml"); //************************************************* My problem comes in on the this line... for(int iRow = 0; iRow < ds.Tables[iTable].DefaultView.Count; iRow++) The error that is displayed is as follows.... "An unhandled exception of type 'System.Data.InvalidConstraintException' occurred in system.data.dll Additional information: ForeignKeyConstraint Computer_ComputerHardware requires the child key values (3) to exist in the parent table." On this part of the code three matches are found & displayed so I'm not sure if it is important. The error occurs on the 'iRow++' part pf the statement but I don't know why. I can't set breakpoints in C# nor can I see where the error is because I can't step through the code. Any idea of this would happen? I'm really stumped on this, below is a snippet of my XML document so you know what I am using in this code. Thanks for any help, Dennis //***************************************** <Office_Inventory> <Computer> <RoomNumber>G2017</RoomNumber> <ComputerNumber>G201701</ComputerNumber> <InServiceDate>2003-03-15</InServiceDate> <ComputerHardware> <Printer>HP DeskJet 500</Printer> <Scanner>HP Scan 100</Scanner> <CD-DVD>40X CD-ROM</CD-DVD> <Monitor>Acer 67L</Monitor> </ComputerHardware> <ComputerSoftware> <OS>Windows 2000</OS> <Office>Office 2003 Professional</Office> <Programming>Visual Studio 2003 Profressional</Programming> <Utilities>Norton AntiVirus 2005</Utilities> </ComputerSoftware> </Computer> </Office_Inventory> Tag: Distinct Values from a Datatable Tag: 114664
  - 2
    - Use datareader to get a value for UserNo Hi, I'm relatively new to ADO, so forgive me if I am going about this in the wrong way. I have a login.aspx page, with a textbox 'usernameTxtBx' I would like to extract a value from a single table in an SQL database. The database has two columns of interest usrNo and usrName, they are in the same table. I would like to set the value from usrNo as an int where the value in the usrName column matches that entered in the usernameTxtBx. I have attempted to use a datareader in c#. Here's the relevent code: // Declare conn from Web.Config SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]); conn.Open(); // Set username as a string string Username = usernameTxtBx.Text; //find usrNo SqlCommand cmd = new SqlCommand("SELECT usrNo FROM tblUser WHERE usrName = 'Username'", conn); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); int UserNo = (int)dr["UserNo"]; conn.Close(); This gives the following error: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IndexOutOfRangeException: UserNo In debugging the value of UserNo appears to get set to 0 regardless of the login used, where i would expect the value to equal 1 or 3 or similar integer. Any ideas what i'm doing wrong? am I even on the right track?? Thanks Tag: Distinct Values from a Datatable Tag: 114662
  - 3
    - Clearing dataset tables where they have relations I'm using a Public dataset in the module for all data throughout the project. For most forms, this is great, no need to instantiate a new object, just clear the datatables and reload as needed. However, an issue arises where I have data relations in a form. Reloading the data on those forms requires clearing the relation and the datatables. What I've done in the past is reset the dataset and clear the relations. This also works fine -- except for the obvious, that being that it kills off any data in the dataset. So, I've tried to just clear the tables and then clear the dataset relations. This causes an exception on the 2nd load of data ("The row doesn't belong to the same DataSet as this relation."). How do I resolve this -- without creating a new dataset for each form where I have a data relation? ********************************************************* TECHNIQUE A (this works well, except clears the dataset entirely) ds.Reset() ds.Relations.Clear() TECHNIQUE B (this causes an exception on 2nd load of employee data) If ds.Tables.Contains("dtEmployees") Then ds.Tables("dtEmployees").Clear() End If If ds.Tables.Contains("dtEmpCategoryMatches") Then ds.Tables("dtEmpCategoryMatches").Clear() End If ds.Relations.Clear() Tag: Distinct Values from a Datatable Tag: 114655
  - 4
    - Can rows be ordered in a datatable? I have a DataTable that is bound to a DataGrid that displays a number of selections from a product menu: Item1 quantity price totalAmount Item2 quantity price totalAmount TAX - - - - - - - - - - totalAmount TOTAL - - - - - - - - totalAmount Each time the user makes a selection, the DataTable is updated and re-bound to the DataGrid. The problem is I need to keep the TAX and TOTAL rows as the last rows in the DataTable so they appear at the bottom of the DataGrid. But the only way I know how to do this is to delete the rows every time the user makes a selection from the product menu, then recalculate the order, and lastly reinsert the rows in the DataTable (otherwise the user's most recently selected product is the last row in the DataTable and appears at the bottom of the DataGrid). Is there a way to re-order the rows rather than deleting and re-inserting every time? Is there some way to tell the data table that the Total row should be the last row in the table, and the Tax row second-to-last? That way I could just overwrite the value in those rows rather than deleting and re-inserting after each time the users selects another item. Thanks in advance. Tag: Distinct Values from a Datatable Tag: 114653
  - 5
    - Check to ensure server and db available When I load the startup form, I want to make a check to ensure the named server AND database (SQL2k) is available before trying to load any data. Any recommendations? Tag: Distinct Values from a Datatable Tag: 114646
  - 6
    - Sort Dataview by relationships Is it possible to sort a child table in a dataview on its own ? for example if there are two tables: tblParent & tblChild The form is bound by its dataview. Now there is a tab on the frmMain which lists all the records in tblChild The main form is sorted by a field in tblParent, further to that can I sort the records in the tab by another field in tblChild ? Any input would be appreciated. Thanks Tag: Distinct Values from a Datatable Tag: 114642
  - 7
    - How to create and schedule full-text catalogue programatically Hi, I have writen a database installation application that simply creates tables inside a database. I also need to create and schedule full-text indexing on some of my tables. I am using SQL server 2000 and and VB.NET 2003. Thank you, _dino_ Tag: Distinct Values from a Datatable Tag: 114639
  - 8
    - How do I connect to a FoxPro 6 .dbf file using OleDb? Does anyone know how to simply connect to a FoxPro 6 .dbf file using ADO.NET's OleDb provider so I can query the data? Mainly I need to know what the connection string is so I can execute a query. Thanks, Tony Tag: Distinct Values from a Datatable Tag: 114638
  - 9
    - Stupid bugs in ODP.NET 9.2.0.4.01 1. Execute this SQL DELETE FROM ... WHERE ROWNUM=1 RETURNING a,b INTO :pa,:pb with ExecuteNonQuery(), here a and b are number columns, and the two output parameters' datatype is set to DbType.Int64, you are ok where there is row in database, otherwise your app crashs. 2. Guess what the DbType of this parameter is: OracleParameter p = new OracleParameter("name",0L); it is DbType.AnsiString other than DbType.Int64. Oracle did not release any patch for it for so long time. How could it be a company? Tag: Distinct Values from a Datatable Tag: 114636
  - 10
    - Stupidly named field selection I am trying to work with and IBM AS400 OLE DB data provider and when using the wizard, I am going along selecting my fields and setting a WHERE clause. There is a field with a "#" at the end of it. As soon as I type this WHERE clause, I have an error message about the syntax and I know that it has to do with the "#". I have enclosed the field name with quotes, single quotes and nothing seems to work. I have been using the ODBC which does work fine, however I am a beginner at ASP .Net (I usually do Windows apps) and I have a problem with pulling data from the AS400 using ODBC. Help, what can I do? Brad Tag: Distinct Values from a Datatable Tag: 114634
  - 11
    - Capturing return value from SQL Server's stored procedure Using Microsoft.Practices.EnterpriseLibrary.Data, how do I capture the return value from executing a stored procedure on SQL Server 2000 (i.e., how could I tell the Stored Procedure did not return 0 [indicating failure] or that a transaction the stored procedure begun had been rolled back): No exceptions were thrown from the following when -1 was returned and transaction rolled back: Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "uspCreator"; DBCommandWrapper creatorCommandWrapper = db.GetStoredProcCommandWrapper(sqlCommand); db.ExecuteNonQuery(creatorCommandWrapper); Tag: Distinct Values from a Datatable Tag: 114627
  - 12
    - Dataset constraints A question please. Lets say I have a grid with its datasource as a dataset with three columns in it; UserID (an auto generated ID), LastName and FirstName. Additionally, lets say I want to restrict the user from entering two records with the same last name and first name. I have created a constraint for LastName FirstName in the dataset but I would like a different message than the default message I get when the constraint is violated. Is there a way for me to do this? Tag: Distinct Values from a Datatable Tag: 114622
  - 13
    - Interesting Problem regarding Parameters Backgroud: My company is currently migrating to .Net from PHP for a number of reasons, however we have one slight problem we would very much like to solve before moving to .Net (ok, many but this one is a toughie). Problem: On our current PHP platform we have our own database abstraction class which inherits from the PEAR DB abstraction class. One of the major reasons why we did this is because we wanted to add automatic querie logging to our database connection object. Here is a brief snippit of code to demonstarte the functionality we currently have: //Creating DB connection objects $connection = mis_DB::connect( 'database-server', 'database' ); $connection->addLog( 'file', '/log_path/filename.log', PEAR_LOG_MODE ); $connection->setLogMask( MISDB_LOG_ALL ); This will automatically log any queries thrown at at, for example (I'm using prepare and execute syntax for a reason that will be come clear in just a minute): /* Disclaimer, such a DB does not exist on my company DB server, but it should! */ $query = "SELECT * FROM beer.beer_styles WHERE style = ?"; $handle = $connection->prepare( $query ); $result_object = $connection->execute( $handle, array( "Imperial Stout" ) ); What our current database class will do (after executing the query) is logg the following message to the /log_path/filename.log file: Friday, July 29, 2005 8:41:10 AM [Informational] SELECT * FROM beer.beer_styles WHERE style = 'Imerial Stout' What we would like is to have some thing similar with our new .Net DB class, however the problem I'm running into is I don't know how to get the query that was actually executed on the server, what I mean by that is: //Assum proper connection string OleDbConnection Connection = new OleDbConnection( ConnectionString ); OleDbCommand Command = new OleDbCommand( Connection ); Connection.Open(); Command.CommandText = @"SELECT * FROM beer.beer_styles WHERE style = @style"; Command.Paramaters.Add( "@style", "Imperial Stout" ); OleDbDataReader Reader = Command.ExecuteReader(); Now that the query has executed, how to I pull the value: "SELECT * FROM beer.beer_styles WHERE style = 'Imperial Stout'" out of the database class v. "SELECT * FROM beer.beer_styles WHERE style = @style" Thanks for any help you can provide! -------------------- Carlo Razzeto carlo.razzeto@mtginfo.com Tag: Distinct Values from a Datatable Tag: 114617
  - 14
    - Interesting Problem regarding Parameters Backgroud: My company is currently migrating to .Net from PHP for a number of reasons, however we have one slight problem we would very much like to solve before moving to .Net (ok, many but this one is a toughie). Problem: On our current PHP platform we have our own database abstraction class which inherits from the PEAR DB abstraction class. One of the major reasons why we did this is because we wanted to add automatic querie logging to our database connection object. Here is a brief snippit of code to demonstarte the functionality we currently have: //Creating DB connection objects $connection = mis_DB::connect( 'database-server', 'database' ); $connection->addLog( 'file', '/log_path/filename.log', PEAR_LOG_MODE ); $connection->setLogMask( MISDB_LOG_ALL ); This will automatically log any queries thrown at at, for example (I'm using prepare and execute syntax for a reason that will be come clear in just a minute): /* Disclaimer, such a DB does not exist on my company DB server, but it should! */ $query = "SELECT * FROM beer.beer_styles WHERE style = ?"; $handle = $connection->prepare( $query ); $result_object = $connection->execute( $handle, array( "Imperial Stout" ) ); What our current database class will do (after executing the query) is logg the following message to the /log_path/filename.log file: Friday, July 29, 2005 8:41:10 AM [Informational] SELECT * FROM beer.beer_styles WHERE style = 'Imerial Stout' What we would like is to have some thing similar with our new .Net DB class, however the problem I'm running into is I don't know how to get the query that was actually executed on the server, what I mean by that is: //Assume I have a proper connection string OleDbConnection Connection = new OleDbConnection( ConnectionString ); OleDbCommand Command = new OleDbCommand( "", Connection ); Connection.Open(); //Set the query with parmater then execute reader Command.CommandText = "SELECT * FROM beer.beer_styles WHERE style = @style"; Command.Paramaters.Add( "@style", "Imperial Stout" ); OleDbDataReader Reader = Command.ExecuteReader(); How do I get the query that actually executed on our DB server, i.e. "SELECT * FROM beer.beer_styles WHERE style = 'Imperial Stout'", not "SELECT * FROM beer.beer_styles WHERE style = @style". Thanks for the help! ---------------------- Carlo Razzeto carlo.razzeto@mtginfo.com Tag: Distinct Values from a Datatable Tag: 114616
  - 15
    - CAPTION FOR UPLOAD CONTROL Has anybody been able to figure out how to change the wording of the word "Browse" in a file upload control? It seems to be built in the browser and it doesn't seem like we can change it. anybody knows? THANKS! Tag: Distinct Values from a Datatable Tag: 114612
  - 16
    - Hoping some one here can help me, or at least point me in the right direction I know this dosen't really fit the category, but most of you ADO.NET guys do some reporting at some point in time. If you know a better place for me to put this let me know. I have a Crystal Report that is external to my application. It uses an XML file (also outside my application) as it's datasource. I need to be able to change the XML datasource and pass this to the report (THE XML file it's reporting on) I can't seem to find the anwser. I don't want to pull the XML file into a dataset and then push it to the report, I would prefer to use the Crystal Pull method. Thanks again! Justin Tag: Distinct Values from a Datatable Tag: 114608
  - 17
    - ado.net 2.0 and sql server 7 Hello, we are migrating our "old" .net 1.1 application to 2.0 and have noticed that opening connections to a sql server 7 now is very very slow, but this doesn't happen with sql server 2000. Is there any workaround to speed up this a bit. Our application is now unusable with sql 7. Tag: Distinct Values from a Datatable Tag: 114603
  - 18
    - ODBC Driver not displaying? Hello, I'm trying to install an ODBC driver, specifically IBM's Client Access OBDC Driver (32 Bit) which is installed as part of Client Access for the AS/400. The ODBC driver is installed okay, but if I launch odbcad32.exe (managing odbc data sources), I do not see the driver. I cannot choose the driver when creating a new dsn because it just is not listed. I have checked the registry a HKLM\Software\ODBC and I see that there are entries for the driver, and they appear to be correct. Why can't I see this driver listed so I can use it to create a DSN? My system is WinXp Pro, SP1, .Net 1.1, MDAC 2.8 Thanks for the help - Wayne P. Tag: Distinct Values from a Datatable Tag: 114598
  - 19
    - TableAdapter problems w VS.NET 2005 Hi everyone, When I use the TableAdapter wizard with a SQL select that contains a linked server table (like Select * from SF...Account) , I get an error message when generating the SQL insert. A dialog box appears with the msg : The specified identifier was in an invalid format". The select command generates ok but the insert, update and delete commands do not. I'm using the June CTP of VS.NET 2005 Thanks. -- Bill Emerson Tag: Distinct Values from a Datatable Tag: 114596
  - 20
    - Writing updates from a wide DataTable I have a DataTable with a large number of colums - 50 or more. I'm following the recommendations to use stored procedures to apply updates to the database, and using the Enterprise Llibrary. So I end up with a stored procedure with 50+ parameters, and an Update statement that updates the same number of columns. In a typical use case only a few columns will actually be updated, but my DAL generally doesn't know which - it just gets a DataSet with some changes. Everything works fine, but I feel uncomfortable with this solution. I don't like rewriting all those columns I haven't changed. I don't like shipping all this unchanged data around. Should I feel uncomfortable? Are there better ways of handling this kind of situation? Thanks... -------- Nigel Norris Tag: Distinct Values from a Datatable Tag: 114582
  - 21
    - = Null problem Hi Am using ADO.NET connection from my ASP.NET application to connect to MS SQL SERVER 2000. I have a Stored procedure which works fine when I directly connect to the Database using Native drivers, the same is not working properly when I use ADO.NET connection. When I debugged the Stored procedure I found that the following script was not working with ADO.NET emp_name = Null and the same was working fine when I changed the sql script to emp_name IS Null. I have few hundreds of stored procedure and It might not be possible for me to alter the Stored Procedure. 1.Any body have faced the same problem? 2.Is there an alternative solution to overcome from this problem ? 3.Is this fixed in any service packs from Microsoft ? 4. Or there is no other option rather than change the sql script in Stored Procedure to emp_name IS NULL ? Any help would be greatly appreciated Thank you Mahesh.V Tag: Distinct Values from a Datatable Tag: 114571
  - 22
    - Debug skips DataAdapter.Update code. Why?? Hi, I'm attempting to input data into two related tables using stored procedures. I found some good example code, which i have followed, checked and double checked, but for some reason the update is not happening. Below is the code, it's pretty lengthy so to save you time i'll say now that it runs through fine in debug until near the very end, the patientDataAdapter.Update(dsAddPatient, "Patient"); line just above the 'catch' section. It runs the previous line then jumps this and subsequent lines going straight to 'catch'. The code: private void addPatientDataToDB() { try { // Create the DataSet object DataSet dsAddPatient = new DataSet(); // Connect to database SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]); conn.Open(); // Create the DataTable "Patient" in the Dataset and the DataAdapter SqlDataAdapter patientDataAdapter = new SqlDataAdapter(new SqlCommand("SELECT * FROM tblPatient", conn)); patientDataAdapter.InsertCommand = new SqlCommand("proc_InsertPatient", conn); SqlCommand cmdInsert = patientDataAdapter.InsertCommand; cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.Parameters.Add(new SqlParameter("@patientNo", SqlDbType.Int)); cmdInsert.Parameters["@patientNo"].Direction = ParameterDirection.Output; cmdInsert.Parameters["@patientNo"].SourceColumn = "patientNo"; cmdInsert.Parameters.Add(new SqlParameter("@pntUnitID", SqlDbType.NVarChar,15,"pntUnitID")); cmdInsert.Parameters.Add(new SqlParameter("@pntTitle", SqlDbType.NVarChar,4,"pntTitle")); cmdInsert.Parameters.Add(new SqlParameter("@pntFName", SqlDbType.NVarChar,20,"pntFName")); cmdInsert.Parameters.Add(new SqlParameter("@pntLName", SqlDbType.NVarChar,30,"pntLName")); cmdInsert.Parameters.Add(new SqlParameter("@pntDOB", SqlDbType.DateTime,8,"pntDOB")); cmdInsert.Parameters.Add(new SqlParameter("@pntSex", SqlDbType.NVarChar,1,"pntSex")); cmdInsert.Parameters.Add(new SqlParameter("@pntAddress1", SqlDbType.NVarChar,150,"pntAddress1")); cmdInsert.Parameters.Add(new SqlParameter("@pntAddress2", SqlDbType.NVarChar,150,"pntAddress2")); cmdInsert.Parameters.Add(new SqlParameter("@pntAddress3", SqlDbType.NVarChar,150,"pntAddress3")); cmdInsert.Parameters.Add(new SqlParameter("@pntcountryNo", SqlDbType.Int,4,"pntCountryNo")); cmdInsert.Parameters.Add(new SqlParameter("@pntPostcode", SqlDbType.NVarChar,10,"pntPostcode")); cmdInsert.Parameters.Add(new SqlParameter("@pntHPnone", SqlDbType.NVarChar,14,"pntHPnone")); cmdInsert.Parameters.Add(new SqlParameter("@pntWPhone", SqlDbType.NVarChar,14,"pntWPhone")); cmdInsert.Parameters.Add(new SqlParameter("@pntMobPhone", SqlDbType.NVarChar,14,"pntMobPhone")); cmdInsert.Parameters.Add(new SqlParameter("@pntEmail", SqlDbType.NVarChar,50,"pntEmail")); cmdInsert.Parameters.Add(new SqlParameter("@pntStage", SqlDbType.NVarChar,5,"pntStage")); cmdInsert.Parameters.Add(new SqlParameter("@pntT", SqlDbType.TinyInt,1,"pntT")); cmdInsert.Parameters.Add(new SqlParameter("@pntN", SqlDbType.TinyInt,1,"pntN")); cmdInsert.Parameters.Add(new SqlParameter("@pntM", SqlDbType.TinyInt,1,"pntM")); cmdInsert.Parameters.Add(new SqlParameter("@pntPreviousTreatments", SqlDbType.Char,1000,"pntPreviousTreatments")); cmdInsert.Parameters.Add(new SqlParameter("@pntFurtherNotes", SqlDbType.Char,1000,"pntFurtherNotes")); patientDataAdapter.FillSchema(dsAddPatient, SchemaType.Source); DataTable pTable = dsAddPatient.Tables["Table"]; pTable.TableName = "Patient"; // Create the DataTable "Histology" in the // Dataset and the DataAdapter SqlDataAdapter histologyDataAdapter = new SqlDataAdapter(new SqlCommand("SELECT * FROM tblSample", conn)); histologyDataAdapter.InsertCommand = new SqlCommand("proc_InsertHistology", conn); cmdInsert = histologyDataAdapter.InsertCommand; cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.Parameters.Add(new SqlParameter("@patientNo", SqlDbType.Int,4)); cmdInsert.Parameters["@patientNo"].SourceColumn = "patientNo"; cmdInsert.Parameters.Add(new SqlParameter("@lesHistology", SqlDbType.NVarChar,50)); cmdInsert.Parameters["@lesHistology"].SourceColumn = "lesHistology"; cmdInsert.Parameters.Add(new SqlParameter("@lesNull", SqlDbType.NVarChar,10)); cmdInsert.Parameters["@lesNull"].SourceColumn = "lesNull"; histologyDataAdapter.FillSchema(dsAddPatient, SchemaType.Source); pTable = dsAddPatient.Tables["Table"]; pTable.TableName = "Histology"; // Create the relationship between the two tables dsAddPatient.Relations.Add(new DataRelation("ParentChild", dsAddPatient.Tables["Patient"].Columns["patientNo"], dsAddPatient.Tables["Histology"].Columns["patientNo"])); // Insert the Data DataRow patientRow = dsAddPatient.Tables["Patient"].NewRow(); patientRow["pntUnitID"] = patientCodeTxtBx.Text; patientRow["pntTitle"] = titleCboBx.SelectedValue; patientRow["pntFName"] = fNameTxtBx.Text; patientRow["pntLName"] = lNameTxtBx.Text; patientRow["pntSex"] = sexCboBx.SelectedValue; patientRow["pntDOB"] = DOBTxtBx.Text; patientRow["pntAddress1"] = address1TxtBx.Text; patientRow["pntAddress2"] = address2TxtBx.Text; patientRow["pntAddress3"] = address3TxtBx.Text; patientRow["pntcountryNo"] = countryCboBx.SelectedValue; patientRow["pntPostcode"] = postcodeTxtBx.Text; patientRow["pntHPhone"] = phoneTxtBx.Text; patientRow["pntWPhone"] = workPhoneTxtBx.Text; patientRow["pntMobPhone"] = mobileTxtBx.Text; patientRow["pntEmail"] = emailTxtBx.Text; patientRow["pntStage"] = stageCboBx.SelectedValue; patientRow["pntT"] = tTxtBx.Text; patientRow["pntN"] = nTxtBx.Text; patientRow["pntM"] = mTxtBx.Text; patientRow["pntPreviousTreatments"] = previousTreatmentsTxtBx.Text; patientRow["pntFurtherNotes"] = notesTxtBx.Text; dsAddPatient.Tables["Patient"].Rows.Add(patientRow); DataRow histologyRow = dsAddPatient.Tables["Histology"].NewRow(); histologyRow["lesHistology"] = histologyCboBx.SelectedValue; histologyRow.SetParentRow(patientRow); dsAddPatient.Tables["Histology"].Rows.Add(histologyRow); patientDataAdapter.Update(dsAddPatient, "Patient"); histologyDataAdapter.Update(dsAddPatient, "Histology"); messageLbl.Text = "Data successfully added to database"; } catch (Exception ex) { messageLbl.Text = ex + "Unable to connect to the database"; } finally { // Close the connection DataAccess.DBConnection.CloseDBConnection(); } } Anyone with any ideas why it might be jumping the patientDataAdapter.Update(dsAddPatient, "Patient"); and histologyDataAdapter.Update(dsAddPatient, "Histology"); statements? Thanks. Tag: Distinct Values from a Datatable Tag: 114569
  - 23
    - Strange Behavoir With OleDBDataAdapter Hi, Hope someone can explain this... OK, here is the simplest subset of my code that shows the problem: I have a C# Method: Private void UpdateDataTable(DataTable myDT) { OleDbCommand comm = new OleDbCommand(); comm.CommandText = "AddComponentsForJobT"; comm.CommandType = CommandType.StoredProcedure; OleDbConnection conn = new OleDbConnection(CONNECTION_STRING); conn.Open(); comm.Connection = conn; comm.Parameters.Add("pPartNo",OleDbType.VarChar,10,"PartNo").SourceVersion = DataRowVersion.Current; da.InsertCommand = comm; da.Update(myDT); } An Access Query: AddComponentsForJobT ================== PARAMETERS pPartNo Text ( 255 ); INSERT INTO PropJobParts ( PartNo ) SELECT [pPartNo] AS Expr2; If I pass into the above method a DataTable containing 3 rows with a RowState of 'Added' PartNo ===== AAA BB C The code runs successfully, but what finished up in my Access table is: AAA BBA CBA Anyone tell me what I'm doing wrong or missing out??? It seems like the Automagic stuff inside OledbDataAdapter.Update that runs the Insert command is not clearing the parameters between each subsequent insert. Please! Thanks, Chris. -- Remove Elvis's shoes to reply. Tag: Distinct Values from a Datatable Tag: 114565
  - 24
    - newbie ado net questuon I am trying to get started with ado.net, coming from experience with ado. I have a simple SQL Server stored procedure which inserts a row and returns the value of the identity column for the inserted row (seel below). I have a method in a C# project which is simply going to add a record and return the identity. I am looking throught the documentation to see how to do this. You see I have a dataadapter and a dataset. But I cannot see what methods to use to execute the sp and get back tha value. Can anyone point me in the right direction? public String add(DateTime entryDate, DateTime startTime, DateTime endTime, String shortDescription, String longDescription) { SqlConnection cn = new SqlConnection("Data Source=sstowe;Initial Catalog=Time;User ID=sa;Password=password;"); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); cn.Open; da. <--- WHAT now? da.Fill(ds); return <--- I think I used to know how to work } CREATE PROCEDURE Entry_Add @EntryDate datetime, @StartTime datetime, @EndTime datetime, @Short char(50), @Description varchar(255), @ID int OUTPUT AS BEGIN SET NOCOUNT ON INSERT INTO Entry ( EntryDate, StartTime, EndTime, Short, Description ) VALUES ( @EntryDate, @StartTime, @EndTime, @Short, @Description ) SELECT @ID = SCOPE_IDENTITY() END GO Tag: Distinct Values from a Datatable Tag: 114563
  - 25
    - Get the ID of the newly added row Hello All, I am fairly new to ADO.net, I am using this simple command to add a new row to the database, what I want now is to get the auto increment ID of the row added, can anyone please help me with this? strQuery = "insert into tblFeedChannels ...."; SqlCommand objCmd = new SqlCommand(strQuery, conn); objCmd.ExecuteNonQuery(); Imran. Tag: Distinct Values from a Datatable Tag: 114560
- Next
  - 1
    - Newbie help with relations Hi, I have two tables in a dataset. I want to create a relation between the two tables in which the child table can have foreign keys that do not match primary key fields in the parent table. When the parent table is updated, I want any related foreign key fields in the child table to be updated, but I don't want any deletions to be cascaded. I've tried setting DeleteRule to SetNull and UpdateRule to Cascade, but I get a constraint error on filling the dataset in my program, I guess because most fields in the child table do not have parent rows (but I don't want them to have parent rows). How do I set this up in the dataset schema editor? Thanks, Nathan Tag: Distinct Values from a Datatable Tag: 114558
  - 2
    - ThreadAbortException at System.Data.SqlClient.SqlCommand.ExecuteRe (BIS) Hello, I resend the same question i previously sent because i did'nt used the good reply-to address. I'm having a ThreadAbortException and i don't know why. When i launch the same code sometimes it never crash a the same place but always in the proc. you find below. If it can help, i'm using Nant and i launch the code with "Test with debugger". My base code is reading files on disk and making a lot of insert and update queries on the server. I'm the only user of the database. This is the code : Public Shared Function QueryDataSetWithNoExceptionCode(ByVal SQLQuery As String) As DataSet Try Dim sConnectionString As String = _GetConnectionString() Dim conDB As New SqlConnection(sConnectionString & ";connect timeout = 60") Dim cmdQuery As New SqlCommand(SQLQuery, conDB) cmdQuery.CommandTimeout = 300 Dim da As New SqlDataAdapter(cmdQuery) Dim ds As New DataSet da.Fill(ds) cmdQuery = Nothing conDB = Nothing da = Nothing Return ds Catch ex As Exception Throw ex End Try End Function When the breakpoint is on the catch i have this : ?ex.ToString "System.Threading.ThreadAbortException: Le thread a été abandonné. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Corus.FortisDocumentService.FortisDocumentService.Metier.CorusFortisDataAccess.QueryDataSetWithNoExceptionCode(String SQLQuery) in C:\DATAS\Dvpt\Sources\Clients\Fortis\FortisDocumentService\Trunk\src\FortisDocumentService.Metier\CorusFortisDataAccess.vb:line 55" Tag: Distinct Values from a Datatable Tag: 114557
  - 3
    - ThreadAbortException at System.Data.SqlClient.SqlCommand.ExecuteRe Hello, I'm having a ThreadAbortException and i don't know why. When i launch the same code sometimes it never crash a the same place but always in the proc. you find below. If it can help, i'm using Nant and i launch the code with "Test with debugger". My base code is reading files on disk and making a lot of insert and update queries on the server. I'm the only user of the database. This is the code : Public Shared Function QueryDataSetWithNoExceptionCode(ByVal SQLQuery As String) As DataSet Try Dim sConnectionString As String = _GetConnectionString() Dim conDB As New SqlConnection(sConnectionString & ";connect timeout = 60") Dim cmdQuery As New SqlCommand(SQLQuery, conDB) cmdQuery.CommandTimeout = 300 Dim da As New SqlDataAdapter(cmdQuery) Dim ds As New DataSet da.Fill(ds) cmdQuery = Nothing conDB = Nothing da = Nothing Return ds Catch ex As Exception Throw ex End Try End Function When the breakpoint is on the catch i have this : ?ex.ToString "System.Threading.ThreadAbortException: Le thread a Ã©tÃ© abandonnÃ©. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Corus.FortisDocumentService.FortisDocumentService.Metier.CorusFortisDataAccess.QueryDataSetWithNoExceptionCode(String SQLQuery) in C:\DATAS\Dvpt\Sources\Clients\Fortis\FortisDocumentService\Trunk\src\FortisDocumentService.Metier\CorusFortisDataAccess.vb:line 55" Tag: Distinct Values from a Datatable Tag: 114556
  - 4
    - Newbie question about dataadapter parameter Hi, I have a dataadapter that has 2 parameters. But sometimes I would like to use only one of the parameters. For example: The dataadapter selectcommand would be like this: SELECT CategoryID, CategoryName, Description, Picture FROM Categories WHERE (CategoryID = @CID) AND (CategoryName = @CName) On My code, before filling the dataset, I would add the parameters Mydataadapter.SelectCommand.Parameters("@CID").Value = 1 Mydataadapter.SelectCommand.Parameters("@CName").Value = "Beverages" Mydataadapter.Fill(Mydataset) This Code would run nicely. But how if I want to ignore one of the parameter? For example I just want to use The @CID parameter. How to ignore the @CName parameter? Hope, my question is clear cause my English is not so good. All helps will be greatly appreciated. Thank you Tag: Distinct Values from a Datatable Tag: 114547
  - 5
    - C# Prepared Statements Hi all, Can someone point me to an example of prepared statements being used in C# ado.net? the MSDN site has examples using VB and my documentation in VS 2005 says "to be filled in" or something equally useful. thanks in advance, Pat Tag: Distinct Values from a Datatable Tag: 114538
  - 6
    - Passing Optional Parameter to Stored Procedure in VS VB.net Hi, I'm trying to pass only the required parameters to a stored procedure using the following code. I keep getting the following error now. Running dbo."InsertEmployee" ( @pemployeeno = "888888", @S_I_N = "123456789", @pfirstname = "Sam", @plastname = "Wise", @pmiddlename = <DEFAULT>, @pprimaryemail = "swise@sd61.bc.ca", @psecondaryemail = <DEFAULT>, @status_code = "A" ). ---> Error converting data type varchar to numeric. <------ Dim SIMSSqlcommand As New SqlCommand SIMSSqlcommand.Connection = connection SIMSSqlcommand.CommandText = "InsertEmployee" SIMSSqlcommand.CommandType = CommandType.StoredProcedure SIMSSqlcommand.namedparameter = True SIMSSqlcommand.Parameters.Add("@CustomerID", "PAULK") SIMSSqlcommand.Parameters.Add("@CompanyName", "Pauly's Bar") STORED PROCEDURE CREATE PROCEDURE dbo.InsertEmployee /* ( @parameter1 datatype = default value, @parameter2 datatype OUTPUT ) */ ( @pemployeeno char(10), @S_I_N nvarchar(10), @pfirstname nvarchar(50), @plastname nvarchar(50), @pmiddlename nvarchar(50)=" ", @pprimaryemail nvarchar(50)=" ", @psecondaryemail nvarchar(50) = " ", @status_code char(10) = " " ) AS declare @pstatusid numeric /* SET NOCOUNT ON */ select @pstatusid = statusid from status where statuscode = @status_code; insert into Employee ( Employeeno, S_I_N, firstname, lastname, middlename, primaryemail, secondaryemail, statusid ) values ( @pemployeeno, @S_I_N, @pfirstname, @plastname, @pmiddlename, @pprimaryemail, @psecondaryemail, @status_code ) select @@identity RETURN GO thanks, Will Tag: Distinct Values from a Datatable Tag: 114531
  - 7
    - Validate a CSV file I have a CSV file which contains comma seperated data that I need to validate against our database.I was thinking about loading that CSV file into a Typed-Dataset which has our database schema in it and then try to load the CSV file into that Typed-Dataset and automatically get all the errors and constarint violations. 1) Is it doable? 2) Because I need to check the foriegn keys as well,Can I loaded the data of those refferecing tables into my dataset as well? 3)If number 2 is doable ,how should I update my dataset if a key has been added to the existing refferncing tables? Thanks a lot for taking your time answering this post in advance. J-T Tag: Distinct Values from a Datatable Tag: 114529
  - 8
    - SqlParameter with ParameterName is not contained... I'm receiving the following error when I try to use a stored proc in my code: SqlParameter with ParameterName '@unionRep' is not contained by this SqlParameterCollection I have searched several newsgroups and found similar situations, but so far none of the solutions have worked for me. *Note, I have tried setting the connection and opening it both before and after setting the command text. Please help! Thanks in advance. Here is the code I have: SqlSelectCommand1.CommandType = CommandType.StoredProcedure SqlSelectCommand1.CommandText = "sp_UpdateContractOut1" Dim param As SqlParameter = New SqlParameter("@unionRep", SqlDbType.NVarChar, 50) Dim param1 As SqlParameter = New SqlParameter("@unionSign", SqlDbType.SmallDateTime) Dim param2 As SqlParameter = New SqlParameter("@areaUnionRep", SqlDbType.NVarChar, 50) Dim param3 As SqlParameter = New SqlParameter("@areaUnionRepSign", SqlDbType.SmallDateTime) Dim param4 As SqlParameter = New SqlParameter("@unionComm", SqlDbType.NVarChar, 255) Dim param5 As SqlParameter = New SqlParameter("@companyCoord", SqlDbType.NVarChar, 50) Dim param6 As SqlParameter = New SqlParameter("@companySign", SqlDbType.SmallDateTime) Dim param7 As SqlParameter = New SqlParameter("@maintSupt", SqlDbType.NVarChar, 50) Dim param8 As SqlParameter = New SqlParameter("@maintSuptSign", SqlDbType.SmallDateTime) Dim param9 As SqlParameter = New SqlParameter("@coordComm", SqlDbType.NVarChar, 255) Dim param10 As SqlParameter = New SqlParameter("@ID", SqlDbType.Int) SqlSelectCommand1.Parameters("@unionRep").Value = unionRep.Text SqlSelectCommand1.Parameters("@unionSign").Value = unionSign.Text SqlSelectCommand1.Parameters("@areaUnionRep").Value = areaUnionRep.Text SqlSelectCommand1.Parameters("@areaUnionRepSign").Value = areaUnionRepSign.Text SqlSelectCommand1.Parameters("@unionComm").Value = unionComm.Text SqlSelectCommand1.Parameters("@companyCoord").Value = companyCoord.Text SqlSelectCommand1.Parameters("@companySign").Value = companySign.Text SqlSelectCommand1.Parameters("@maintSupt").Value = MaintSupt.Text SqlSelectCommand1.Parameters("@maintSuptSign").Value = maintSuptSign.Text SqlSelectCommand1.Parameters("@coordComm").Value = coordComm.Text SqlSelectCommand1.Parameters("@ID").Value = txtWO.Text SqlSelectCommand1.Connection = SqlConnection1 SqlConnection1.Open() Try SqlSelectCommand1.ExecuteNonQuery() lblUpdateSuccess.Visible = True btnSuccess.Visible = True Catch ex As Exception lblFail.Visible = True btnFail.Visible = True Finally SqlConnection1.Close() End Try Tag: Distinct Values from a Datatable Tag: 114522
  - 9
    - SCOPE_IDENTITY won't return correct value, but @@IDENTITY does Hi all, I have the following codes, but SCOPE_IDENTITY() just returns NULL to me. If I comment out SCOPE_IDENTITY() line and run @@IDENTITY line, it works fine!! Since I have a trigger on the table, I have to use SCOPE_IDENTITY(). Any ideas? SqlConnection conn = new SqlConnection(connectionString); conn.Open(); //Create the dataadapter SqlDataAdapter da = new SqlDataAdapter(); //Assign the connection & Create and execute the Insert Command da.InsertCommand = new SqlCommand("insert into table1......"); da.InsertCommand.Connection = conn; da.InsertCommand.ExecuteNonQuery(); //Create,assign and Execute the Identity statement da.SelectCommand = new SqlCommand("SELECT SCOPE_IDENTITY()", da.InsertCommand.Connection); //da.SelectCommand = new SqlCommand("SELECT @@IDENTITY", da.InsertCommand.Connection); int intID = Convert.ToInt32(da.SelectCommand.ExecuteScalar()); conn.Close(); return(intID); -- WWW: http://hardywang.1accesshost.com ICQ: 3359839 yours Hardy Tag: Distinct Values from a Datatable Tag: 114515
  - 10
    - ANN: QueryADataset Product Release For anyone who might have visited the web site before or anyone needing a full SQL query engine against a ADO.NET DataSet or XML document, you might be interested in the QueryADataset assembly I've been working on at http://www.queryadataset.com. It lets you perform complex SQL SELECT statements including UNION, INNER and OUTER JOINS, GROUP BY, HAVING, ORDER BY, sub-queries, aggregates etc against the tables in a DataSet. The release version also supports common built-in functions like ISNULL, date functions, string functions and math functions. The assembly is now available for purchase at an introductory price of $100 US. You can also download a trial version for evaluation. For more information, please visit the link below or contact me. Thanks Adrian Moore http://www.queryadataset.com Tag: Distinct Values from a Datatable Tag: 114511
  - 11
    - number of Columns in DataGrid (not DataSource!) Hi, I need a function that gives me the number of Columns shown in a DataGrid. So I don't need to know the number of columns shown in tha DataSource, because this number can be completely something else than the number of columns defined in the currently active TableStyle! I currently use DataGrid.TableStyles(0).GridColumnStyles.Count, but i know this won't work when using more than one TableStyle, or having a TableStyle with another mappingname... Has anybody any idea? Maybe a combination of these 2 functions that search first which type of DataSource I have, if it has a table, and if there is a TableStyle with that name etc? But it doesn't seem really logical to me, and I really wonder if there isn't any method that gets it directly from the DataGrid? Thanks a lot in advance, Pieter private void PrintCurrentListName(DataGrid myDataGrid){ CurrencyManager myCM = (CurrencyManager) BindingContext[myDataGrid.DataSource, myDataGrid.DataMember]; IList myList = myCM.List; ITypedList thisList = (ITypedList) myList; Console.WriteLine(thisList.GetListName(null)); } Private Function GetColumnCount() As Integer Dim intCount As Integer If TypeOf Me.DataSource Is DataTable Then intCount = DirectCast(Me.DataSource, DataTable).Columns.Count ElseIf TypeOf Me.DataSource Is DataView Then intCount = DirectCast(Me.DataSource, DataView).Table.Columns.Count ElseIf TypeOf Me.DataSource Is ArrayList Then intCount = DirectCast(Me.DataSource, ArrayList).Count '???? ElseIf TypeOf Me.DataSource Is Collection Then intCount = DirectCast(Me.DataSource, Collection).Count '???? ElseIf TypeOf Me.DataSource Is DataSet Then intCount = DirectCast(Me.DataSource, DataSet).Tables(0).Columns.Count Else intCount = 0 End If Return intCount End Function Tag: Distinct Values from a Datatable Tag: 114505
  - 12
    - Filtering uncommited data ? If I do a select query with the hint WITH (NOLOCK) are uncommited reads marked somewhere in the dataset/datatable/datarow so I can filter them out ? I havent been able to find a flag to use for this. Thank you PL. Tag: Distinct Values from a Datatable Tag: 114503
  - 13
    - Unspecified error: E-Fail (0x80004005) Hi All, We connected with OLEDBConnect to oracle database in a asp.net and C#. Database Server and WebServer is in a computer. This compputer is a Windows 2000 server with SP4 and installed Framework .Net 1.1 and IIS. When i try to connect to database i get error: System.Data.OleDB.OleDbException: Unspecified error: E-FAIL (0x80004005) How can i solve this error? Thanks Mad Tag: Distinct Values from a Datatable Tag: 114500
  - 14
    - Howto specify which DataTables of a DataSet will be stored with WriteXml? Hello, I would like to save a DataSet to xml-file. But I only want to save some DataTables of the DataSet, not all. The DataSet.WriteXml(...) methods does not allow this. Does anyone knows a workaround? An additional requirement is, to store all DataTables in the same file. Thanks Gordian Tag: Distinct Values from a Datatable Tag: 114490
  - 15
    - Difference between DataTable.Clone ( ) and DataTable.Copy ( ) ? Hello, does anyone knows the difference between: DataTable.Clone ( ) DataTable.Copy ( ) Thanks Gordian Tag: Distinct Values from a Datatable Tag: 114489
  - 16
    - SqlParameter error I keep getting this error when I am executing a Stored Procedure multiple times. The SqlParameter with ParameterName '@ApplicantID' is already contained by another SqlParameterCollection. Anyone know what causes this and how to fix it? Thanks, Tom Tag: Distinct Values from a Datatable Tag: 114483
  - 17
    - Howto iterate over objects stored in one column of a DataTable ---- Hello, I want to iterate over the objects stored in one column of a DataTable. I can do it the following way: --------------------------- foreach (DataRow dr in myDataTable) { // do something with the data in column 3 string s = dr[2].ToString(); } --------------------------- But is there another way without the overhead of DataRow / DataTable? (I assume there is an overhead!) Perhaps a method, which returns an array of objects stored in one column of a DataTable. Greetings Gordian Tag: Distinct Values from a Datatable Tag: 114481
  - 18
    - Few Questions in C# Hi All I have following questions regarding C# Assembly and Threading. Let me know the precise answer or lead me to the proper materials. 1. Is memory leakeage possible in .Net Manager Code ? 2. Is memory leakage possible in .Net Unmanaged Code ? 3. How can I find the what % of memory is being used by DLL at run time ? 4. What is difference between Sunchronous processing and Async processing in .Net ? How can I achieve it ? 5. Can any one lead me towards Multithreading GUI development in Winforms ? 6. Difference between Delegate and Event ? 7. Is there any specific Design Patterns specifically for WinForms ? Awaiting reply Thanks Silent Ocean Tag: Distinct Values from a Datatable Tag: 114479
  - 19
    - Multiple Inserts and Identity problem Hi, I have created a data table using SQL Server 2000 which includes an identity field [CollectID] [bigint] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [Filename] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL I am adding new rows to a typed dataset and calling the data adapter Update in order to Insert the new rows to the table. My insertCommand calls a stored procedure that looks like this. ALTER PROCEDURE spInsertCollect ( @Filename varchar(50), @Identity int OUTPUT ) AS INSERT INTO Collect(Filename) VALUES (@Filename); SET @Identity = @@IDENTITY RETURN My InserCommand looks like the following: // Create the parameters IDataParameter[] parameters = { CreateDataParameter("@Filename", DbType.String, 50, "Filename"), CreateDataParameter("@Identity", DbType.Int64, 8, "CollectID") }; parameters[1].Direction = ParameterDirection.Output; insertCommand = BuildStoredProcedureCommand("spInsertCollect", parameters); Now, before updating I set the adapter insertCommand member to the one described above. Now, if the dataset that I pass to Update has only one new row, then the above works fine, the new row is added to de table and the new CollectID value is copied to the CollecID field in the dataset for that row. However, if the dataset has multiple rows (CollectID are numbered consecutively starting with 0 on the dataset before updating), and I call the update method, the first row is added and the CollectID is copied to the dataset, but the second row is not added to the database and I get the following exception: An unhandled exception of type 'System.Data.ConstraintException' occurred in mydata.dll Additional information: Column 'CollectID' is constrained to be unique. Value '8' is already present. Value 8 is the value that was assigned for the first row in the dataset. Whan am I doing wrong? Thanks Jeronimo Bertran Tag: Distinct Values from a Datatable Tag: 114476
  - 20
    - Comma delimited cells to lookup table I have a cell in a MSSQL database that has comma delimited values. I.E. ( "1", "2", "3","4" ). These values represent property types. I.E. 1 = 1-Unit 2 = 2-Unit 3 = 3-Unit 4 = 4-Unit 5 = Condo etc... Lets assume there is no "look-up" table (I've search some 50 tables so far and could'nt find a table that relates the values there is over 200 more tables to search and tables do not have recognizable or intuitive names) When I bind the data from this cell to a textbox I see "1", "2", "3","4" exactly whats in the database which makes perfect sense. How do I make it so these values show the appropriate text. So instead of -> "1", "2", "3","4" <- I would see 1-Unit 2-Unit 3-Unit ect... How would I add or remove values from these cells/columns? I'm programing with C# and is pretty new to .Net. Any help in this matter would be greatly appreciated. Thanx Cyberbless Tag: Distinct Values from a Datatable Tag: 114475
  - 21
    - ORA-1866 I use ODP.NET as data provider, an exception with "ORA-1866 The datetime class is invalid error" is thrown when the SQL has a DateTime output parameter: DELETE FROM ... RETURNING A INTO :p here A is a TIMESTAMP column and p is a DateTime output parameter. But there is no exception if I change the data type of parameter p into DbType.String. I guess it is a bug in ODP.NET. Did anybody have the same problem? Does Oracle have a fix for it? Thanks. Simon Tag: Distinct Values from a Datatable Tag: 114465
  - 22
    - PaintEventArgs becoming empty -> black screen Hi, To get faster performance of my DataGrid during scrolling I wanted to build a timer in the Paint-event that waited some milli-seconds to Paint and cancelled the method in case it received a new Paint (during scrolling). But it doesn't seem to work :-( The whole screen becomes empty, and when I look into the PaintEventArgs it returns several errors (for exemple: ?petmr.Graphics.Clip -> <error: an exception of type: {System.ArgumentException} occurred>). Does anybody knows a solution for this? Thanks a lot in advance! Pieter This is my code: Protected Overrides Sub OnPaint(ByVal pe As System.Windows.Forms.PaintEventArgs) 'my override 'stop the timer tmrPaint.Stop() 'store the PaintEventArgs peTmr = pe 'restart the timer tmrPaint.Start() End Sub Private Sub tmrPaint_Elapsed(ByVal sender As Object, ByVal e As System.Timers.ElapsedEventArgs) Handles tmrPaint.Elapsed 'call my paint-method SubOnPaint(peTmr) End Sub Private Sub SubOnPaint(ByVal pe As System.Windows.Forms.PaintEventArgs) 'do all the painting stuff with MyBase.Paint etc etc End sub Tag: Distinct Values from a Datatable Tag: 114463
  - 23
    - Select all DataRows of a DataColumn Hello, >> Context VS2005 b2 DataTable.Select(string filterExpression) >> Aim I want to select all DataRows of a DataColumn. >> What I tried I tried the like-operator with wildcards* and %. But the compiler misses the operand. This behaviour is documented in msdn-docu: "A wildcard is allowed at the beginning and end of a pattern, or at the end of a pattern, or at the beginning of a pattern" "http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclassexpressiontopic.asp >> Compiler.Message "Syntax error: Missing operand after '*' operator. >> And howto select non-string DataColumns The like-operator does only work with string-DataColumns ( I think ). Greetings Gordian Tag: Distinct Values from a Datatable Tag: 114453
  - 24
    - business logic and data access I am building an object oriented application asp.net application which is accessing a relational database. I am a bit unclear as to the best place for business logic to appear. My understanding (perhaps imperfect) of object oriented methods is that the data and operations should be contained together in business objects. This sort of suggests that data access and business logic should be combined into the same objects. I am aware of the use of controller objects but my understanding is that they should sequence the flow of events of the business objects not actually contain any business logic as such themselves. I would appreciate anyones ideas on how they stucture their data access/business logic. -- Scott Tag: Distinct Values from a Datatable Tag: 114440
  - 25
    - overriding DataGridTextBoxColumn Paint -> Any idea to be faster? Hi, I 'wrote' my own DataGrid, using the normal DataGrid, and overriding some of the DataGridTextBoxColumn-methods (mostly the Paint-method). I based most of my changes on the Windows Form FAQ: - http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q745q - http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q758q - http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q837q Basicly it works like this: Every time a cell has to be painted, it throws an Event with an custom EventArgs-object. In that Event the specific property's of that cell are defined and returned to my Paint-method, who paints the cell as wanted. I have now behaviours like: - Custom painted column- and row-headers (image, border, color, background, ...) - bold/underlinded/italic text, backgroundimage, pictures, masks, ... for each cell, depending on it's value or another value in that row etc. The problem is: During the last year I added some new behaviours for each new project. But it becomes slower and slower... Scroling trough the DataGrid takes much more time than through a normal DataGrid. this isn't abnormal offcource, because on every Paint and for every Cell an event is thrown, and the whole logic has to be redone (checking values, select case, if then, selecting images... etc), even if the properties of the Cell remains the same. So my question is: Does anybody has any idea how I could make this stuff faster? And how to see which parts cost the most time? I alreaddy tried to look with a Now.Tick at the beginning and the end of a function to see if it took long time or not, but I was really surprised to see that the difference between the ticks before and after the method was zero! I also tried to put every Event-Args in a 2-dimensional array (for each cell one), but even this didn't give me a noticaable difference in eprformance... Can anybody help me? I really like my customized DataGrid, but it's really on the edge of useable now... :-/ thanks a lot in advance, Pieter Tag: Distinct Values from a Datatable Tag: 114439

guys, Has anyone tried this before?
i have a dataset and rather than doing an addtional trip to the server with a DISTINCT sql query - i'd like to just loop thru the existing dataset in memory.
i assign that dataset (ds) to a datatable, declare a datarow and then use the select property to get the distinct employee id.
i keep getting "Syntax error: Missing operand after 'EmplId' operator." and i've pretty much been out on the web looking for a solution to this.
any help is appreciated. snippet of the code is below.
thanks
rik

Dim oTable As DataTable = ds.Tables(0)
Dim myRow As DataRow
For Each myRow In oTable.Select("DISTINCT EmplId")
cboEmplList2.Items.Add(myRow.Item(0))
Next

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Top

Re: Distinct Values from a Datatable by W

W
Sun Jul 31 14:29:16 CDT 2005

http://support.microsoft.com/default.aspx?scid=kb;en-us;326176
"rik butcher" <rbutch@coair.com> wrote in message
news:Ok%23RBNglFHA.1968@TK2MSFTNGP14.phx.gbl...
> guys, Has anyone tried this before?
> i have a dataset and rather than doing an addtional trip to the server
> with a DISTINCT sql query - i'd like to just loop thru the existing
> dataset in memory.
> i assign that dataset (ds) to a datatable, declare a datarow and then use
> the select property to get the distinct employee id.
> i keep getting "Syntax error: Missing operand after 'EmplId' operator."
> and i've pretty much been out on the web looking for a solution to this.
> any help is appreciated. snippet of the code is below.
> thanks
> rik
>
> Dim oTable As DataTable = ds.Tables(0)
> Dim myRow As DataRow
> For Each myRow In oTable.Select("DISTINCT EmplId")
> cboEmplList2.Items.Add(myRow.Item(0))
> Next
>
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
> ASP.NET resources...

Top

Re: Distinct Values from a Datatable by Cor

Cor
Sun Jul 31 23:48:38 CDT 2005

Rik,

See this sample on our website

http://www.windowsformsdatagridhelp.com/default.aspx?ID=dcad9a66-1366-4d61-8d32-1a580eb893b2

I hope this helps,

Cor

Top

Re: Distinct Values from a Datatable by rik

rik
Mon Aug 01 14:36:03 CDT 2005

guys, i appreciate the help. this'll definately save a round trip and is extrememly fast since it's already in memory.
thanks again
rik

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Top