Problem with Restore (SMO) PercentCompleteNotification

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
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138233
  - 2
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138213
  - 3
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138212
  - 4
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138209
  - 5
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138206
  - 6
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138202
  - 7
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138201
  - 8
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138196
  - 9
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138194
  - 10
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138191
  - 11
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138186
  - 12
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138185
  - 13
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138184
  - 14
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138182
  - 15
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138181
  - 16
    - "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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138174
  - 17
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138170
  - 18
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138169
  - 19
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138162
  - 20
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138160
  - 21
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138159
  - 22
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138158
  - 23
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138154
  - 24
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138149
  - 25
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138147
- Next
  - 1
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138144
  - 2
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138136
  - 3
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138133
  - 4
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138132
  - 5
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138131
  - 6
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138130
  - 7
    - how to get row number from DataTable.Compute method how do you get the row number from the DataTable Compute() method? Thanks Tag: Problem with Restore (SMO) PercentCompleteNotification Tag: 138129
  - 8
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138118
  - 9
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138108
  - 10
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138107
  - 11
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138106
  - 12
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138099
  - 13
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138087
  - 14
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138085
  - 15
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138084
  - 16
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138079
  - 17
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138075
  - 18
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138074
  - 19
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138070
  - 20
    - SQLBulkCopy and SQL Server 2000? Hi all, Does .NET 2.0's SQLBulkCopy class work with SQL Server 2000? Thanks! Tag: Problem with Restore (SMO) PercentCompleteNotification Tag: 138064
  - 21
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138060
  - 22
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138058
  - 23
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138057
  - 24
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138051
  - 25
    - 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: Problem with Restore (SMO) PercentCompleteNotification Tag: 138050

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.

Top

Re: Problem with Restore (SMO) PercentCompleteNotification by David

David
Sun Mar 18 09:12:14 CDT 2007

"Scott" <Scott@discussions.microsoft.com> wrote in message
news:0BE03A8B-2CDF-4657-969D-52AE18898E02@microsoft.com...
> 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?
>

The backup and restore percent complete messages aren't guaranteed to fire
exactly on the target percent. The PercentCompleteEventArgs has the percent
complete value, which should be accurate.

David

Top

Re: Problem with Restore (SMO) PercentCompleteNotification by Scott

Scott
Sun Mar 18 17:05:02 CDT 2007

David,

Your answer was of great help.
I was able to connect this handler properly to a progress bar which now
reports the correct percentage.
Thanks.

Scott

> The backup and restore percent complete messages aren't guaranteed to fire
> exactly on the target percent. The PercentCompleteEventArgs has the percent
> complete value, which should be accurate.
>
> David
>
>

Top