ORA-00917 missing comma when using OleDb to insert chinese character

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
    - Why custom (config) files are not copied in Web Site / Webservice bin folder Hi all, I have a solution that contains a Web Site / Webservice project and one library project. The library project use a config file. When I build the solution, the config file is not copied in bin folder of web site in spite of the config file is flagged as "Copy Always". Someone could explain me why and give me a solution? Thanks Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138290
  - 2
    - Problems Updating Access Table I'm fairly new to VB.Net 2005 development and I am in need of updating MS Access 2000 data via code. This was easy to do in my prior programming language, but I am stuck here. :( I am using the following test code that when a button is pushed, the contents of the Customer_ID field is changed. Well, it does change. I have a datagrid on Windows Form connected to an Access database and the chage occurs, but is not saved. When I exit the program and re-run it, the old data remains. Thanks for any assistance. Private Sub btn_GetCustomerInfo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_GetCustomerInfo.Click Dim MyData As DataRow Dim MyString As String MyData = ds_Binding.Tables(0).Rows(CARES_BindingSource.Position) MyString = MyData("Customer_ID") MessageBox.Show(MyString) 'Change It's Value MyData("Customer_ID") = "123456789" MyData.AcceptChanges() End Sub Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138277
  - 3
    - How do i move this stuff to a client site? Hello. Developing VS2005, SP1, .NET 2.0, VB Windows form program on WIN XP Pro, SP2. It has a Dataset with two tables using an SQL 9.0 Server Express. I just spent the whole day trying to figure out why my program stopped updating the database when it was working perfectly fine last night. It was working exactly the way i wanted it to, but i had to be a real smart guy and try to move the database from the \C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder to where my VS program was, so that when i go to my clients to install everything, i wouldn't have to track down files in more than one location. Boy, i thought i was going to be so efficient. After i did that, everytime i tried a test, it would not update the database even though it was not giving me errors. I even watched it go through the code and not error out on the add rows etc. I ran the Show Table Data in server explorer and the Preview Data in DataSet designer and no records would show up. When i ran the Preview Data from the data source window, it would always give this error: "An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\INVHST.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." Well, it turns out that after moving the database back to the original folder, everything ran fine again. I can't explain why it would not work after moving the database to a different location. Which leads me to a question. How am i going to bring this stuff to a client and install it there so that i don't run into this problem there? Any help would be gratefully appreciated. Thanks, Tony Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138275
  - 4
    - Closing an Access OleDBConnection from another Form I have Form1 that has two OleDBconnections to an Access database. I have Form2 that has a function that requires the Access db be disconnected from my application. My Form2 knows nothing about the db connections in Form1 obviously. How do I close the open dbconnections from Form2 when they are associated with Form1? Thanks much! Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138271
  - 5
    - A thorny issue regarding composite keys in a typed dataset Hello group: Given a data table in a typed dataset with a composite key made up of 2 integer fields, what approaches have people taken with regard to editing them? The following might help describe the situation better. Situation: I have a grid view displaying some customer configuration information about which county they live in, product shipping cost adjustments, etc... The grid view can be edited and is bound to an object data source which brokers communication to a web service. The data table 's key is made up of a customer id (cannot be edited by the grid obviously) and a county id. The county id is edited as a dropdownlist when the grid goes into edit mode. When the changes are pushed to the object data source, its update method retrieves the row in memory that is being edited, changes the relevant fields, including county id if it is changed, and pushes those changes to the webservice as a diff gram. The problem comes when the adapter on the web service goes to update the changed row via the 'update' method. Since the composite key is made up of both the customer id (no problems there) and the county id (which *might* be changed depending on whether or not the user changed the county value), there is a possibility the stored proc will never match the row being updated on account of the fact that the PK is now different (e.g. - a different county id). Possible resolution: Does anyone have any suggestions for dealing with this problem? Some things that jump to mind for me: 1) Modify the sp and the datatable by adding a column to the table that is the equivalent of old county id or something and adding a parameter to the sp that uses the old id value to find the row to update. 2) Not handling this particular update via an adapter, but instead through a series of synchronous calls as each client-side row is changed. 3) Add a surrogate key (autonumbered) in both the db and the typed dataset and use this for additions/changes on the client 4) Add the data column from option 1 client-side thus making it uptyped, and bind to the parameter in the webservice. 5) On an edit of the county id, mark the row being edited for deletion and add a new row with the changed values then push the changes to the web service. Note that I can get the dba to modify whatever I need to be done to solve this issue since the product isn't to market yet. Although I am leaning toward option 1, there are some things I don't like about it. For one, outside callers not going thru our ui might find this new column confusing. Also, it seems like it shouldn't be necessary to address something like this in this fashion. Option 2 doesn't appeal to me at all since the customer config change is really only one of several possible changes to the dataset and I'd really like to keep them together. Option 3 would seem to be the least invasive, but I will be bothering the data architect with this one. Once again, I don't like option 4 because outside callers will have a problem comprehending the meaning. Although option 5, might be confusing, it seems the cleanest of my proposed ideas because we could explain that to outside callers as 'you cannot edit the county id of a config record, only delete it and re-add a new one...' Anyone have any other suggestions? Thanks all, Drew Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138263
  - 6
    - Problem with Restore (SMO) PercentCompleteNotification All, I am using SQL Server Manager Objects (SMO) Restore to restore an SQL Database. All works well however when I set the PercentCompleteNotification = 1 I would of expected the PercentCompleteEventHandler to trigger every one percent, instead it triggers a total 23 times not 100. Yet If I set PercentCompleteNotification = 10 the PercentCompleteEventHandler will trigger ten times which is expected. Does anyone know what the problem is? Thanks in advance. Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138236
  - 7
    - Simple problem: Why does this cause a massive memory leak? Hi all, I have a huge memory leak problem in what is really very simple data insert code. In my app I'm trying to use a typed dataset to insert into a database. It adds quite a few rows (say hundreds). Unfortunately it has a big ass memory leak and I dont understand why. The code below demonstrates the memory leak. It's like nothing is cleaned up after PerformOperation is called. According to .net memory profiler, after running the console app, there are huge numbers of undisposed objects and meory usage is through the roof. I've tried to attach a screenshot from .net memory profiler showing what I mean Any help would be very much appreciated Thanks Simon class Program { static void Main(string[] args) { for (int i = 0; i < 1000; i++) { PerformOperation(); } } private static void PerformOperation() { GPSPositionTableAdapter da = new GPSPositionTableAdapter(); GPSPositionTable tblGPSPositions = new GPSPositionTable(); GPSPositionRow currentRow = null; for (int i = 0; i < 50; i++) { currentRow = tblGPSPositions.NewGPSPositionRow(); currentRow.DownloadID = 1; currentRow.TTUReference = 9999; currentRow.Timestamp = DateTime.Now; currentRow.Latitude = 66.66666666666; currentRow.Longitude = 66.66666666666; tblGPSPositions.AddGPSPositionRow(currentRow); } da.Update(tblGPSPositions); } } Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138233
  - 8
    - Where is the decimal point? Hello. Working on a VS2005 SP1 Windows form program in .NET 2.0, on XP Pro, SP2. I must be pretty stupid. I can't figure out how use decimal data in a table where there is no decimal point. I populated the table with data from a flat file that has a number like this "000001645000". Without the quotation marks of course. The assumed decimal point is five digits from the right. So that number shuould be 0000016.45000. How do i use this decimal in a calculation as 16.45000. I'm not looking to truncate any zeros, left or right, i just want to be able to use it as the value it should be, 16.45. Also, i'm not looking to convert it to a string as 16.45000. I know how to do that. It is stored in the datatable as 1645000. I don't see a decimal point in the table data. Any help would be gratefully appreciated. Thanks, Tony Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138213
  - 9
    - How do you clear a datatable? Hello. Working on a VS2005 SP1 Windows form program in .NET 2.0, on XP Pro, SP2. I have a datatable with no keys and just three columns. How do you clear a datatable to no rows ? I tried : itemsDataTable.Clear() itemsDataTable.AcceptChanges() itemsDataTable.Rows.Clear() itemsDataTable.AcceptChanges() I can load data into it it, but cannot clear it. Searching the internet shows it as that simple. Any help would be gratefully appreciated. Thanks, Tony Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138212
  - 10
    - dataset designer - building data access layer - how to close connect on exception I have been going through some tutorials on using the new dataset designer in Visual Studio 2005 to build dataadapters which include inserts, updates, and deletes...so I don't have to code it all by hand. This tutorial is tutorial #1 located here http://www.asp.net/learn/dataaccess/default.aspx?tabid=63. When I call my dataadapter insert statement, and my insert is invalid (e.g. wrong permissions on my database or trying to insert null value into column that requires value input), I am able to log the exception that is thrown, but my database then 'chokes' because it seems the connection did not get closed properly. The databsae thinks it still has a connection to it. Since I have not hand coded the connection, I don't know how to close it when an exception is thrown (I don't think have access to the connection object). Normally I would close a connection in my finally statement. Please advise. Thanks. Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138209
  - 11
    - SqlCeDataAdapter not running Insert Command... Hi all I am having problems getting my SqlCeDataAdapter to Update the SQL Mobile Data base. i am using C# CF2. I have tried this a number of different ways. Starting with the command builder but eventually i wrote out the entire command my self, and still nothing. The only thing that i can think this that because i am trying to add a table that is created outside the data adaptor and then Merge/Copy the data into the Adaptor so it can be saved. If some one could take a look at the code below and let me know if it should work? Or am I doing something wrong cos I have virtually copied this from the MSDN site and i am getting no errors. Sorry but there is allot of commenting out because of testing and trying different things. Thanks, ink #region OLD CODE DataTable dtAnswers = (DataTable)e.AnswersDataTable; SqlCeCommand oComSelect = null; SqlCeCommand oComInsert = null; //SqlCeCommandBuilder oComBuild = null; DataSet oDS = null; SqlCeDataAdapter oDA = null; //string sSQL = "SELECT [pda_AuRe_AuditResultsID] FROM AuditResults WHERE 1=2"; string sSQL = "SELECT [AuRe_CreatedDate] ,[AuRe_UpdatedDate] ,[AuRe_TimeStamp] ,[pda_AuRe_AuditsID]"; sSQL += " ,[aure_ResultText] ,[aure_ResultValue] ,[aure_AuditHeaderResult] ,[aure_Floor] ,[aure_RoomName] "; sSQL += " ,[aure_Comment] ,[pda_aure_RoomTypeId] ,[pda_aure_SurveyQuestionsID]"; sSQL += " FROM AuditResults WHERE 1=2"; try { oDS = new DataSet(); //Set the Locale for the DataSet. //Use the current culture as the default. oDS.Locale = System.Globalization.CultureInfo.CurrentCulture; oComSelect = new SqlCeCommand(); oComSelect.Connection = DBConnection.GetLocalConnection(); oComSelect.CommandText = sSQL; oDA = new SqlCeDataAdapter(oComSelect); //oDA.SelectCommand = oCom; sSQL = "INSERT INTO [AuditResults] ([AuRe_CreatedDate], [AuRe_UpdatedDate], [AuRe_TimeStamp], [pda_AuRe_AuditsID], "; sSQL += " [aure_ResultText], [aure_ResultValue], [aure_AuditHeaderResult], [aure_Floor], [aure_RoomName], "; sSQL += " [aure_Comment], [pda_aure_RoomTypeId], [pda_aure_SurveyQuestionsID])"; sSQL += " VALUES (?, ?, ?,? ,?, ?,?,?, ?,?, ?,?)"; //sSQL += " VALUES (@AuRe_CreatedDate, @AuRe_UpdatedDate, @AuRe_TimeStamp,@pda_AuRe_AuditsID,@aure_ResultText, @aure_ResultValue,@aure_AuditHeaderResult,@aure_Floor, @aure_RoomName,@aure_Comment, @pda_aure_RoomTypeId,@pda_aure_SurveyQuestionsID)"; oComInsert = new SqlCeCommand(); oComInsert.Connection = DBConnection.GetLocalConnection(); oComInsert.CommandText = sSQL; oComInsert.Parameters.Add(new SqlCeParameter("@AuRe_CreatedDate", SqlDbType.DateTime, 8, "AuRe_CreatedDate")); oComInsert.Parameters.Add(new SqlCeParameter("@AuRe_UpdatedDate", SqlDbType.DateTime, 8, "AuRe_UpdatedDate")); oComInsert.Parameters.Add(new SqlCeParameter("@AuRe_TimeStamp", SqlDbType.DateTime, 8, "AuRe_TimeStamp")); oComInsert.Parameters.Add(new SqlCeParameter("@pda_AuRe_AuditsID", SqlDbType.UniqueIdentifier, 16, "pda_AuRe_AuditsID")); oComInsert.Parameters.Add(new SqlCeParameter("@aure_ResultText", SqlDbType.NVarChar, 500, "aure_ResultText")); oComInsert.Parameters.Add(new SqlCeParameter("@aure_ResultValue", SqlDbType.Int, 4, "aure_ResultValue")); oComInsert.Parameters.Add(new SqlCeParameter("@aure_AuditHeaderResult", SqlDbType.NChar, 1, "aure_AuditHeaderResult")); oComInsert.Parameters.Add(new SqlCeParameter("@aure_Floor", SqlDbType.NVarChar, 50, "aure_Floor")); oComInsert.Parameters.Add(new SqlCeParameter("@aure_RoomName", SqlDbType.NVarChar, 50, "aure_RoomName")); oComInsert.Parameters.Add(new SqlCeParameter("@aure_Comment", SqlDbType.NVarChar, 2000, "aure_Comment")); oComInsert.Parameters.Add(new SqlCeParameter("@pda_aure_RoomTypeId", SqlDbType.UniqueIdentifier, 16, "pda_aure_RoomTypeId")); oComInsert.Parameters.Add(new SqlCeParameter("@pda_aure_SurveyQuestionsID", SqlDbType.UniqueIdentifier, 16, "pda_aure_SurveyQuestionsID")); //oComBuild = new SqlCeCommandBuilder(oDA); //oComBuild.QuotePrefix = "["; //oComBuild.QuoteSuffix = "]"; //oComBuild.SetAllValues = true; //oComBuild.DataAdapter = oDA; //oComInsert = new SqlCeCommand(); //oComInsert = DBConnection.GetLocalConnection().CreateCommand(); //oComInsert.Parameters.Add(oComBuild.GetInsertCommand().Parameters); //oComInsert.CommandText = oComBuild.GetInsertCommand().CommandText; //oDA.InsertCommand = oComInsert; //oDA.InsertCommand.CommandText = oComBuild.GetInsertCommand().CommandText; ////Use the Combo Name for the data table name to. //if (oDS.Tables["Answers"] == null) //{ // //Fill the DataTable People within the DataSet sqlDS // oDA.Fill(oDS, "Answers"); //} //else //{ // // Refresh the Employees DataSet. // oDS.Clear(); // oDA.Fill(oDS, "Answers"); //} //oDS.Tables["Answers"].BeginLoadData(); //oDS.Tables["Answers"].Merge(dtAnswers); //oDS.Tables["Answers"].EndLoadData(); oDS.Tables.Add(dtAnswers.Copy()); //oDA.Update(oDS.Tables["Answers"]); oDA.Update(oDS, "Answers"); oDS.AcceptChanges(); } catch (SqlCeException err) { GlobalErrorHandler.ErrHandler(err, "QA_Audit_QuestionsFinnished"); } catch (Exception err) { GlobalErrorHandler.ErrHandler(err, "QA_Audit_QuestionsFinnished"); } finally { if (oDA != null) { oDA.Dispose(); } } //Close the form when done. this.Close(); #endregion Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138206
  - 12
    - Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Hello Everyone, We have a .net application (1.1 Framework) that uses a strongly typed dataset. The application is in production for over 2 years. One of the users recently reported that when he tried starting the app. in the morning it failed and the logs showed the following error details. After like 10 minutes or so he double clicks the app. and it starts up with no errors. I have tried searching on this issue and most of the threads\articles discuss this issue in development environment. Has any one faced this issue in production environment and most of all how to fix this strange error.?. The Typed dataset in question has two table only in a Master-Detail relationship. Source: System.Data Message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Stack Trace: at System.Data.DataSet.FailedEnableConstraints() at System.Data.DataSet.EnableConstraints() at System.Data.DataSet.set_EnforceConstraints(Boolean value) at System.Data.DataTable.EndLoadData() at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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 Company.DataLayer.API.Database.CreateTradeCache(String ProductID, String reportID) at Company.DataLayer.API.Database.CreateReportCache(String ProductID, String reportID) at Company.DataLayer.API.Database.CreateUserCache(String userName) at Company.DataLayer.API.Database.Login(String userName, Boolean NotificationRequired) Any help will be appreciated. Nadeem Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138202
  - 13
    - Invalidate disconected recodset Hi, We would like to use MS SQL Server Express database for out data. The data can be updated by many clients. There will be an application that will show these data. This application can work with the disconnected recordest. My question is, how to notify this application, about the data in recordset are not valid anymore, because the table in the database had been changed by a client? As I understand, I can not use Notification Services with SQL Express. 1/ Is the trigger that would send message to the Service broker suitable for this scenario? 2/ Can I use Event notification? I think they donâ??t work with DML 3/ What would be the best way to inform *.exe app that the disconnected recodset is not valid? Thanks for any ideas. Lubomir Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138201
  - 14
    - SqlServer ntext truncated Hi all I am inserting data into an ntext column in SqlServer 2000 but it is being truncated. In every StackTrace and Steps column (the only 2 ntext columns) I am seeing the text truncated to about 255 chars. Can anyone tell me why this is, and maybe how to solve the problem? Thanks Pete InsertLogCommand = Connection.CreateCommand(); InsertLogCommand.CommandText = "Insert into ErrorLog (DataFromPPC, DateTime, Description, Steps, StackTrace) values (@DataFromPPC, @DateTime, @Description, @Steps, @StackTrace)"; parameter = new SqlParameter(); parameter.ParameterName = "@DataFromPPC"; parameter.SqlDbType = System.Data.SqlDbType.Int; InsertLogCommand.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.ParameterName = "@DateTime"; parameter.SqlDbType = System.Data.SqlDbType.DateTime; InsertLogCommand.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.ParameterName = "@Description"; parameter.SqlDbType = System.Data.SqlDbType.VarChar; InsertLogCommand.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.ParameterName = "@Steps"; parameter.SqlDbType = System.Data.SqlDbType.VarChar; InsertLogCommand.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.ParameterName = "@StackTrace"; parameter.SqlDbType = System.Data.SqlDbType.VarChar; InsertLogCommand.Parameters.Add(parameter); while ...... { InsertLogCommand.Parameters["@DateTime"].Value = logDateTime; InsertLogCommand.Parameters["@DataFromPPC"].Value = archiveID; InsertLogCommand.Parameters["@Description"].Value = description; InsertLogCommand.Parameters["@Steps"].Value = steps; InsertLogCommand.Parameters["@StackTrace"].Value = stackTrace; InsertLogCommand.ExecuteNonQuery(); } Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138196
  - 15
    - compiler error during scripting Oracle stored procedure How to find out or catch compiler error during scripting stored procedure via OracleCommand class? E.g. OracleCommand _oracleCommand = new OracleCommand(); ...... StringBuilder sb = new StringBuilder(); sb.AppendLine("create or replace procedure test_proc(var_number in number) as"); sb.AppendLine("begin"); sb.AppendLine(" insert into test_table (data) values (var_number);"); sb.AppendLine(" any wrong code;"); sb.AppendLine("end;"); _oracleCommand.CommandText = sb.ToString(); _oracleCommand.Connection.Open(); _oracleCommand.ExecuteNonQuery(); _oracleCommand.Connection.Close(); ADO .NET throws no exception, bu stored procedure is not valid. Is any solution? TIA Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138194
  - 16
    - Small problem with storing connection strings Hi all, I have a data access library project within which I have created a number of datasets. In one of the datasets I've added a number of strongly typed datatable/tableadapters and configured them to use a connection string that has been stored in a settings file. The problem I'm having is that wehn I open another dataset and try and create a new table adapter (or modify an existing one) it won't let me select the connection string that I've already added to the settings file. It will add another connection string to the same settings file - but it wont let me use the one I've already added. Can anyone please tell me how I can get the damn thing to use only one connection string as this is making deployment an absolute nightmare. Thanks to anyone who can advise Simon Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138191
  - 17
    - Data Addaptor Not updating database?? Can some on tell me what i am missing please. Hi all The Code is below but i will give you a brief over view first. I am using C#, SQL Mobile and the CF2.0 with Merge Replication. My Primary Keys are all "uniqueidentifier" types with default value of (newsequentialid()) . Problem is I am trying to save the results for a questioner to a Results table and it does not work. I have built a windows mobile control that all seems to be working fine when the questions are completed it raises the event you see below handing out a Data Table with all the answers in it. I then open up a blank Data Table in a Data Set and merge the Data from the Answers Data Table to the Blank Data Table. This all seems to work fine, i have checked it by viewing the count, After i have Merged the count is 18 on both tables which is correct. But it is like when i call the Data Adaptor Update nothing is going into the database and there is no error. I have tried both oDA.Update(oDS.Tables["Answers"]); And oDA.Update(oDS); But still not saving. And as you can see below i have set up a command builder. My other concern is that the Primary Key is a Auto Generated "uniqueidentifier" column. With a default value of (newsequentialid()). And this column seems to be blank the whole time. Perhaps it only Generates the GUID when the Data Adaptor is updated? Any help would be welcome ### CODE ### private void QA_Audit_QuestionsFinnished(object sender, QuestionAnswerControl.QuestionsFinnishedEventArgs e) { DataTable dtAnswers = (DataTable)e.AnswersDataTable; SqlCeCommand oCom = null; SqlCeCommandBuilder oComBuild = null; DataSet oDS = null; SqlCeDataAdapter oDA = null; string sSQL = "SELECT * FROM AuditResults WHERE 1=2"; try { oDS = new DataSet(); //Set the Locale for the DataSet. //Use the current culture as the default. oDS.Locale = System.Globalization.CultureInfo.CurrentCulture; oCom = DBConnection.GetLocalConnection().CreateCommand(); oCom.CommandText = sSQL; oDA = new SqlCeDataAdapter(oCom); oComBuild = new SqlCeCommandBuilder(); oComBuild.DataAdapter = oDA; //Use the Combo Name for the data table name to. if (oDS.Tables["Answers"] == null) { //Fill the DataTable People within the DataSet sqlDS oDA.Fill(oDS, "Answers"); } else { // Refresh the Employees DataSet. oDS.Clear(); oDA.Fill(oDS, "Answers"); } oDS.Tables["Answers"].BeginLoadData(); oDS.Tables["Answers"].Merge(dtAnswers); oDS.Tables["Answers"].EndLoadData(); oDS.AcceptChanges(); oDA.Update(oDS.Tables["Answers"]); } catch (SqlCeException err) { GlobalErrorHandler.ErrHandler(err, "QA_Audit_QuestionsFinnished"); } finally { if (oDA != null) { oDA.Dispose(); } } //Close the form when done. this.Close(); } ### END CODE #### Thanks, ink Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138186
  - 18
    - Linefeed in Datacolumn.Expression Hello ng I edit the field expression with '\n' or '\r\n' in the property-designer of the dataset/datacolumn. At runtime in the datagrid I miss the linebreak. The charaters '\n' or '\r\n' were shown in the datagrid. How can I include a linebreak in the Datacolumn.Expression from a typed dataset? I hope you can help me! Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138185
  - 19
    - Refresh not working on TableAdapter Okay, so I've read various articles on setting up a TableAdapter to retrieve a newly generated identity column value back into the dataset after an insert. However, I'm having issues with the dataset actually getting updated. I swear this was working Monday, but once I thought it was working, I moved on to get my updates and deletes working, and now today when I ran my final tests the refresh after insert is not working :( So here is what I did: Right-clicked on the TableAdapter and chose "Add Query". I selected an "INSERT" for my new query and I left the default generated SQL for the insert as is, which came out like this (admittedly I'm typing this by memory so may not be exact, but basically I left it as is): INSERT INTO [dbo].[mytable] ([column1],[column2]) VALUES (@column1, @column2); SELECT [keycolumn], [column1], [column2] FROM [dbo].[mytable] WHERE ([keycolumn] = SCOPE_IDENTITY()) So then I name this new insert "InsertSingleRecord" (I've tried this with the InsertSingleRecord set to "NonQuery" and "Scalar"; of course, when I set it to scalar, I can retrieve the identity as a return value from InsertSingleRecord if I change the SELECT to "SELECT SCOPE_IDENTITY()" however it does me no good since at that point row.keycolumn is read-only so I can't manually update it myself with the real value. Later in my code I have something like this: mytableadapter.InsertSingleRecord( row.column1, row.column2 ); I'm leaving out some stuff for brevity, and if you think it matters let me know and I'll post it, but suffice to say, after the InsertSingleRecord call completes, if I examine row.keycolumn, I can see that it has NOT been refreshed after the insert completed (and I verified the insert was successful). This is the case immediately after the insert finishes, and even after all inserts have completed and I have called AcceptChanges(). Does the refresh not work when you use these custom inserts as opposed to just calling TableAdapter.Update(...)? I swear I had this working like a charm on Monday before I started on my updates/deletes; maybe I imagined it... Any help or suggestions appreciated. Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138184
  - 20
    - How to create own DataColumn Aggregate function 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 Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138182
  - 21
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138181
  - 22
    - "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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138174
  - 23
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138170
  - 24
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138169
  - 25
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138162
- Next
  - 1
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138160
  - 2
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138159
  - 3
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138158
  - 4
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138154
  - 5
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138149
  - 6
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138147
  - 7
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138144
  - 8
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138136
  - 9
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138133
  - 10
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138132
  - 11
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138131
  - 12
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138130
  - 13
    - how to get row number from DataTable.Compute method how do you get the row number from the DataTable Compute() method? Thanks Tag: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138129
  - 14
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138118
  - 15
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138108
  - 16
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138107
  - 17
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138106
  - 18
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138099
  - 19
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138087
  - 20
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138085
  - 21
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138084
  - 22
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138079
  - 23
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138075
  - 24
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138074
  - 25
    - 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: ORA-00917 missing comma when using OleDb to insert chinese character Tag: 138070

I have a program using OleDbCommand to insert some chinese character
information into Oracle Database.
It runs normal except when data contains a particular chinese
character "=A6=E2" and the exception message is ORA-00917 missing comma.

This is so strange for me since this is a very simple chinese
character and it could be inserted when I tested with other
applications(i.e. Oracle Financials).
Is this the problem of OleDbCommand of .Net?
Any idea?

Thanks and Regards,
Cherry

Top

Re: ORA-00917 missing comma when using OleDb to insert chinese character by Miha

Miha
Mon Mar 19 05:02:35 CDT 2007

Hi,

Use parametrised commands (send values using parameters) and you'll be
(probably) fine.

--
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/

"cherry" <cherryparadise001@gmail.com> wrote in message
news:1174295658.638205.312690@d57g2000hsg.googlegroups.com...
I have a program using OleDbCommand to insert some chinese character
information into Oracle Database.
It runs normal except when data contains a particular chinese
character "¦â" and the exception message is ORA-00917 missing comma.

This is so strange for me since this is a very simple chinese
character and it could be inserted when I tested with other
applications(i.e. Oracle Financials).
Is this the problem of OleDbCommand of .Net?
Any idea?

Thanks and Regards,
Cherry

Top