Sort Dataview by relationships

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
    - 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: Sort Dataview by relationships Tag: 114639
  - 2
    - 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: Sort Dataview by relationships Tag: 114638
  - 3
    - 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: Sort Dataview by relationships Tag: 114636
  - 4
    - 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: Sort Dataview by relationships Tag: 114634
  - 5
    - 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: Sort Dataview by relationships Tag: 114627
  - 6
    - 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: Sort Dataview by relationships Tag: 114622
  - 7
    - 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: Sort Dataview by relationships Tag: 114617
  - 8
    - 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: Sort Dataview by relationships Tag: 114616
  - 9
    - 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: Sort Dataview by relationships Tag: 114612
  - 10
    - 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: Sort Dataview by relationships Tag: 114608
  - 11
    - 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: Sort Dataview by relationships Tag: 114603
  - 12
    - 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: Sort Dataview by relationships Tag: 114598
  - 13
    - 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: Sort Dataview by relationships Tag: 114596
  - 14
    - 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: Sort Dataview by relationships Tag: 114582
  - 15
    - = 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: Sort Dataview by relationships Tag: 114571
  - 16
    - 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: Sort Dataview by relationships Tag: 114569
  - 17
    - 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: Sort Dataview by relationships Tag: 114565
  - 18
    - 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: Sort Dataview by relationships Tag: 114563
  - 19
    - 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: Sort Dataview by relationships Tag: 114560
  - 20
    - 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: Sort Dataview by relationships Tag: 114558
  - 21
    - 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: Sort Dataview by relationships Tag: 114557
  - 22
    - 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: Sort Dataview by relationships Tag: 114556
  - 23
    - 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: Sort Dataview by relationships Tag: 114547
  - 24
    - 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: Sort Dataview by relationships Tag: 114538
  - 25
    - 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: Sort Dataview by relationships Tag: 114531
- Next
  - 1
    - 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: Sort Dataview by relationships Tag: 114529
  - 2
    - 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: Sort Dataview by relationships Tag: 114522
  - 3
    - 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: Sort Dataview by relationships Tag: 114515
  - 4
    - 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: Sort Dataview by relationships Tag: 114511
  - 5
    - 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: Sort Dataview by relationships Tag: 114505
  - 6
    - 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: Sort Dataview by relationships Tag: 114503
  - 7
    - 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: Sort Dataview by relationships Tag: 114500
  - 8
    - 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: Sort Dataview by relationships Tag: 114490
  - 9
    - Difference between DataTable.Clone ( ) and DataTable.Copy ( ) ? Hello, does anyone knows the difference between: DataTable.Clone ( ) DataTable.Copy ( ) Thanks Gordian Tag: Sort Dataview by relationships Tag: 114489
  - 10
    - 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: Sort Dataview by relationships Tag: 114483
  - 11
    - 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: Sort Dataview by relationships Tag: 114481
  - 12
    - 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: Sort Dataview by relationships Tag: 114479
  - 13
    - 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: Sort Dataview by relationships Tag: 114476
  - 14
    - 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: Sort Dataview by relationships Tag: 114475
  - 15
    - 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: Sort Dataview by relationships Tag: 114465
  - 16
    - 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: Sort Dataview by relationships Tag: 114463
  - 17
    - 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: Sort Dataview by relationships Tag: 114453
  - 18
    - 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: Sort Dataview by relationships Tag: 114440
  - 19
    - 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: Sort Dataview by relationships Tag: 114439
  - 20
    - how to connect hi i want to connect to filemaker pro 6.0 through vb or vb.net applicationn can anbody tell me how to connect . i want connection string. Tag: Sort Dataview by relationships Tag: 114437
  - 21
    - Howto get the corresponding DataRow when clicking into a cell of Hello, I want to get the corresponding DataRow-object when I click into a DataGridViewCell. (The DataGridView is bound to a special DataTable in a DataSet) Thanks a lot Gordian Tag: Sort Dataview by relationships Tag: 114436
  - 22
    - How to call a Stored Procedure in Oracle having Boolean IN paramet Hi Gurus, I have a stored procedure which accepts boolean parameters as IN. In ado.net the system.data.oracleclient does not have boolean data type when declaring the parameter names. Please advise what should be done and the possible workarounds. I m in a tight position, and need a reply soon. Many thanks, -- Life is a box of chocolates. You never know what u get till you try it. Tag: Sort Dataview by relationships Tag: 114430
  - 23
    - ado.net updatecommand Ok...I give up. I am coding my own ole data adapter. I have a table called "Savings" which I am updating via a datagrid. I have the following code to set up my update command: ----------------------- // Setup Savings //Update uCmd = new OleDbCommand("UPDATE Savings SET " + "[Description]=@Description," + "Amount=@Amount " + "WHERE (TransDate=@TransDate)"); uCmd.Parameters.Add("@Description", System.Data.OleDb.OleDbType.VarChar, 100, "Description"); uCmd.Parameters.Add("@Amount", System.Data.OleDb.OleDbType.Currency, 4, "Amount"); uCmd.Parameters.Add("@TransDate", System.Data.OleDb.OleDbType.Date, 0, "@TransDate"); oleDbDataAdapter1.UpdateCommand = uCmd; ------------------------------------------ If I update a row in the datagrid and hit Update the database will be updated but every row in the database table is updated. Doesn't look like the system is using my where clause. I have 2 rows in the table and transdate is the primary key. If I have 7/01/05 and 7/02/05 rows and I update only the 7/01/05 row, the change is made to both rows. Can someone please point in the correct direction here? Thanks Tag: Sort Dataview by relationships Tag: 114427
  - 24
    - RowFilter Question In SQL Server, I can have the following statement: select * from MyTable where (MyColumn & 0x0001) = 1 Basically any row with a 1 or a 3 in the MyColumn will return on this call. If I load the entire table into a DataTable object and then attempt this same filter by setting the RowFilter property: oDataTable.DefaultView.RowFilter = "(MyColumn & 0x0001) = 1"; I get an error: System.Data.SyntaxErrorException: Cannot interpret token '0' Is the bitwise operator invalid on the RowFilter property, or do I need to set this property differently? Thank you in advance...-Ron Ward Tag: Sort Dataview by relationships Tag: 114426
  - 25
    - Data binding a date to a text box I have a data binding issue that I was hoping someone could help me with. We have converted a VB6 app to .NET unsung a conversion tool that came with .NET studio. Instead of converting the ADO code to ADO.NET it used COM interop to call to continue to use ADO objects. In the app sever date fields are bound to date data fields. In the old app after data binding the date would show with just the date (1/1/2000). After the app was converted the text boxes now show the date and time (1/1/2000 12:00 AM). When I edit the text box by deleting the time and TAB out of the field the binding immediatly adds it back in. I know that if we were to manually convert the app to use ADO.NET I could attach to events on the Binding object that is put into the TextBox.DataBindings collection (http://www.kdkeys.net/forums/715/ShowPost.aspx). However due to budget constraints this is not feasible. I have checked all the properties and events on the textbox and ADO bindings to try to get the time out of the text box with no success. Is there any way I can get the time out of the text box using ADO through COM interop? Tag: Sort Dataview by relationships Tag: 114397

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

Top