tablenames

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
    - Closing a connection BEFORe command execution has completed Hi What happens in the above scenario? Does the query still continue executing on the Databas server or is it immmediately terminated and resources released (including locks). If this is not recommended, then what is the recommended approach for terminating command's execution. Thanks in advance Tag: tablenames Tag: 142328
  - 2
    - Time out Expire (asp.net) iam calling a stored precedure from my program, the process is to bring the datas in tree structure so the data is heavy , when i tried to bring more datas its says "(Network Error (tcp_error) A communication error occurred: " i try to increase the connection & command time out still the same. *** Sent via Developersdex http://www.developersdex.com *** Tag: tablenames Tag: 142327
  - 3
    - How to insert data into wider table There are two tables. First with fields "ProductID, ProductName and Price", in other table there is also "NumberOItems". How can I do this. Is it an extra field in sql query. Here is my other code. Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim luku As Double Dim conn As New SqlConnection("Data Source=DV2\SQLEXPRESS;Initial Catalog=testaus;Integrated_ Security=True") Dim cmd As New SqlCommand("insert dbo.ost select * FROM dbo.Tuot WHERE_ Tuotekoodi=@Tuotekoodi", conn) Dim param As New SqlParameter() param.Direction = ParameterDirection.Input param.ParameterName = "@Tuotekoodi" param.SqlDbType = SqlDbType.VarChar param.SqlValue() = Tuotekoodi cmd.Parameters.Add(param) cmd.Connection.Open() luku = cmd.ExecuteNonQuery() cmd.Connection.Close() End Sub I have not decided yet how to get the amount, but let say it is a number variable initialized as "1". Tag: tablenames Tag: 142324
  - 4
    - Add Records Well, I spent about 45 minutes trying to find a simple example that shows how to add records to a SQL database from C# code. All I can find is databound stuff, or examples working with Access and who knows what. How hard can it be? I want to write some code that adds records to an existing table. No controls will be involved (bound or otherwise). Can anyone show me how, or point me in the right direction? Thanks! -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: tablenames Tag: 142313
  - 5
    - Importing Data I'm new to SQL stuff. All I have is MS SQL Express that came with Visual Studio 2005, and SQL Server Management Studio Express, which I downloaded and installed. I've created a new table, and I have a comma-delimited text file of data I want in that table. Can someone tell me the least painful way to import that data into the table? Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: tablenames Tag: 142312
  - 6
    - How to GROUP SELECT WITH some value and WITHOUT some other? I have a table Customer =========== INT (Identity), Varchar(50), Varchar(50), Varchar(50) ============ ID, City, FirstName, LastName ================= 1 Brisbane Jon Smith 2 Brisbane Allan Parker 3 Sydney James Parker And now I try to find all City WITH customer named 'Paker' AND WITHOUT customer named 'Smith' (That would be 'Sydney' in this sample). What kind of SQL could I write to do that? some kind of SQL like below would be good if it could work SELECT City FROM Customer WHERE LastName NOT IN ('Smith') and LastName in ('Parker') GROUP BY City Tag: tablenames Tag: 142308
  - 7
    - Keeping a OdbcConnection Open I am dealing with an AS400 DB2 system and am running into some query execution timeouts. It seems like every time you Open the initial connection the query can take over 1 min to return results. Once the connection is open the next queries execute as expected, usually. If I leave the connection open and reuse it for each call does it behave asyncronously and execute any query as it comes or is it sequentail and will process them one at a time. So If I had a query that took 2 mins to execute does everthing stand still until it is complete? I have 100+ users using an application that queries for account info and does stuff with the results. If I use the typical scenerio, Open then Close for each request I get random execution times, milliseconds then around 1 min (For the same query) I dont necessarily agree with keeping the connection open but was wondering if anyone out there has come across this situation and came up with some different solutions. Thanks for your time - Paul Tag: tablenames Tag: 142304
  - 8
    - BindingSource.EndEdit and Position When I call BindingSource.EndEdit on one of the BindingSources of my application, it correctly finishes the addition of the new row but surprisingly it also resets its Position to zero (and so also changes the object referenced by its Current property to the first item on the DataView that underlies). I would like to know if this is an expected behavior. It does not happen with all my BindingSources. I've handled the BindingSource.CurrentChanged event and I see something like this in the call stack: MyForm.bindingSource_CurrentChanged [Native to managed] [Managed to native] System.Windows.Forms.dll!System.Windows.Forms.BindingSource.OnCurrentChanged System.Windows.Forms.dll!System.Windows.Forms.BindingSource.CurrencyManager_CurrentChanged System.Windows.Forms.dll!System.Windows.Forms.CurrencyManager.OnCurrentChanged System.Windows.Forms.dll!System.Windows.Forms.CurrencyManager.ChangeRecordState System.Windows.Forms.dll!System.Windows.Forms.CurrencyManager.List_ListChanged [Native to managed] [Managed to native] System.Windows.Forms.dll!System.Windows.Forms.BindingSource.OnListChanged System.Windows.Forms.dll!System.Windows.Forms.BindingSource.InnerList_ListChanged System.Data.dll!System.Data.DataView.OnListChanged System.Data.dll!System.Data.DataView.IndexListChanged System.Data.dll!System.Data.DataViewListener.IndexListChanged System.Data.dll!System.Data.Index.OnListChanged System.Data.dll!System.Data.Index.RecordChanged System.Data.dll!System.Data.DataTable.RecordChanged System.Data.dll!System.Data.DataTable.SilentlySetValue System.Data.dll!System.Data.DataTable.EvaluateDependentExpressions System.Data.dll!System.Data.DataTable.EvaluateExpressions System.Data.dll!System.Data.DataTable.SetNewRecordWorker System.Data.dll!System.Data.DataTable.InsertRow System.Data.dll!System.Data.DataView.FinishAddNew System.Data.dll!System.Data.DataRowView.EndEdit System.Windows.Forms.dll!System.Windows.Forms.CurrencyManager.EndCurrentEdit System.Windows.Forms.dll!System.Windows.Forms.BindingSource.EndEdit Thank you very much in advance Tag: tablenames Tag: 142302
  - 9
    - How to resort records in a dataSet? Hello, friends, We have an app in c#.net 2003. There is a dataSet. Its data are populated to a customized list in a loop (NO data binding, now and future). We need to modify it so that it can be sorted based on user's selections. I tried the follows by using DataView, but no luck: It still keeps the original order. Any ideas? Any other methods that we can resort records in a dataSet? Thanks ! ----------------------- DataView mDataView = new DataView(); mDataView = mDataSet.Tables[0].DefaultView; mDataView.Sort = "--user's selections--"; mDataSet.Tables.Clear(); mDataSet = null; DataSet mDataSet2 = new DataSet(); mDataSet2.Tables.Add(mDataView.Table); foreach (DataRow dr in mDataSet2.Tables[0].Rows) { //check the order } Tag: tablenames Tag: 142299
  - 10
    - simple SQL: select missing rows I have some simple data like that Product -------- PR_Id (PK), Name -------- 1 Wall Clock 2 Nails Invoice ------- IN_id (PK) ------- 1 2 InvoiceLine ------------ LI_Id (PK), IN_id (FK in Invoice), PR_id (FK in Product) ------------ 1 1 1 2 2 1 3 2 1 Now I'm trying to write some SQL that will get the Invoice with WallClock and no Nails. Any tips? I'm stuck.... Tag: tablenames Tag: 142294
  - 11
    - How to debug sql 2005 on remote machine. I am administrator on both my dev machine and remote sql server machine. How to debug sql 2005 on remote machine. I am administrator on both my dev machine and remote sql server machine. I get this error when i try to connect to remote machien with visual studio: unable to connect to microsoft vistual studio remote debugging monitor named msdb3. the microsfot visual studio remote debugging montor (msvsmon.exe) does not appear to be ru nning on the remote computer. please see help for assistance. Do i need to install more then jsut sql server 2005 on remote machine before i can attach to processes remotely? also what all ports need to be open? Tag: tablenames Tag: 142287
  - 12
    - Need utility for deleting rows In the course of developing my application, it inserts many test rows into the test database. These are standard Orders with details and other data. Now, I wish to delete these "dummy" orders, but because of the relationships between the order, details, and other tables, it's a tedious manual process. I was wondering if anyone know of any "ready-made" utilities for selecting a row in a table and deleting it along with any rows on which it depends or depends on it. For example, if I provide an order id, I want to delete that order, plus any details and any addresses, contacts, etc. which are related to that order. I can write a script to do this, but in an effort to save some time, I thought I would check to see if anyone knows of any utilities that can do this. Since this is a test database that is shared by other developers, I cannot simply truncate the tables. As I said, writing a script would take me time that I would rather not expend unless I have to. That's why I am asking if anyone knows of a utility or script that is available to do this. Thanks for any assistance. Chris Tag: tablenames Tag: 142283
  - 13
    - "IDBCommand.CommandTimeout" property won't change! Hi I have an ADO.NET 2.0 command object. i am trying to set the CommandTimeout property. Whatever value I try get ignored and the property remains on 0! Any idea? Thanks Tag: tablenames Tag: 142280
  - 14
    - DotNetNuke Development http://www.itechart.com/ DotNetNuke development services for DNN include: =B7 Product Design and Analysis =B7 Prototyping =B7 Incremental Development Approach =B7 Full Product Testing Cycle =B7 Customization Services =B7 Localization Services =B7 Integration Services =B7 Product Support =B7 Documentation DNN custom module development technology list: =B7 .Net application development based on Framework 1.1 or 2.0 =B7 MS SQL 2005, MS SQL 2k, MySQL database design =B7 HTML, XML, JavaScript, AJAX and more =B7 Security testing by Web Inspector =B7 Performance testing by LoadRunner or SilkPerformer =B7 Custom Skin Design by Adobe Photoshop Tag: tablenames Tag: 142275
  - 15
    - IsZombied (This SqlTransaction has complete; it is no longer usable.) We develop software used by banks and financial planners throughout Australia. On one particular site (out of thousands) we are getting an error: This SqlTransaction has completed; it is no longer usable. Server stack trace: at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback() at NAB.WM.SHAPE.HI.DataAccess.Dax.InsertAllDocumentData(Int32 documentTypeID, Boolean documentIsEncrypted, Int32 adaptorID, String userName, String data, NameValueCollection keys, NameValueCollection metaData) The code of InsertAllDocumentData is very simple - it rollbacks on error (Catch block) and commits otherwise (within Try). None of the code that InsertAllDocumentData does or calls closes or disposes the connection or the transaction. In investigation I decompiled .NET 2.0 code and found that SQLTransaction's ZombieCheck method calls _internalTransaction.IsCompleted rather than _internalTransaction.IsZombied (which seems a little odd): Friend ReadOnly Property IsZombied As Boolean Get If (Not Me._internalTransaction Is Nothing) Then Return Me._internalTransaction.IsCompleted End If Return True End Get End Property Is that a bug in the framework? It seems odd to have a method called IsZombied on the SqlInternalTransaction class but not to use it... Tag: tablenames Tag: 142274
  - 16
    - Underlying (SQL Server) DataTypes for Columns in a DataSet? I have an application that allows the user to enter any number of (SQL Server) select statements in a text box, execute the "script" and work with the resulting data. Due to the multiple queries, I use a SqlDataAdapter.Fill to get the dataset as opposed to a DataReader. I need to use another library that requires the *SQL Server datatype* specification (preferably as a string) for the columns in the DataSet. Since I don't really know where the result columns are coming from, I can't just inspect the database schema directly. Any suggestions? Tag: tablenames Tag: 142269
  - 17
    - sqlcommand I am trying to come up with a generic way of generating an insert statement widh command builer then additional parameter to the insert command so I can get the id of new records back. Once I get the inserrt command from sql command builder any changes I make do not get reflected when the intert command runs. i have to copy the information to a new sqlcommand and use it. If I query the commandtext it has been updated but the updated version does not run. Any ideas why the changes to not get updated. I am updating a sql 2005 server with this. The following code works but I am looking for a way to make the changes without needing a second sqlcommand private sub updrec() Dim cn As New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind") Dim sql As String = "select CategoryId,CategoryName,Description from categories where CategoryID='105'" Dim sqlData As New SqlDataAdapter(sql, cn) Dim prm As SqlParameter Dim sqlBld As New SqlCommandBuilder(sqlData) Dim OsqlCmd As SqlCommand = sqlBld.GetInsertCommand cn.Open() Dim nSqlCmd As New SqlCommand OsqlCmd.CommandText += " set @CategoryID = SCOPE_IDENTITY()" prm = New SqlParameter("@CategoryID", SqlDbType.Int, 0, "CategoryID") prm.Direction = ParameterDirection.Output OsqlCmd.Parameters.Add(prm) nSqlCmd = OsqlCmd.Clone Dim sqlCmd As New SqlCommand(OsqlCmd.CommandText, cn) CopyParams(OsqlCmd, sqlcmd) ' sqlData.InsertCommand = sqlCmd sqlData.UpdateCommand = sqlBld.GetUpdateCommand sqlData.DeleteCommand = sqlBld.GetDeleteCommand TextBox2.Text = sqlData.InsertCommand.CommandText Dim myDs As New DataSet sqlData.Fill(myDs, "Categories") myDs.Tables(0).Rows(0).Item("Description") = "freddy" Dim mYrow As DataRow mYrow = myDs.Tables(0).NewRow mYrow.Item("categoryname") = "cat1" mYrow.Item("description") = "Desc1" myDs.Tables(0).Rows.Add(mYrow) mYrow = myDs.Tables(0).NewRow mYrow.Item("categoryname") = "cat1" mYrow.Item("description") = "Desc1" myDs.Tables(0).Rows.Add(mYrow) sqlData.Update(myDs, "Categories") 'myDs.GetChanges() end sub Private Sub CopyParams(ByVal oldCmd As SqlCommand, ByRef NewSqlCmd As SqlCommand) Dim oParam As SqlParameter Dim NPrm As SqlParameter For Each oParam In oldCmd.Parameters NPrm = New SqlParameter(oParam.ParameterName, oParam.SqlDbType, oParam.Size, oParam.SourceColumn) NPrm.Direction = oParam.Direction NewSqlCmd.Parameters.Add(NPrm) Next End Sub Thank You Tag: tablenames Tag: 142266
  - 18
    - xcopy deployment to sql server DTS package in restricted environme Hello. I'm an old VB6 programmer who would like to distribute an .exe with the simplest method possible, and that's not working. I have an application which updates rows on a SQL Server. If I run the .exe in my project's debug folder, it runs fine. If I run it from my project's release folder, I get a sqlClientPermission error when it tries to update data on the server. I don't have administrative rights to my PC, so I'm assuming I have to live with this or find someone with admin rights to grant me permission to run the release version of my application on my PC. If I run it copied to a folder on the network, I get the same error, but what I really need is for it to run in a DTS package on our SQL Server so it can be scheduled to run nightly. The release .exe gets the same error in the DTS package, and I'm not sure who needs to do what to get this to work. The debug.exe runs ok in the DTS package as long as my sps have dbo ownership. I'm not sure if I need to create a setup project and have the DBA install the .exe on the sql server, have some administrator (not our DBA) grant client access permissions to my .exe on the sql server, or some other set of magic tricks. Distributing applications used to be easy, but now it's harder and muddling through documentation on code access security is frying my brain. Please help me if you can. Thanks for all replies, -Beth Tag: tablenames Tag: 142260
  - 19
    - Fastest way to move XML document into and back out of CLR function Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of the C# CLR function when the C# CLR function is done modifying it? I tried this but get deployment error becuase SQLServer2005/CLR dotn support System.Xml.XmlDocument: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction] public static int InsertSomeNode(System.Xml.XmlDocument pDoc) { // return 1; } }; thorws error: Error 1 Column, parameter, or variable #1: Cannot find data type XmlDocument. InsertSomeNode Tag: tablenames Tag: 142253
  - 20
    - Generics? Hi I am fairly proficient in vb6 and vb.net but I am baffled by generics. What are generics about and can I make use of them in my winform vb.net database applications? Many Thanks Regards Tag: tablenames Tag: 142252
  - 21
    - ADO Net examples October 31, 2007 Hi all Can someone point me out to a site with some good examples of data file manipulation. Thank you Mike TI Tag: tablenames Tag: 142243
  - 22
    - Connections String Questions Oct 31, 2007 Hi all Sorry for repeating my previous posting. I am new to VB Net. Q1. Which provider should be preferred when defining a connection, Data provider for SQL server or Data provider for OLEDB. I intend to use SQL Express 2005. Q2. I have a database on my local PC (SQL Server Express) and the same database on a remote PC. I built a simple form with a grid. Now I want to define the connection string in such a way that I am able to use any one of the above two by changing the connection string definition on one place. How do I go about this. Thank you in advance. Mike TI Tag: tablenames Tag: 142241
  - 23
    - vs2008 Hi What are the advantage of vs2008 over vs2005? Thanks Regards Tag: tablenames Tag: 142239
  - 24
    - Elementary question on connection string Oct 30, 2007 Hi all Using VB.Net 2005 & SQL 2005. I tried to use a database on my local PC and a remote database. Now is there a way I can make the connection string flexible. I tried to change the connection string in the APP.CONFIG file however I was not successful. It would be nice if I am able to store the connection string in some kind of a text file. What I may be doing wrong. Mike TI. Tag: tablenames Tag: 142233
  - 25
    - is there anything like XmlDocument.ImportNode but for SQL Server XQuery? is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: tablenames Tag: 142232
- Next
  - 1
    - How is fastest way to construct an XML node then a bunch of slow xquery How is fastest way to construct an XML node then a bunch of slow xquery modify statements? This SQL Server 2005 logic is rather slow to simply add a new item to an xml document. Any way to do this all in one statement and faster for creating a new node without having to re-select to set the attribute values? set @currentItems.modify('insert <Item></Item> as first into (/Items/ParentItem[(@id=sql:variable("@parentItemID"))])[1]') set @currentItems.modify('insert (attribute id {sql:variable("@itemID")}, attribute length {sql:variable("@metadataLength")}, attribute activityDate {sql:variable("@activityDate_xml")}) into (/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/Item)[1]') set @currentItems.modify('replace value of (/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@totalCount)[1] with ((/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@totalCount)[1] + 1)') set @currentItems.modify('replace value of (/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@lastModified)[1] with sql:variable("@lastModified_xml")') One idea is to do this in a CLR function that uses a simple string builder to create the node, but then it has to be reserialized and there is CLR overhead. Any ideas on how to make this faster? Tag: tablenames Tag: 142231
  - 2
    - FillSchema and stored procedure IF statements I'm trying to use FillSchema to get the results schema for a stored procedure that, simplified, does this: CREATE PROCEDURE SomeProc @Flag bit AS IF @Flag = 1 SELECT 'foo' = 'bar' SELECT TOP 5 'baz' = snafu FROM SomeTable GO If I then call objSQLCommand.CommandType = CommandType.StoredProcedure objSQLCommand.CommandText = "SomeProc" objDataAdapter.MissingSchemaAction = MissingSchemaAction.Add objDataAdapter.SelectCommand = objSQLCommand objDataAdapter.FillSchema(objDataSet, SchemaType.Source) objDataAdapter.Fill(objDataSet) with @Flag = 1, I get the correct dataset back: two tables, the first with one column called 'foo' and one row, the second with one column called 'baz' and 5 rows. However, if I call this code with @Flag = 0, what I get back are two tables, the first with two columns called 'foo' and 'baz' and 5 rows, and the second with one column called 'baz' and no rows at all. This seems to be because the FillSchema goes down into the IF @Flag branch in my stored procedure for schema information regardless of the value of @Flag and that then the DataAdapter.Fill is putting its one table of data into the first available table. My question is, what other options do I have for getting the schema information here? Can I change this behavior of FillSchema's? In this particular instance I could skip the FillSchema step entirely if I know that @Flag <> 1, but I'd really prefer a more general solution that would allow me to put more branches in my stored procedure if they're needed someday. Thanks, Caitlin Shaw Tag: tablenames Tag: 142229
  - 3
    - Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. We have a several vb.net apps, that were recently upgraded from Framework 1.1 to Framework 2.0. Randomly these apps have started throwing the error below, the line of code is a connection.open, the connection string has a timeout of 500, which should be plenty of time. All of the apps use the same data layer class (happens on the same line of code). It doesn't happen every time, it's just random and it happens on the connect open not when executing the command(an insert into a large table). Anyone have any suggetions? The Source was: .Net SqlClient Data Provider With the Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PSXSTL.Digecenter.LookupDataReference.insertDB() in C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558 Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean) Additional Info: Error occurred in PSXSTL.Digecenter.LookupDataReference/insertDB at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PSXSTL.Digecenter.LookupDataReference.insertDB() in C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Thanks in advance! Rick Tag: tablenames Tag: 142219
  - 4
    - User default schema Hi Using SQLServer2005, connecting via sql server authentication. In the Instance I created a database (MyDatabase) and a Login. In MyDatabase I created a schema (MySchema), Tables (attached to MySchema) and a User (based on the Login). I set the Login's default database to MyDatabase. I set the User as MySchema's owner. When I connect to the database via SMSE, I can successfully issue SQL statements without using the MySchema prefix on the Table names. If I connect to the database via C# and SqlClient (again using sql server authentication), and issue a query command (without a MySchema prefix) I get an error stating that my table object does not exist, (indicating that it is ignoring the default schema for the User). If I use the prefix the query runs fine. My mindset is that the default schema used by the connection should be that stated in SqlServer for the given user (in this case MySchema). However the observed behaviour is suggesting that I need to do more in order to ensure that MySchema is used as the User's default schema. So two questions: Am I understanding of this problem correct? How can I ensure that when I connect via ADO.NET that the connection will use the default schema attached to the user? Regards Aidan Tag: tablenames Tag: 142204
  - 5
    - Creating a new Access database file (.mdb) in .NET/C# I'm making changes to a small, portable, single-user database application I wrote a couple of years back built around a muli-table Access database and written in C# and .NET 1.1. Most of the changes are are minor, but one involves "subsetting" the database, that is, creating a new database file (.mdb) with a subset of the current database's rows. Read in a schema and some tables from one database / file, write them out to a brand new database / file. Right? Well, either I'm being incredibly dense, or this is an extremely non-trivial task. Since it's difficult for me to imagine that 'CREATE' support wouldn't be hidden _somewhere_ in .NET's OleDb support, I'm hoping that if I describe what I've tried someone will put me out of my misery with a few, well-chosen -- but helpful -- comments on my obtuseness. <grin?> Reading tables from the original database ("Filling") into DataTables in a DataSet is fairly straightforward, and the 'web abounds with examples of how to do this. Creating a new DataSet with a duplicate schema isn't hard, either: DataSet dsClone = dsOriginal.Clone(); followed by selected row-copies from the old to the new via DataViews: dsClone.Tables[tname].ImportRow( dv[i].Row ); Then you open a connection to the new database-to-be: OleDbConnection connDb = new OleDbConnection(); connDb.ConnectionString = DbConnString1 + filename + DbConnString2; connDb.Open(); Whoops! - If the file name doesn't already exist, you get an exception. - If the file exists but hasn't been Access-initialized, you get an exception ("wrong file structure" or something similar). So either there is a secret substring I need to include in my ConnectionString ("...Mode=Create;..." ?) to prepare the file for a CREATE-like operation, or the file structure has to be "built" / initialized prior to opening the Connection. There's got to be some step there that I'm overlooking. Hints would be appreciated. If I can't figure out how to do this, my fallbacks include: 1) Byte-copying the current .mdb file -- while it's open -- under a new name, opening ("connecting to") the new file, and then emptying some tables and chopping out rows from others (and maybe doing a compress-in-place on the result), 2) Adding an Empty-Db.mdb file ("...just the Schema, Ma'am") to the package that would only be used for subsetting the database, following the steps in option (1), or 3) Reverse-engineering the .mdb file structure and coding the creation of a new one "by hand". (No, I'm not serious -- or not entirely serious-- about this one, just frustrated enough to start thinking anlong those lines.) 4) Embedding a binary string containing a complete (but table-less) .mdb file into my applic... no, let's not go there. (But it _would_ be portable. <grin!>) Please, someone, point out to me that I've been repeatedly reading past an OleDbConnection.OpenNew() method that does exactly what I'm trying to do... or something along those lines! <grin> Frank McKenney -- "The most amazing achievement of the computer software industry is its continuing cancellation of the steady and staggering gains made by the computer hardware industry..." -- Henry Petroski -- Frank McKenney, McKenney Associates Richmond, Virginia / (804) 320-4887 Munged E-mail: frank uscore mckenney ayut minds pring dawt cahm (y'all) Tag: tablenames Tag: 142200
  - 6
    - How much of the functionality of SQL Server is mirrored in ADO.Net Ok, bear with me. This is a bit lengthy. This roughly explains a real-life legacy data structure problem Iâ??m having. Assume a SQL Server 2000 database with 2 tables, Table1 and Table2. Table1 has fields id1 (Integer, primary key, but NOT an identity field) and content (varchar 10). Table2 has fields id1 (integer), id2 (integer, identity field) and content (varchar 10). The primary key of Table2 is id1/id2. The 2 tables are joined by a relationship in which table1/id1 is the foreign key of table2/id1. Also the options are set to cascade updates and deletes. Now I go into SQL Server Enterprise Manager and: 1. Create a Table1 record with an id1 = 1 2. Create a Table2 record with an id1 = 1 3. I then go back into Table1 and change id1 to a value of 2. The change is immediately reflected in the Table2 record. Thatâ??s exactly what I expected and wanted. Now the big question â?? can I get ADO to do the same thing in memory? Now I create a Winforms app in VB/Dot Net 2.0. I add a dataset (xsd) to the project and drag tables 1 and 2 onto the designer simultaneously so that the relationship comes too. I then create a minimal class inheriting from the dataset so I can fill Tables 1 and 2 from the server. I add a pair of DataGridViews to the form to display Tables 1 and 2. If I update Table1, id1, update to the database and reload the data, the changes are reflected in Table2 as expected. What I cannot figure out is how to immediately show the changes in the Table2 grid without an update. In other words is there a way to make the system do this? Am I looking for something that does not exist? Tag: tablenames Tag: 142193
  - 7
    - Missing first record Using asp.net and .net framework 2 and SQL server 2000 I am using simple SELECT statement in SP to retrieve data and then bind to a datagrid but fail to pick up the first record in the dataset: invConn = New SqlConnection(ConfigurationManager.ConnectionStrings("Connectstring").ConnectionString) invConn.Open() invComm = New SqlCommand(zStrg, invConn) invComm.CommandType = Data.CommandType.StoredProcedure invComm.Parameters.AddWithValue("@ClCode", strClCode) iP = invComm.ExecuteReader iP.Read() dgPInv.DataSource = iP dgPInv.DataBind() iP.Close() invConn.Close() The SP is pulling back the full dataset but code above misses first rec. with thanks Tag: tablenames Tag: 142191
  - 8
    - DOWNLOAD CRACKED 2008's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008 Our team provide different types of services such as: - proffessional cracking of any kind of software (CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux, FreeBSD, OS/2, MAC OS etc.) - producing keygens, licenses for different proctection systems (FlexLM, SentinelLM, ElanLM, CrypKey, etc.) - producing emulators for any kind of dongles (SentinelPro, SentinelSuperPro, Hasp4, Hardlock, WIBU, Guardant, etc.) - quality reverse engineering (decompilation of programs, algorithms reconstruction, etc.) - any other reverse engineering services... Also we have an excellent relationship with all our customers and we always happy to help them solve their problems. Our skills and experince will help you make a valuable conribution to your business. All soft we offer have been completely cracked and tested carefully by expert in corresponding field. All programs are full copies of originals (not demo, evaluation, trial or educational version) including English or multilanguage tutorial and crack or license file that makes program work as registered software from the house. Here is just a part of our software list.For getting the additional information, view our software list and ordering programs just visit our WEBSITE: http://www.x-softwares.com >> Contact e-mail: support@x-softwares.com Here is an example of the most popular offered latest software: 23.10.2007 Schrodinger Suite 2007 Intel VTune Performance Analyzer v9.0.030 Bentley Microstation GEOPAK Survey XM Edition v08.09.04.37 Delcam Powermill Pro 8009 CB1098013 SP1 Bentley Map XM v08.09.04.45 Bentley Microstation GEOPAK Site XM v08.09.04.37 UGS NX5 V5.0.2 MSC PATRAN V2007 FOR R1B LINUX IRIX,Win MSC FEA AFEA V2006 R1 GEOMAGIC STUDIO V9 SR3 GEOMAGIC QUALIFY V9 SR2 16.10.2007 GEOMAGIC ESHELL V8 CAD TRANSLATORS FOR CRANES NISA V15.1 SmartCode VNC Manager Enterprise v3.6.24.0 Siemens SIMATIC S7 SCL v5.3 SP2 Bentley Civil Extension for GEOPAK v08.08.02.81 Bentley Microstation GEOPAK Civil Engineering Suite XM v08.09.04.37 Bentley Microstation GEOPAK Suite v8.08.02.81 Bentley PowerCivil v08.09.04.37 for Powerdraft XM Bentley PowerSurvey v08.09.04.37 for Powerdraft XM PTC PRO ENGINEER WILDFIRE v3.0 M100 08.10.2007 ADAPT BUILDER ABI_V5.0 UGS SOLID EDGE V20 DIMSOLN COMBINED 3D V4.0.0 DIMSOLN FOUNDATION 3D V4.0.0 DIMSOLN MAT 3D V4.0.0 DIMSOLN SHAFT 3D V3.0.0 LEAPSOFT CONBOX V7.0.1 LEAPSOFT CONSPAN RATING V7.0.1 LEAPSOFT CONSYS V1.3.0 LEAPSOFT GEOMATH V7.0.0 LEAPSOFT RC-PIER V7.0.0 Reation Design Chemkin v4.11 CADRASTER PRO V8.0 FOR AUTOCAD 01.10.2007 TESSEL HYPERDOC V4.51 Pointwise Gridgen v16.0 ANSYS PRODUCTS V11 SP1 Mastcam X2 MR2 V11.2.35 BMW ETK v8.0 2007 OpenMind HyperMILL V9.5 incl SP4 HF 33658 Siemens Simatic WinCC Connectivity Pack v6.2 Mathworks Matlab R2007b GibbsCAM 2007 v8.5.3 SolidWorks 2008 NI LabVIEW v8.5 DSC Module Run Time System NI LabVIEW Embedded Development Module v2.5. NI LabVIEW v8.5 PDA Module 24.09.2007 MSC MD ADAMS 2007 R2 Synapticad Allproducts v12.09a Altera QUARTUS II v7.2 Altera QUARTUS II v7.2 Modelsim v6.1g Altera QUARTUS II DSP Builder v7.2 Altera QUARTUS II Megacore IP Library v7.2 Altera QUARTUS II The Nios II EDS v7.2 Synapticad Allproducts v12.08a Avanti Synopsys Hspice 2007.09 Xilinx PlanAhead v9.2.3 AWR Design Environment v7.51.3650 Cadence OrCad V16 PCB Designer Suite with PSpice 17.09.2007 Adobe Photoshop Elements v6.0 Adobe Premiere Elements v4.0 Digital Light and Color ColorMechanic Pro v2.0 for Photoshop Digital Light and Color Picture Window Pro v4.0 1.11 Digital Anarchy Backdrop Designer v1.2.2 for Photoshop INTERPOSER V1.6.1 FOR CINEMA4D REDGIANT MAGIC BULLET LOOKS V1.0 FOR AE&AVID&PREMIERE SIDEFX HOUDINI MASTER V9.0.747 LINUX GCC33 SIDEFX HOUDINI MASTER V9.0.747 AUTODESK MAX 2008 Avid NewsCutter XP v6.7.5 Avid Xpress Pro v5.7.5 MathMagic Pro Edition v3.6.0.36 for Adobe InDesign WONDERTOUCH PARTICLEILLUSION V3.02 10.09.2007 PAM STAMP 2G 2007(C)ESI Sigma Design ARRIS v9.2 Sigma Design BuildersCAD v9.1 VERO Visi Series v14 SP MULTiLANGUAGE Dassault Systemes DELMIA V5R16 MISSLER TOPSOLID V2007 Think3 ThinkiD DesignXpressions v2007.1.106.36 COADE CADWORX IP V2008 COADE CADWORX EQUIPMENT V2008 COADE CADWORX P AND ID PRO V2008 COADE CADWORX PLANT PRO V2008 COADE CADWORX STEEL PRO V2008 MATERIALISE MAGICS RP V11.1 02.09.2007 GRAITEC ADVANCE STEEL V7.1 SP2 GRAITEC ADVANCE CONCRETE V7.1 SP2 INVENSYS SIMSCI DYNSIM V4.2.3 PLANIT SOLID V4.1 INVENSYS SIMSCI HEXTRAN V9.1 GibbsCAM 2007 v8.5.27 ROBOBAT ROBOT OFFICE V20 NI LabVIEW v8.5 DSC Module NI LabVIEW v8.5 Real Time Module NI Motion v7.6 NI Multisim Analog Devices Edition v10.0.1 Stata v10.0 (c) StataCorp LP 25.08.2007 ArtiosCAD v7.2 (c) Esko nv CambridgeSoftware ChemOffice Ultra 2008 v11 PlanetPress Suite v6.0 Solidworks Video Tutorial Volume 2.3 MSC SOFY V2007 R1 DELCAM FEATURECAM V14 SCANVEC-AMIABLE FLEXISIGN PRO V8.1 R1 DELCAM ARTCAM JEWELSMITH V9.126 Algor DesignCheck v20.3 SP1 DELCAM ARTCAM PRO V9.126 Agenda Software v8.0 R3 MasterCAM X2 v11 SP1 Algor Pipe Pack V10 SP3 18.08.2007 AUTODESK AUTOCAD RASTER DESIGN V2008 WILCOX PC-DMIS V4.2 UGS NX V5.0.1.4 64BIT CSCC MASTERSERIES V2006.19 Autodsys AcceliCAD 2008 CD-adapco Star-CCM Plus v2.08 CD-adapco Star-Design v4.12 AUTODESK REVIT MEP V2008 GibbsCAM 2007 v8.5.22 MSC Marc 2007 R1 ICAM-CAM-POST V17 Minitab v15.1.1 Dolphin SMASH v5.9.2 Xilinx PlanAhead v9.2.2 Fintronic Super FinSim v9.2.3 SynaptiCAD AllProducts v12.04a 12.08.2007 LUMONIX PUPPETSHOP V3.41 FOR 3DS MAX DIRFIX Toon Boom Studio v4.0 LUMONIX SHADER FX V1.8 FOR 3DS MAX LUMONIX PUPPETSHOT V3.41 FOR 3DS MAX ILLUMINATE LABS TURTLE V4.0.0.8 FOR MAYA 32BIT& 64BIT EYEON FUSION V5.2 FINAL EYEON FUSION RENDERSLAVE V5.2 FINAL PHOTRON PRIMATTE V1.1.0 FOR FUSION 5.2 DigiEffects Fantazm v1.14 for Adobe After Effects POWER NURBS PRO AND POWER TRANSLATORS PRO V2.82 FOR 3DS MAX 9 FLUID MASK V3.0.2 AVEVA PDMS 11.6 Intergraph PDS 2007 SmartPlant CNC MACHINIST TOOLBOX V9.2 ABAQUS V6.7 (c) SIMULIA FOR win &Linux TRANSCENDATA CADFIX V7.1 Camtek PEPS v5.3.12 05.08.2007 CAMMAN v4.0.5 Bentley AutoPipe XM v09.00.00.08 Bentley Building Mechanical Systems XM v08.09.04.29 GibbsCAM 2007 v8.5.16 Insightful S-PLUS v8.0 FunctionBay RecurDyn v6.3 SP5 LUSAS FEA V14.03 GridPro v4.5 Bentley Microstation Architecture & Structural & Triforma XM v08.09.04.30 Bentley Microstation XM v8.09.04.51 SAP ECC5 DELCAM FEATURECAM INCL SOLID PLUGIN V13.3.0.13 SOFTPLAN V13.33 30.07.2007 Mathematica v6.01 for Windows &Linux SDS/2 Suite V7.025 (C) Data Design System AUTODESK REVIT ARCHITECTURE V2008 SP1 ADAPT BUILDER EX V3.1 ADAPT PT V8.0 SOFTTECH STRUDS V2007 Hampson Russell CE v8 R1.2 MSC Nastran v2007 R1 CHIEF ARCHITECT X1.V11 ROMEO V4.3.1 (c) INVENSYS SIMSC UGS NX I-DEAS V5 OPTIS OPTISWORKS STUDIO V2007 SOFTIMAGE ALIENBRAIN V8 24.07.2007 ALGOR Designcheck v20.2 SP1 Bentley Microstation GEOPAK Suite v8.08.02.73 Bentley Civil Extension For InRoads XM v8.09.01.42s Bentley InRoads Suite XM Edition v8.09.01.4 GibbsCAM 2007 v8.5.15 AWR Design Environment v7.51 AWR Testwave for AWRDE v2.04 ACTEL LIBERO IDE V8.0 SP1 Synplify Premier v8.8.0.4 with Identify v2.4.2 ZELAND PRODUCTS SUITE V12 19.07.2007 CoventorWare V2006.002 Mentor Graphics ModelSim SE6.3a Mentor Graphics QuestaSim v6.3a FLOMERICS FLOTHERM V7.1 Super-FinSim v9.1.12 DOWNSTREAM CAM350 V9.5.1 Actel Designer v8.0 AUTODESK MAYA UNLIMITED V8.5 SP1 RED GIANT KEY CORRECT PRO V1.0 FOR AE Flaming Pear Photography Pack v1.1 for Adobe Photoshop Avid Liquid v7.2 Adobe Photoshop Lightroom v1.1 HEADUS UVLAYOUT V1.20.2 12.07.2007 IMAGINEER SYSTEMS MOTOR V1.1.3 JoeAlter Shave And A Haircut For Maya 8.0 v4.5 v32 BINARY ALCHEMY ROYAL RENDER V5.7 Conoa Superpak v2.1 for After Effects SOFTWARESHIELD SYSTEM SDK V3.1.12.187 Avid NewsCutter XP v6.7.2 Avid Xpress Pro v5.7.2 Avid Studio Toolkit v5.6.4 DAZ 3D HEXAGON V2.2 PixelGenius Photokit Color v2.11 for Adobe Photoshop PixelGenius Photokit Sharpener v1.26 for Adobe Photoshop PixelGenius Photokit v1.26 for Adobe Photoshop 06.07.2007 TEKLA XSTEEL STRUCTURES V13 DASSAULT SYSTEMES CATIA V5R17 SP6 Simulia Abaqus v6.7 Mercedes Benz Navigations CD Audio 50 APS Europa MSC Adams 2007 R1 PROCAD 3DSMART V2007.1 CODEGEAR RAD STUDIO DELPHI V2007 PTC PRO ENGINEER WILDFIRE v3.0 M090 MSC EASY5 v2005 R1.4 Simulia Abaqus v6.7 29.06.2007 Falk Navigator 5 Kartenmaterial Europa 2007 MSC Dytran 2007 R1 Transmagic Plus v7.0 Route66 Navigate v7.0 Europa NI SoftMotion Controller v2.1 Medion GoPalPE.3.0A INVENSYS SIMSCI PROII V8.1 Rasterweq Software SmartCUT Pro v2.3.2.0 Cigraph ArchiTabula v1.97 For Archicad 11 Cigraph ArchiSketchy v1.97 For Archicad.11 Cigraph ArchiTime v1.97 For Archicad.11 22.06.2007 Route66 Navigate v7.0 Europa NI SoftMotion Controller v2.1 Graphisoft ArchiCAD v11 International Retail Readnfo GibbsCAM 2007 v8.5.13 Megatech MegaCAD 3D v2007 IMSIDesign TurboCAD Designer v14 CURIOUS WORLD MAPS V7.2F Bentley Microstation XM v8.09.04.44 Bentley Microstation Prerequisite Pack v8.09.04.01 Transmagic Plus v7.0 UNIGRAPHICS NX5 SURFWARE SURFCAM VELOCITY III SP1 14.06.2007 UGS FEMAP V9.3 ETA CAD Translator v1.200704 ETA VPG v3.2 WiNNT2K CSI SAFE PLUS DETAILER V8.1.0 AutoForm Master 4.1 Abaqus v6.7 VectorWorks V12.5.1 GibbsCAM 2007 v8.5.10 Malz Kassner CAD6 Industry v2007 Malz Kassner CAD6 Studio v2007 Dolphin SMASH v5.8.4 05.06.2007 SynaptiCAD AllProducts v12.01b Super FinSim v9.1.11 Depth Of Field Generator PRO v3.0.74 for Adobe Photoshop NI Circuit Design Suite Educational v10.0.1 NI Circuit Design Suite Pro v10.0.1 Dolphin SMASH v5.8.3 Aldec Active HDL v7.2 CST Studio Suite v2006B SP3 CD-Adapco Star-CD v4.02 Intel Thread Profiler v3.1.021 Intel Thread Checker v3.1.021 29.05.2007 SURFWARE SURFCAM VELOCITY III SP1 Bentley speedikon Architectural v08.00.00.25 for MicroStation XMS Bentley speedikon Industrial v08.00.00.25 for MicroStation XM PROTEUS ENGINEERING MAESTRO V8.7.6 PROTEUS ENGINEERING FASTSHIP V6.1.29 PTC PRO ENGINEER WILDFIRE v3.0 M080 Intel VTune Performance Analyzer v9.0.010 Intel VTune Performance Analyzer v9.0.969 Intel C Plus Plus Compiler v9.1.037 Intel Visual Fortran Compiler Pro v9.1.037 Carbon Coder v2.51 Rhozet Corporatio OPTIMAL SOLUTIONS SCULPTOR V2.1 20.05.2007 CSI ETABS NL V9.1.4 Solidworks 2007 SP0.0-SP3.1 Service Pack ALTAIR HYPERWORKS V8.0 SR1 AUTODESK PRODUCTSTREAM PRO V2008 Autodsys IntelliCAD v6.3 Pro Plus Edition NI DIAdem v10.2 NI LabWindows CVI FDS v8.1.1 NI Teststand v4.0 Eurosystems SmartCut Pro 6.1.13 CimatronE v8.0 FunctionBay RecurDyn v6.3 SP4 UGS TEAMCENTER VISUALIZATION V2005 13.05.2007 CADopia Professional 6.0 SP1 CADopia Intellicad 5 Standard SP1 v5.0.20.0 Ansoft Maxwell 2D & 3D 11.1 GEOMAGIC STUDIO V9 DHI MIKE NET V2007 DHI MIKE STORM V2007 PROKON STRUCTURES V2.2-LND LEAP SOFTWARE LEAP BRIDGE V6.0 MOLDFLOW DESIGN LINK V5.2 ADAPT BUILDER-EX V3.0 CEI ENSIGHT GOLD V8.2.4B 32BIT 04.05.2007 GibbsCAM 2007 v8.5.6-Lz0 SURFWARE SURFCAM VELOCITY III MSC PATRAN V2006 R1for IA64&IRIX&HPUX DASSAULT SYSTEMES CATIA V5R17 SP5 FOR 32 &64 BIT MOLDFLOW PLASTICS ADVISERS V7.3 ARRIBA Planen Kompakt v12.3.233 GGU-Footing v5.0 GGU-Retain v4.42 GGU-Slab v6.0 GGU-SS-Flow2D v8.03 GGU-Stability v8.08 26.04.2007 UGS Solid Edge v19 Update.5 AUTODESK ALIASSTUDIO V2008 ALLDATA v9.20.1002 GibbsCAM 2007 v8.5.2 Maple V11 Professional MAC OSX UB Autodesk Inventor Professional 2008 FLUENT Polyflow v3.11.0 E-ON VUE INFINITE V6.0.5 ALTAIR HYPERWORKS V8.0 X64 VectorWorks v12.5.0 R1 18.04.2007 UGS Jt Catia v5 Translator v4.0 EDS UNIGRAPHICS NX V5.0.25 OpenMind HyperCAD v2006.2.105.41 Dolphin SMASH v5.8.2 Dolphin SoC GDS v5.9.1p2 SynaptiCAD AllProducts v11.18a Agilent Genesys 2007 uper FinSim v9.1.0 Puppetshop v3.35 for 3ds Max Multimeios Fulldome v1.2.0.0 for Adobe After Effects NEWTEK LIGHTWAVE3D V9.2 10.04.2007 CSI SAP2000 11.0 NI DASYLab 9.0.2 THINK3 THINKDESIGN THINKID v2006.2 Think3 ThinkiD DesignXpressions v2006.2 105 41 Aveva Vantage PDMS v.11.6 SP3.5 DELCAM ARTCAM PRO 9.021 DELCAM ARTCAM INSIGNIA 4.019 Bentley Microstation XM v08.09.03.65 Autodesk 3ds Max 9 Extension 1: Productivity Booster Altair HyperWorks 8.0 Ansys Fluent 6.3 Win32 Ansys Fluent 6.3 x64 03.04.2007 Autodesk VIZ 2008 Autodesk AutoCAD Architecture 2008 Autodesk AutoCAD Electrical 2008 Autodesk AutoCAD Mechanical 2008 Autodesk AutoCAD 2008 Autodesk AutoCAD LT 2008 Adobe RoboHelp 6.0 Cedrat Flux 9.3.1 Sofistik Soficad 17.1 3D Home Architect Design Suite Deluxe 8.0 AutoDsys AcceliCAD 2007 v6.2.36.5 CADlink EngraveLab Expert 7.1 rev.1 Build 8 Comsol Multiphysics 3.3 x64 26.03.2007 Adobe LiveMotion 2.0 for Mac Altera Quartus II 7.0 Citrix Password Manager 4.5 Finale SongWriter 2007 Missler Topsolid 2006 Moldflow Products 2007 PTC InterComm Expert 5.2 VX CAD CAM 12.70 Xilinx ISE 9.1 Adobe Photoshop CS3 v10.0 19.03.2007 CSC Structural 7.02 Digital Element WorldBuilder Pro 3.55 MSC MD Nastran R2 Mathworks Matlab R2007a Nemetschek Allplan v2006.2 GibbsCAM 2006 v8.0.38 CD-adapco Star CD v4.02 CD-adapco Star-CCM Plus v2.04 InfoGraph InfoCAD v6.51 VX CAD CAM V12.70 Moldflow Plastics Insight v2007 PTC InterComm Expert v5.2 F000 Cenit FasTRIM LaserCUT v3R7GA Dicad Strakon v2007 incl SP2 Pointwise Gridgen v15 10 R1 13.03.2007 NI Vision v8.2.1 Development Module NI DIAdem v10.1 SP1 NI Vision Builder AI v3.0.1 NI LabVIEW SignalExpress v2.0 Intel C Plus Plus Compiler v9.1.047 GERBER ACCUMARK FAMILY V8.2.0.156 Solidworks Video Tutorials Series 1& Series 2 Siemens Sinutrain v6.3 Edition 3 UGS I-DEAS NX12M4 MSC SIMXPERT R1.1 MSC SIMOFFICE R1 MSC PATRAN 2006 R2 PATHTRACE EDGECAM V11.5 DASSAULT SYSTEMES CATIA V5R17 SP4 for SOLARIS ANSYS PRODUCTS LINUX V11 GibbsCAM 2006 v8.0.36 PTC Mathcad v14.0 SYSTAT v12.0 Genstat v9.2.153 05.03.2007 CATIA P3 V5R17 WITH SP4 UGS NASTRAN NX V4.1 FTI FORMING SUITE V5.0 CEDRAT FLUX V9.3.1 DASSAULT SYSTEMES CATIA V5R17 SP3 SOLARIS AEGIS CIRCUITCAM SUITE V6.0.2.2 BENTLEY STORMCAD XM V05.06.012.00 Smirtware DieShop v6.0 DieNC DieBuild v2.3 MSC PATRAN 2006 R1 Cadenas Partsolutions v8.1.04 Comsol Multiphysics v3.3a 24.02.2007 SynaptiCAD AllProducts v11.17 Altera QUARTUS II v7.0 Xilinx ISE v9.1 Super FinSim v9.0.2 Mentor Graphics PADS v2007 IAR Embedded Workbench for dsPIC v1.30A SynaptiCAD AllProducts v11.15d Xilinx EDK v8.2 Synplify v8.8 with Identify v2.6 Dolphin SMASH v5.8.1. Actel Designer v7.3 SPA SOFiSTiK SOFiCAD v17.1 GibbsCAM 2006 v8.0.33 15.02.2007 CAMTEK PEPS v5.3.11 FUJITSU MATERIALS EXPLORER V4.0 ULTRA TEXXRAY PROFESSIONAL V1.21 DATACAD V11 NI DIAdem INSIGHT v2.09 ILight FieldView v11.1 UGS NX2D V4.0.1 CADlink EngraveLab Expert 7.1 rev 1 Build 8 Spartan 2006 v1.0.2 Esteco modeFRONTiER v3.2.0 SUB100 CSC STRUCTURAL OFFICE V7.02 Autodsys AcceliCAD 2007 v6.2.36.5 Spring Technologies NCSimul v8.3 ANSYS DESIGNSPACE V11 VERO Visi Series v14 SP1 MIDAS GEN V7.02 07.02.2007 NI LabWindows CVI FDS v8.1 NI Vision v8.2.2 Acquisition Software NI LabView with Embedded Support v8.2.1 NI LabView Embedded Module for ADI Blackfin v2.0 NI Circuit Design Suite Pro v10.0 NI Circuit Design Suite Educational v10.0 Intel Fortran Compiler v9.1 041 Hampson Russell CE v8.R1 ALGOR Designcheck v19.3 SP2 Intel C Plus Plus Compiler v9.1.034 FTI FORMING SUITE V4.0.1 Rib Construction Suite v12.3.135 GRAPHITECH CIMAGRAPHI V8.07 FEM DESIGN V6.01.004 Delcam PowerMILL Pro PM7006 CB1084537 SP5 RagTime v6.0.1 Dolphin SMASH v5.8.0p1 Actel Designer v7.3 Adobe LiveMotion 2.0 for Mac 27.01.2007 AUTODESK BUILDING SYSTEMS V2007.1 Transmagic Catia V5 Read Inventor Add-In v2006 SP1 Transmagic Catia V4.Read Write Inventor Add-In v2006 SP1 MIDAS CIVIL V7.01 R2 COMSOL MULTIPHYSICS V3.3 ProgeCad 2007 v7.08 SPSS Clementine v10.1 Dolphin SMASH v5.8.0 Agilent IC-CAP 2006 SYNOPSYS Star-Hspice 2006.09 with sp1 GC-powerstation 7.1.4 Cinema Craft Encoder SP v2.70.02.12 Puppetshop v3.29 for 3ds Max 22.01.2007 AUTODESK MAYA UNLIMITED V8.5 Heyne Multimedia Drive v1.00 for Cinema4D 9.5 and 10 DDAG HairFX v1.6.0.66 for 3ds max 9 64bit Heyne Multimedia SplinePatch v1.10.2 for Cinema4D ALIAS STUDIOTOOLS V13.5 Adobe Flex Builder 2.0 Fujitsy Cache 7.5.0.85 IMSI CAD Symbols 2.0 Lectra DesignConcept 3D v3R1c NavisWorks JetStream 5.2.3 Rib Construction Suite v12.2.189 Serif PanoramaPlus 3.0 SPSS v15.0 15.01.2007 Delcam PowerMILL 7006 SP4 GibbsCAM 2006 v8.0.27 PCA SLAB V2.0 PCA BEAM V2.0 LEAP SOFTWARE RC-PIER V6.00 LEAP SOFTWARE CONSPAN RATING V6.00 Transmagic Plus v2006 SP1 Comsol Multiphysics V3.3 Lectra DesignConcept 3D v3R1c 10.01.2007 SOLIDWORKS V2007 SP 2.0 CSI CONCEPTS UNLIMITED V4 SP1 NL SIMULIA ABAQUS V6.6.3 InfoGraph InfoCAD v6.5 ESI PROCAST V2006 Sescoi WorkNC v18.17 FORMSYS MAXSURF V12.04 Tribon M3 BENTLEY TriForma v8.05.04.13 BENTLEY Architectural v8.05.04.07 BENTLEY Microstation XM Architectural v8.09.02.53 BENTLEY Microstation XM Triforma v8.09.02.66 04.01.2007 SPSS v15.0 SRAC COSMOSWORKS V2007 SRAC COSMOSM V2007 SRAC COSMOSFLOWORKS V2007 SRAC COSMOSMOTION V2007 SRAC COSMOS EMS II GibbsCAM 2006 v8.0.26 AUTODESK LUSTRE V2007 EXT1 Super FinSim v8.3.6 27.12.2006 SynaptiCAD AllProducts v11.13c ManiaBarco Ucam v8.1 FLOMERICS FLOTHERM V6.1 Xilinx PlanAhead v8.2.7 Cedrat FLUX922 Agilent EMDS 2006B Agilent GENESYS 2006 v10 FINAL JoeAlte Shave And A Haircut For Maya 8.0 v4.4v18 F-EDGE V1.0.3 FOR 3DSMAX3 TO 9 2D3 BOUJOU V4.0.1 AVID SOFTIMAGE XSI ADVANCED V6.0 20.12.2006 NI LabView Professional v8.2.1 NI LabVIEW v8.2.1 Embedded Development Module VisualCAM 2006 SR1 GibbsCAM 2006 v8.0.20 NI ECU Measurement and Calibration Toolkit v2.0.1 REALVIZ ImageModeler v4.03 MAGICS RSM ESHELL V4.0.0.28 Cadlink ProfileLab 2D 7.1 rev.1 Build 8 CURIOUS NATURAL EARTH NASA 1KM V5.1 FOR CURIOUS WORLD MAPS 6.1 AND 7.0 CURIOUS NATURAL EARTH PLANET OBSERVER 1KM V5.1 FOR CURIOUS WORLD MAPS.6.1 AND.7.0 12.12.2006 Cadlink SignLab Vinyl 7.1 Rev.1 Build.7 REIWORLD STAAD PRO v2006 BUILD 1002 InfoGraph InfoCAD v6.34 CGTECH VERICUT V6.0.3 DASSAULT SYSTEMES CATIA V5R17 SP2 LECTRA FORMARIS V5R1C1 BENTLEY Microstation Descartes XM v8.09.02.71 Cigraph Archiwall 2.0 For ArchiCAD v10 Cigraph ArchiTerra 3.0 For ArchiCAD v10 MATERIALISE MIMICS V10.01 This is not our complete software list. If you want to get access to our Software archive you should visit our website: http://www.x-softwares.com >> Contact e-mail: support@x-softwares.com *** Sent via Developersdex http://www.developersdex.com *** Tag: tablenames Tag: 142183
  - 9
    - Save mix data in database Hi EveryBody: What is the data type that I have to use when I want to save mix data in database for example photos,music,text fiel,doc file and movies ? any help will be appreciated regard's Husam Tag: tablenames Tag: 142181
  - 10
    - Get Query string from Dataset/Datatable Hello When i fetch data from database i do the following: DataSet ds = new DataSet(); OledbConnection con = new OledbConnection(ConnectionString); using ( OledbCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT * FROM [tblCustomers] WHERE [CustomerName] LIKE 'A%';"; using ( OledbDataAdapter da = new OleDbDataAdapter(cmd)) { da.Fill(ds); ds.Tables[0].TableName = "tblCustomers"; } } The above just ment as an illustration. The DataSet ds now contain one table with the result of the query within the cmd. Now my question, is the cmd Query stored somewhere within the DataSet/Table? Kind regards Johnny E. Jensen Tag: tablenames Tag: 142179
  - 11
    - ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Hi, All: UDAParts has updated .NET versions of SocketProAdapter at www.udaparts.com for supporting binary remoting .NET ADO.NET objects, DataSet, DataTable and DataReader. Key features and improvements over MS technologies are: 1. Bi-directional remoting DataSet, DataTable and DataReader across desktop and smart devices. 2. Bi-directional remoting DataSet, DataTable and DataReader across different .NET runtime versions (1.0, 1.1, 2.0, .....). 3. Significantly faster (1 - 6 times) than MS .NET remoting and MS WCF. 4. Significantly reduce transaction latency without using worker threads. 5. Consume significantly less memory and much smaller footprint. 6. 100% open source code (C++/CLI and C#) for your reviewing. It is highly extensible. 7. Secure through SSL/TLS. 8. Built-in real-time notification, 9. Integrated or user defined authentication. 10. Built-in online compression. ...... Samples for VB.NET and C# are available at ..\udaparts\SocketPro\samples\RAdo after you downloading latest version (4.8.2.19) of SocketPro Soon, UDAParts will provide a short article for describing remoting ADO.NET objects through SocketPro using batching, asynchrony and parallel computation. www.udaparts.com Tag: tablenames Tag: 142170
  - 12
    - DAtaset comparision ?? Dear all, What is the best way to compare 2 dataset ? What I mean by that is not comparing that its teh same object but allso that rows data values in both . In other words I need an effeective way which tells me if records between 2 dataset are the same or different thnaks for help regards serge Tag: tablenames Tag: 142168
  - 13
    - there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? I have a simple wraper around System.Diagnostics.Stopwatch.GetTimestamp() : public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction] public static long GetTimestampF() { return System.Diagnostics.Stopwatch.GetTimestamp(); } }; but if i run this it is hardly accurate. the time of getting from sql server to a CLR function seems to be relatively slow for nanosecond calculations: DECLARE @before bigint DECLARE @after bigint SET @before = dbo.GetTimestampF() -- do something SET @after = dbo.GetTimestampF() SELECT @after - @before as nanoseconds is there nyway to elimitate this overhead so that dbo.GetTimestampF() executes as fast for TSQL as it is to call GetTimestampF() in C#? If i call my GetTimestampF() on c# it executes fast enough for the nanosecond results to be accurate Tag: tablenames Tag: 142167
  - 14
    - Problem in copying SQLite file in C# code I have a little Windows application written in C# with a SQLite back- end. I'm using the System.Data.SQLite provider. One of the features the application provides is a database back-up, which just basically copies the S3DB file to a specified location. See the code below: //------------------------------------------------ System.IO.File.Copy(srcPath, destPath, true); //------------------------------------------------ The file is copied without any problems, but when the application attempts to access the original S3DB file again, the following exception is thrown: -------------------------------------------------- System.Data.SQLite.SQLiteException was unhandled Message="Unable to open the database file" Source="System.Data.SQLite" ErrorCode=-2147467259 StackTrace: ...etc... -------------------------------------------------- If I shut the application down and then start it up again, I can access the database again with no problems. Suspicious of what the File.Copy() method might be doing behind the scenes, I tried using the following approach instead to hopefully ensure that the files were being released: //------------------------------------------------ using (FileStream fsSrc = new FileStream(srcPath, FileMode.Open)) { //Get the source length once so we don't have to keep retrieving it later int srcLen = (int)fsSrc.Length; //Create the destination file (this will overwrite the destination file if it already exists) using (FileStream fsDest = File.Create(destPath, srcLen)) { //Buffer the contents of the source file Byte[] buffer = new Byte[srcLen]; fsSrc.Read(buffer, 0, srcLen); //Write buffered contents to the new file fsDest.Write(buffer, 0, srcLen); } } //------------------------------------------------ Unfortunately, the same problem occurs. I even tried executing the code in its own thread, but with the same results. Any ideas why this is happening and how to fix it? Thank you. Tag: tablenames Tag: 142165
  - 15
    - databinding I have a checkbox (along with textboxes) that I am trying to use as a databound control to an integer field on a database. I am using Format and Parse with the checkbox to write -1 to the database if the checkbox is unchecked and 0 if checked. I am finding that the Dataset and Database are not updated if I change the checkstate of the checkbox and when I change the checkstate of the textbox, the other controls (textboxes) will not allow focus. The code I have written is below. Any suggestions would be appreciated. // chbActive System.Windows.Forms.Binding chkBoxBinding = new System.Windows.Forms.Binding("CheckState", this.tblEmployeeBindingSource, "inActive", true); chkBoxBinding.Format += new System.Windows.Forms.ConvertEventHandler(IntegerToCheckState); chkBoxBinding.Parse += new System.Windows.Forms.ConvertEventHandler(CheckStateToInteger); this.chbActive.DataBindings.Add(chkBoxBinding); this.chbActive.CheckStateChanged += new System.EventHandler(this.chbActive_CheckStateChanged); //this handles integer to checkstate private void IntegerToCheckState(object sender, ConvertEventArgs cevent) { // the method converts only to CheckState inActive is 0 if false if ((int)cevent.Value == 0) { chbActive.CheckState = CheckState.Checked; } else { chbActive.CheckState = CheckState.Unchecked; } } private void CheckStateToInteger(object sender, ConvertEventArgs cevent) { // if Active is checked then they are active and inActive should be 0 if (chbActive.CheckState == CheckState.Checked) { cevent.Value = 0; } else { cevent.Value = -1; } } Tag: tablenames Tag: 142164
  - 16
    - Confusing Error related to MappingSource? I'm trying to force LINQ to SQL to do some inheritance modeled around the "Table per Concrete Class" methodology as opposed to the normal "Table per Class Hierarchy" model it officially supports. To do this, I omitted all the properties of the inheritance relationship (Discriminator information and such) and provided the proper Table attribute to associate my derived class with its own table by addint a new partial class implementation manually. So what I end up with is a base class that has all the columns in it, and two derived classes that inherit from it in the designer, and have no additional properties. Then in another file, I declare both derived classes just to supply the Table attribute, providing each derived class' table name. The problem I run into is this error message: "Data member 'Int32 DocNum' of type '(my base class)' is not part of the mapping for type '(my derived class)'. Is the member above the root of an inheritance hierarchy?" Now I've checked the contents of the MappingSource. I retrieved context.Mapping.GetMetaType(GetType(<my derived class>)).DataMembers and was able to verify in the debug window that the DocNum property was defined in that MetaType information, and the DeclaringType matched <my derived class>, so I don't know what it's complaining about. Is there any way to make this work? Any explanation what this error is complaining about? I did notice that if I create a property in my derived class that shadows the base class DocNum property, then that property doesn't have the error any more (the next property does). But the point is not to have to re-declare all the properties in all me derived classes again. Why doesn't it pick up the base class' attributes, even though the mapping info makes it look like it did? Tag: tablenames Tag: 142162
  - 17
    - How do I (cleanly) dispose of a row in DataGridView DataError even (Reposted from Winforms forum. Not sure where this belongs.) I'm writing a Winforms project in VB/Dot Net 2.0 and I'm having some trouble handling the DataError event. The grid is bound to a filtered binding source. Add is enabled. Part of the primary key is set by one of the cells in the grid which is in combobox mode. My main concern is duplicate keys. The combobox cell is the only problem. The other row fields are either hidden or easy-to-validate text entry boxes (handled in RowValidating). What I want to do in DataError is give the user the choice of remaining in the row to fix it (e.cancel = true) or just dispose of the changes/additions. If it is an existing row, virtually anything seems to work fine (such as <bindingsource.ResetBindings, or nothing for that matter.) What gives me trouble is a newly added row (I'm even sure 'new' is the right term, but it is newly added. By the time it gets to DataError, the row's IsNewRow property = False). Any attempt to get rid of the new row by any means seems to get me into some sort of infinite loop back to DataError, with errors like 'Index <number> does not have a value'. Am I even trying to handle the error in the right place? Tag: tablenames Tag: 142161
  - 18
    - Inconsistent dat paremeter in query I am using the same code to query different databases, one SQL 2005 and the other SQL 2000. The query contains a date paremeter @Date... Me.SqlSelectCommand1.Parameters.AddRange(New System.Data.SqlClient.SqlParameter() {New System.Data.SqlClient.SqlParameter("@Date", System.Data.SqlDbType.DateTime, 8, "Date")}) The code was written using VS2003 (.Net 1.1) and is now executing on .Net 2.0. SQL Profiler displays the generated query for SQL 2000 as... exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM vwTicketedFunctions WHERE (Date >= @Date) AND (OnSaleDate <= @Date) ORDER BY StartTime', N'@Date datetime', @Date = 'Oct 26 2007 12:00:00:000AM' and the generated query for SQL 2005 as ... exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM vwTicketedFunctions WHERE (Date >= @Date) AND (OnSaleDate <= @Date) ORDER BY StartTime',N'@Date datetime',@Date=''2007-10-26 00:00:00:000'' Note that the date paremeter formats are different. My problem is that the SQL 2000 query parses Ok but the SQL 2005 generates the error: Line 2: Incorrect syntax near '2007'. Note also that regional setting is English(Australia). Tag: tablenames Tag: 142155
  - 19
    - web service for accessing db? hi, is web service good solution for accesing (havily) database (remote or not)? that looks slow, any other methods for secure connection? SOme of coworkers wants to use web service because they don't want expose connection string. thanks fro advise Tag: tablenames Tag: 142154
  - 20
    - Null Dates in Dataset Using C# 2.0 & SQL Server 2000, have a stored procedure that return 0, 1, or more rows. At least one of the columns is a date and it may null. I have created an XSD of the output from the stored proc. The entry for the nullable date column is "<xs:element name="Sent_Dttm" minOccurs="0" type="xs:dateTime" nillable="true"></xs:element>". I copied the XSD to the C# 2.0 windows app I am developing and it nicely generates a strongly typed dataset. The problem is I get an error when attempting to access this column in the dataset when the value is null: [System.Diagnostics.DebuggerNonUserCodeAttribute()] public System.DateTime Sent_Dttm { get { try { return ((System.DateTime)(this[this.tableOwizCommDoc.Sent_DttmColumn])); } catch (System.InvalidCastException e) { throw new System.Data.StrongTypingException("The value for column \'Sent_Dttm\' in table \'OwizCommDoc\' is DBNull.", e); } } set { this[this.tableOwizCommDoc.Sent_DttmColumn] = value; } } Checking the properties of this field, I noticed that the "NullValue" property has a value of "(throw exception)' Tag: tablenames Tag: 142146
  - 21
    - Jobsite for SALE JOBSITE FOR SALE For Details Contact: Netxure@gmail.com FEATURE LIST Job Seeker Features =B7 This Job site contains Advanced features of Dice and Monster =B7 Search jobs by location, date range, categories, Job type and keywords. =B7 View all jobs posted by a specific employer =B7 Find out how often your resume was viewed by interested employers. =B7 Set up job notification agents to automatically get matching jobs by email everyday. =B7 Submit your resume to any registered employer from your account with one click. =B7 Add Jobs to Inbox for later viewing. =B7 Apply to multiple Jobs with one click. =B7 Post 'Private' resumes =B7 Make resume searchable or unsearchable =B7 Update your profile at any time. =B7 Subscribe/unsubscribe to the mailing list from your account. =B7 Email a specific job to a friend. =B7 Retrieve forgotten passwords by automated email. =B7 Save time with the easy-to-use and clean user interface. Employment Features =B7 Search resumes by date range, geographic location, industry, Job type and keywords. =B7 Advanced Talent Search to find Jobseekers thru skill search. =B7 Role Based / Position Based Search for easy search process =B7 Add, edit and delete jobs from your account on the fly. =B7 Find out how often each posting has been viewed by job seekers. =B7 Build your company profile and upload a company image or logo. =B7 Professional display of job searches and resume details make for easy reading. =B7 Sign-up for multiple resume notification agents to automatically receive matching resumes by email everyday. =B7 Resumes sent to employer are saved in private inbox for viewing at a later time. =B7 Save time with flexible and powerful resume search interface. =B7 Ability to display resume details in a 'printer friendly format' without any images/colors for easy printing. =B7 Ability to easily sign-up online for Memberships, Job packages, job postings or resume database access. =B7 Automatically receive automated emails notifying of expiring jobs or expiring memberships to give the chance to renew online Administration Features =B7 Broadcast e-mails to job seekers and/or employers who signed up for the mailing list. =B7 Add, edit, and delete jobs on the fly. =B7 Add, edit, and delete employers on the fly. =B7 Add, edit, and delete job seekers on the fly. =B7 Add, edit, and delete job categories on the fly. =B7 Print mailing list of job seekers and employers in the database along with their contact information. =B7 Get general statistics summary including the number of registered job seekers, registered employers, pending job orders, active jobs, active resumes in the database and searched keywords and categories statistics. =B7 Control job expiry dates. =B7 Control resumes expiry dates. =B7 Define featured Jobs to be displayed on homepage =B7 Define featured employers to be displayed on homepage, with direct link to employer's job listing. Tag: tablenames Tag: 142143
  - 22
    - Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Server Project which creates a Test.sql, i then simply added a Stored Procedure to it called the default name StoredProcedure1.cs and put a break point in my simple StoredProcedure1.cs and hit F5 and i got this error: Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Do i need to do something on the server so that I can debug this? Any walk through on how to configure this sql server 2005 to have this RPC so i can debug my CLR stored procedures in this way? e.g. step over, step into, run to cursor etc. Is this CLR debugging feature complete and tested yet? if so is there any walk through on creating simple CLR helloworld in vs2005 and then executing it in sql server 2005 but catching a break point in the StoredProcedure1.CS code? I would like to debug these StoredProcedure1.cs as while sql server executes it is why. so as of now my current error when i try this is: Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Tag: tablenames Tag: 142128
  - 23
    - datatable vs custom List<MyClass> Let's say I want a read-only copy of a simple query that joins 2 tables. When I compare a DataTable (adapter.fill) and a custom List + DataReader, I see that the custom sol'n is about 6x faster and takes 5x less memory. For my test I read about 100K rows and then bind to a grid so the timing takes into account both getting the data and binding the data. From profiling the app I see one thing that really stands out - the internal DataTable routine to build the (default?) index takes up most of the time - it clearly is doing linear scans of a red-black tree and the hit count for traversing parts of the tree ending up in the 100's of millions. Can I give the DataTable some hint (via a property) to tell it not to perform this extra work? In the end I may go w/ a custom sol'n but I first want to check if the built in classes can solve my problem. btw, this is .net 2.0, c#, and I'm just setting the datasource w/out any other binding code. thanks, Paul. Tag: tablenames Tag: 142127
  - 24
    - very strange behavior of the method GetChanges(...) from the DataSet class Hello ! i'm using a typed DataSet called myDs. This dataset has 2 Tables, Table1 and Table2. i have created a DataSet like this: myDs dsOld = new myDs(); //here i populate the 2 tables ...... //and then call the method to get the added rows myDs dsNew = (myDs)dsOld.GetChanges(DataRowState.Added); at this point on dsNew i have only the added rows of Table1 instead Table2 is set to null.So, the method returns only the rows of 1 table (Table1). i have debugged the code and i see that the both tables of the dataset dsOld are full of rows that have the rowstate = added. somebody can explain me whats the problem ? it's seem like a bug E. Tag: tablenames Tag: 142122
  - 25
    - Access vs vb.net/ado.net Hi What are the advantages of writing an app in vb.net/ado.net as opposed to MS Access? I need this to sell the idea to the management. Many Thanks Regards Tag: tablenames Tag: 142118

After I Open(ed) an OleDbConnection, I need the names of the Tables
right away. How? (in C# or in VB)

Re: tablenames by William

William
Mon Nov 05 16:23:55 PST 2007

Some providers implement the GetSchema method of the Connection object.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Martijn Mulder" <i@m> wrote in message
news:472f748c$0$74233$dbd43001@news.wanadoo.nl...
> After I Open(ed) an OleDbConnection, I need the names of the Tables right
> away. How? (in C# or in VB)

Top

Re: tablenames by Andrew

Andrew
Mon Nov 05 18:52:48 PST 2007

GetSchema works well for the major databases I've used, Oracle, SQL Server,
MySQL, PostgreSQL as well as CSV & Excel. However, you may have to deal
with some of the pecularities of the implementation of each of them. They
should all return the table names similarly, however, some will return all
the system tables. Some will return only the tables accessible to the user.
There are some other peculiarities that show up such as whether null or the
empy string is returned for blank columns.

Still, it's the best method I've found.

--
Andrew Faust
andrew[at]andrewfaust.com
http://www.andrewfaust.com

"William Vaughn" <billvaNoSPAM@betav.com> wrote in message
news:ePBrStAIIHA.484@TK2MSFTNGP06.phx.gbl...
>
> Some providers implement the GetSchema method of the Connection object.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Martijn Mulder" <i@m> wrote in message
> news:472f748c$0$74233$dbd43001@news.wanadoo.nl...
>> After I Open(ed) an OleDbConnection, I need the names of the Tables
>> right away. How? (in C# or in VB)
>

Top