Binding a DataRelation to a Datagrid??

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
    - BULK INSERT and VB.Net I wrote a program that uses the BULK INSERT statement. All goes well and everything gets imported fine but the return results (rows affected) is double what was actually inserted. My application creates a format file (for bulk insert, by itself without bcp) and creates a data file using an imported file from an ibm mainframe. Before using BULK INSERT it took 22 minutes to complete, now it takes < 2 minutes. So, it's definately worth it. But I do have a couple of questions about it before I check it all in and Label it. 1.) Why are the affected rows returned by SqlCommand.ExecuteNonQuery double what was actually affected? 2.) Since it is bulk inserted, and there is a problem with, let's say, the 213,000th row, do all the rows get rolled back? 3.) When using BCP, it shows how many rows have been inserted, how do they get the # of rows affected? If I used a dataset, I could use the SqlDataAdapter to fire an event for this, but I'm not. I'm just using a SqlCommand object to do my updates and setting the BULK INSERT data and format vars in the sql statement. Any and all help appreciated, thank you... Mythran Tag: Binding a DataRelation to a Datagrid?? Tag: 108169
  - 2
    - memory leak in SqlDataAdapter.Fill method? I have a program that invokes the following block of code every x seconds. The process private bytes keeps increasing after every call. I've try to dispose the SQlDataAdapter in the finally block, but did not work. If I invoke the garbage collector manually GC.Collect in the finally block, there is no more memory leak. What's wrong with the following block of code? Is there a real leak or am I missing something? I've been working on this for few days, but I cannot figure it out. Please help! private DataSet GetJobQ() { DataSet ds = new DataSet(); SqlConnection conn = new SqlConnection( "myconnectionstring" ); SqlDataAdapter adpt = new SqlDataAdapter( "EXEC GetJobQ", conn ); try { adpt.Fill( ds ); } finally { con.Close(); } return ds; } Tag: Binding a DataRelation to a Datagrid?? Tag: 108167
  - 3
    - ADO.Net Connection Pooling Problem with Oracle Howdy, I recently implemented an ASP.Net application and am having trouble with running out of database connections. I've read many articles on the web concerning pooling, but have yet to find one that really describes in detail how pooling is supposed to behave. My problem is that over time, the number of database sessions in Oracle seem to increase to the point where we start getting the "Maximum number of sessions exceeded". I've already increased the SESSIONS init parameter in Oracle from 150 to 300, but we're coming pretty close to this limit. I've been monitoring the sessions using the V$SESSION view in Oracle and there are sessions with the same connection string (same USERNAME). For instance, one user may have over 100 database sessions. Here's a sample of what my connection strings look like: "Pooling=true;Data Source=mydb;Password=pass;User ID=fred" I believe the default max pool size is 100, so why do I see over 100 database sessions for a particular user, not to mention there can be 200 or more for the whole db? I use a shared component for all database executions (queries or updates). I've triple checked this component and I'm closing the database connections everywhere they're used. Everywhere I close them, it's done in the Finally portion of a Try-Catch block. For example: Dim connOracle As OracleClient.OracleConnection Dim cmdOracle As New OracleCommand Dim adpOracle As OracleClient.OracleDataAdapter Dim dsOracle As New DataSet Dim sConnectionString Dim sSQL Try sConnectionString = "Pooling=true;Data Source=mydb;Password=pass;User ID=fred" sSQL = "SELECT Username FROM Users" 'Open a connection - get from pool if already one in pool connOracle = New OracleConnection(sConnectionString) connOracle.Open() cmdOracle.Connection = connOracle cmdOracle.CommandType = CommandType.Text cmdOracle.CommandText = sSQL adpOracle = New OracleDataAdapter(cmdOracle) adpOracle.Fill(dsOracle) Finally If connOracle.State <> ConnectionState.Closed Then connOracle.Close() End If adpOracle = Nothing connOracle = Nothing cmdOracle = Nothing End Try When I first discovered the pooling problem, I thought it was because I wasn't closing the db connections. I was using DataReaders and it wasn't easy to close the connections using a shared component, so I changed everything to use DataSets. This seemed to improve the situation, but it didn't completely solve it. I've talked with Oracle Support and they say this is not a database issue since the database doesn't close the connections. They leave it up to the application. If connections are orphaned, you have to implement what they call the Dead Connection Detector if you want Oracle to clean them up. I did this, but ran into some very serious problems as a result (CPU utilization was hitting 99% after 3 to 4 hours). I don't think Oracle should have to clean up every database connection that is created from ADO.Net, so I'm now going to the root of the problem - the application. I've also done some testing with non-pooled connections. I was seeing multiple Oracle sessions for the loading of one ASP.Net page. I ran the code through the debugger and verified that the db connections were being closed. I was confused at first, but then realized this was because the garbage collector didn't clean things up yet. I added a call to System.GC.Collect and sure enough, no database sessions were left open (in V$SESSION table) after loading the page. It's not feasible to collect the garbage everytime I close a database connection and establishing new connections everytime an SQL statement runs kills performance. Isn't that what connection pooling is for????? Why isn't this working????? For our environment, we're using version 1.1.4322 of the .Net Framework, Microsoft's OracleClient ADO.Net Provider and version 9.2.0.6 of the Oracle database. We're running this on Windows Server 2003 WITHOUT service pack 1, but all of the latest critical patches. I would really appreciate anybody's help in solving this problem. Bird Tag: Binding a DataRelation to a Datagrid?? Tag: 108160
  - 4
    - DataView.RowFilter issue Hello, I use The RowFilter property to select number of row from my dataview. How can i get the number of rows found ? I experience that the number of rows remains the same as before the filter was applyied if there i no match for the filter. Any comment will be highly appreciated. JB Tag: Binding a DataRelation to a Datagrid?? Tag: 108145
  - 5
    - PLEASE HELP - UserControl DataBinding flow thru HI, I have a UserControl with a textbox in it. How can i bind the textbox to a datasource, only binding the UserControl, ie what functionality should i add to the UC to "transfer" databinding to nested textbox? I tried some different things, like exposing textbox.Text property and binding datasource to it, creating virtual UC property DataBindings, which would return DataBindings of textBox, but nothing helps so far.. Any ideas would be highly appreciated! Thank you, Andrey Tag: Binding a DataRelation to a Datagrid?? Tag: 108138
  - 6
    - Constraints Hi, I would like to ad Constraints to a database column, which only can have unique values. The column can be empty only if the table is empty (no records). Im using the syntaxt: pk = new DataColumn[1]; pk[0] = ds.Tables["table"].Columns["ID"]; ds.Tables["table"].Constraints.Add(new UniqueConstraint("ConstrName", pk[0])); ds.Tables["table"].PrimaryKey = pk; The problem is when the datatable is empty. I get an error message "the column doesn't contain the unique value". Is it possible to avoid this with an empty table? Thanks, Lubomir Tag: Binding a DataRelation to a Datagrid?? Tag: 108133
  - 7
    - Formatting a SQL query Hi, I have the following query written for MS Access: PARAMETERS [Enter a keyword to search] Text ( 255 ); SELECT TOP 10 ISBN, Title FROM Books WHERE Keywords LIKE "*" & [Enter a keyword to search] & "*" ORDER BY Title; This query works as expected. Now, how do I write this query in VB.NET for an OleDBCommand's text property? I tried this but it doesn't seem to be working: "Select Top 10 ISBN, Title FROM Books WHERE Keywords Like '*' & ? & '*' ORDER BY Title ASC;" Any thoughts? Thanks, Roshawn Tag: Binding a DataRelation to a Datagrid?? Tag: 108127
  - 8
    - Cannot Open Any More Tables I was working on creating a data library to use throughout my applications, when I came across an odd behavior. I encounter â??Cannot Open Any More Tables.â?? After using the OleDBCommand.ExecuteNonQuery method. I have included code that recreates the exception. I cannot recreate this error with the SQLCommand.ExecuteNonQuery method. The problem only occurs when I first declare my connection object as the base object IDBConnection. If I use OLEDBConnection from the start, then I am fine. Any Ideas? Thanks Private Structure Record Dim Rank As Long Dim BoyName As String Dim BoyChosen As Long Dim GirlName As String Dim GirlChosen As Long End Structure Private aNames As ArrayList Private Sub LoadData() 'Dim pobjTest As ATG.DataLayer.BaseConnection Dim pobjConnection As System.Data.IDbConnection pobjConnection = New System.Data.OleDb.OleDbConnection ReadNames() 'pobjTest = New ATG.DataLayer.OLEData("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Documents and Settings\matt\My Documents\TimeKeeper.mdb;Mode=Share Deny None;") 'pobjTest.Connect() pobjConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Documents and Settings\matt\My Documents\TimeKeeper.mdb;Mode=Share Deny None;" pobjConnection.Open() 'pobjTest.BeginTrans() For Each oRec As Record In aNames ExecuteSQL("INSERT INTO [NAMES] (Rank, BoyName, BoyChosen, GirlName, GirlChosen) VALUES('" & oRec.Rank.ToString.Replace("'", "''") & "','" & oRec.BoyName.Replace("'", "''") & "'," & oRec.BoyChosen.ToString.Replace("'", "''") & ",'" & oRec.GirlName.Replace("'", "''") & "'," & oRec.GirlChosen.ToString.Replace("'", "''") & ")", pobjConnection) Next 'pobjTest.CommitTrans() pobjConnection.Close() pobjConnection = Nothing End Sub Private Function ExecuteSQL(ByVal SQL As String, ByVal pobjconnection As System.Data.IDbConnection) As Long ' Executes a SQL Statement ' Checks for an active ' transaction and uses ' it. ' Returns the number of ' rows affected ' Const Routine As String = "ExecuteSQL()" Const pstrExceptionDescription As String = "There was an error executing a SQL statement." Dim cmd As OleDb.OleDbCommand Dim iRet As Integer = -1 Try 'If Me.State = ConnectionState.dbOpenConnection Or Me.State = ConnectionState.dbInTransaction Then 'we have an active connection 'Check to see if we are in a transaction 'If Me.plngState = ConnectionState.dbInTransaction Then 'cmd = New OleDb.OleDbCommand(SQL, pobjConnection, pobjTransaction) 'Else cmd = New OleDb.OleDbCommand(SQL, pobjconnection) 'End If 'execute the statement cmd.Prepare() iRet = cmd.ExecuteNonQuery() cmd = Nothing 'Else 'ThrowCloseStateError(Routine) 'End If Catch ex As OleDbException 'There was a problem with the sql connection 'Set our state 'Me.plngState = ConnectionState.dbError Debug.WriteLine(SQL) MsgBox(ex.ToString) 'Throw New DataLayer.DataException(pstrExceptionDescription, ex, SQL) Catch ex As Exception 'Some other error occured Debug.WriteLine(SQL) 'Throw New DataLayer.DataException(pstrExceptionDescription, ex, SQL) Finally cmd = Nothing End Try Return iRet End Function Private Sub ReadNames() Dim oRec As Record, Line As String Dim aRec() As String aNames = New ArrayList Dim oFile As System.IO.StreamReader = New System.IO.StreamReader("c:\2003 popular names.txt.csv") Do Line = oFile.ReadLine() If Line Is Nothing Then Exit Do aRec = Line.Split(",") 'Debug.WriteLine("Read:" & Line) With oRec .Rank = aRec(0) .BoyName = aRec(1) .BoyChosen = aRec(2) .GirlName = aRec(3) .GirlChosen = aRec(4) End With aNames.Add(oRec) Loop Until Line Is Nothing End Sub Tag: Binding a DataRelation to a Datagrid?? Tag: 108110
  - 9
    - Editing Info in a DataTable Hello: How can you you edit data in a datatable? I already have the datatables created. I want to know how i can refer to the columns in the data table and what commands do i have for editing info in the table. I want to be able to move the values in one column to another in the same table Thanks Prasun Tag: Binding a DataRelation to a Datagrid?? Tag: 108105
  - 10
    - shared access folder problem Hi guys... I have a web app that works pretty good . It was developed with the access database in the virtual directory....now thats its about done, i would like to reference the database from a shared network directory. I thought all I had to do was the following in the web.cinfig file <appSettings> <add key="cs" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ServerX\xtemp\sfleet.mdb"/> </appSettings> "Serverx is a file server, xtemp is a shared directory but I cant get it to work...when i give a absolute path c:\xtemp\sfleet.mdb it works fine what am i doing wrong? Tag: Binding a DataRelation to a Datagrid?? Tag: 108104
  - 11
    - weird ADO issue Hi all, I apologize for posting in this NG if this post is a better fit for some other group, however I am up against the wall here. My program uses free threaded COM. Once in a while (depending on routines I call) I instantiate ADO, use it and release. Everything works fine on XP Professional, and on Windows 2000 (workstation) however, when I run it on Windows 2000 server, in the beginning everything works fine, and then, out of nowhere, I get intermittent failure (0x80010105 HRESULT) from: ADODB::_ConnectionPtr spConn; hr = spConn.CreateInstance( ADODB::CLSID_Connection ); (I use VC++7) Similar behavior I get when I instantiate VBScriprt's RegExp component in the same program. But here I am catching 0xC0000005 error from m_spRegExp.CreateInstance( __uuidof(VBS_REGEX::RegExp) ); Yes, I know... maybe I don't release objects properly, or some other bug in my software... I've tried almost everything there is to try.... the bottom line It WORKS on XP sp2, but not on 2000 server sp4. Please help, I am up against the wall here. Thanks. Paul Tag: Binding a DataRelation to a Datagrid?? Tag: 108103
  - 12
    - multiple tables in a flat grid What is the best way to create a datasource for a single flat grid that pulls from multiple updateable datatables? I'd like to pull back multiple tables, create relationships between them, then have a grid bind to a 'view' of these tables so that when I update a field in the grid, it updates the datatable in which that field resides. Thanks, Chris Tag: Binding a DataRelation to a Datagrid?? Tag: 108102
  - 13
    - Rows How might I return a current count of rows in a dataset table? I tried the obvious: DataSet.Tables("TableName").Rows.Count However that returns the original number of rows, and not the number of rows filtered subsequently in my datagrid. How may I return either the number of filtered roceds in the dataset, or lacking that the number of rows displayed in my datagrid? Thanks... Unfortuantely because the documentation is so deeply nested and multi-rooted, its next to impossible to find anything specific :-S Any help would be greatly appreciated. Tag: Binding a DataRelation to a Datagrid?? Tag: 108092
  - 14
    - Why can't I find...? Why can't I find a reference page for ADO.Net, you know, objects, properties, methods...? I can find all kinds of feel good stuff like: Best Practices, Migration, ADO.Net & You...but no straight up, no b.s. reference. Kinda sucks :-S Tag: Binding a DataRelation to a Datagrid?? Tag: 108088
  - 15
    - Schema Collection -> Strongly Typed Dataset I have a bunch of .xsd files some of which inherit from others, such that there are elements that have attributes in one file and also inherts other attributes from another file. These schemas come from an external source (I have no control over them). We plan to store the .xml documents as they come in (using Oracle XML DB), then read them in, validate and manipulate them in Visual Studio (2005 beta due to a bug in 2003 that the schemas abuse). I want to create a strongly typed dataset, so that when I read the document in I can reference it using the tables and columns in the dataset. How do I go about creating this dataset from the (20+) schemas? Tag: Binding a DataRelation to a Datagrid?? Tag: 108075
  - 16
    - Dataset Merge Question Does anyone know exactly how the MERGE method on the dataset functions? The reason that I am asking is that it does not appear to be doing what I expect, and what the documentation claims will happen (if I am understanding it correctly). According to the following link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskmergingdatasets.asp You can specify merge options to achieve a variety of goals: Add new records to one dataset by copying them from another dataset. Update the state of records in one dataset based on another. In this situation, the second dataset contains information not only about new records, but also changed records and deleted records, and you want your first dataset to reflect all these changes. Copy not only new records and changes, but specify what to do if the datasets do not have the same schemas. My problem is that it will not update changed records. It will only add new records. I have included my code below. If anyone has a suggestion, I would greatly appreciate it. 'Get SQL Table for each table in XML File TableName = xmlDataSet.Tables(TableLoop).TableName SQLText = "SELECT * FROM " & TableName Dim SQLAdapter As SqlDataAdapter = New SqlDataAdapter SQLAdapter.SelectCommand = New SqlCommand(SQLText, SQLConnect) Dim SQLCmdBuild As SqlCommandBuilder = New SqlCommandBuilder(SQLAdapter) sqlDataSet = New DataSet(TableName) 'Fill Dataset with SQL Table, and then merge in XML Table SQLAdapter.ContinueUpdateOnError = True SQLAdapter.Fill(sqlDataSet) sqlDataSet.Merge(xmlDataSet) SQLAdapter.Update(sqlDataSet, TableName) -- Jim McFadden Northern Health Anesthesia A Division of VantageMed, Inc. Tag: Binding a DataRelation to a Datagrid?? Tag: 108074
  - 17
    - ReadXml into a DataTable? Hi, I've gotten the dataset.ReadXml() method to load XML from a remote source but I was wondering since I plan on having multiple datatables in the dataset, can you specify which table to read XML into? I'm using ASP.NET 1.1 Thanks, Dave Tag: Binding a DataRelation to a Datagrid?? Tag: 108065
  - 18
    - Multiple DataTables in Dataset Hi, I am returning multiple datatables from a stored procedure into a dataset. It keeps naming the datatables as "Table","Table1","Table2" etc. Is there a way i can change the sproc so that my datatables get created with a name ? The multiple select statements have multiple joins too so i am not sure where to alias it. I do not want to depend on the indexes to grab the right tables. Let me know if there's a solution. Thanks! Tag: Binding a DataRelation to a Datagrid?? Tag: 108064
  - 19
    - MS Best Practice - Load subset of a single Row Can someone please tell me the recommended best practice for loading a subset of the columns from a single row of a database table? Users can make fields come and go from the form, so a stored procedure is not an option as I see it. Using a datareader opens a cursor, which seems an inefficient way to get one row, but I do not see an alternative. I tried ExecuteNonQuery with a Select statement, but it didn't seem to like selects at all. ORA-01036 - invalid parameter name/number. Any help would be appreciated. Tag: Binding a DataRelation to a Datagrid?? Tag: 108063
  - 20
    - Reset SQL Server connection pool? Is there a way to reset the connection pool on a machine so that all cached connections to a database are closed? Cheers, Jon Tag: Binding a DataRelation to a Datagrid?? Tag: 108060
  - 21
    - Retrieving datarows using DataTable.Select method and adding it to new DataTable Hi, I have the following fragment of code which retrieves datarows from a data table using the Select method.I want to add these rows into another data table.But I get the Exception: 'Column "ReleaseDate" already belongs to another table' // Use the Select method to find all rows matching the filter. DataRow[] foundRows = dt.Select( strExpr, strSort, DataViewRowState.CurrentRows); int len = foundRows.Length; DataColumn dc=new DataColumn(); foreach( DataRow r in foundRows ) { foreach( DataColumn c in r.Table.Columns ) { dc=c; dt1.Columns.Add(c); ColCnt=r.Table.Columns.IndexOf(c); } ii = 1; } dr=dt1.NewRow(); dr[ColCnt]=dc; dt1.Rows.Add(dr); }*/ -- Message posted via http://www.dotnetmonster.com Tag: Binding a DataRelation to a Datagrid?? Tag: 108053
  - 22
    - Transactions in ADO.Net 2 strongly-typed datsets. Here's the scenario: I have a custom object that represents a group in our law firm. For each group, there are many members of that group. Now, the group object exposes a property that is a strongly-typed datatable of the member records. The UI programmer will add/delete records from this datatable as the user adjusts the members of the group. Then, the Update method of the group object will not only update it's normal properties (name, description, etc.) but will call the update method of the adapter for the datatable to write the changes to the members. My question as a ADO.Net 2 newbie is this: How to I wrap the group object changes and the changes written by the update in the datatable in the same transaction? I knew how to do this in ADO.Net 1.x, but the properties exposing the insert, update, delete command objects in the datatable are not there. What am I missing? Any help would be GREATLY appreciated. Sincerely, Glen Wolinksy Tag: Binding a DataRelation to a Datagrid?? Tag: 108051
  - 23
    - data access Hi all, I am trying to gather records from different databases into one dataset. I can do the select statements and get the data into the datatables and then into a dataset. The problem is then being able to get the data I need from the dataset so that I can display it for a report. (I am trying to do a select on the dataset tables) My question is, am I going about this in the right manner or am I going down the wrong path. From everything I have seen and read, a dataset query is not possible. Can anyone steer me in the right direction? Any help or advice would be appreciated. Joe Hassan Tag: Binding a DataRelation to a Datagrid?? Tag: 108049
  - 24
    - What is "Any instance members are not guaranteed to be thread safe" ? Hello all, I was developing an ASP.NET application using c#, and I was thinking for adding some instance variables for my xyz.aspx like this :- public class SetCustomers : System.Web.UI.Page { private string s_workemail = ""; private void Page_Load(object sender, System.EventArgs e) { I however came across this in the Page Class definition :- Thread Safety Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe. so I got confused, my question is, does this mean that my instance variable s_workemail is NOT thread safe? i.e if user A and user B access my page and modify the value at the same time, will I get wrong results? or will there be 2 variables, 1 on every thread? Thanks for your help. Tag: Binding a DataRelation to a Datagrid?? Tag: 108044
  - 25
    - problem with nested relations in typed datasets hi.. i have 2 problems if i create a table relationship between 2 tables and define it as nested in the "is nested" property schema it does not create any DataRelations if i try to define a nested Relation in runtime but with a constructor it will be ignored. only using isNested Property of the date Relation will work Tag: Binding a DataRelation to a Datagrid?? Tag: 108041
- Next
  - 1
    - DataColumn.Caption I've set the Caption property for a table in DataSet, so when hte DataSet is binded to a Datagrid, the caption is displeyd instead of the column name. But it doesn't work. I get the column name instead of caption. What may be the cause? Tag: Binding a DataRelation to a Datagrid?? Tag: 108036
  - 2
    - How to use Like in free text search on Datadview.Rowfilter or DataTable.Select() Hello, I need to implement a free text search on an asp.net page. I need to search two columns based on a text entered in a tex box. it should be possible to search any subsrting included in one of the two columns. I did the following: DataView dv=MyOriginaleDataTable .DefaultView; dv.RowFilter=" column1 Like ' "+srearchstring.text +" ' or column2 Like ' "+ srearchstring.text+ " ' "; ..... MydataList.DataSource =dv. ......... This is not working. Can someone tel me what i'm doing wrong? Many thanks JB Tag: Binding a DataRelation to a Datagrid?? Tag: 108034
  - 3
    - Bug of SqlClient?! Problem with output parameter/SQL Server 2000! Here is the simple test stored procedure: <code> CREATE PROCEDURE pr_test ( @xParam1 nvarchar(200) = null output ) as --set @xParam1 = newid() select result = @xParam1 set @xParam1 = newid() </code> If I run the following test SQL script in Query Analyzer, I get expected result: declare @x nvarchar(500) <code> set @x = '1234' exec pr_test @x output select result = @x </code> <output> result -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1234 (1 row(s) affected) after ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 92CBE528-6097-48C6-A0C4-C152425D180A (1 row(s) affected) </output> However, in Visual Studio .NET 2002/2003, the following code does not get expected result: <code> DataSet ds = new DataSet(); this.sqlDataAdapter1.SelectCommand.Parameters["@xParam1"].Value = "1234"; this.sqlDataAdapter1.Fill(ds); this.dataGrid1.DataSource = ds.Tables[0]; this.Text = this.sqlDataAdapter1.SelectCommand.Parameters["@xParam1"].Value.ToString(); </code> The output paramter @xParam1 has been setup correctly. The datagrid always shows the value of 'result' column as 'null'. Do I have misunderstanding of ADO.NET/SqlClient or this is simply a bug? Tag: Binding a DataRelation to a Datagrid?? Tag: 108028
  - 4
    - Using Transactions in C# Hi, i have some wired behaviour using c#, ado and sql server. There are two tables on sql server: Order and Orderdetails. (Order_ID is primary key on Table Order and foreign Key on Orderdetails.) I have two c# Classes calles Order and Orderdetails. They contain two Methods for inserting Orders or Orderdetails on Database. (Parameterized with an sql connection an an transaction.) On the main programm a transaction is started an calling Order.Insert(...) Then, i do serveral Orderdetails.Insert(...) before committing the transaction. This works as supposed, but there is one big issue i cant figure out: I start debugging the app and opend query-analyzer. After calling Order.Insert(...)-but not yet committed the transaction - i am able to do a "select * from order where order_id = 1". BUT: After calling Orderdetail.Insert(...)in the code -but not yet committing the transaction- i cant do a "select * from orderdetail where order_id = 1), because Query Analyzer is waiting until the transaction is commited. Why that? I mean it did work for Order.Insert; why not for Orderdetail.Insert??? When i use the command "select * from orderdetail with (readpast) where order_id = 1" it asap returns data. (There are about 1000 Datarows in the Tables; that with order_id = 1 has been already inserted. The isolationlevel is set to IsolationLevel.ReadUncommitted) Can anyone help? Thanks, bye DS Tag: Binding a DataRelation to a Datagrid?? Tag: 108027
  - 5
    - DeriveParameters and Jet OLEDB Provider Hi I've just discovered that the Jet OLEDB Provider does not support OleDbCommandBuilder.DeriveParameters, to discover the number and type of parameters expected by a Microsoft Access query. I'm a little surprised, as it was always possible to use the ADO Refresh method with this provider to populate a Paramters collection. Is there a reason for this? Is there a workaround? I know that it's an expensive operation which should be avoided anyway, but it's sometimes useful, and I'd like to use the same code against both Access and SQL Server. Thanks in advance. -- Doug Tag: Binding a DataRelation to a Datagrid?? Tag: 108024
  - 6
    - ADO.NET 2.0 - Question for Microsoft Employees Okay, so we have a new Isolationlevel for transactions in ADO.NET - the snapshot isolation. That exists at System.Data - which leads me to believe that nothing really stops me from setting that isolation level on Oracle. So my question is - by setting that on Oracle, does it mean the same as SET TRANSACTION READ ONLY Or does Isolationlevel.Snapshot not work on Oracle? (Frankly my opinion, IsolationLevel.Snapshot not working on Oracle is not a good answer, but if that is what it does, then that is what it does ..) Can anyone advise? :) - Sahil Malik [MVP] http://codebetter.com/blogs/sahil.malik/ Tag: Binding a DataRelation to a Datagrid?? Tag: 108021
  - 7
    - Casting IntPtr/Byte etc... Trying to get HP's Biometric API for the .NetCF to work by storing fingerprint data in a DB and then retrieving it. First problem: casting to the right types to store in the DB. Right now I'm casting each fingerprint property to OleDbType.Variant prior to inserting in the DB and then in a stored procedure casting each property to either Int, Binary or smallint before storing it in a table. I get a problem when retrieving though - exceptions on pretty much each data type. System.UInt32 Length; System.Byte HeaderVersion; BioAPI_BIR_DATA_TYPE Type; System.UInt16 FormatOwner; System.UInt16 FormatID; SYstem.Byte Quality; BioAPI_BIR_PURPOSE Purpose; BioAPI_BIR_AUTH_FACTORS FactorsMask; System.IntPtr BiometricData; System.IntPtr Signature; The 3 custom datatypes are either of type UInt8 or type UInt32. I'm even having problems with re-casting (i.e. after retrieving info back from the DB) type Byte (ex: HeaderVersion, "An unhandled exception of type 'System.InvalidCastException' occured"). Could anyone point me out as to what I should do. And also how I can cast, or import, data that has type System.IntPtr. Thanks so much! Tag: Binding a DataRelation to a Datagrid?? Tag: 108019
  - 8
    - Datarepeater Hi, NG! Is there any updated version (.Net) of the Datarepeater control or do I have to use the old (VS6.0) version? Thanks. pax Tag: Binding a DataRelation to a Datagrid?? Tag: 108014
  - 9
    - Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraint We've moved a database from one SQL server to another using a backup and restore, we had some problems because the location was slightly different when we moved the database, then we had to create all the users again. We're now receiving an error when opening the client utility - which is "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraint" Any suggestions? database was working beforehand so i can't see why it would be an error in the code Regards Paul PS SQL2000 with SP3 Tag: Binding a DataRelation to a Datagrid?? Tag: 108004
  - 10
    - ExecuteNonQuery returns ORA-01036 illegal variable name/number I have used ExecuteNonQuery with no trouble for inserts, updates and deletes. The best practices book I have says this is also the most efficient way to return multiple column values from a single row. The requested fields can be changed by users adding/removing fields from the form, so a stored proc will not work - variable number of return values. I tried: Select name, rank into ( :V1, :V2 ) from mytable where keyvalue = :V3 and get ORA-01036. The bound parameters are named to match the sql statement. IN params work fine, but I cannot make it happy with the OUT params. Any help would be appreciated. Tag: Binding a DataRelation to a Datagrid?? Tag: 108002
  - 11
    - how to connect Access database I was using the following classes to get data from. Now I would like to know which class shall I use from Windows Forms VC++ 2005. CDaoDatabase m_Dao; // Variables in String Table // m_file = "C:\\Program Files\\Onair\\InVer.mdb" // m_upass = "password" m_Dao.Open(m_file ,FALSE, FALSE, m_upass); CDaoRecordset m_Set; COleVariant m_varprofile; COleVariant m_varsection; m_Set.GetFieldValue ("Profile", m_varprofile); etc.., Tag: Binding a DataRelation to a Datagrid?? Tag: 108001
  - 12
    - Case-sensitivity in a stored procedure Hi there! How can I toggle case-sensitivity within a stored procedure? I'd like to compare 2 passed in parameters against fields in a table. The first comparison is case-sensitive, the second is not. How can I do that? By default it seems they're not case-sensitive. Thanks in advance. -- /Matthias Tag: Binding a DataRelation to a Datagrid?? Tag: 107999
  - 13
    - To Insert Multiple Rows in Oracle using oledbCommand I need to know how to Insert Multiple Rows in Oracle using oledbCommand -------------------------------- From: Mose Joseph ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>wLuDr7c3DU+/lMo6w74RrQ==</Id> Tag: Binding a DataRelation to a Datagrid?? Tag: 107991
  - 14
    - (Q for David Sceppa!) Problems submitting hierarchical changes to DB Hello, On page 786 of the ADO.NET Core Reference (chapter 11 - Advanced Updating Scenarios), David Sceppa gives the basic steps for submitting hierarchical changes (paraphrased): 1. Submit new master rows 2. Submit new detail rows 3. Submit modified master rows 4. Submit modified detail rows 5. Submit deleted detail rows 6. Submit deleted master rows I took this process and applied it to a rather large, normalized data structure. However, the modified detail row changes would never make it to the database. I stepped through the code and found that after updating the modified master rows (step 3), the related detail rows' RowState would change from Modified to Unchanged. This, of course, keeps the detail rows from being sent to the database. After swapping steps 3 and 4, the database was successfully updated. My questions...why does that happen in the first place? Will swapping steps 3 and 4 have some other adverse effect? Thank you! Eric Tag: Binding a DataRelation to a Datagrid?? Tag: 107989
  - 15
    - Get the name of the primary key Working with a Microsoft Access database, what is the best way to get the name of the primary key field? I know the table name. Tag: Binding a DataRelation to a Datagrid?? Tag: 107988
  - 16
    - Parameter expected? It keeps saying the stored procedure expects the parameter '@entity' which was not suppplied, but I'm supplying it: OdbcConnection cn = new OdbcConnection(CNSTR); OdbcCommand cmd = new OdbcCommand("GetMyList", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@entity", OdbcType.VarChar, 4); cmd.Parameters.Add("@type", OdbcType.VarChar, 4); cmd.Parameters["@entity"].Value = "PRAC"; cmd.Parameters["@type"].Value = "TYPE"; cn.Open(); OdbcDataReader reader = cmd.ExecuteReader(); cn.Close(); If I substitute a SQL statement (no parameters) all is good. What I am I doing wrong on the parameter creation/adding? Thanks in advance. Tag: Binding a DataRelation to a Datagrid?? Tag: 107986
  - 17
    - Generic error in GDI+ I'm loading thousands of images into a SQL Server 2000 database. I have a .NET windows application that I'm working on written in C# that retrieves the fileinfo of the directory and then loads all of the images into an image field in the database. The problem I'm having is that I get an unhandled exception after loading about 900 images that says "A generic error occured in GDI+". I've determined that it has something to do with loading the images. If I do everything but actually retrieve and load the images it runs fine. Here is the code that retrieves and loads the images to the database: string strSQL = @"INSERT INTO page(page_image) VALUES (@page_image)"; SqlCommand sqlCommand_page = new SqlCommand(strSQL, sqlConnection_DocImage); SqlParameterCollection pc_page = sqlCommand_page.Parameters; pc_page.Add(new System.Data.SqlClient.SqlParameter("@page_image", System.Data.SqlDbType.VarBinary, 2147483647, "page_image")); Image img; sqlConnection_DocImage.Open(); foreach(FileInfo row in jpgFileInfo) { using(MemoryStream imageMS = new MemoryStream()) { img = Image.FromFile(row["fullname"].ToString()); img.Save(imageMS, ImageFormat.Jpeg); pc_page["@page_image"].Value = imageMS.ToArray(); } sqlCommand_page.ExecuteNonQuery(); } sqlConnection_DocImage.Close(); The error message gives me no clue to diagnose what's happening. It sounds like a resource isn't being disposed of. Thanks in advance for any help. HArlan Marshall Tag: Binding a DataRelation to a Datagrid?? Tag: 107983
  - 18
    - Errors connecting with Microsoft.Jet.OLEDB.4.0 Hi, I install Crystal Reports 8, and some permissions for the= registry subkeys and their lower-level subkeys are modified=2E I= used a Crystal restoration utility, and everything come back= fine again, all except for the OLEDB connections using= Microsoft=2EJet=2EOLEDB=2E4=2E0 provider, I can't connect to excel files anymore, I guess is= something about the registry subkeys=2E Thanks=2E -------------------------------- From: Javier Villarreal ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>scAM4u3dcUKg/FQYxOGZeQ=3D=3D</Id> Tag: Binding a DataRelation to a Datagrid?? Tag: 107980
  - 19
    - VB.Net Joining Paradox and SQL Server Table? Has anyone done this yet? I know it is easily done in Paradox, but I would like to do it in VB.Net. Can anyone point me in the right direction? Thanks, Rog Tag: Binding a DataRelation to a Datagrid?? Tag: 107972
  - 20
    - dataadapter and component I'm creating a component that contains a function. This function is to return a data set of state values (AL,IL,TN,CA,...). I'm new to dataadapters this is my first, but something just doesn't seem right. the function return a dataset, but do it need to define a dataset in the body of the function as well as in the calling routine? 2. can i bind this dataset to two different drop down lists? here is my function. Public Class states Inherits System.ComponentModel.Component Public Function GetStates() As DataSet Dim ddlStates As DataSet = New DataSet Dim strcon As String = "DSN=SE;" Dim conSE As New OdbcConnection(strcon) Dim strSQL As String = "select staStateName, staLongName from sta where 1=1 order by staStateName" Dim daStates As OdbcDataAdapter daStates = New OdbcDataAdapter(strSQL, conSE) 'Fill dataset conSE.Open() daStates.Fill(ddlStates, "states") conSE.Close() Return ddlStates End Function Tag: Binding a DataRelation to a Datagrid?? Tag: 107970
  - 21
    - Filter Dataset Correct me if I'm wrong, but once I have my data returned from a stored procedure, in a dataset and displayed in a DataGrid (ASP.Net)...I can filter the data correct, without making a return trip to the server? Anyone have an example of how this works? Thanks Tag: Binding a DataRelation to a Datagrid?? Tag: 107962
  - 22
    - No cursor when compared with ADO After a dataset has been populated, it no longer reflects changes in database. It is the shortcoming I found in ADO.NET. In ADO, we have dynamic recordset, keyset recordset which can reflect the changes to database done by other users immediately. Why can't I find these useful stuff in ADO.NET? Tag: Binding a DataRelation to a Datagrid?? Tag: 107961
  - 23
    - Memory leak in OleDbCommand.ExecuteNonQuery()? Maybe there's something I'm doing wrong here. I'm open to any suggestions. I'll see if I can explain this clearly... I have a C# application that runs 24x7 collecting data from some source and storing the data in a Microsoft Access database. The problem is, every time it stores the data using a call to OleDbCommand.ExecuteNonQuery(), the applications memory usage grows. After a few days, the application has consumed most of the systems' virtual memory and grows more and more sluggish and unresponsive. The only solution right now is to restart the application every couple of days. Since the app uses one database and stores the same database fields with only the data changing, I set up everything at the start of the program. After that, as data comes in, only the stored data parameter values change. The first thing I do is open the MS Access database using an OleDbConnection with a Microsoft.Jet.OLEDB.4.0 provider. I then create a OleDbCommand with a command string that basically consists of "INSERT INTO table (field1, field2...) VALUES (?,?...)". Next I use OleDbCommand.Parameters.Add to add OleDbParameter data parameters that correspond to each field to the OleDbCommand, with the proper datatype for each field. Lastly I set the OleDbConnection in the OleDbCommand. As the data is collected I go through each OleDbParameter and set its Value to either the data collected or DBNull.Value if the data is missing. Then I call OleDbCommand.ExecuteNonQuery to actually store the data. That occurs successfully, but the virtual memory alllocation goes up and up each time the data is stored. I monitor the memory usage with Sysinternals ProcExp, and if I comment out the call to actually store the data, the memory usage remains constant. So am I doing something wrong, or is there a memory leak in OleDbCommand.ExecuteNonQuery? Tag: Binding a DataRelation to a Datagrid?? Tag: 107957
  - 24
    - SQLConnection connection pool issue I have a similar problem to several other people who have posted= here - I can only open up to <Max Pool Size> connections=2E After= that I get a timeout expired exception=2E Looking at the open / pooled connections in perfmon (in both SQL= Server stats, and the CLR runtime), there are never more than 5= / 6 connections open, but without fail, I cannot open more than= <Max Pool Size> connections, even when I change this value or= don't specify it=2E I have already tried several suggested solutions - disabling SQL= Server debugging in VS=2Enet, running in release mode, connecting= to several other databases on several other computers, but= nothing seems to have any effect=2E I have gone through the code= with a fine tooth-comb, and put "open connection" counters into= my database class (all the connections are opened and closed by= a single pair of shared functions - and yes, the connection= object is passed by ref=2E), and ensured that the connections are= actually reporting they are closed (via SqlConnection=2EState)= both inside and outside the function that closes them=2E I'm all out of ideas now=2E Any suggestions would be greatly= appreciated=2E -------------------------------- From: Rory Smith ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>gdTZqEcYx0eoUbAQReEUNQ=3D=3D</Id> Tag: Binding a DataRelation to a Datagrid?? Tag: 107956
  - 25
    - XML Schema (XSD) and ADO.net DataSet - limitations mapping between them The following valid XSD schema can NOT be successfully read by the ReadXMLSchema method of the DataSet object - it errors out with a "NonEmptyString not defined" error. This schema is more complex than a plain vanilla schema, but doesn't strike me as obscenely complex. Are there general rules for what can an can not be mapped between any XSD schema & a .net DataSet? Thanks <?xml version="1.0" encoding="UTF-8" standalone="yes"?> -- edited with XMLSpy v2005 rel. 3 U (http://www.altova.com) by Wheels Inc (Wheels Inc) -->  <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xs:element name="CollisionTemplateA1"> <xs:complexType> <xs:sequence> <xs:element ref="FullName"/> <xs:element ref="Hometown"/> <xs:element ref="Province"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="FullName"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" fixed="/LR/Deeper/IsDriverInsane"/> <xs:attribute name="conditional" fixed="yes"/> <xs:attribute name="source1" fixed="/LR/Deeper/Name"/> <xs:attribute name="source2" fixed="/LR/Name"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:element name="Hometown"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" type="xs:string" fixed="/LR/City"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:element name="Province"> <xs:complexType> <xs:simpleContent> <xs:extension base="NonEmptyString"> <xs:attribute name="from" type="xs:string" fixed="/LR/State"/> </xs:extension> </xs:simpleContent> </xs:complexType> </xs:element> <xs:simpleType name="NonEmptyString"> <xs:restriction base="xs:string"> <xs:minLength value="1"/> </xs:restriction> </xs:simpleType> </xs:schema> Tag: Binding a DataRelation to a Datagrid?? Tag: 107953

Hi,

I'm trying to bind a datarelation to a datagrid so that I'll show all the
columns from the first and second datatables that relate (parent/child).

The code below only shows the data from the master table? How do I include
the children? I'm having trouble find docs on this.

dst.Relations.Add("ArticleCompany", dst.Tables["Article"].Columns["CoId"],
dst.Tables["Company"].Columns["CoId"],false);

DataGrid1.DataSource = dst.Tables["Article"].DefaultView;
DataGrid1.DataMember = "ArticleCompany";
DataGrid1.DataBind();

Top

Re: Binding a DataRelation to a Datagrid?? by Val

Val
Tue Apr 05 19:11:25 CDT 2005

Hi,

Check next KB with an example

http://support.microsoft.com/default.aspx?scid=kb;en-us;308052

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

"Dave" <Dave@discussions.microsoft.com> wrote in message
news:630E64D5-75E3-48D0-A522-7481D2F14BC3@microsoft.com...
> Hi,
>
> I'm trying to bind a datarelation to a datagrid so that I'll show all the
> columns from the first and second datatables that relate (parent/child).
>
> The code below only shows the data from the master table? How do I include
> the children? I'm having trouble find docs on this.
>
> dst.Relations.Add("ArticleCompany", dst.Tables["Article"].Columns["CoId"],
> dst.Tables["Company"].Columns["CoId"],false);
>
> DataGrid1.DataSource = dst.Tables["Article"].DefaultView;
> DataGrid1.DataMember = "ArticleCompany";
> DataGrid1.DataBind();

Top