Datagrid SortCommand does not work ???

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
    - Error Message: Timeout expired. Hello there, I have about 50 users who use an asp.net application i made. For a while there were no problems but now i see a lot of timeout expired messages i diiferent forms of my application. See the stack trace below: What can i do to avoid this? Thnx in advance, Victor Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Page Error Occured: /webgabprod/Administration/administration.aspx ExceptionType: System.Data.SqlClient.SqlException Stack trace: 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 WebGab.WebForm1.GetAanvragen() at WebGab.WebForm1.btn_zoek_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() Tag: Datagrid SortCommand does not work ??? Tag: 100251
  - 2
    - concurrency violation with bound control Hi. I'm sorry if this is a repost. Please reply with existing links, if any. I have a list box with a datatable as data source. I edit an item from the list box (by changing the item in the datatable) and call the update method() of a data adapter. My problem is I get a concurrency violation saying no rows were affected. Tag: Datagrid SortCommand does not work ??? Tag: 100241
  - 3
    - DataTable.LoadDataRow - can you improve on this? DataTable is dt, filled already and with keys defined, uid, seq etc, suitable variables ... object[] newRow = new object[5]; newRow[0] = uid; newRow[1] = seq; newRow[2] = text; newRow[3] = type; newRow[4] = data; dt.LoadDataRow(newRow,false); >>>> I don't like this because it relies on the column positions - of course I could use an enumeration for readability but that wouldn't remove the underlying problem >>>> I can create a detached row with thr right schema DataRow newRow = dt.NewRow(); >>>> and then fill the columns by name .... newRow["uid"] = uid; newRow["seq"] = seq; >>>> which is great, but then there is no overloaded method for .LoadDataRow, which allows me to load that data ... any suggestions for achieving the required effect - loading data without hardwiring the column positions? Cheers Jim Tag: Datagrid SortCommand does not work ??? Tag: 100239
  - 4
    - ado vs oledb Hi, I use to program using VB + ADO with MS Access. however, i've read that oledb is faster and better then ADO to access to DB. could you tell me in which wqy is it faster ? what i've seen till now, it's that i need 3 times more code lines to do the same thing. thanks a lot, PM Tag: Datagrid SortCommand does not work ??? Tag: 100230
  - 5
    - Using DSN in connection string with SqlConnection Object I want to use DSN in Connection string. But for opening connection i am using 'SqlConnection' object. i.e using System.Data.SqlClient; So is it possible to use DSN in connection string with 'SqlConnection' object. OR i should go only for 'OdbcConnection'. Tag: Datagrid SortCommand does not work ??? Tag: 100229
  - 6
    - best way to retrieve thousands of records. I have currently using a dataset to access my data from sql server 2000. The dataset contains 3 tables that is related to each other. parent/child/grandchild relationship. My problem is it's very slow to retrieve records from sql server. I'm using sqldataadapter.fill method to populate dataset. Parent table contains more than 3,000 records and child table contains more than 10,000 records and grandchild table contains more than 90,000 records as of now. I tried to limit the number of records to return by a select command using the criteria but my problem is I dont know how to limit the number of records return by a 3rd table (grandchild). I'm using textboxes in parent table and datagrid in 2nd and 3rd table. There is no problem querying the 1st and 2nd table but I don't know how to query the 3rd table. 3rd table must know first the primary key value of the 2nd table that is stored in a datagrid. but don't know how to do this. Anyone know what is the better way to access this data? I would love to read some article about techniques on accessing table that has a relationship up to 3rd table (grandchild). thanks in advance. Tag: Datagrid SortCommand does not work ??? Tag: 100222
  - 7
    - Is there any way to know if a connection is in a transaction? Greets. A very simple question in the topic, probably takes about 10 seconds for an expert to answer =) Thanks .. Tag: Datagrid SortCommand does not work ??? Tag: 100217
  - 8
    - DataGridView error Hi, i have DataGridView whose sourse i set to a datatable with 5 columns containing data. i then remove the 3rd column, created a DataGridViewComboBoxColumn, set it's DataSource, ValueMember and DisplayMember. the Valumeber is an integer and the displaymember is a string. I then instert this into the same location as the column that was removed. the problem i am getting is when the Grid is loaded, i get errors stating "System.FormatException: the value of the DataGridViewComboBoxCell is invalid. To replace this default dialog, please handle the DataError event.". Why is this error happening? here is the code that does the replacing and adding of a combo box: private void addExchangeLookUpCombs( DataGridView dt ) { dt.Columns.Remove( "exchange_id" ); DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn( ); cb.DataSource = DbConnection.instance.getDbTable("StockExchange"); cb.ValueMember = "exchange_id"; cb.DisplayMember = "symbol"; cb.FlatStyle = FlatStyle.Flat; dt.Columns.Insert( 2, cb ); } Tag: Datagrid SortCommand does not work ??? Tag: 100215
  - 9
    - RowState Question Hi folks, I'm reading through David Sceppa's excellent ADO.NET book, trying to teach myself ADO.NET, and have a question about the RowState property. If I add a new row to a DataTable, it has a RowState of 'Added'. If I modify an existing row, its RowState is 'Modified'. If I add a row, but before I call AcceptChanges I modify that row, is it still 'Added'? I guess it has to be ... but what happens to the data I first entered into the row that I might have overwritten with the subsequent edit? Just trying to get a handle on how this stuff fits together :) Cheers, Matt Tag: Datagrid SortCommand does not work ??? Tag: 100209
  - 10
    - RowState Undelete? A row was deleted in a DataTable, and now I want to bring it back so I can remove it (so my dataadapter will not touch it later). How can I do that? Thanks. replaceExisting Tag: Datagrid SortCommand does not work ??? Tag: 100201
  - 11
    - OracleDataReader returning no rows or data even though data exists Hi All, I am trying to get result from Oracle Function that returns a number. When I rum from SQL Plus I could see the result. When I call from my C# application I get no data. I am using System.data.OracleClient to access oracle function on Database 8.1.7. I am using Oracle 9i client from my application to connect to 8.1.7 Database. I am able to get results if i use query like select * from table name. I have paseted my code and Oracle function below. I would really appreciate any help As I have spent couple of days trying to get it work. //Oracle Function create function test_func return number as begin return 5; end; C# code StringBuilder commandText = new StringBuilder("TEST_FUNC"); string str = "Data Source=EXP_DUP;User Id=test;Password=tst;Integrated Security=no;" ; System.Data.OracleClient.OracleConnection Conn = new OracleConnection(str); OracleCommand DSCmd = new OracleCommand(commandText.ToString(),Conn); Conn.Open(); DSCmd.CommandType = CommandType.StoredProcedure; //Set OUT parameter direction DSCmd.Parameters.Add("RC", OracleType.Number).Direction = ParameterDirection.ReturnValue; try { OracleDataReader dataReader = DSCmd.ExecuteReader(); if( dataReader.HasRows) { while (dataReader.Read()) { System.Windows.Forms.MessageBox.Show(dataReader.GetString(0).ToString()); } } dataReader.Close(); } catch( Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } Please any suggestions on how to achieve this or what am I missing. Thanks in Advance, MS Tag: Datagrid SortCommand does not work ??? Tag: 100199
  - 12
    - How can I format date in databound combobox in windows app? Hi, I have a combobox bound to a smalldatetime column in a table. The ComboBox displays all available dates. However it displays them in long format and I want to display them in short format. Is this possible? Tag: Datagrid SortCommand does not work ??? Tag: 100196
  - 13
    - Displaying dates in dd/mm/yy format I have two Date/Time fields in my Access 2003 database. The VB.NET app I'm developing (and making some real progress with) uses TextBoxes to input these as part of a record in a DataSet. Problem: Access always stores years as 4 digits, and it automatically tags a time onto the field, so when the user enters: 30/11/04 I end up with: 30/11/2004 00:00:00 when I view the record after it's created; the DataSet is populated using the database schema. Since the TextBox is set to display only 8 characters, this is annoying at best. The only way I can think of around this is to store the date as a string and write a validation handler for each TextBox that inputs dates. But is there a better way? Can I somehow force Access to store the short date and nothing else? Tag: Datagrid SortCommand does not work ??? Tag: 100193
  - 14
    - Very simple INSERT INTO with a DateTime parameter -> "Syntax Error in INSERT INTO statement" Hello. The following very simple code does not seem to accept the DateTime variable as a parameter - why? The table (MS Access db) here contains only a primary key and a column Date of type date/time. connection.Open(); transaction = connection.BeginTransaction(); commandString = "INSERT INTO [Events] (Date) Values(@Date)"; command = connection.CreateCommand(); command.CommandText = commandString; command.Transaction = transaction; OleDbParameter param_Date = new OleDbParameter("@Date", OleDbType.DBTimeStamp); // Also tried DBTime and DBDate param_Date.Value = date; // date == DateTime command.Parameters.Add(param_Date); // Execute command command.ExecuteNonQuery(); // Syntax error in INSERT INTO statement??? Tag: Datagrid SortCommand does not work ??? Tag: 100189
  - 15
    - Read-only transaction in Oracle Hello All; Does anybody know any way to start read-only Oracle transaction in .NET application? This mode can be set in PL/SQL by SET TRANSACTION READ ONLY statement, but Oracle provider for .NET does not support such isolation level. Thank you, Maxim Tag: Datagrid SortCommand does not work ??? Tag: 100187
  - 16
    - Add Raw DataRow Collection? I have a remote DataTable and I want to add 5 DataRows to it. My current code does a "remoteTable.Rows.Add( new object[] { .... } );". That results in 5 remote calls, which is bad. I already know the schema of the remote DataTable. Is it possible to create a DataRow collection, populate all 5 rows, and then send than entire collection to the DataTable? Thanks. Tag: Datagrid SortCommand does not work ??? Tag: 100177
  - 17
    - mapping 2 datatable columns to one datagrid column Is this possible? I want to concatenate two columns in my table and display them in one datagrid column. I have a TableStyle where I create DataGridColumnStyle's. I'd like to set the MappingName to two columns but I dont see how this can be done. Thanks. Tag: Datagrid SortCommand does not work ??? Tag: 100175
  - 18
    - Use of undocumented sp_MSforeachtable and MStablespace What is wrong with the following code? What I want to do is to store the results of MStablespace for every table in a DataTable. The result contains the number of rows and the data space and the index space. This seems to be okay, because dataTable has three columns after executing the code. The problem is, that I get only one row. using ( SqlConnection conn = new SqlConnection(connString) { conn.Open(); SqlCommand cmd = new SqlCommand("sp_MSforeachtable", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@command1","exec sp_MStablespace '?'"); SqlDataAdapter adapter = new SqlDataAdapter( cmd ); DataTable dataTable = new DataTable("Statistics"); adapter.Fill(dataTable); } Thanks for any hints, Hans Tag: Datagrid SortCommand does not work ??? Tag: 100169
  - 19
    - question for the minds This is what should be an easy question, but I can't get it through my head. Can someone help me undestand the following? The way I see it, .DataSource is whatever you decide to refer back to thel the Datalist in my case it is an array: System.Collections.ArrayList al = new ArrayList(); DropDownLIst1.DataBind(); is the call that I have to bind my fields that is an easy one, but for the life of me I DON'T GET: DropDownList1.DataTextField="Name"; DropDownList1.DataValueField="ID"; It doesn't make sense to me what the difference is for DataTExtField and DataValueField. It seems that it doesn't matter one way or another, can someone help me understand? Provided below are all of the items but my question only lies in the ones marked Q: DropDownList1.DataSource=al; Question: DropDownList1.DataTextField="Name"; Question: DropDownList1.DataValueField="ID"; DropDownList1.DataBind(); Tag: Datagrid SortCommand does not work ??? Tag: 100167
  - 20
    - [BUG?] (2) Update database using stored procedure and OleDbDataAdapter.Update As suggested by Cor Ligthert, i've created a simpler sample, with the same problem; this is the full source code, so everyone can try itself: Access database "dati.mdb": Tables: "myTable" Fields: fNumber Numeric fString VarChar(50) No primary keys defined. Stored Procedures: "qry_Ins": PARAMETERS [@fNumber] Long, [@fString] Text ( 255 ); INSERT INTO myTable ( fNumber, fString ) VALUES ([@fNumber], [@fString]); C# Project: Only 1 WebForm (WebForm1.aspx) ////////////////////////////////////////// // Code Start ////////////////////////////////////////// private void Page_Load(object sender, System.EventArgs e) { OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("dati.mdb") + ";"); conn.Open(); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM myTable", conn); DataSet ds = new DataSet(); // The table is initially empty so ds has no rows da.Fill(ds, "myTable"); OleDbCommand upCmd = new OleDbCommand("qry_Ins", conn); upCmd.CommandType = CommandType.StoredProcedure; upCmd.Parameters.Add("@fNumber", OleDbType.Integer, 0, "fNumber"); upCmd.Parameters.Add("@fString", OleDbType.VarChar, 50, "fString"); da.InsertCommand = upCmd; int i = 1; while (i<=20) { ds.Tables["myTable"].Rows.Add(new object[] {i, "data_" + i}); i++; } da.Update(ds, "myTable"); conn.Close(); conn = null; } ////////////////////////////////////////// // Code End ////////////////////////////////////////// This is the output in the database after 1 execution of the above code: fNumber fString 1 data_1 1 data_2 1 data_3 1 data_4 1 data_5 1 data_6 1 data_7 1 data_8 1 data_9 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_1 1 data_2 As visible, fNumber is always 1, and fString is truncated to 6 chars. So, how to fix? It's a BUG??? Tag: Datagrid SortCommand does not work ??? Tag: 100163
  - 21
    - newbie question. Hello, I have backed up a table from a database in an DataTable (dt ) object. The table has been wiped up (in sql server) after the backup but i still have the copy in memory (in my DataTable object ). now i need to restore the table from memory. Is there a quick way of doing this apart from a row by row insert? I'm not using typed dataset. Many thanks in advance JB Tag: Datagrid SortCommand does not work ??? Tag: 100162
  - 22
    - XML Dataset I have a dataset that is based on an xml file, which contains the same structure as a sql server table and is exported from a dataset. When I do: sqlDataAdapter.Update(dataset, strTableName) I get the error: "Missing the DataColumn 'InspectionDate' in the DataTable 'tblEquipmentInspections' for the SourceColumn 'InspectionDate' The reason the column InspectionDate is missing is beacuse its a null value and when you export a dataset to xml in dot net it doesn't create an entry for any null columns in the xml. I'm guessing I need to do something with table mappings but I'm not sure where to go. Any ideas ? Many thanks Séan Tag: Datagrid SortCommand does not work ??? Tag: 100161
  - 23
    - Annoying Bug with parent-child-grandchild relationships. Tables: Parent, Child, Toys Relationships: ParentToChildRel, ChildToToysRel. dataGridParent.Datamember="Parent"; dataGridChild.Datamember="Parent.ParentToChildRel"; dataGridToys.Datamember="Parent.ParentToChild.ChildToToysRel"; all grids pointing to same datasource. the flaw is that when a move to a parent, whose child has no toys but the previous one had, datagridToys still shows the toys of the previous one instead of none. I think this is a bug, because it should display none. Tag: Datagrid SortCommand does not work ??? Tag: 100156
  - 24
    - how to move record forward or backward hi all I have got a datareader by sqlcommand, now I wanna move forward or backward, but I don't find first,last,prior and next methods. How can I do it? thanks for your suggestion. hui Tag: Datagrid SortCommand does not work ??? Tag: 100150
  - 25
    - ExecuteScalar intermittently returns "0" Hello all I have an interesting problem which is causing me to lose sleep. I have a vb.net app in use by approximately 100 people on a daily basis. This app is mission critical for the business. I'm using windows server 2003 for the web front end, SQL server 2k for the backend, and a mixture of winXP and w2k PCs as clients. The app works 100% except for one strange behavior: Once in approximately 300 instances, one of my sql insert statements fail - I'm using a stored procedure to insert a record in the SQL DB. I process / verify the data on the front end to ensure nulls, empty values, and data types are handled correctly. The exact failure is my connection.executescalar() function returns "0". Regardless of how many times I resubmit the failing request, the function returns 0 (which rules out locking issues). I have no connectivity problems between the DB, web server, and the clients (pings are always solid). Now here is the strange part. If I close the internet explorer window, reopen IE and give the SAME input, the function will return the @@identity like it should. I am using sessions but I've verified the particular session value which is inserted using this function is intact when the 0 is returned (by writing just that session value to another table). I'm not sure posting code would help given the parameters of this problem. Has anyone heard of this before?? Help Please! Tag: Datagrid SortCommand does not work ??? Tag: 100147
- Next
  - 1
    - Aborting a thread corrupts my SqlConnection (?) Hi, I'm running a long query in a separate thread. If I abort that thread and then I try to use the same connection string again, I get an unexpected result. Details: the aborted thread runs a query that returns a resultset, using a DataAdapter. the query run afterwards is: INSERT INTO Report_selection_ids DEFAULT VALUES; SELECT SCOPE_IDENTITY() which usually returns an integer, but if executed after the resultset query thread was killed, it returns what seems to be the 1st field of the 1st record of the recordset, which happens to be a string. I've seen posts on a similar problem in framework 1.0, which was supposed to be fixed long ago. I'm using framework 1.1 (no SP - is there one?) thx Uri Tag: Datagrid SortCommand does not work ??? Tag: 100146
  - 2
    - how to move hi guys I have got a datareader, now I wanna get last record or locate any record by some integer step. How can I do it? thanks hui Tag: Datagrid SortCommand does not work ??? Tag: 100145
  - 3
    - how to move hi guys I have got a datareader, now I wanna get last record or locate any record by some integer step. How can I do it? thanks hui Tag: Datagrid SortCommand does not work ??? Tag: 100144
  - 4
    - alter table structure using FillSchema Hi All, using FillSchema() method of an dataadapter can I alter a table on sql server? instead of using "alter table alter column..." strings I'll use getSchemaTable modify columns I need and then use FillSchema to submit changes to the server... Thanks, Daniel Tag: Datagrid SortCommand does not work ??? Tag: 100142
  - 5
    - data adapter update using datatable that has MANY changes Hi. I magine that I have a listbox that is bound to a data table. This means that there is the possiblity that the data table will have new rows, edited rows, and/or deleted rows. After everything is done, I would like, at the push of a button, to update the database with the change(s) made to the data table via the data adapter's update() method. However, when I call the update() method, I get an exception error telling me that the InsertCommand, UpdateCommand, or DeleteComand has not been set. My problem is, if I set the said properties, I do not have the necessary values to pass to the commands (e.g. values for new rows). How do I do this all at once? Thank you Tag: Datagrid SortCommand does not work ??? Tag: 100139
  - 6
    - Using OleDbConnection to retrieve OLAP schema information Hi, I'm trying to use OleDb (ado.net) to retrieve olap member information from analysis services. I use the following code: OleDbConnection conn = new OleDbConnection("provider=msolap.2;datasource=myserver;database=foodmart 2000"); conn.Open(); DataTable t = conn.GetOleDbSchemaTable(new Guid("c8b522de-5cf3-11ce-ade5-00aa0044773d"), new object[] {null, null, "Sales"}); This returns a DataTable with all members in FoodMart 2000's Sales cube. Now, instead of getting all the members in the cube, I was to restrict the results so I get only the members with a specific value in the PARENT_UNIQUE_NAME column (column index = 15). I tried doing it like so: DataTable t = conn.GetOleDbSchemaTable(new Guid("c8b522de-5cf3-11ce-ade5-00aa0044773d"), new object[] {null, null, "sales", null, null, null, null, null, null, null, null, null, null, null, null, "[Customers].[All Customers].[Canada].[BC]"}); But an exception is thrown will the following obscure message: "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll" Can anyone help? Thanks. Tag: Datagrid SortCommand does not work ??? Tag: 100138
  - 7
    - Removing rows from a DataTable is VERY slow I'm using a DataTable to hold a selection of rows (100,000+) from a large database table (1,000,000+ rows). At times I want to remove rows that aren't used anymore from the DataTable to save memory. But my tests shows that it takes very long time to remove the rows. Running the code below on a Pentium 2.4 Ghz under Windows XP reports that it takes 187ms to add 100,000 rows, but 32s (seconds, that is!) to remove half of them. Can anybody tell me what I'm doing wrong or an alternative, faster way to do this? // Create table with one int column DataTable table = new DataTable(); table.Columns.Add( new DataColumn( "Col1", typeof(int) ) ); // Add a number of rows to the table int ticks = Environment.TickCount; for (int i = 0; i < 100000; i++) { table.Rows.Add(new object[] {i}); } int elapsed = Environment.TickCount - ticks; MessageBox.Show("Added " + table.Rows.Count + " rows in " + elapsed + " ms."); // Create a list of rows to remove (half of those in table) ArrayList rowsToRemove = new ArrayList(table.Rows.Count/2); for (int i = 0; i < table.Rows.Count; i++) { if ((i % 2) == 0) rowsToRemove.Add(table.Rows[i]); } // Remove the rows from the table ticks = Environment.TickCount; for (int i = 0; i < rowsToRemove.Count; i++) { table.Rows.Remove((DataRow)rowsToRemove[i]); } elapsed = Environment.TickCount - ticks; MessageBox.Show("Removed " + rowsToRemove.Count + " rows in " + elapsed + " ms."); Grateful for any help on this, Markus Hjarne Tag: Datagrid SortCommand does not work ??? Tag: 100133
  - 8
    - How to refresh Currencymanager that is pointing to deleted rows. Hi, I get a RowNotInTableException while accesing a row that has been deleted and refetched from the database. How can I refresh the currencymanager to point to the correct row. Thanks, Debi. Tag: Datagrid SortCommand does not work ??? Tag: 100130
  - 9
    - SQLDataReader My application is using the SQLDataReader to retreive and itereate thru rows of data from SQL Server, then for each row of that SQLDataReader, selects related rows from another table via yet another SQLDataReader. When I finish with a row, I do a SQLDataReader.Close and set it to nothing, but my .NET Memory Profiler shows that the instances of the SQLDataReaders are never being disposed. Am I missing something? Thanks, Michael Tag: Datagrid SortCommand does not work ??? Tag: 100121
  - 10
    - te Tag: Datagrid SortCommand does not work ??? Tag: 100115
  - 11
    - Specifying format of DateTime columns read from CSV files Hi, I am reading a CSV file into a DataTable with the following code : internal static DataTable ReadFromCSVFile( string csvFileName ) { if ( !File.Exists( csvFileName ) ) { throw new ApplicationException( " Cannot find CSV file : \"" + csvFileName + "\"." ); } string csvPath = Path.GetDirectoryName( csvFileName ); OleDbConnection connection = new OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + csvPath + ";" + "Extended Properties=\"Text;HDR=Yes\"" ); return ReadDataTable( connection, Path.GetFileName(csvFileName) ); } private static DataTable ReadDataTable( OleDbConnection connection, string tableName ) { connection.Open(); try { // Read all data into a data table. OleDbDataAdapter adapter = new OleDbDataAdapter( "SELECT * FROM [" + tableName + "]", connection ); DataTable dataTable = new System.Data.DataTable( tableName ); adapter.Fill( dataTable ); return dataTable; } finally { connection.Close(); } } How do I specify the format of columns containing DateTime values ? If my CSV file contains the following : Ints,Doubles,Dates1,Dates2 34,34.5,01/02/2003,12:43:00 p.m.,01/02/2003 Then the "Dates2" column in the DataTables is of type DateTime, but the "Dates1" column is of type string. Thanks in advance, Joel Gordon. Tag: Datagrid SortCommand does not work ??? Tag: 100114
  - 12
    - Converting array formula to work with datatables/dataset tia sal Greets, All Converting array formula to work with datatables/dataset tia sal I finally completed a formula I was working on, see working code below. I would like to change this code so it will work with a variable mutl- row, 5 column datatable where the users select items. Anyone have any suggestions on where to start? Or changes in the current code that might be made. Private Sub Arraylooptest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Arraylooptest.Click Dim arraya() As Integer = {15, 17, 20, 25} 'variable numbers users can change Dim arrayb() As Integer Dim arrayc() As Integer Dim i, k As Integer, total As String Dim v As Object ReDim arrayb(arraya.GetUpperBound(0) - 1) arrayb(0) = arraya(0) + arraya(1) Console.WriteLine("Numbers used ") For Each v In arraya Console.WriteLine((v)) Next Console.WriteLine(String.Format("a(0)->({0}) + a(1)->({1})= b (0)->({2})", arraya(0), arraya(1), arrayb(0))) For i = 1 To arraya.GetUpperBound(0) - 1 Console.WriteLine(String.Format("b({0})->({1}) + a({2})-> ({3})= b({4})->({5})", i - 1, arrayb(i - 1), (i + 1), arraya(i + 1), i, arrayb(i - 1) + arraya(i + 1))) arrayb(i) = arrayb(i - 1) + arraya(i + 1) Next ReDim arrayc(arrayb.GetUpperBound(0) - 1) 'If statement to break if only two elements selected If (arrayc.Length) = 0 Then MessageBox.Show("only two elements use your calculator :-)") Exit Sub Else End If arrayc(0) = arrayb(0) + arrayb(1) Console.WriteLine("==Loop of Sums==") Console.WriteLine(String.Format("b({0})->({1}) + b({2})->({3})= c ({4})->({5})", 0, arrayb(0), 1, arrayb(1), 0, arrayb(0) + arrayb(1))) For k = 1 To arrayb.GetUpperBound(0) - 1 arrayc(k) = arrayc(k - 1) + arrayb(k + 1) Console.WriteLine(String.Format("c({0})->({1}) + b({2})-> ({3})= c({4})->({5})", k - 1, arrayc(k - 1), k + 1, arrayb(k + 1), k, arrayc(k))) Next ReDim Preserve arrayc(k) 'Show overall answer or puts answer in next open array slot If k = 1 Then Exit Sub Else arrayc(k) = arrayc(k - 2) + arrayc(k - 1) Console.WriteLine(String.Format("c({0})->({1}) + c({2})-> ({3})= c({4})->({5})", k - 2, arrayc(k - 2), k - 1, arrayc(k - 1), k, arrayc(k))) End If End Sub This is the output Numbers used 15 17 20 25 a(0)->(15) + a(1)->(17)= b(0)->(32) b(0)->(32) + a(2)->(20)= b(1)->(52) b(1)->(52) + a(3)->(25)= b(2)->(77) ==Loop of Sums== b(0)->(32) + b(1)->(52)= c(0)->(84) c(0)->(84) + b(2)->(77)= c(1)->(161) c(0)->(84) + c(1)->(161)= c(2)->(245) PS. Thanks to everyone who got me this far. I sure have learned alot. TIA Tag: Datagrid SortCommand does not work ??? Tag: 100113
  - 13
    - DataSet Memory Usage I'm working with a large ADO.Net DataSet and my application uses quite a bit of memory. According to the memory profiler I am using, there are about 120,000 DataRows, and they take up about 5 Megabytes. These DataRows are contained in a total of about 70 tables. However in addition there are about 8,000 int32[] array objects that all together take up about 50 Megabytes. I think that most of these are instantiated from within the System.Data namespace. My application inserts, deletes or modifies about 10 percent of the DataRows. It also uses DataViews and sorting. Is this a known problem of some kind? Tag: Datagrid SortCommand does not work ??? Tag: 100110
  - 14
    - date cell in Excel is null Hi. I hope somebody can help me. I am trying to read an excel file via ADO.NET. I have tried using a datareader and filled datatable (by oledbadapter). My problem is that some cells with date format are being returned as null. Can anybody offer some explanation and solution? I am trying to avoid using automation (creating an excel process instance). With it though, I have no problem reading the data... Thank you. Tag: Datagrid SortCommand does not work ??? Tag: 100109
  - 15
    - Using Datarow as Tag for Treenode Hi, I've set the tag for a node as a datarow. When the user moves the node, I update the underlying datatable to reflect the change - I remove that row from the datatable and do a fetch again. On the tree I'm cloning the node to move it to the new position - that, as I've understood duplicates the tag too. So after fetching the new data, I set the tag again by finding the row in the table using the primary key. But when I select that node again, I get a "RowNotInTableException". I was thinking that the datarow does not point to the table, even if it does, I have updated the table and set the tag again. Can anyone give me pointers on what to do now. Thanks, Debi. ********************************************************** Private sub Tree_afterselect........ Dim drTreeTag As DataRow CurrTreeNode = tvSchedule.SelectedNode drTreeTag = CurrTreeNode.Tag ******This line gives error for drtreetag.item(0)********* CurrMgrForm.Position = dsAssignMaster.Tables("AssignMaster").DefaultView.Find(drTreeTag.Item(0)) ************************************************************ This is while reloading data TreeDetailMgr.Position = dsAssignMaster.Tables("TreeDetails").DefaultView.Find(sAssignid) CurrTreeNode.Tag = dsAssignMaster.Tables("TreeDetails").Rows(TreeDetailMgr.Position ************************************************************ Tag: Datagrid SortCommand does not work ??? Tag: 100105
  - 16
    - I can't fill a required field in a record Add (before EndEdit) I have a required field in my db table. I am filling a table with a NEW row via a form with bound textboxes. I get a particular required field ( a foreign key) from another source. When I get ready to update my table I do an "EndEdit" and it detects that I have not yet filled the required field...and I error out. So I try to force the field value into the table BEFORE the "EndEdit", referencing Row(0), but I error out with an error that points out that I don't HAVE a Row(0) yet! So how do I fill in a required field in a new record BEFORE I get to the EndEdit? I have been able to do it with "0 x 0" textboxes, but this seems very bad form, right? ??????????? TIA, Larry Woods Tag: Datagrid SortCommand does not work ??? Tag: 100101
  - 17
    - Evaluating Reporting Tools for .NET I am currently doing some research on reporting features provided / compatible with dotnet features. Our current application has excel reprots that are emailed both with an without scheduling through a web front end that uses coldfusion as well as asp. There are custom vb compnents that generate the data as well as stored procs on a sql 2k servers that produce the data. The requirement is for excel reports and pdf reports, web viewing if possible that are data concentric with totals, subtotals and formatting with header and footers. There is no need for any kind of charts. However, i think it is imperative scheduling and on the fly report generation is possible. Currenly as reports are emailed the user cannnot really change the report in any way. We will use ADO for access and ODBC is not being used. Web controls should be highly desireable for client to request and view reports on the web . I haev come across the following products. - SQL Reporting Services - Actuate - ActiveReports - Crystal Reports - AESPOSE.Excel The three main ones that stand out are crystal reports .net , sql reporting services and active reports. Seems as though people are complaining about the high maintenance as well as overhead for the Crystal Reports. On the other hand i also read the Active reports does not have an extensive API and provides buggy features with a poor GUI. I couldn't much feedback on SQL reporting services but it seemed to be pretty simple database server concentric. I would really appreciate it if someone can point me in the right direction and give me some feedback. - Mohammad S Khan mskhanis@hotmail.com Tag: Datagrid SortCommand does not work ??? Tag: 100100
  - 18
    - How to write a custom data adapter Hi, How to write a custom data adapter to retrieve value from legacy database(image database on HP Mainframe). Any help on this will be appriciated.. Thank you Vinay Tag: Datagrid SortCommand does not work ??? Tag: 100095
  - 19
    - Problem copying datatable-long post Sorry for posting a long post, (the code) but, I am having a problem copying one data table to another new table in another Access database that has the same table schema. You will notice that I do not list exact column names etc. because this routine needs to be generic so I can use it to copy different tables into new tables and each one has different Column Names, Types and Field sizes. There is only a few constants between all tables and those I have a special routine that looks for those (by looking at the Column Names) and sets the data type for those special fields to correspond to the types in the new table. The original data table(s) come from CSV files and do not contain any schema info as CSV does not pass that info to the file for import. Access treats everything in a CSV file as a String and sets the default field size to 255. Therefore, I am doing the conversion on the fly. Here's the code: Private Sub btnAddData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddData.Click 'table name from database loaded Dim mytbl As String With OpenFileDialog1 .Filter = "Access Database(*.mdb)|*.mdb" End With OpenFileDialog1.ShowDialog() 'this opens the new EMPTY database with a new "pre-built" datatable Dim myconnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" + OpenFileDialog1.FileName + ";Mode=ReadWrite" Dim myconn As New OleDb.OleDbConnection(myconnString) myconn.Open() 'gets tablename from database table schema Dim schematable As DataTable = myconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) Dim dr As DataRow ' cheezy but, I needed to get the table name so just slightly modified another routine For Each dr In schematable.Rows mytbl = dr("TABLE_NAME").ToString() TextBox2.Text = mytbl Next Dim objcommand As New OleDb.OleDbCommand("SELECT * FROM [" & mytbl & "]", myconn) Dim objda As New OleDb.OleDbDataAdapter 'objda.InsertCommand = New OleDbCommand("INSERT INTO mytbl(myfield) VALUES(myvalue)", myconn) objda.SelectCommand = objcommand Dim objds As New DataSet objda.Fill(objds, mytbl) DataGrid2.DataSource = objds.Tables(mytbl).DefaultView ' not using binding manger--- yet bmb = Me.BindingContext(Me.DataGrid2.DataSource, Me.DataGrid2.DataMember) myconn.Close() 'below is routine to copy data and insert it into the new database's new table Dim x As Integer Dim i As Integer Dim j As Integer Dim col As Integer Dim myfield As String Dim myvalue As Object Dim rc As DataRowCollection Dim myrow As DataRow roc = objDataset1.Tables(0).Rows.Count - 1 For x = 0 To roc 'For i = 0 To objDataset1.Tables(0).Rows.Count - 1 For j = 0 To objDataset1.Tables(0).Columns.Count - 1 'myvalue = "" 'myfield = "" myrow = objds.Tables(mytbl).NewRow() myfield = objDataset1.Tables(0).Columns(j).ColumnName Dim cellvalue As Object = Me.DataGrid1(x, j) myvalue = cellvalue 'this routine makes sure the each data's type is correct, Integer,string etc. Select Case myfield Case myfield = "RECNUM" myvalue = CType(myvalue, Integer) Case myfield = "RECORDID" myvalue = CType(myvalue, Integer) Case myfield = "REFID" myvalue = CType(myvalue, Integer) Case myfield = "CLIENTID" myvalue = CType(myvalue, Integer) Case myfield <> "" myvalue = CType(myvalue, String) Case Else myvalue = myvalue End Select myrow(myfield) = myvalue Next ' counts records being proccessed........ Label8.Text = "Proccessing: " & x + 1.ToString ' adds each new row to the new table objds.Tables(mytbl).Rows.Add(myrow) 'Have tried both these insert commands,,,,,,,,don't work will not add new rows 'objda.InsertCommand = New OleDbCommand("INSERT INTO mytbl(myfield) VALUES(myvalue)", myconn) 'objda.InsertCommand = New OleDbCommand("INSERT INTO mytbl(myrow)", myconn) ' Dim objcommandbuilder As New OleDbCommandBuilder(objda) Application.DoEvents() ' stops the openfile dialog from freezing until proccessing is finished Try myconn.Open() objds.AcceptChanges() 'tells dataset to accept changes- NOT objda.Fill(objds, mytbl) 'fills the table with the new data-NOT Dim objcommandbuilder As New OleDbCommandBuilder(objda) objda.Update(objds, mytbl) myconn.Close() DataGrid2.Refresh() Catch oledbe As OleDbException MsgBox("ERROR" & oledbe.ToString) End Try Next Dim ct As Integer ct = objds.Tables(mytbl).Rows.Count ' ends up being empty (Null) in each row MessageBox.Show("RECORDS ADDED: " & ct) Label8.Text = "TOTAL RECORDS ADDED: " & ct End Sub Several things I have tried are commented out. But, left in the code just in case I was on the right track and had just missed a couple of things. As can be seen, (hopefully) I have tried building INSERT commands to insert the data into the new table and that does not work. (not for me) And I have tried to Copy the entire table from the original to the new table, and that does not work. Which might be because the original table contains all strings with field sizes of 255. Anyway, if you have read this far and haven't decided I am nuts, I am open to suggestions on how to make this work. james Tag: Datagrid SortCommand does not work ??? Tag: 100094
  - 20
    - Storing passwords in database I am using SQL Server as the database for my ASP.NET app. I have a users table with a password field. What is the best way to encrypt it before it goes into the table, then decrypt it to read the value? Any sample code or links would be helpful. Thanks! Tag: Datagrid SortCommand does not work ??? Tag: 100088
  - 21
    - Encrypting/Decrypting Connection String I have my SQL Server connectionstring in my web.config file. I'm scared that someone will open the file and get my username/password. How do I encrypt, then decrypt the connection string in the web.config file? Tag: Datagrid SortCommand does not work ??? Tag: 100087
  - 22
    - populating dataset from excel range, error where no data. My web app allows users to upload an excel file and then ado.net loads the data (if there is any) into sql server. I have a problem when if there is no data in the excel spread (completed on a weekly basis), then the code fails when i try to fill the data adapter with the dataset. should this fail? whats the best way to deal with this? just simply do a count on the dataset? Tag: Datagrid SortCommand does not work ??? Tag: 100078
  - 23
    - Slow OleDbParameter Hi all, I have a question about performance of OleDbCommand with command parameters. I try to get records from table with 1500000 records in two ways, with command parameters (a) and without them (b). Field type is char and it also has index. Option (a) gives me result in 30 seconds and option (b) in 0.15 seconds. With SqlCommand results are the equal. Any ideas? Dim t As New DataTable Dim cmd As New OleDbCommand Dim cnn As new OleDbConnection(".....") Dim rdr As oledbDataReader (a) cnn.open() cmd.connection=cnn cmd.CommandText = "SELECT * FROM Table WHERE Field >= ? AND Field <= ?" cmd.Parameters.Add("P1", "Value1") cms.Parameters.Add("P2", "Value2") rdr=cmd.ExecuteReader (b) cnn.open() cmd.connection=cnn cmd.CommandText = "SELECT * FROM Table WHERE Field >= 'Value1' AND Field <= 'Value2'" rdr=cmd.ExecuteReader Thanx in advance. Tomislav Tag: Datagrid SortCommand does not work ??? Tag: 100072
  - 24
    - reportdefinition.xsd conversion Hello All, I am trying to generate a dataset from the reprotingdefinition.xsd. When I use the xsd.exe to generate the dataset I get next error message "The same table (style) cannot be the child table in two nested relations". Does anybody have the solution for this problem? THX --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- Tag: Datagrid SortCommand does not work ??? Tag: 100067
  - 25
    - Can't import .OCX assembly into Web Matrix Project. Hi, I am using Web Matrix Project as .NET programming environment. Can you show me detailed steps how to import the .ocx library into the Web Matrix Project. I can't seem to be able to import other assembly than .dll, .exe or .mcl . I am pretty new to the .NET programming environment, and may be missing something. I can see the file in C:\Program Files\Common Files\Tops\xyzxyz.ocx , but I can't find a way to import it into the Web Matrix Project to see all Methods and Properties of the assembly. Thank you for any help. Tag: Datagrid SortCommand does not work ??? Tag: 100064

Hi There

I have a datagrid with a Select(LinkButton) Column followed by several Bound
Columns.

I have enabled the columns to sort and created the correct event handler (I
think) - however the crux of my problem is that when I click on one of the
column headers to sort by it the ItemCommand fires rather than the
SortCommand.

in the .aspx file I have:
OnItemCommand="SalesGroupInitial_ItemCommand"
OnSortCommand="SalesGroupInitial_SortCommand"

which correlate to the .aspx.vb file (I also have an OnItemDatabound event
if that is of any significance)

I have not included the code at this juncture as it is a flat case of the
wrong event firing when I click the Column Header

Any ideas would be very much appreciated

Stuart

Top

Re: Datagrid SortCommand does not work ??? by W

W
Wed Dec 01 18:02:40 CST 2004

You can just bind to the DataTable's DefaultView instead - and set the Sort
= the ColumnValue reflected in the index of the eventarg.

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Stuart" <Stuart@discussions.microsoft.com> wrote in message
news:4A4E8159-D635-4966-AA6A-E4008AADBF26@microsoft.com...
> Hi There
>
> I have a datagrid with a Select(LinkButton) Column followed by several
Bound
> Columns.
>
> I have enabled the columns to sort and created the correct event handler
(I
> think) - however the crux of my problem is that when I click on one of the
> column headers to sort by it the ItemCommand fires rather than the
> SortCommand.
>
> in the .aspx file I have:
> OnItemCommand="SalesGroupInitial_ItemCommand"
> OnSortCommand="SalesGroupInitial_SortCommand"
>
> which correlate to the .aspx.vb file (I also have an OnItemDatabound event
> if that is of any significance)
>
> I have not included the code at this juncture as it is a flat case of the
> wrong event firing when I click the Column Header
>
> Any ideas would be very much appreciated
>
> Stuart
>

Top