SQLDMO Code Sometimes Works

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
    - DataSet and Stringbuilder? Hi expert, I received a sample from bank for the header record in the output file (attached at the bottom). I want to use same method to have a stringbuilder to arrange the fix length positions, and the fields will be retrieved from database and put into the dataset. But I am familiar at how to use dataset and put into .insert stringbuilder. Here is the code that I am working on (the function should return 1 string line at a time. The loop of reading rows will be controled in main form): Can someone show me how to retrieve a column, say LastName and put into strResult.Insert()??? Thanks. Imports System.Data.SqlClient Module Module1 Public Function GenerateA(ByRef strEmpID As String, ByRef strClientAcct As String, ByRef strAcctStatus As String, ByRef strAddressFlag As String, ByRef strNameFlag As String) Dim strResult As New System.Text.StringBuilder Dim GPConnection As SqlConnection Dim dr As SqlDataReader Dim GPDataset As New DataSet GPConnection = New SqlConnection("............................") Dim GPDataAdapter As New SqlDataAdapter("SELECT LASTNAME,FRSTNAME,MIDLNAME,PHONE1,BRTHDATE FROM UPR00102 where EmployID="+strEmpID,GPConnection) Try GPConnection.Open() GPDataAdapter.Fill(GPDataset, "AcctInfoTble") Dim DS As DataSet = New DataSet 'position 1 20A strResult.Insert ????????????????? Catch ex As Exception MessageBox.Show(ex.ToString) Finally GPConnection.Dispose() End Try Return strResult.ToString End Function End Module ------------------------------------------------------------------------------------- Module GenerateFile Public Function GenerateFH(ByRef strCompanyName As String, ByRef strTopCorp As String, ByRef strBatchNum As String, ByRef dtFileDate As Date) Dim strResult As New System.Text.StringBuilder strResult.Capacity = 731 'Position 1 2A FH strResult.Insert(0, "FH") 'Position 3 10A Header Date strResult.Insert(2, dtFileDate.Date.Year & "/" & dtFileDate.Date.Month.ToString.PadLeft(2, "0") & "/" & dtFileDate.Date.Day.ToString.PadLeft(2, "0")) 'Position 13 8A Header Time strResult.Insert(12, dtFileDate.TimeOfDay.Hours.ToString.PadLeft(2, "0") & ":" & dtFileDate.TimeOfDay.Minutes.ToString.PadLeft(2, "0") & ":" & dtFileDate.TimeOfDay.Seconds.ToString.PadLeft(2, "0")) 'Position 21 10A Transfer File Version strResult.Insert(20, "4.0".PadRight(10, " ")) 'Position 31 10A Product Type strResult.Insert(30, "EFUNDS".PadRight(10, " ")) ............. Return strResult.ToString End Function End Module --------------------------------------------------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: SQLDMO Code Sometimes Works Tag: 100394
  - 2
    - Moving solution to another machine, SQL Failure Hi all, I've developed a .NET 2003/SQL Server 2000 application. When the app fires up, it loads combo boxes (Using SQLDMO) with available servers, databases and tables. It works great. However, when I move the solution to another PC and try to run it, it fails saying "Login failed for user DEVONE\Guest'. DEVONE is the name of the machine where I developed the application, which is running SQL Server 2000 Developer. No where in my code does it reference DEVONE, so somewhere a reference to the previous machine name or SQL Server instance name is being held in the solution. Any ideas? Thanks Michael Tag: SQLDMO Code Sometimes Works Tag: 100390
  - 3
    - GetChanges false positives, How to avoid? I was curious if anybody know of a way to avoid false positives while using the GetChanges method. In most of my updateable aspx pages I have text/ddl/checkboxes that are populated from the existing data that the user can change, then hit the save/update button. When the save/update button is clicked the dataset is updated from the controls values regaurdless if the values in the controls have changed or not. Such as ds.Table1.Col1 = TextBox1.Text; // set whether text has changed or not. ds.Table1.Col2 = TextBox2.Text; The problem arises when a user hits the save/update button without changing anything on the page. This means that all the values in the dataset get set to exactly what they were before; however, the GetChanges returns rows with no real changes in them. Take the following code. The last GetChanges always returns 1 row even though no values in the row have changed. Dataset1 ds = new Dataset1(); Dataset1.UsersRow r = ds.Users.NewUsersRow(); string s = "asdf"; r.UserName = s; r.UserID = 1; ds.Users.Rows.Add(r); ds.AcceptChanges(); DataTable dt = ds.Users.GetChanges(); if(dt != null) Console.WriteLine("# of changed rows " + dt.Rows.Count); ds.Users[0].UserName = s; // change the value to exactly what it was. dt = ds.Users.GetChanges(); if(dt != null) Console.WriteLine("# of changed rows " + dt.Rows.Count); Any help is appreciated, EntDevGuy Tag: SQLDMO Code Sometimes Works Tag: 100388
  - 4
    - SchemaTable I'm using the following code to obtain information about any table in a database. Now _schemaTable contains the info about the table and one of its fields is "IsKey" which as far as I know should identify the columns that are the primary keys in the table. Unfortunately "IsKey" is always false for me even though some columns are the primary keys. Why is that? Is there something I'm doing wrong or something that I'm not doing? Some of the other information in the _schemaTable such as "ColumnName" is correct for each of the columns in the table. The following is the code sample: Thanks for help in advance. Tom. System.Data.IDataReader reader; this._Command.CommandText = "SELECT * FROM [" + tableName + "]"; reader = _Command.ExecuteReader(System.Data.CommandBehavior.SingleRow); _schemaTable = reader.GetSchemaTable(); Tag: SQLDMO Code Sometimes Works Tag: 100385
  - 5
    - Row-wise vs columnwise If I need to iterate through all the field values in a dataset, is there any preference for organising the outer iterations by row or by column . ie should I do (in VB.Net): For i as integer = 1 to table(0).columns.count For j as integer = 1 to table(0).rows.count ......... Next j Next i or swap columns or rows, or is it immaterial? TIA JGD Tag: SQLDMO Code Sometimes Works Tag: 100383
  - 6
    - SqlException - Help pls Using SQLServer database. UserId defined as numeric and First/LastName fields defined as nvarchar(50). Here is my SQL Statement: SELECT UserId, LastName & ', ' & FirstName AS FullName FROM Users ORDER BY LastName, FirstName; What does this error mean? Server Error in '/Test' Application. ________________________________________ Invalid operator for data type. Operator equals boolean AND, type equals nvarchar. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid operator for data type. Operator equals boolean AND, type equals nvarchar. Source Error: Line 136: End If Line 137: Line 138: Dim dr As SqlDataReader = MySqlHelper.ExecuteReader(CONNECTION_STRING, CommandType.Text, strSql) Line 139: Line 140: Return dr Source File: c:\inetpub\wwwroot\Test\Components\dbUsers.vb Line: 138 Stack Trace: [SqlException: Invalid operator for data type. Operator equals boolean AND, type equals nvarchar.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText) Test.dbUsers.GetAllUsers(Int32 UserId) in c:\inetpub\wwwroot\Test\Components\dbUsers.vb:138 Test.ManageUsers.FillUsersDdl() in c:\inetpub\wwwroot\Test\Secured\ManageUsers.aspx.vb:139 Test.ManageUsers.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\Test\Secured\ManageUsers.aspx.vb:59 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731 ________________________________________ Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Tag: SQLDMO Code Sometimes Works Tag: 100382
  - 7
    - How to effiently load many, many SQL records I have a need to effiently load millions of fairly small records into SQL Sever 2000. I have some financial data with many, many observations (one set has 37 million records) and I need to get it into a SQL server. I create a comma separated variable (CSV) file using a VB.NET program acting on the raw data. I have tried importing it into SQL Server using DTS import, but it says that it completes after about 18 million records, with no error. Using Visual Studio 2004 VB, I wrote a windows program that uses a SQL dataadapter to the table I want to insert records in, set the field parameters to the generated SQL insert command and then call ExecuteNoQuery to insert each record. This process works, but is seems to take forever to create a lot of records this way. I am fairly well versed in VS 2003 and VB.NET, but I am new to using these tools to load so many records. I must be doing something wrong or not using the appropriate technique to do this. Any help will be appreciated. Thanks! Bill Patterson UW-Madison School of Business Tag: SQLDMO Code Sometimes Works Tag: 100378
  - 8
    - Navigating child rows of a relationship Hi there, Here's my problem : I have 2 tables with a one-to-many relationship. I setup the relationship via the dataset component. ParentTable : Parentkey col1 col2 ChildTable : Childkey ParentKey col1 col2 I Have setup the databindings like this : textBox1.DataBindings.Add("Text",ds,"ParentTable.Parentkey"); textBox2.DataBindings.Add("Text",ds,"ParentTable.col1"); textBox3.DataBindings.Add("Text",ds,"ParentTable.col2"); textBox4.DataBindings.Add("Text",ds,"ParentTable.MyRelation.Childkey"); textBox5.DataBindings.Add("Text",ds,"ParentTable.MyRelation.Parentkey"); textBox6.DataBindings.Add("Text",ds,"ParentTable.MyRelation.col1"); textBox7.DataBindings.Add("Text",ds,"ParentTable.MyRelation.col2"); I setup a currency manager to track position and navigate in the dataset like this : myCurrency = (CurrencyManager)this.BindingContext[ds,"ParentTable"]; myCurrency.Position = 0; The events to navigate through the ParentTable rows are as follows : private void navPrevious_Click(object sender, System.EventArgs e) { if(myCurrency.Position != 0) { myCurrency.Position -= 1; } } private void navNext_Click(object sender, System.EventArgs e) { myCurrency.Position += 1; } My question is : since the ParentTable can have one or many chlidren, how can i navigate (Navigate next, previous,etc ) through these rows ? Do i have to setup another currency manager ? I tried this : myCurrency2 = (CurrencyManager)this.BindingContext[ds,"TableParent.MyRelation"]; myCurrency2.Position = 0; This doesn't seem to work if i setup the events like this : private void navPrevious_Click(object sender, System.EventArgs e) { if(myCurrency2.Position != 0) { myCurrency2.Position -= 1; } } private void navNext_Click(object sender, System.EventArgs e) { myCurrency2.Position += 1; } What am i doing wrong ? Is there a solution ? Thanks a lot for the help. Tag: SQLDMO Code Sometimes Works Tag: 100375
  - 9
    - Connection Pool Hello, Is it ado provider by default do the connection pooling? or it is depending on the database. I know sqlclient provider does the connection pooling but can I use connection pooling with MYSQL? thanks ap Tag: SQLDMO Code Sometimes Works Tag: 100371
  - 10
    - All data is text in ADO Update to Excel... I am updating several excel worksheets using ADO.NET (OLEDB objects). = Everything is working fine except all the data is inserted as text = despite being typed in the DataTable object and when the Excel worksheet = was actually created. If the user-specified Excel Workbook does not exist, one is created and = worksheets are added using "CREATE TABLE" statements with type-specific = data columns. The data type for each column is specified in the = DataTable object as well as the actual "CREATE TABLE" SQL statement. However, if the user-specified workbook already exists, the worksheets = will be updated correctly, but all data will be inserted as text values = regardless of how it is typed in the DataTable. Any help, suggestions, or advice would be greatly appreciated. - Carl Tag: SQLDMO Code Sometimes Works Tag: 100367
  - 11
    - Cascade without relation I have two datatables, dtTable1 has an INDENTITY column, dtTable2 has a integer column to have the value of table1 indentity column but it can be null. so I can't create the relation between tables (unless there is some kind of ignore null relation). Now when I add new row to dtTable1, then add new row to dtTable2 with the same indentity value (of cause a temp value, will change in dtTable1 when save to database) from dtTable1, is there any way to cascade value to dtTable2 when I save data into database? Please... Wei Tag: SQLDMO Code Sometimes Works Tag: 100363
  - 12
    - ADO.NET text driver not importing data as text I have the following comma delimited file to read: Date,campaign code,count 12/1/2004,DM31,10 12/1/2004,DM32,15 12/1/2004,DM33,20 12/1/2004,DM34,25 12/1/2004,DM35,30 I'm using the ADO.NET, System.Data.Odbc namespace to create and ODBCConnection to this file and read it using the following (simplified) code. Dim cn As New OdbcConnection("Driver={Microsoft Text Driver (*.txt; _ *.csv)};DefaultDir=d:\websites\jpg\dataimport;") Dim cmd As New OdbcCommand ("select * From cfr.csv") Dim myreader As OdbcDataReader cn.open() cmd.connection = cn myreader = cmd.executereader() response.write("<table>") While myreader.read() response.write("<tr><td>" & myreader.getstring(0) & "</td><td>" & _ myreader.getstring(1) & "</td><td>" & _ myreader.getstring(2) & "</td></tr>") End While response.write("</table>") cn.close() It outputs the following: 2004-12-01 00:00:00 31.0000 10 2004-12-01 00:00:00 32.0000 15 2004-12-01 00:00:00 33.0000 20 2004-12-01 00:00:00 34.0000 25 2004-12-01 00:00:00 35.0000 30 It converted the second field to a numeric value. I can get it to treat the field as character data if I put the values inside quotes but I don't have control of this file, it's delivered to me from a third party as is. Is there anyway to get it to read the data as plain character data without modifying the file? --Buddy Tag: SQLDMO Code Sometimes Works Tag: 100360
  - 13
    - DateTimePicker problem with .AddNew Hi! My Windows Form contains DateTimePicker to show date-type data from DataTable. Because application need to be able to save "no date" ie. NULL into database table, I solved it like way... ("dtpRepaired" is DateTimePicker-control) dtpRepaired.Checked = Not IsDBNull(dt.Rows(cm.Position)("Repaired")) If dtpRepaired.Checked Then dtpRepaired.Value = Date.Parse(dt.Rows(cm.Position)("Repaired").ToString()) End If Private Sub dtpRepaired_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dtpRepaired.TextChanged dt.Rows(cm.Position)("Repaired") = IIf(dtpRepaired.Checked, dtpRepaired.Value, DBNull.Value) End Sub ...because I didn't succeeded to do this like this way bounding it directly to the DataTable... 'dtpRepaired.DataBindings.Add(New Binding("Text", dt, "Repaired")) This is almost working fine, but it occurs an error after cm.AddNew when trying to change dtpRepaired-controls value or Checked-state. Error message is: "There is no row at Position 5.". I understand this why, but don't know how I could solve to make it possible to "add new" and make it possible to edit dtpRepaired too without this problem. Any succestions? Is it really impossible to bound DateTimePicker-control to DataTable, and make it possible to change date in DataTable to "NULL" ? Hopefully you understand my problem with my poor english, I'm finnish :) -- Thanks in advance! Mika Tag: SQLDMO Code Sometimes Works Tag: 100358
  - 14
    - Problem catching exception from a procedure Hi! I wrote a procedure in my sybase database this procedure is one line only, and attemp to insert a record in a table generating a constraint violation of a primary key and an exception. I do this only for test... then when I call the procedure from .net: com.Connection = conn com.CommandType = CommandType.StoredProcedure com.CommandText = "PRUEBA" Dim valor Try conn.Open() com.ExecuteNonQuery() Catch ex As System.Data.OleDb.OleDbException ms = ex.Message finally conn.Close() End Try there is not excetion catch!!! , I try several code modification whitout result... Tag: SQLDMO Code Sometimes Works Tag: 100351
  - 15
    - SqlDataAdapter aand transaction Hello, I'm using SqlDataAdapter to insert data from one table into another with SqlCommand after I start a transaction. If I have convertion error for the insertion of the data, The transaction is no longer valid, I'ts rolled back. Is there a property to leave the transaction open ? my code : SqlTransaction trans = m_Conn.BeginTransaction(); SqlCommand oCmd1 = new SqlCommand("Insert into tbl1(col1) select col1 from tbl2", m_Conn); oCmd1.Transaction = trans; oCmd1.ExecuteNonQuery(); Thanks, Sharon Tag: SQLDMO Code Sometimes Works Tag: 100349
  - 16
    - DataSet, new row and default values ? When I add a new row to a DataSet that was filled with info from a database the new row does not get the default values defined in SQL Server, how do I accomplish this seemingly simple task ? I don't want to have to fill in the default values in the row first, I want it to understand the defaults set in the database and fill it automatically as you would expect it to. Thank you PL. Tag: SQLDMO Code Sometimes Works Tag: 100348
  - 17
    - Best aproach to update DataAdapters with XML-Data Hi all What's the best aproach to import xml-based data into an oracle 9i database with ado.net DataAdapters, when the data is in an xml-file? The operations should insert new rows and update changed rows. Does ado.net provide some automatisms for this or do i have to do this with functions written myself? Is there anywhere some example code? Thank you Adrian Tag: SQLDMO Code Sometimes Works Tag: 100347
  - 18
    - Help ... I need somebody Help I have create such a DB -> look at the end: And I would like to have a 2 comboboxes in which I could select all Prog_Id And Profile_Id and in this way modified datasource in each of Rows in table Progs and aloso 6 textboxes to display and modified datasource in each of rows in Profile_Base. How it can be done in the fastest way ?? It is really urgent, beacuse i sit on it 3 days !! Thanks in advance ----------------------------------------- CREATE DOMAIN For_Prog_ID AS VARCHAR(20); CREATE DOMAIN For_SubProgs As VARCHAR(20); CREATE TABLE Profile_Base( Profile_ID For_SubProgs NOT NULL PRIMARY KEY, Param_1 FLOAT, Param_2 FLOAT, Param_3 FLOAT, Param_4 FLOAT, Param_5 FLOAT, Param_6 FLOAT ); CREATE TABLE Progs ( Prog_ID For_Prog_ID NOT NULL PRIMARY KEY, Profile_S1 For_SubProgs, Profile_S2 For_SubProgs, Tenon_S1_S1 For_SubProgs, Tenon_S1_S2 For_SubProgs, Tenon_S2_S1 For_SubProgs, Tenon_S2_S2 For_SubProgs, FOREIGN KEY (Profile_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Profile_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S2_S1) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID) ON UPDATE CASCADE ON DELETE CASCADE ); -------------------------------- *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: SQLDMO Code Sometimes Works Tag: 100344
  - 19
    - How To Recursively Search Directories by Using C# .NET I've found this script on microsoft site that searches for file with given extension, its window based. How can i convert it to make it web based? I am looking for a c# script that will search a particular drive with given file extension and email the search result. http://support.microsoft.com/default.aspx?scid=kb;en-us;303974 Please help.. many thanks in advance. Tag: SQLDMO Code Sometimes Works Tag: 100340
  - 20
    - Updating table at a different database Hello, I'm using SqlDataAdapter to get records from table at database different from my connection using the databasename at the select statment "Select * from otherdb..myTable" After updating the data I want to update the table, I'm using SqlCommandBuilder to set the UpdateCommand at the SqlDataAdapter. But when I use the SqlDataAdapter.Update I get an error : "Invalid object name 'myTable'" I tried to change the UpdateCommandText to "Update otherdb..myTable ..." but it's not working. I don't want to use another connection. Is there a way of making it work? Thanks, Sharon. Tag: SQLDMO Code Sometimes Works Tag: 100336
  - 21
    - Printing excel files Hi. Can anybody help me on how to print excel files that has been read via ADO.NET. Or anyway, what I want to avoid is automation (instantiating an excel application object). Hopefully, there is way aroudn this.. Thanks in advance. Tag: SQLDMO Code Sometimes Works Tag: 100324
  - 22
    - higher reads when using ADO.NET thatn when using Query Analyzer I was doing some testing and noticed that when I execute a stored procedure from my ADO.NET (using the Command class of the System.Data.SQLClient namespace) the number of reads on a relatively simple query were significantly higher. As a matter of fact I have not found a case where the reads when executed from ADO.NET are lower than the reads when executing in QA. Sometimes they may be the same but QA is always has equal or fewer reads. Any reason why this is and is there any thing I can do to get ADO.NET to perform like QA? --Buddy Tag: SQLDMO Code Sometimes Works Tag: 100317
  - 23
    - OleDbConnection problem with more than 1 connection Hi, I had wrote 2 app in c#.net one Windows Form base and one Web Base and those 2 connect to a access database and some time I got this error in my web base application and I can't figure out what's wrong, I just hit reload and it's work Thanks for your time Sylvain Bissonnette Server Error in '/WebApplication1' Application. Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. Source Error: Line 77: // Open database connection Line 78: OleDbConnection MyConn = new OleDbConnection(ConnectionString); Line 79: MyConn.Open(); Line 80: Line 81: // Create the data adapter and execute the query Source File: C:\Inetpub\wwwroot\WebApplication1\Light.aspx.cs Line: 79 Stack Trace: [OleDbException (0x80004005): Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 WebApplication1.Light.MyDataGrid_ItemCommand(Object source, DataGridCommandEventArgs e) in C:\Inetpub\wwwroot\WebApplication1\Light.aspx.cs:79 System.Web.UI.WebControls.DataGrid.OnItemCommand(DataGridCommandEventArgs e) +110 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +68 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +106 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +121 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Tag: SQLDMO Code Sometimes Works Tag: 100315
  - 24
    - Command Builder in tables without primary key Hi every one, i'm trying to use a sqlcommandbuilder in an application using a table without a primary key, when i call the DataAdapter.Update Method there comes an Error saying that "the selectcommand does not return information about the primary key" or some thing like that... Does some one knows a way to implement the command builder or similar method to work around on updating tables with out primary key?? Tag: SQLDMO Code Sometimes Works Tag: 100306
  - 25
    - SqlHelper.UpdateDataSet with transaction Hi, I'm trying to use the SqlHelper.UpdateDataSet method with transactions. The DAAB 2.0 documentaion only say: "SqlHelper.UpdateDataset does not include transaction support. If you need this, you can implement it yourself by a preceding call to the helper method SqlHelper.ExecuteScalar("begin transaction")." but I didn't find any matching overload in the ExecuteScalar method. What would be the correct way of using the UpdateDataSet with transaction? Thanks, Gwenda Tag: SQLDMO Code Sometimes Works Tag: 100293
- Next
  - 1
    - encapsulating SQL queries into OO framework Right now I'm putting my query strings into static functions in a DbQuery class that returns Datatables. Eg. public class DbQuery { public static Datatable GetMyData() { Dataset ds; ... string query = "select * from SomeTable"; .... return ds.Tables[0]; } } Over time, I'm accumulating a lot of static methods in my DbQuery class. This way seems very procedural. I'm trying to make it more object oriented. Any recommendations on how to encapsulate individual queries into a more object oriented framework? Tag: SQLDMO Code Sometimes Works Tag: 100291
  - 2
    - How to update one table based on a match found in another Hi I'm trying to figure out the best way to perform a simple but repetitive task in vb.net. Access DB with 2 tables: first table - a list of phone numbers not to call and a table holding contact information. Both tables have a 'telephone' column and I need to set a logical flag = 1 in the second table only if a match is found in the first. I've tried using a single Dataadapter for each and two Datasets and every other combination. I've even tried example code from MS (KB Q308057) but this doesn't work. However, when I try to retrieve a record it all falls apart and vb.net throws a relation exception that I cannot fathom out. I know I can run a simple update query - but want to do this programatically. If anyone can throw me a bone or suggest a place to start again - I really would appreciate any help. With thanks Tag: SQLDMO Code Sometimes Works Tag: 100284
  - 3
    - MSDN Webcast: Introducing ADO.NET 2.0 for SQL Server 2005 We'll host a webcast on ADO.NET 2.0 & SQL Server 2005 next week. I thought you guys might be interested. For more information you can check out: http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032263284&Culture=en-US This is part of a webcast series on SQL Server that will take place during the week. For more information about the series you can look at: http://msdn.microsoft.com/sql/2005webcasts/default.aspx Thanks, -- Pablo Castro Program Manager - ADO.NET Team Microsoft Corp. This posting is provided "AS IS" with no warranties, and confers no rights. Tag: SQLDMO Code Sometimes Works Tag: 100282
  - 4
    - DataObjects.NET OR mapping, any opinions ? Hajo, I consider to use DataObjects.NET (http://www.x-tensive.com/Products/DataObjects.NET/) and I need any opinions about this solution. 1. Is is mature enaugh to use it in commercial project? 2. Can it work seamlessly with Oracle data base? thanks in advance for info Gawel Tag: SQLDMO Code Sometimes Works Tag: 100281
  - 5
    - Storing missing values For a column in (eg an Access) database that's used to store numeric data, is there a specific way to designate a missing value for a given row (ie the value was simply never measured or assigned). Or must I set up my own convention, ie if it's a short type then to use eg -32768 or -999 (or some other value obviously outside the valid range for that column)? JGD Tag: SQLDMO Code Sometimes Works Tag: 100279
  - 6
    - System.Data.OracleClient Version Recently I started a project attempting to connect to an Oracle 9i database using the System.Data.OracleClient namespace with .Net 1.1. The database's service name is longer than 16 characters & I have since found that their is indeed a bug limiting service names to 16 characters in the namespace. What is the latest version of the library I should be using? The assembly version (installed on my development environment) for System.Data.OracleClient is 1.0.5000.0. Is there a fix forthcoming if this is the latest version? Tag: SQLDMO Code Sometimes Works Tag: 100277
  - 7
    - Passwords with Special Characters I'm trying to figure out a general algorithm to allow any valid MS SQL 2000 username/password combination to log into a Winform application. I'm having trouble with special characters. I'm created a user named test The password assigned is test'"; (that is, the word test, followed by a single quote, followed by a double quote, followed by a semi-colon) In the connection string, I've tried quoting the password with double quotes and doubling each double quote in the password. That causes the code to run fine (no runtime exceptions), but it can't log into the SQL server. I also tried the above with single quotes instead of double quotes. That doesn't work either. If I change the password to test' I can then place double quotes around it, and it works fine. If I change the password to test" I can plance single quotes around it and it works fine. But I can't get the combination of both single and double quotes in a single password to work. Thanks in advance! Tag: SQLDMO Code Sometimes Works Tag: 100276
  - 8
    - Stored procedure not returning a value in @RETURN_VALUE Hi everyon, I am experiencing a problem with a stored procedure not returning a value in the parameter @RETURN_VALUE when debugging in C#. The stored procedure looks something like this: CREATE PROCEDURE dbo.ListSomething @myParam int AS declare @rc int set @rc = 0 select * from dbo.myTable where myField = @myParam if (@@error <> 0) set @rc = @@error return @rc When I run this stored procedure in Query Analyzer, it works as expected returning any matching records and a return value of 0. For information, the SQL I'm using in Query Analyzer is: declare @rc int exec @rc = ListSomething 123 select @rc In my C# code though, when I query the @RETURN_VALUE parameter in the Parameters collection of the SqlCommand, all I ever get is "undefined value". Even if I change the stored procedure to return something specific such as 1, 2, 3, etc. The code I'm using is: SqlConnection DBConnection = new SqlConnection(); SqlCommand DBCommand = new SqlCommand(); DBConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=myDatabase;server=myServer"; DBConnection.Open(); DBCommand.Connection = DBConnection; DBCommand.CommandText = "ListSomething"; DBCommand.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(DBCommand); if (DBCommand.Parameters.Count > 1) { foreach (SqlParameter SPParameter in DBCommand.Parameters) { // set the value of each input parameter } } SqlDataReader CommandResults = DBCommand.ExecuteReader(CommandBehavior.CloseConnection); if (DBCommand.Parameters["@RETURN_VALUE"].Value == 0) { // display results from stored procedure } else { // raise an error } CommandResults.Close(); I have read that the use of DeriveParameters is not recommended because of the additional roundtrip to the server, but this isn't an issue for me as the stored procedures are not going to be used that often, and I need a way of dynamically building the parameters list for population without having to define all of them in advance. When I debug the code, the line that reads the value of @RETURN_VALUE fails as it has an "undefined value". The return value just isn't coming back from the stored procedure, even though through Query Analyzer it is being returned. Is anyone able to help me get the return value from my stored procedure please? I've searched the internet but haven't had much luck. Many thanks in advance Adam Ainger Tag: SQLDMO Code Sometimes Works Tag: 100272
  - 9
    - Aggregate data columns not working after the dataset is deserializ Hi, I have a dataset with three tables in it. A parent table MenuPricing and two child tables Labor and Parts. In the MenuPricing table I created a data column named TotalPrice with the following expression: Sum(Child(relParts).TotalPrice). See the xml source below. This dataset will work fine if used locally ie in the same app domain. But if I access this dataset from a web service, I get the error below. Is there a way arround this bug? System.InvalidOperationException: There is an error in XML document (1, 4190). ---> System.Data.EvaluateException: Cannot find column [TotalPrice]. at System.Data.AggregateNode.Bind(DataTable table, ArrayList list) at System.Data.DataExpression.Bind(DataTable table) at System.Data.DataExpression..ctor(String expression, DataTable table, Type type) at System.Data.DataColumn.set_Expression(String value) at System.Data.Merger.MergeSchema(DataTable table) at System.Data.Merger.MergeTableData(DataTable src) at System.Data.Merger.MergeDataSet(DataSet source) at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction) at ServiceMonitor.SMService.MenuPricingDS.ReadXmlSerializable(XmlReader reader) in C:\softdev\CS\SM2\ServiceMonitor\Web References\SMService\Reference.cs:line 7407 at System.Data.DataSet.System.Xml.Serialization.IXmlSerializable.ReadXml(XmlReader reader) at System.Xml.Serialization.XmlSerializationReader.ReadSerializable(IXmlSerializable serializable) at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read13_GetMenuPricingResponse() --- End of inner exception stack trace --- Dataset definition: <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="MenuPricingDS" targetNamespace="http://tempuri.org/MenuPricingDS.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/MenuPricingDS.xsd" xmlns:mstns="http://tempuri.org/MenuPricingDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"> <xs:element name="MenuPricingDS" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Labor"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" minOccurs="0" /> <xs:element name="MpHeaderID" type="xs:int" minOccurs="0" /> <xs:element name="MpLaborID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" minOccurs="0" /> <xs:element name="Description" type="xs:string" minOccurs="0" /> <xs:element name="Quantity" type="xs:float" minOccurs="0" /> <xs:element name="HourRate" type="xs:decimal" minOccurs="0" /> <xs:element name="TotalPrice" type="xs:decimal" minOccurs="0" msdata:Expression="Quantity * HourRate" /> <xs:element name="OpCode" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Parts"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" minOccurs="0" /> <xs:element name="MpHeaderID" type="xs:int" minOccurs="0" /> <xs:element name="MpPartID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" minOccurs="0" /> <xs:element name="PartNo" type="xs:string" minOccurs="0" /> <xs:element name="Quantity" type="xs:float" minOccurs="0" /> <xs:element name="Description" type="xs:string" minOccurs="0" /> <xs:element name="UnitPrice" type="xs:decimal" minOccurs="0" /> <xs:element name="TotalPrice" type="xs:decimal" minOccurs="0" msdata:Expression="Quantity * UnitPrice" /> <xs:element name="Cost" type="xs:decimal" minOccurs="0" /> <xs:element name="Profit" type="xs:decimal" minOccurs="0" msdata:Expression="UnitPrice - Cost" /> <xs:element name="TotalProfit" type="xs:decimal" minOccurs="0" msdata:Expression="(Quantity * UnitPrice) - (Quantity * Cost)" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="MenuPricing"> <xs:complexType> <xs:sequence> <xs:element name="DealerID" type="xs:short" /> <xs:element name="MpHeaderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /> <xs:element name="Description" type="xs:string" /> <xs:element name="YearID" type="xs:int" /> <xs:element name="ModelID" type="xs:int" /> <xs:element name="CategoryID" type="xs:int" /> <xs:element name="ShowOnWeb" type="xs:boolean" /> <xs:element name="PrePaid" type="xs:boolean" /> <xs:element name="Rental" type="xs:boolean" minOccurs="0" /> <xs:element name="TotalParts" type="xs:decimal" minOccurs="0" msdata:Expression="Sum(Child(relParts).TotalPrice)" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="MenuPricingDSKey1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:MenuPricing" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:unique> <xs:keyref name="relParts" refer="MenuPricingDSKey1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade"> <xs:selector xpath=".//mstns:Parts" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:keyref> <xs:keyref name="relLabor" refer="MenuPricingDSKey1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade"> <xs:selector xpath=".//mstns:Labor" /> <xs:field xpath="mstns:DealerID" /> <xs:field xpath="mstns:MpHeaderID" /> </xs:keyref> </xs:element> </xs:schema> Tag: SQLDMO Code Sometimes Works Tag: 100269
  - 10
    - Datagrid SortCommand does not work ??? Hi There I have a datagrid with a Select(LinkButton) Column followed by several Bound Columns. I have enabled the columns to sort and created the correct event handler (I think) - however the crux of my problem is that when I click on one of the column headers to sort by it the ItemCommand fires rather than the SortCommand. in the .aspx file I have: OnItemCommand="SalesGroupInitial_ItemCommand" OnSortCommand="SalesGroupInitial_SortCommand" which correlate to the .aspx.vb file (I also have an OnItemDatabound event if that is of any significance) I have not included the code at this juncture as it is a flat case of the wrong event firing when I click the Column Header Any ideas would be very much appreciated Stuart Tag: SQLDMO Code Sometimes Works Tag: 100267
  - 11
    - Error Message: Timeout expired. Hello there, I have about 50 users who use an asp.net application i made. For a while there were no problems but now i see a lot of timeout expired messages i diiferent forms of my application. See the stack trace below: What can i do to avoid this? Thnx in advance, Victor Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Page Error Occured: /webgabprod/Administration/administration.aspx ExceptionType: System.Data.SqlClient.SqlException Stack trace: at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at WebGab.WebForm1.GetAanvragen() at WebGab.WebForm1.btn_zoek_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() Tag: SQLDMO Code Sometimes Works Tag: 100251
  - 12
    - concurrency violation with bound control Hi. I'm sorry if this is a repost. Please reply with existing links, if any. I have a list box with a datatable as data source. I edit an item from the list box (by changing the item in the datatable) and call the update method() of a data adapter. My problem is I get a concurrency violation saying no rows were affected. Tag: SQLDMO Code Sometimes Works Tag: 100241
  - 13
    - DataTable.LoadDataRow - can you improve on this? DataTable is dt, filled already and with keys defined, uid, seq etc, suitable variables ... object[] newRow = new object[5]; newRow[0] = uid; newRow[1] = seq; newRow[2] = text; newRow[3] = type; newRow[4] = data; dt.LoadDataRow(newRow,false); >>>> I don't like this because it relies on the column positions - of course I could use an enumeration for readability but that wouldn't remove the underlying problem >>>> I can create a detached row with thr right schema DataRow newRow = dt.NewRow(); >>>> and then fill the columns by name .... newRow["uid"] = uid; newRow["seq"] = seq; >>>> which is great, but then there is no overloaded method for .LoadDataRow, which allows me to load that data ... any suggestions for achieving the required effect - loading data without hardwiring the column positions? Cheers Jim Tag: SQLDMO Code Sometimes Works Tag: 100239
  - 14
    - ado vs oledb Hi, I use to program using VB + ADO with MS Access. however, i've read that oledb is faster and better then ADO to access to DB. could you tell me in which wqy is it faster ? what i've seen till now, it's that i need 3 times more code lines to do the same thing. thanks a lot, PM Tag: SQLDMO Code Sometimes Works Tag: 100230
  - 15
    - Using DSN in connection string with SqlConnection Object I want to use DSN in Connection string. But for opening connection i am using 'SqlConnection' object. i.e using System.Data.SqlClient; So is it possible to use DSN in connection string with 'SqlConnection' object. OR i should go only for 'OdbcConnection'. Tag: SQLDMO Code Sometimes Works Tag: 100229
  - 16
    - best way to retrieve thousands of records. I have currently using a dataset to access my data from sql server 2000. The dataset contains 3 tables that is related to each other. parent/child/grandchild relationship. My problem is it's very slow to retrieve records from sql server. I'm using sqldataadapter.fill method to populate dataset. Parent table contains more than 3,000 records and child table contains more than 10,000 records and grandchild table contains more than 90,000 records as of now. I tried to limit the number of records to return by a select command using the criteria but my problem is I dont know how to limit the number of records return by a 3rd table (grandchild). I'm using textboxes in parent table and datagrid in 2nd and 3rd table. There is no problem querying the 1st and 2nd table but I don't know how to query the 3rd table. 3rd table must know first the primary key value of the 2nd table that is stored in a datagrid. but don't know how to do this. Anyone know what is the better way to access this data? I would love to read some article about techniques on accessing table that has a relationship up to 3rd table (grandchild). thanks in advance. Tag: SQLDMO Code Sometimes Works Tag: 100222
  - 17
    - Is there any way to know if a connection is in a transaction? Greets. A very simple question in the topic, probably takes about 10 seconds for an expert to answer =) Thanks .. Tag: SQLDMO Code Sometimes Works Tag: 100217
  - 18
    - DataGridView error Hi, i have DataGridView whose sourse i set to a datatable with 5 columns containing data. i then remove the 3rd column, created a DataGridViewComboBoxColumn, set it's DataSource, ValueMember and DisplayMember. the Valumeber is an integer and the displaymember is a string. I then instert this into the same location as the column that was removed. the problem i am getting is when the Grid is loaded, i get errors stating "System.FormatException: the value of the DataGridViewComboBoxCell is invalid. To replace this default dialog, please handle the DataError event.". Why is this error happening? here is the code that does the replacing and adding of a combo box: private void addExchangeLookUpCombs( DataGridView dt ) { dt.Columns.Remove( "exchange_id" ); DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn( ); cb.DataSource = DbConnection.instance.getDbTable("StockExchange"); cb.ValueMember = "exchange_id"; cb.DisplayMember = "symbol"; cb.FlatStyle = FlatStyle.Flat; dt.Columns.Insert( 2, cb ); } Tag: SQLDMO Code Sometimes Works Tag: 100215
  - 19
    - RowState Question Hi folks, I'm reading through David Sceppa's excellent ADO.NET book, trying to teach myself ADO.NET, and have a question about the RowState property. If I add a new row to a DataTable, it has a RowState of 'Added'. If I modify an existing row, its RowState is 'Modified'. If I add a row, but before I call AcceptChanges I modify that row, is it still 'Added'? I guess it has to be ... but what happens to the data I first entered into the row that I might have overwritten with the subsequent edit? Just trying to get a handle on how this stuff fits together :) Cheers, Matt Tag: SQLDMO Code Sometimes Works Tag: 100209
  - 20
    - RowState Undelete? A row was deleted in a DataTable, and now I want to bring it back so I can remove it (so my dataadapter will not touch it later). How can I do that? Thanks. replaceExisting Tag: SQLDMO Code Sometimes Works Tag: 100201
  - 21
    - OracleDataReader returning no rows or data even though data exists Hi All, I am trying to get result from Oracle Function that returns a number. When I rum from SQL Plus I could see the result. When I call from my C# application I get no data. I am using System.data.OracleClient to access oracle function on Database 8.1.7. I am using Oracle 9i client from my application to connect to 8.1.7 Database. I am able to get results if i use query like select * from table name. I have paseted my code and Oracle function below. I would really appreciate any help As I have spent couple of days trying to get it work. //Oracle Function create function test_func return number as begin return 5; end; C# code StringBuilder commandText = new StringBuilder("TEST_FUNC"); string str = "Data Source=EXP_DUP;User Id=test;Password=tst;Integrated Security=no;" ; System.Data.OracleClient.OracleConnection Conn = new OracleConnection(str); OracleCommand DSCmd = new OracleCommand(commandText.ToString(),Conn); Conn.Open(); DSCmd.CommandType = CommandType.StoredProcedure; //Set OUT parameter direction DSCmd.Parameters.Add("RC", OracleType.Number).Direction = ParameterDirection.ReturnValue; try { OracleDataReader dataReader = DSCmd.ExecuteReader(); if( dataReader.HasRows) { while (dataReader.Read()) { System.Windows.Forms.MessageBox.Show(dataReader.GetString(0).ToString()); } } dataReader.Close(); } catch( Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } Please any suggestions on how to achieve this or what am I missing. Thanks in Advance, MS Tag: SQLDMO Code Sometimes Works Tag: 100199
  - 22
    - How can I format date in databound combobox in windows app? Hi, I have a combobox bound to a smalldatetime column in a table. The ComboBox displays all available dates. However it displays them in long format and I want to display them in short format. Is this possible? Tag: SQLDMO Code Sometimes Works Tag: 100196
  - 23
    - Displaying dates in dd/mm/yy format I have two Date/Time fields in my Access 2003 database. The VB.NET app I'm developing (and making some real progress with) uses TextBoxes to input these as part of a record in a DataSet. Problem: Access always stores years as 4 digits, and it automatically tags a time onto the field, so when the user enters: 30/11/04 I end up with: 30/11/2004 00:00:00 when I view the record after it's created; the DataSet is populated using the database schema. Since the TextBox is set to display only 8 characters, this is annoying at best. The only way I can think of around this is to store the date as a string and write a validation handler for each TextBox that inputs dates. But is there a better way? Can I somehow force Access to store the short date and nothing else? Tag: SQLDMO Code Sometimes Works Tag: 100193
  - 24
    - Very simple INSERT INTO with a DateTime parameter -> "Syntax Error in INSERT INTO statement" Hello. The following very simple code does not seem to accept the DateTime variable as a parameter - why? The table (MS Access db) here contains only a primary key and a column Date of type date/time. connection.Open(); transaction = connection.BeginTransaction(); commandString = "INSERT INTO [Events] (Date) Values(@Date)"; command = connection.CreateCommand(); command.CommandText = commandString; command.Transaction = transaction; OleDbParameter param_Date = new OleDbParameter("@Date", OleDbType.DBTimeStamp); // Also tried DBTime and DBDate param_Date.Value = date; // date == DateTime command.Parameters.Add(param_Date); // Execute command command.ExecuteNonQuery(); // Syntax error in INSERT INTO statement??? Tag: SQLDMO Code Sometimes Works Tag: 100189
  - 25
    - Read-only transaction in Oracle Hello All; Does anybody know any way to start read-only Oracle transaction in .NET application? This mode can be set in PL/SQL by SET TRANSACTION READ ONLY statement, but Oracle provider for .NET does not support such isolation level. Thank you, Maxim Tag: SQLDMO Code Sometimes Works Tag: 100187

I have this code on two identical machines, named DEVONE and DEVTWO. Both on
the network. It works on DEVONE, finding (local) and DEVONE and populates
the combo box with them, but does not find any server(s) on DEVTWO, putting
<No Servers Found> in the combo box. Can anyone shed any light.

Code below:
Private Sub GetSQLServers()

Dim i As Integer

Dim sqlApp As New SQLDMO.ApplicationClass

Dim sqlServers As SQLDMO.NameList = sqlApp.ListAvailableSQLServers()

For i = 0 To sqlServers.Count - 1

Dim srv As Object = sqlServers.Item(i + 1)

If Not IsNothing(srv) Then

Me.cboRelevantServer.Items.Add(srv)

Me.cboMainServer.Items.Add(srv)

End If

Next

If Me.cboRelevantServer.Items.Count > 0 Then

Me.cboRelevantServer.SelectedIndex = 0

Else

Me.cboRelevantServer.Text = "<No Servers Found>"

End If

End Sub

Thanks,
Michael

Top