How to create own DataColumn Aggregate function

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
    - Is it possible to use flat files as datasource Hello. Developing a VS2005, VB, .NET 2.0, Windows form program. Is it possible to use flat files with fixed length fields as a datasoure. I would use one for input and another to update. Any help would be gratefully appreciated. Thanks, Tony Tag: How to create own DataColumn Aggregate function Tag: 138181
  - 2
    - "Scroll" cursor in Oracle? I'm going to use server-side cursors from ADO.NET, like in this article. Creating and Managing Server-Side Cursors with ADO.NET: http://www.betav.com/Files/Content/Whitepapers/SS%20Cursors%20with%20ADO.NET.pdf Do Oracle has such kind of cursor ("scroll cursors")? PS. I'm newbie to databases and Oracle is my first experience. But in this article I've read about cursors that I ever meet in Oracle. Thanks in advance. Tag: How to create own DataColumn Aggregate function Tag: 138174
  - 3
    - Get PK back on an insert into Oracle I am trying to get returned the autogenerated primary key value from Oracle when I insert a row. I am using the Microsoft OracleConnection class. My code is: // cmd is an OracleCommand object. cmd.CommandText += "; returning " + column_name + " into :r1"; OracleParameter pkParam = new OracleParameter(); pkParam.Direction = ParameterDirection.ReturnValue; pkParam.DbType = DbType.Decimal; cmd.Parameters.Add(pkParam); object rtn = cmd.ExecuteScalar(); But ExecuteScalar() throws an exception. Any ideas? -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.windwardreports.com/film.htm Tag: How to create own DataColumn Aggregate function Tag: 138170
  - 4
    - DataGridView and Combobox columns I am trying to populate a DataGridView Combobox column with a different data binding source (dataset) depending upon a selection made in a previous column. I can handle the previous column but how do I assign the following properties dynamically in code? DataPropertyName DataSource DisplayMember I do see how to set these at design time but that won't do because I need different data in the combobox per each row depending upon the previous selection made. I hope I explained the problem well enough. Tag: How to create own DataColumn Aggregate function Tag: 138169
  - 5
    - Inherit form typed Dataset Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this dataset and modify tables (add columns or other tables) in that dataset as they wish using designer. Am I at the wrong design path or something can be done after all? Thanks in advance, Denis Tag: How to create own DataColumn Aggregate function Tag: 138162
  - 6
    - I need an approach to storing/editing data amongs forms I'm working on a small, single user .net 2005 windows application in c# connecting to SQL Express. I'm trying to learn Typed DataSets, DataTables, DataAdapters, etc. What I need to figure out is a reasonable approach (doesn't have to be totally academic) to dealing with data. In other words, how do I store it, display it and manipulate it? Right now I have created a global DataSet with some TableTables and am Filling this structure on program startup. I'm using a freeware custom tree/list control that doesn't seem to support databinding so I'm loading it up manually from the global DataTable. So far "ok". Now I want to be able to add and remove rows and also edit rows. As an example, say I have a sub form for editing an existing row. Dragging Columns onto the form creates a BindingSource, a TableAdapter and a DataSet. I already have two of these in the global structure. Should I be removing these and trying to bind to them instead in the sub form? Or, do I want to create local copies for manipulation? But then how would I sync the results to the global objects? If I do use the global objects, how do I keep the list in sync with edits, for example? I guess I'm looking for a "pattern" on housing and connecting to data, manipulating it throughout the application. I'm hoping to start easy, rather than jumping into something complicated like MVC. Thank you for any assistance. Tag: How to create own DataColumn Aggregate function Tag: 138160
  - 7
    - Password protect .mdb file Hi I'm using AccessDataSources to access my .mdb file, like so... <asp:AccessDataSource ID="adsStory" runat="server" DataFile="~/App_Data/MyDB.mdb" SelectCommand="SELECT * FROM Table WHERE ColumID = ?"> <SelectParameters> <asp:QueryStringParameter Type="Int32" QueryStringField="id" /> </SelectParameters> </asp:AccessDataSource> I want to password protect the database in Access, so that if someone downloads it they can't get to the data. How do I do that, and still able to open the database from my AccessDataSource? Obviously, I don't want the cleartext password in any of my .aspx pages. Thanks, Dan Tag: How to create own DataColumn Aggregate function Tag: 138159
  - 8
    - A search module in c# Hello I need to create a search form which allows the user to search for records using multiple criteria, and then they can select that record and when clicked ok, that particular record to be displayed in the main form. I have the main form, I need to implement the search feature for that (its a windows based app). Any samples would be very helpful. Thanks Tag: How to create own DataColumn Aggregate function Tag: 138158
  - 9
    - TableAdapter Configuration Wizard Hi, I created a DSN (ODBC) to connect to a database in IBM DB2. I wanted to create a dataset for 'Select' Statement by wizard. When I add a query variable @strGeoID in 'where' statement - where (PRODDTA.F1755.ZAURRF = @strGeoID), I got the error message: ----------------------------- Generated SELECT statement. Error in list of function arguments: '@' not recognized. Unable to parse query text. ----------------------------- Does anybody can tell me how to solve the problem? Thanks ! Tag: How to create own DataColumn Aggregate function Tag: 138154
  - 10
    - connecting SQL server using OleDb - Reg While trying to connect to SQL server using OleDb I am getting the following error. The connection string used is Provider=SQLOLEDB.1;server=ctsinprnslse;database=Sample;user id=140869; password=140869 The Error I received is A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll Kindly help me to come out from this. Thanks&Regards, Yasodhai Tag: How to create own DataColumn Aggregate function Tag: 138149
  - 11
    - connecting SQL server using OleDb - Reg While trying to connect to SQL server using OleDb I am getting the following error. The connection string used is Provider=SQLOLEDB.1;server=ctsinprnslse;database=Sample;user id=140869; password=140869 The Error I received is A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll Kindly help me to come out from this. Thanks&Regards, Yasodhai Tag: How to create own DataColumn Aggregate function Tag: 138147
  - 12
    - How can I use connected mode instead of disconnected? I would like to bind some datagrids to datasource and have them update the database when a row is changed. I don't like the disconnected mode. I am developing a Windows Form app, not an ASP.net app. Would like to have the same functionality as I did with VB6 and Delphi.... Thanks Tag: How to create own DataColumn Aggregate function Tag: 138144
  - 13
    - Microsoft Certification Ebooks - C#, ASP.NET, VB.NET etc Microsoft Certification Ebooks - C#, ASP.NET, VB.NET etc Free ebooks of MCTS Exams (70-431, 70-529, 70-528, 70-526, 70-536) http://free-tech-ebooks.blogspot.com/2007/02/download-free-ebook-of-mcts-exams-70.html 36 Microsoft Certification Tutorials and Free Practice Exams http://free-tech-ebooks.blogspot.com/2007/01/36-microsoft-certification-tutorials_19.html MCSD Exam Ebooks http://free-tech-ebooks.blogspot.com/2007/01/mcsd-exam-ebooks.html Free Microsoft MCSE MCSD Certification Ebooks http://free-tech-ebooks.blogspot.com/2007/01/free-microsoft-mcse-mcsd-certification.html For more links go to http://free-tech-ebooks.blogspot.com/search/label/Microsoft%20Certifications Tag: How to create own DataColumn Aggregate function Tag: 138136
  - 14
    - Inherit from typed dataset Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this dataset and modify tables (add columns or other tables) in that dataset as they wish using designer. Am I at the wrong design path or something can be done after all? Thanks in advance, Denis Tag: How to create own DataColumn Aggregate function Tag: 138133
  - 15
    - Inherit a typed dataset Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this dataset and modify tables (add columns or other tables) in that dataset as they wish using designer. Am I at the wrong design path or something can be done after all? Thanks in advance, Denis Tag: How to create own DataColumn Aggregate function Tag: 138132
  - 16
    - Import text file with DATE column into MS Access Database with VB.NET or C# Hello, I followed the thread "Import large text file to MS Access Database" trying to solve a similar problem, but with no help. I have a CSV file called "orders.csv" which I want to export to a MS Access table. The CSV file has the following structure: ORDER,DATE,TIME,F_NAME,L_NAME 10001,3/10/2007,5:40:20,Rafael,Lindberg 10002,4/11/2007,6:50:10,Luis,Mcgary The MS Acces table ("orders_tbl") has the following structure: ORDER TEXT, 10 DATE DATE TIME TEXT, 15 F_NAME TEXT, 30 L_NAME TEXT, 30 I tried the following code, but with no success: '<------ begins code Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB. 4.0;Data Source=c:\myPath\orders.mdb;User Id=Admin;Password=;") AccessConn.Open() Dim strSQL As String strSQL = "" strSQL += "INSERT INTO [orders_tbl] (" strSQL += "ORDER," strSQL += "DATE, " strSQL += "TIME, " strSQL += "F_NAME, " strSQL += "L_NAME) " strSQL += "SELECT " strSQL += "ORDER, " strSQL += "DATE, " strSQL += "TIME, " strSQL += "F_NAME, " strSQL += "L_NAME " strSQL += "FROM " strSQL += "[Text;DATABASE=C:\myPath;]" strSQL += "." strSQL += "[orders.csv]" Dim AccessCommand As New System.Data.OleDb.OleDbCommand(strSQL, AccessConn) AccessCommand.ExecuteNonQuery() AccessConn.Close() '<--------- ends code The error message I got is: "Syntax error in INSERT INTO statement." The problem comes from the DATE and TIME fields, because if I don't include these fields the code works. I have tried to change in the access table the field type to Date or Text unsuccessfully. It seems I have to do some previous transformations on the date and time columns in the csv file BUT I don't have any idea. Please any help appreciated!! efiguero Tag: How to create own DataColumn Aggregate function Tag: 138131
  - 17
    - typed datasets populated by generic lists? We have an application that makes use of a strongly typed dataset. However, some issues have come up with the database and tools. We would like to continue using it, but would prefer to populate it from a Genric List business object. Are these possible: 1) use a generic list of business objects to populate a strongly-typed dataset 2) change the source of an existing strongly-typed dataset from from a database to a generic list. This is w/.net 2 Thanks much Mark Tag: How to create own DataColumn Aggregate function Tag: 138130
  - 18
    - how to get row number from DataTable.Compute method how do you get the row number from the DataTable Compute() method? Thanks Tag: How to create own DataColumn Aggregate function Tag: 138129
  - 19
    - An existing connection was forcibly closed by the remote host. I've seen this message a lot in the groups but I haven't found a solution for it yet. Our setup is SQL Server 2000 on a Windows Server 2003 cluster. I don't believe this issue happened as often when the OS was Server 2000 but that was before I started here. We see this quite a bit from our wireless clients: Errors=System.Data.SqlClient.SqlErrorCollection Class=20 (0x14) LineNumber=0 (0x0) Number=10054 (0x2746) Server=OurSQLServer State=0 (0x0) ErrorCode=-2146232060 (0x80131904) Message=A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Data=System.Collections.ListDictionaryInternal I initially thought it had something to do with them losing the network connection but when I was trying to recreate (killing the wireless connection during a long running process) that I always got the following details: Errors=System.Data.SqlClient.SqlErrorCollection Class=20 (0x14) LineNumber=0 (0x0) Number=64 (0x40) Server=OurSQLServer State=0 (0x0) ErrorCode=-2146232060 (0x80131904) Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) Data=System.Collections.ListDictionaryInternal To recreate the original, all you have to do is run the KILL command on the spids associated with your application from Query Analyzer. Given this, I'm focusing on the server itself causing the errors and not the client computers. So now we have something to go on when we attempt to code around the issue. I've been able to "soothe" the issue by executing SqlConnection.ClearAllPools() when we see a SqlException with a severity level of 20 or higher. However, I'd like to know if there's a setup issue with my SQL Server box that I could change that would at least lessen the frequency of these errors. Thanks in advance for any advice, Austin Tag: How to create own DataColumn Aggregate function Tag: 138118
  - 20
    - Is it possible to fill a DataSet.DataTable with values from more than one database table? Hello, is there a way to fill a DataSet.DataTable with values from more than one table from a single database file? The thing I'd like to achieve is to get something similar to a result of the JOIN keyword in SQL. Thanks for any help... With regards nvx Tag: How to create own DataColumn Aggregate function Tag: 138108
  - 21
    - Urgent Memory Leak Problem Using Type Dataset. Please help! :-( Hi all, I'm having a baffling problem with a windows service that I'm working on. Basically, I am using a typed dataset to insert a large number of rows into an SQL Server 2005 database. But there's a memory leak that seems to be to do with calling the data adapters update method. It's making the memory usage go through the roof and ultimately the service crashes after running out of memory. I've used ".net memory profiler" to analyse the service. It tells me that there are huge numbers of undisposed @List<SQLParamter>.Enumeration@ objects. I'm guessing this is a bad thing. I don't know what to do about it though. As far as I know, the dataset table adapter should be cleaning up after itself once the method ends. In case it helps, a sample of my code would ... Start a foreach loop currentRow = tblActiveMessages.NewActiveMessagesRow(); currentRow.DownloadID = currentMessage.ID; currentRow.TTUReference = currentMessage.VehicleID; ... Assign more properties tblActiveMessages.Rows.Add(currentRow); ... For loop ends da.Update(tblActiveMessages); I've tried putting a using statement around both the data table and the table adapter, but it had absolutely no effect. Can anyone advise me on what I can do to get rid of these little buggers! Sincerest thanks to anyone who can help - even a little bit! :-( Simon Tag: How to create own DataColumn Aggregate function Tag: 138107
  - 22
    - Stopping a Query I have a program which allows the user to graphically create SQL statements without having to know SQL. They just drag and drop fields to view, select criteria and sort order. When the user indicates that they want to execute a query, I parse the SQL statement to verify correctness and then create a recordset and assign it to a datagrid for viewing. If the query is taking too long to run or is retrieving too many records, I would like to have a button to stop the query. If they click this button, how do I programmatically stop a query while it is running? Bill Tag: How to create own DataColumn Aggregate function Tag: 138106
  - 23
    - Microsoft Training/ Certification Dumps /Materials Urls Microsoft Training/ Certification Dumps /Materials Urls Get the links from here : http://free-tech-ebooks.blogspot.com/2007/03/microsoft-training-certification-dumps.html Tag: How to create own DataColumn Aggregate function Tag: 138099
  - 24
    - Deployment + Vista We use strongly typed datasets, and thus our connection string is bound to an application setting. Currently we can deploy and alter the app.exe.config file at installation time to successfully install, and use some basic XML editing to allow the target database to be changed. Writing to the application directory in vista will throw compatibility errors, and not persist the changes at all. What do we do? Is there a better way of getting the connection string in your application, or a way of telling the designer where to get your connection setting from?? Tag: How to create own DataColumn Aggregate function Tag: 138087
  - 25
    - Eliminating CRUD procedures Your know the ones, you have a table and it has Create,Read,Update and Delete Stored procedures and the app always uses these to talk to the DB eliminating dynamic sql in your apps. Makes perfect sense when you have a table however when you have 500 tables its not so clever (thats 2000 stored procs to maintain) Shouldnt the framework and sql guys talk to each other and come up with a single proc that accepts the CRUD as an argument to a single UpdateMyTable proc for each table. Then Hey presto 500 tables = 500 procs It would be nice if i didnt have to code it myself and the dataset wizard just happened to offer this option in the next framework version! Colin Robinson. Tag: How to create own DataColumn Aggregate function Tag: 138085
- Next
  - 1
    - Writing xml file from dataset different than the original Hello all. I'm reading the data from an XML file similiar to below, using the code below. When the file is edited in the datagridview and then re-written, it doesn't write the xml file as it was originally written. So what am I doing wrong? My code and samples are below. Any help would be greatly appreciated!! VISUAL STUDIO 2005 .NET 2.0 FRAMEWORK, VB.NET CODE Declare a bindings source, a dataset, a binding navigator, and set up a datagridview where the data is displayed & edited 'now associate them bndgSrc1.DataSource = ds dgvConfig.DataSource = bndgSrc1 binNav1.BindingSource = bndgSrc1 'Now read the xml file into the dataset & ds.readxml(filename) ds.ReadXml(My.Settings.configFile) bndgSrc1.DataMember = "pnum" bndgSrc1.ResetBindings(False) I save the edited info as below: dgvConfig.EndEdit() bndgSrc1.EndEdit() If ds.HasChanges Then ds.AcceptChanges() ds.WriteXml(My.Settings.configFile, XmlWriteMode.WriteSchema) End If bndgSrc1.ResetBindings(False) !<ORIGINAL XML FILE SAMPLE BELOW> <?xml version="1.0" standalone="yes"?> <config> <workstations> <ws>pcnamexxx</ws> <ws>pcnamexxx</ws> </workstations> <patches> <pnum>1837</pnum> </patches> <users> <uid>user3</uid> <uid>user4</uid> </users> <ad> <ou>OU=firstlevel,OU=secondlevel,DC=GOOGLE,DC=COM</ou> <ou>OU=anotherou,OU=yetanother,DC=GOOGLE,DC=COM</ou> </ad> </config> If I delete all the records, I just get the "<patches /> remnant left behind: !<SAVED (ALL PATCHES RECORDS DELETED) XML FILE SAMPLE BELOW> <?xml version="1.0" standalone="yes"?> <config> <workstations> <ws>pcnamexxx</ws> <ws>pcnamexxx</ws> </workstations> <patches /> <users> <uid>user3</uid> <uid>user4</uid> </users> <ad> <ou>OU=firstlevel,OU=secondlevel,DC=GOOGLE,DC=COM</ou> <ou>OU=anotherou,OU=yetanother,DC=GOOGLE,DC=COM</ou> </ad> </config> If I enter a new record, it doesn't nest it within the parent, as below: !<SAVED (NEW PATCHES RECORD INSERTED) XML FILE SAMPLE BELOW> <?xml version="1.0" standalone="yes"?> <config> <workstations> <ws>pcnamexxx</ws> <ws>pcnamexxx</ws> </workstations> <patches> <pnum>1837</pnum> </patches> <pnum>1838</pnum> <users> <uid>user3</uid> <uid>user4</uid> </users> <ad> <ou>OU=firstlevel,OU=secondlevel,DC=GOOGLE,DC=COM</ou> <ou>OU=anotherou,OU=yetanother,DC=GOOGLE,DC=COM</ou> </ad> </config> Tag: How to create own DataColumn Aggregate function Tag: 138084
  - 2
    - Insert a whole datatable I have two access database (with identical schema). One is the master and the other is SHOULD be a subset of master data (Let call them MasterDB and SubDB The user enters data into the SubDB and I need to bring the new changes to the MasterDB. Traditionally, I can get a the new changes (into a dataTable). Loop through all the rows and insert them into the MasterDB ONE AT A TIME. My question: IS THERE A BETTER WAY? For SQL Server, there is a SqlBulkCopy but I am dealing with MS Access. In my case, performance is not an issue, I just want write less code. Thanks John Tag: How to create own DataColumn Aggregate function Tag: 138079
  - 3
    - Some ADO.NET Mobile Advice please. Hi all I am building an Windows Mobile 5 forms control in C#, for a Windows Mobile 5 application. I am using CF2.0 and SQL Mobile 2005. The control is a Questions and answer control. Basically I have 3 applications using the same code to dynamically display questions and save the answers. I am trying to consolidate it all into 1 control for easer maintenance. I need to pass the control the questions and meta data for the questions. And when the last question has been completed the control should hand back the Answers for saving. What is the best why of doing this? I really would like to get this right the first time. I know I am developing with the CF2 platform. So I am concerned about getting the most efficient why of doing this. Possible scenarios I are. 1.. Pass the control a Questions DataTable and an Answers DataTable (Flat File), use the Questions DataTable to load up an array and loop through the array asking questions and saving the answers to Answers DataTable. When the Questions are finished raise an event handing the Answers table as an Event Arg. 2.. Pass the control a QuestionsAnswers DataSet with a Questions DataTable and an Answers DataTable in it, use the Questions DataTable to loop round asking questions and saving the answers to Answers DataTable. When the Questions are finished raise an event handing the QuestionsAnswers DataSet as an Event Arg. 3.. Hand the control a Connection and get it to read the questions directly from the Database and save the answers directly to the database. I really am lost. I don't what to take the wrong path and I don't have enough background experience to make an informed decision about what the best way to handle this with ADO.NET and the CF would be. Any suggestions would be welcomed. Thanks, ink Tag: How to create own DataColumn Aggregate function Tag: 138075
  - 4
    - Datatable For i = 0 To dtSubOpt.Rows.Count - 1 intOptNo = dtSubOpt.Rows(i)(1) strSelectSubOpt = "select tblOptions.strOptName as OptionName,tblOptions.intParent ,tblMOMT.strMOTag as MessageSentFromServer,tblMOMT.strMTTag as MessageSentToServer from tblOptions inner join tblMOMT on tblMOMT.intOptId=tblOptions.intOptId where intParent=" & intOptNo & " order by OptionName" dtOptName = dbCon.GetRecordSet(strSelectSubOpt, "tblOptions") Next In my above coding i need to keep all the records retrieved through looping the query in the same datatable. In my coding every time intOptNo has changed and retrieve the records corresponding to that particular intOptNo . The loop executed every times and get the records ,but the records overwrite the records already in a datatable this is my problem .So to avoid this I need to increment the index of the datatable row .But I don't know how to change the row index depending upon the number of rows returned by the query .Is there any way to find the row index of the datatable and to increment that no to keep the next records orelse tell me some other way to keep all the records retrieved through looping the query in the same datatable or in the same DataSet. Kindly expecting the reply, meka. Tag: How to create own DataColumn Aggregate function Tag: 138074
  - 5
    - Problem saving 24 hour date/time in SQL I have an SQL table(MS SQL 2005) with a field called SignInDate and have created this as DateTime. When I save the current time using the Now function, it does not save the value in 24 hour format. For example, if it is 2:15:36 PM (i.e. 14:15:36) it saves the value in SQL Sever as 2007-03-08 02:15:36.000 and when I read it back, it resuls in 2:15:36 AM. I have tried formatting as a string using HH:mm:ss for the time portion but SQL Server still saves as shown above. How can I get it to save as 2007-03-08 14:15:36.000 so it will be correct when I read it back? TIA, John Tag: How to create own DataColumn Aggregate function Tag: 138070
  - 6
    - SQLBulkCopy and SQL Server 2000? Hi all, Does .NET 2.0's SQLBulkCopy class work with SQL Server 2000? Thanks! Tag: How to create own DataColumn Aggregate function Tag: 138064
  - 7
    - how does ado.net SqlDataReader.GetString() know which encoding to read the data into a string as? Does sql sever set this at the column data type level, server wide encoding setting, os encoding? how does ado.net SqlDataReader.GetString() know which encoding to read the data into a string as? Does sql sever set this at the column data type level, server wide encoding setting, os encoding? Tag: How to create own DataColumn Aggregate function Tag: 138060
  - 8
    - Using Sql2005's OUTPUT Hello all... Here is what i want to do (in VB code)... <code> Dim SQL As String = "SELECT ROWID FROM (INSERT INTO STATIC_CONTENT (NAME, CONTENT) OUTPUT INSERTED.ROWID SELECT 'Contact Us', '') SRC" Dim newId As Integer myDbObject.ExecuteScalar(SQL) </code> Assume that myDbObject has already been set up with all the necessary connection strings and junk. The question revolves around using ExecuteScalar to return the value from an INSERT-OUTPUT clause. I can 100% guarantee that this is a single-row insert everytime. This table (STATIC_CONTENT) has a trigger on it to set the update-date every time it's updated. Is this possible somehow? short of writing my own overloaded ExecuteScalar that would turn this into a whole big T-SQL BEGIN/END block with temporary variables and all that mess? Thanks in advance, - Arthur Dent; Tag: How to create own DataColumn Aggregate function Tag: 138058
  - 9
    - PARSE a Blank Space??? Using ASP.NET 2.0 with SQL Server 2000 Inside my dropdown list box I am using an SQL DataSource to select the following data SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact, c.phone As PriPortPhone FROM mppaContacts c Dropdown list box works well ..... Example "Bart Simpson" First_name = Bart Last_name = Simpson DropDownList -->> RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact ANS:: "Bart Simpson" How can I parse the blank space I am trying to PARSE it based on the space that I placed into the string found in the DropDownlist box??? UPDATE mppaContacts SET [Name_First] = @FirstName [Name_last] = @LastName [phone] = @phone Any ideas would be greatly appreciated........not sure how to extract the individual names and place them into their specific fields. Thanks in advance ~Brad ------------------------------ Brad Isaacs Tag: How to create own DataColumn Aggregate function Tag: 138057
  - 10
    - Dynamic access to DataTable during DataAdapter.Fill Hello, Does anyone know if its possible to access the row/column values of a DataTable while a DataAdapter is filling the table? Maybe using a new thread? I am currently trying to use a seperate thread for access while the main thread runs the DataAdapter.Fill and so so far it looks like the table and rows/columns are not added incrementally, but instead are only filled once entire resultset has been determined and returned. Any advice is appreciated. Thanks, Andrew Tag: How to create own DataColumn Aggregate function Tag: 138051
  - 11
    - can I alias an ADO.Net table (tablename)? Greetings, Is it possible to alias an ADO.Net table? I have this one table that has a pretty long name dsDataEntry.Tblsomebigtablename. I tried Dim dt As DataTable = ds...Tbl... Welll, that created table dt, but it did not populate the table. I guess I would have to loop through the original table. So is there a way to assign a shorter name to the table I need to work with? Thanks, Rich Tag: How to create own DataColumn Aggregate function Tag: 138050
  - 12
    - UPDATE a DropDownList box~ HElp Please Using ASP.NET 2.0 with SQL Server 2000 Inside my dropdown list box I am using an SQL DataSource SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact, c.phone As PriPortPhone FROM mppaContacts c Now I am trying to UPDATE the table name mppaContacts with what the user selects from the drop down list box. How do I UPDATE the table when the names are concatenated? I need to select a substring for the Name_First field then for the Name_Last field. UPDATE mppaContacts SET [Name_First] = @FirstName [Name_last] = @LastName [phone] = @phone Any ideas would be greatly appreciated........not sure how to extract the individual names and place them into their specific fields. Thanks in advance ~Brad ------------------------------ Brad Isaacs Tag: How to create own DataColumn Aggregate function Tag: 138049
  - 13
    - Parameterized query problem using Access Database in VS.NET2005 New to the VS.NET 2005 and I am writing a program using an access database as the datasource in visual studio.NET 2005 The problem I have is I am trying to write a parameterized query where a wildcard can be used to pull a complete name from only one or two characters entered. If I have the exact name I can get it to work with a ? but this defeats the purpose of the query and the sql select for the access database doesn't reconize the * that is used in access as a wildcard. The satements I have right now are: SELECT CustomerNumber, Name, Address, City, State, Zip, Phone, LastOrdDate, Inactive FROM Customers WHERE Name = ? SELECT CustomerNumber, Name, Address, City, State, Zip, Phone, LastOrdDate, Inactive FROM Customers WHERE CustomerNumber = ? and when I try to do this (or any version of it): SELECT CustomerNumber, Name, Address, City, State, Zip, Phone, LastOrdDate, Inactive FROM Customers WHERE CustomerNumber = '*' or WHERE CustomerNumber = ? &'*' I get an error of this: Error in WHERE clause near '*'. Unable to parse query text. I have even tried the % for sql databases and still no help. Tag: How to create own DataColumn Aggregate function Tag: 138046
  - 14
    - problem with Ole DB on Windows XP Hi Everybody, I've got a strange problem on one of our clients computers: I've got a dotnet 1.1 application that connects to a database using .Net OleDB provider for Visual FoxPro. On most of our clients' computers everything works as expected, However on 1 computer running Windows XP Pro + SP2 we get this error: ** System.InvalidOperationException: The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later. ---> System.Runtime.InteropServices.COMException (0x80040154): Class not registered at System.Data.Common.UnsafeNativeMethods.CoCreateInstance(Guid rclsid, IntPtr pUnkOuter, Int32 dwClsContext, Guid riid) at System.Data.OleDb.OleDbConnection.CreateInstanceDataLinks() at System.Data.OleDb.OleDbConnection.CreateInstanceMDAC() --- End of inner exception stack trace --- at System.Data.OleDb.OleDbConnection.CreateInstanceMDAC() at System.Data.OleDb.OleDbConnection.GetObjectPool() at System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) at System.Data.OleDb.OleDbConnection.Open() .. We tried to install MDAC 2.8, but we get a message that MDAC 2.8 is already installed as part of the OS. How do we solve this problem? Thanks, Nadav Tag: How to create own DataColumn Aggregate function Tag: 138040
  - 15
    - Please HELP!!!! Hi, I have this problem, I do an update to VFP table, using oledb all works fine while I run the asp net application from visual net IDE when I close the IDE (same computer) and open explorer to run the application and try to update the table, I get the error "cannot update the cursor 'cursor' " as if the table is read only, of course not, because works fine inside IDE so, Have I to share the table o make some changes to give permisions or something to acces tables write mode? thanks Tag: How to create own DataColumn Aggregate function Tag: 138028
  - 16
    - Date and Time field concatination I have field with a Date and a field with a Time; is there anyway to make a complete DateTime using an expression in ADO.NET? I don't have an option to do this in a database before getting the data into the app. Thanks, Joe Tag: How to create own DataColumn Aggregate function Tag: 138023
  - 17
    - Stored procedure returns two result sets Hi everyone, I have a stored procedure called 'PagingTable' that I use for performing searches and returning just the results for the current 'page'. That way I can do my paging on the server and only the data that actually gets displayed on the webpage is returned from the database server. The sp returns two result sets. The first result set contains a single row and columns telling me how many total results the query retuned, how many 'pages' (based on the number of items per page that I specify) and the current page I am on. The second result set returns the rows of data for the current page. In 'classic' ASP I handled it this way: strSQL = "EXECUTE PagingTable " & _ "@ItemsPerPage = 10, " & _ "@CurrentPage = " & CStr(intCurrentPage) & ", " & _ "@TableName = 'Products', " & _ "@UniqueColumn = 'ItemNumber', " & _ "@Columns = 'ItemNumber, Description, ListPrice, QtyOnHand', " & _ "@WhereClause = '" & strSQLWhere & "'" 'Open the recordset rsItems.Open strSQL, conn, 0, 1 'Get the values required for drawing the paging table intCurrentPage = rsItems.Fields("CurrentPage").Value intTotalPages = rsItems.Fields("TotalPages").Value intTotalRows = rsItems.Fields("TotalRows").Value 'Advance to the next recordset Set rsItems = rsItems.NextRecordset Its that last line that was key. I could then go on loop over the results and output them. How do I do this in ASP.NET 2.0? The DataSource control only allows a single "DefaultView". So does the DataReader. How can I bind a repeater control to the second result set (the actual data) and use the info in the first result set to build a "pager" UI? Thanks, Ken VdB Tag: How to create own DataColumn Aggregate function Tag: 138021
  - 18
    - How to cancel execution of an asynchronously executing SqlCommand? Hello! ADO.NET 2.0 offers the possibility to execute SqlCommands asynchronously, for instance SqlCommand.BeginExecuteReader. Let's assume it takes quite some time to execute such an SqlCommand. Is there a way to cancel the execution of an SqlCommand executing in this asynchronous manner? Best regards, Henrik Dahl Tag: How to create own DataColumn Aggregate function Tag: 138020
  - 19
    - System.Data.OracleClient InvalidOperationException on Inline queri I'm using ADO.Net (Framework 1.1) against an Oracle database. I need a resolution to the inline query problem posted at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=186761&SiteID=1 It appears that someone from the ADO.Net team(Alazel Acheson) posted a bug for it (#428203) last year. but I can't find a resolution for this problem in the forum listed above or anywhere else on the web. Was this bug ever fixed? what 1.1 patch/updates do I need to install to get the OracleClient to execute inline queries? I always automatically install updates from MS so there must be another place where I can get the fix I need. Thank you. Tag: How to create own DataColumn Aggregate function Tag: 138019
  - 20
    - index to foxpro files i need to access a legacy database that uses dBase files running under foxpro for read only purposes, within net 2.0, ado 2.0 using vb and sql statements. i have no problem getting the info i need, but it is very slow. i'm not using any indexes which the databases have, *.idx files, i don't know how to access them. the connection string i use is: DBFConnedction = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBASE IV;User ID=Admin;Password=;Data Source=""M:\Names\"" M is a network drive, Names is the folder name where the databases are. how do i make my data access go thru the indexes, do i change the connection string, or the sql statement, or something else? i would appreciate a code snippet. thanks ray Tag: How to create own DataColumn Aggregate function Tag: 138014
  - 21
    - Create new table in DataSet I have a DataSet that contains one table. I want to create two new tables each of which contains all the rows but only some of the columns from that first table. Can I do this without going back to the original data source? THanks. -- Peter Aitken Tag: How to create own DataColumn Aggregate function Tag: 138013
  - 22
    - Updateing event of datagridview I m using the datagridview. Except Update event rest of the all i.e. Edit cancel, delete. I want to read the cell content . if its a Quantity user may change it so tht bases on tht i m going to calculet the price. Dim tb1 as textbox tb1 = CType(DataGrid2.row(e.rowIndex).cell(8).Control(0), TextBox) Dim a as string a = tb1.text REturns only "1".....Not the cell content. What to do to get the Cell COntent which user may change and then click Update! Please advice!! Tag: How to create own DataColumn Aggregate function Tag: 138006
  - 23
    - Filling tableadapaters in master/child dataset I have defined a strongly-typed dataset with two tableadapters in a master/child relationship. On the master tableadapter, there is a parameter which restricts the fill of the tableadapter to less than the entire contents of master table. After filling the master table, do I simply fill the child tableadapter with a single call and it magically "knows" to fill the child based on the relationship, or do I have to walk the master table rows and fill the child multiple times based on the rows of the master? Sorry for this ignorant question, but I am lost here. Thanks, Flomo Tag: How to create own DataColumn Aggregate function Tag: 138003
  - 24
    - Recommended:How to get control of you life and time Get control of our own life and time is the skills to be successful.This blog is strongly recommended. http://linux1689.blog.sohu.com/36289314.html Recommended:How to get control of you life and time Tag: How to create own DataColumn Aggregate function Tag: 138001
  - 25
    - DataAdapter.Fill, ConstraintException, and Primary Keys I am running into ConstraintExceptions with the following VB.NET code: Dim daResult As SqlDataAdapter = New SqlDataAdapter Dim Result As DataSet = Nothing [code to set up the data adapter with a stored procedure, parameters, connection, etc.] daResult.MissingSchemaAction = MissingSchemaAction.AddWithKey daResult.Fill(Result, tableName) and SQL code in the called stored procedure: SELECT '2_FieldID' = table2.idfield FROM base_table LEFT JOIN (table1 INNER JOIN table2 ON table1.2_idfield = table2.idfield) ON base_table.idfield = table1.base_idfield where idfield is an IDENTITY(1, 1) PRIMARY KEY field on table2 and 2_idfield is a foreign key to it on table1. *However*, I don't get the ConstraintException when I make the SQL statement like this: SELECT '2_FieldID' = table1.2_idfield FROM base_table LEFT JOIN table1 ON base_table.idfield = table1.base_idfield nor do I get this error when I leave out the VB.NET line: daResult.MissingSchemaAction = MissingSchemaAction.AddWithKey I do need the MissingSchemaAction; I can fudge my stored procedures to avoid selecting the idfields directly, but I can't help but feel that I'm missing something here, especially since I'm using the same code in a lot of places and only running into the problem in a small handful of stored procedures which aren't, as far as I can tell, bases on tables with any different constraints than the unproblematic ones. (Is there something I should be looking for?) Thanks, Caitlin Shaw Tag: How to create own DataColumn Aggregate function Tag: 137999

I want to create my own Aggregate function to be used in the
DataColumn.Expression property.

So for example,
DataColumn col = new DataColumn("foo", typeof(String));
col.Expression = "my_custom(Child.Test)";

Anyone done this before? Any suggestions on where to start?

thanks

Top

Re: How to create own DataColumn Aggregate function by Miha

Miha
Sat Mar 17 09:16:26 CDT 2007

I would implement ColumnChanged and RowChanged event and do the calculation
there.
What exactly do you need?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"whiteboy" <bjkelly@gmail.com> wrote in message
news:1173936897.333855.295990@e1g2000hsg.googlegroups.com...
>I want to create my own Aggregate function to be used in the
> DataColumn.Expression property.
>
> So for example,
> DataColumn col = new DataColumn("foo", typeof(String));
> col.Expression = "my_custom(Child.Test)";
>
> Anyone done this before? Any suggestions on where to start?
>
> thanks
>

Top