DBMS for remote database management

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
    - get DataColumn length hi, another ADO problem: how can i get the Column legth as declaredat the Sql data base? for example - char(6)filed, char(10), .., the DataColumn.DataType property bring me the Type System.String for those columns but i need the specific length, is it possible? thank's stan Tag: DBMS for remote database management Tag: 128260
  - 2
    - get table name problem hi, i am trying to get the original table name as declared at the sql database but instead of the real name the DataTable.TableName always holds the word "Table". i am using VS 2 and Sql 2003 any ideas? thank's stan Tag: DBMS for remote database management Tag: 128259
  - 3
    - [Help] How to modify DataSource of CrystalReport at runtime? Hello everyone, I am using .NET 2.0 (WinForms - C#) for building my project. I faced a problem while I tried to change datasource of CrystalReport. These are my program snippets CrystalReport1 obj = new CrystalReport1(); obj.SetDatabaseLogon("cipto", "cipto"); obj.SetDataSource(objEngine.manipulateData("SQL" ); //--> SQL = select statemtens obj.SetDataSource(dataSet1.Tables["result"]); //objEngine= my engine to results //dataset. i'm sure it works. crystalReportViewer1.ReportSource = obj ; In my crystal report i select all data , then in SQL statement (at runtime) I changed the select statement with some criteria, it wont run, in my case the result displayed 'freak' data. :( What's wrong with the code? Thank you, My Regards, Jati Indrayanto Tag: DBMS for remote database management Tag: 128258
  - 4
    - Updating datasource reports an error Hi! Could someone help? I'm having trouble with the following code. Everythig goes fine till the last line where I'm trying to update the datasource. The program stops executing and displays the message "No value given for one or more required parameters." I tried many ways of doing the same, nothing works. Public Class FormX Private Sub FormX_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim MyCNN As New Data.OleDb.OleDbConnection MyCNN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\MyDB.mdb" Dim SelectStatement As String = "SELECT Field1, Field2, Field3 FROM MyTable" Dim MyDA As New Data.OleDb.OleDbDataAdapter(SelectStatement, MyCNN) Dim strInsertCmd As String = "INSERT INTO MyTable (Field1, Field2, Field3) VALUES (?, ?, ?)" Dim InsertCmd As New Data.OleDb.OleDbCommand(strInsertCmd, MyCNN) MyDA.InsertCommand = InsertCmd Dim MyDS As New DataSet MyDA.Fill(MyDS, "TableName") Dim drNew As DataRow drNew = MyDS.Tables("TableName").NewRow drNew.Item("Field1") = "New value" 'string field drNew.Item("Field2") = 12 'integer drNew.Item("Field3") = 123 'integer MyDS.Tables("TableName").Rows.Add(drNew) MyDA.Update(MyDS, "TableName") <------------ the offending code End Sub End Class I'd really like to understand what's going on. Thanks, Georges Tag: DBMS for remote database management Tag: 128256
  - 5
    - How to call an oracle function in C# 2.0? Hello, Assum i have an oracle function called ofunction. Can someone tell me how i can call this function assuming it take the parameter in_param of type clob. Any help will be highly appreciated C# .ADO.NET 2.0 Tag: DBMS for remote database management Tag: 128251
  - 6
    - Check to see DataColumn DataType is Boolean? Hello, Iam trying to do the following- if(myColumn.DataType==typeof(bool)) { } I get the error "Operator == cannot be applied to operands type and object and bool." Is there a workaround? Thanks. jay Tag: DBMS for remote database management Tag: 128245
  - 7
    - ado.net and sql 2005 We have been testing a migration of our application from 2000 to 2005. All seemed well until last week. Our framework generates a set of business objects and maps them through a DAL to a specific table/column. In Sql Server (we also support Oracle) our columns definined by the developer as currency (internal type name) map to a .Net 1.1 decimal type and a sql server table column of money. From my understanding these columns have a default scale of 4. In Sql 2000 (and oracle) when we perform a data adapter fill (sp_execute), the decimal type is truncated down to 4 decimal places. Thus 34.3456432 gets truncated down to 34.3456. This is fine with us because the excess precision is a result of cost calculations and we have no interest in keeping the info. The money type is stored correctly and our clients are happy. YET... now in 2005 we get an exception passing the value. It complains about exceeding the precision but I was under the assumption for a money type that the precision was thirty something... ------------------------------------------------------- Unable to apply changes to the DataSet (SqlException):The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 5 ("@AREAAVGCST"): The supplied value is not a valid instance of data type numeric. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision Here is the value: 5.9232811750188790881984289485 --------------------- What is going on? We have a client going live on 2005 and this makes no sense. Are we supposed to check every decimal to see if it exceeds the column precision? Is there a database setting or something to turn on to fix this? Thank you, Russell Tag: DBMS for remote database management Tag: 128244
  - 8
    - problem writing blob to oracle hi, i have a problem writing a blob to oracle using ado.net. maybe someone can help. here's my code: OleDbConnection con = new OleDbConnection("Provider=msdaora;Data Source=orcl;User Id=******;Password=******;"); try { con.Open(); string save_blob = "INSERT INTO blobtable " + "(id,content) " + "VALUES " + "(1,:contentParam)"; OleDbParameter contentParameter = new OleDbParameter(); contentParameter.OleDbType = OleDbType.LongVarBinary; contentParameter.ParameterName = "contentParam"; contentParameter.Value = this.content; // where content is an array of byte OleDbCommand command = new OleDbCommand(save_blob, con); command.Parameters.Add(contentParameter); command.ExecuteNonQuery(); command.Dispose(); } catch (Exception ex) { System.Diagnostics.Debug.Write("DATABASE ERROR:" + ex); } finally { con.Close(); } now everytime i try and run that code i get the following error: A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll DATABASE ERROR:System.Data.OleDb.OleDbException: ORA-01008: not all variables bound any ideas? Tag: DBMS for remote database management Tag: 128243
  - 9
    - Transactions with generated DataAdapters Hello, I have generated a DataSet with Visual Studio 2005 by selecting Data -> Add New Data Source ... -> Database etc. from the menu and selected 2 objects (tables) in the Data Source Configuration Wizard. As a result I get an .XSD DataSet file that automatically generated a DataAdapter. I have added an insert statement to both tables. Question 1: One table has an autonumber id field that automatically generates a primary key when inserting a new row into the database. How do I get that automatically primary key which I need for the insert statement in the second table? Question 2: Both insert statements should be performed in one transaction. How do I set up a business method for inserting values into both tables that executes both insert statements in one transaction, i.e. public void insertValues() { MyFirstDataSet.MyFirstDataAdapter a1 = new MyFirstDataSet.MyFirstDataAdapter (); MySecondDataSet.MySecondDataAdapter a2 = new MySecondDataSet.MySecondDataAdapter (); // start transaction a1.InsertValues("mike", "miller"); // a value is inserted into a table with autogenerated primary key int key = ... a2.InsertValues(key, "test"); // end transaction or rollback } Any help would be much appreciated. Steffen Tag: DBMS for remote database management Tag: 128237
  - 10
    - Table name's in Dataset Hello Guys, I have a proc which returns variable number of tables. I want to do some validations on these tables and dont want to use the index (e.g Dataset.Tables(0)) to refer to the table, I want to use the tablenames instead. I cant do a tablemapping either caus I dont know which table will be returned at which position. Is there a way to get the table names returned by the proc in the dataset instead of the default names like Table1, Table2 ... Thanks in advance... Tag: DBMS for remote database management Tag: 128236
  - 11
    - SMO Table Owner Using SMO, how to I get a table's ower? I'm scripting out some tables to disk based on the table's name, but I'm getting a clash on the file name because the same table name exists with multiple owners. I want to encorporate the owner's name into the file name to prevent such clashes. Thanks. Scott C. Tag: DBMS for remote database management Tag: 128234
  - 12
    - dataset merge bug! my query returns 12000 rows I m filling the dataset with increment size 5000 this.MainTableDA.Fill(ds,start,5000,MainViewName); but when I merge two dataset with have 5000 rows it couse an error sometimes it returns shortly 5000 rows 5000 rows not equal to 10,000 rows. sometimes it have 7022 rows sometimes 65023 rows. its not fixed. the merge method is not working well i think it is bacause merge method does not work well. anyone have any idea? Esref DURNA Tag: DBMS for remote database management Tag: 128226
  - 13
    - Help! Something adds 1 hour to my datetimes! :-S Hi, For some reason, somewhere in my application 1 hour is added to my dates, depending in which time zone the application is run... Because I don't have a clue where this happens, I posted this to the three relevant newsgroups (vb/ado, sql and xml): my aplogize for this. I'm doing a Synchronisation between two SQL Servers (2000): All the Data is read into a DataSet, and exported to an XML-file: SQL Server -> DataSet (VB.NET 2003) -> XML -> DataSet -> SQL Server When I run everything in the West Central Africa Timezone (GMT+1, no summer-time): everything works fine. But I notice that all my dates in my XML-file are written like this "<DATE_DEB_APP>2006-02-01T00:00:00.0000000+01:00</DATE_DEB_APP> ": with the "+01:00" at the end. But not that big of a problem, because the application writes the date with 00:00 hours to the database. I (well, my pc) is in the Brussels Timezone (GMT+1: but because of the summer-hour we actuallt have GTM+2 now). Everything goes fine also when I put the databse on my local SQL Server, make the XML-file, read it again, and write it to the other database (also local). All the dates are also presented with the "+01:00"-suffix. Except one: a date that the application writes to the database when filling the DataSet, and select it at the end to put it in the XML-file also: this one gets the suffix "+02:00": <SyncSend>2006-05-03T09:58:19.6070000+02:00</SyncSend> So far so good: some not-really wanted things, but everything goes fine. Problems start when I'm doing a synchronisation between an SQL server in Central African TimeZone, and a local one in Brussels Timezone. What hapens is that all my dates are having 1 hour added to them! So instead of the "2006-02-01T00:00:00" they have as value "2006-02-01T01:00:00"!! I somehow can understand why this happens; because 00:00h in Central Africa is 01:00h in Brussels on this moment. But I don't want it to happen! I want the exact time to be transfered! Does anybody has a clue where this exactly happens? And how to prevent this? Is there a way to say that it has to use the actual value? and not one that calculates the time? On this moment it's really nice to be able to use tha capbilities of the DataSet with the XML-files and SqlDataAdapter with commandbuilder to do my insert and updates. I won't really like to loose this :-S Thanks a lot in advance! Any help our hints would be really appreciated! Pieter Tag: DBMS for remote database management Tag: 128225
  - 14
    - update tabledefinition using dataadapter and datacolumn Hi everybody! I'm trying use the datacolumn class to create new columns in a datatable object and submit the new created column to the database (Access 2000). Here's the code: Sub Main() Dim oconn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source=C:\test.mdb") Dim adapter As New OleDbDataAdapter("SELECT * FROM Cities", oconn) Dim mydt As New DataTable Dim nCol As New DataColumn adapter.Fill(mydt) With nCol .Caption = "Newcolumn" .DataType = OleDbType.Boolean.GetType End With 'Add column to Datatable mydt.Columns.Add(nCol) 'Write changes to database adapter.Update(mydt) ReadLine() End Sub I know I could use "ALTER TABLE ALTER COLUMN" commands as well, but is there any way to create/update columns to a table in a database using ADO.NET (without using DAO or ADOX) Thanks for your efforts! wkr binder Tag: DBMS for remote database management Tag: 128224
  - 15
    - VS2005: Bug in Rowchanged event during cascade update? New 'behaviour' in ADO.NET 2.0? In a DataSet, I create a ParentTable with a Primary Key (ParentID). I then create a ChildTable with a Primary Key (ChildID) an a ParentID column. I create a Relation from ChildTable.ParentID to ParentTable.ParentID with both Relation and Foreign Key Constraint and Cascade Update rule. I then write at little program: 1. Add a row to the ParentTable (ParentID = 1). 2. Add a row to the ChildTable, referencing the row in the ParentTable. 3. Add RowChanged handlers to both tables. 4. Update ParentID in the parentRow (parentRow.ParentID = 100); - The ParentRow is updated and the update is cascade to the ChildTable. ChildTable.RowChanged is fired. The problem: In the ChildTable.RowChanged handler I can see the childRow has been updated: ((ChildTableRow)e.Row).ParentID is 100. BUT ((ChildTableRow)e.Row).ParentTableRow returns null !!! If I output ds.ParentTable.Rows[0].ParentID (I only have one row in the table) it is 100. The field has been updated in both tables - but ChildTableRow.ParentTableRow cannot find it. If I call ds.ParentTable.FindByParentID(100), null is returned. When the ParentTable.RowChanged event is fired subsequently, there is no problem with ChildTableRow.ParentTableRow. What is going on? Can anybody help me? Regards, Zach Tag: DBMS for remote database management Tag: 128223
  - 16
    - Stored Procedure in SQL Server 2000 ? Hi, How do I get the all possible stored procedures for a given table in SQL Server 2000 for example like To Insert, To Insert with Parameters, To Update, To Delete, To Do Transaction ie for example to Transfer Some Amount from One Account to Another Account. I should be able to pass the Account A, Account B and the Amount to be Transfer. Thanks & Regards, SS Tag: DBMS for remote database management Tag: 128220
  - 17
    - binding navigator delete modification The delete button in a data binding navigator by default will delete de current row in the binding source. Can anyone tell me how can I cancel a delete after a click on the button delete?? I want to do this in order to delete the current row just in some cases, for instance when the user is asked to confirm the deletion. Any help is very appreciated, Tag: DBMS for remote database management Tag: 128218
  - 18
    - Connection string is class module Hello, I put the connection string to the Web.config file, then in Global.asax I'm assigning this string to the application variable: cn = New OracleConnection cn.ConnectionString = AppCrypto.decrypt(ConfigurationSettings.AppSettings("ConnectionString")) Then I use this to variable to connect to the server: cn = New OracleConnection(Application("ConnectionString")) Everything works great with the webforms. However, to keep my connection code in one place, I put all my connection code in the class module. But in the class module this doesn't work! I have to use exactly the same code as in the Global.asax: cn = New OracleConnection cn.ConnectionString = AppCrypto.decrypt(ConfigurationSettings.AppSettings("ConnectionString")) This is not acceptable, because the connection is encripted, and if it gets decripted every time my application connects to the database, it slows things down badly. Why the application variable doesn't work in the class module? Probably I'm doing something incorrectly. The only solution I see now is to drop my connection class and connect to db in the webforms, which is not a smart application design. Is there a better solution? I would appreciate your advice very much. Thank you, -- Peter Afonin Tag: DBMS for remote database management Tag: 128217
  - 19
    - DataTable.Select - There is no Row at position X -- Exception Hello, I'm facing this problem for a long time from now... I have a datatable that after a set number of rows gets all rows deleted (and archived into a xml) but to not have a clash with id's I set the start index from the datatable to the last id written in the xml plus 1, no problem... BUT... after a lot of deletes and inserts, when I run a .Select statement into a DataTable I get this error "There is no row at position X" where X is a number that really doesn't exist... but I simply run a select statement, not a foreach nor nothing... it's nonsense to look for a data that doesn't exist... e.g.: if my table is limited to 200 entries, after a few selects, deletes and inserts, it starts to return an error at some random position (not sure if is random but absolutely is not the same row) for example, BUT, sometimes, it says that there's no row in a position that has a row... I already debugged and in a few situations, this exception was thrown on the row 10, for example, but looking at position 10 of the datatable I could find data AND ACCESS IT... Does anyone knows something about it? Is some kind of bug...? Am I missing something?! Thanks in advance Tag: DBMS for remote database management Tag: 128215
  - 20
    - Creating Strongly Typed Data Set Hi, I created a strongly typed data set that contains two tables (Orders and OrdersDetails). The tables have a parent/child relationship. How can I populate both tables based on values returned by a stored procedure in such a way so that the OrderDetails table contains only data for orders that exist in Orders table (i.e. preserving the parent/child relationship)? I'm usng SQL 2000 and .NET 2.0 Thank you. Tag: DBMS for remote database management Tag: 128214
  - 21
    - Can anyone suggest an easier or better way to skin this cat? Two Select Queries Hi All, Here's my situation. I have two tables. Table1 is a 'transaction' table. Table2 is a 'master' table. What I want to do is two-fold. First I want to check if there is a match between ProdGrp (t1ProdGrp = t2ProdGrp). If there isn't a match, indicate on the transaction there is a critical error. If there is a match, check to see if there is a complete match (t1ProdGrp = t2ProdGrp AND t1Cat = t2Cat AND t1subCat = t2SubCat). If there is a full match flag the transaction as valid. If not a full match, indicate on the transaction there is a minor (correctable) error. My original thought was to create 2 select statements and do 2 queries against Table2. "Select * from Table2 where t1ProdGrp = t2ProdGroup " "Select * from Table2 where t1ProdGrp = t2ProdGroup AND _ t1Cat = t2Cat AND t1subCat = t2SubCat" That seems quite expensive in terms of processing. (Maybe it isn't) The tables have the following key and field structure: Table1 PK t1Date pk t1Part pk t1WH t1ProdGrp t1Cat t1SubCat ....other fields..... Table2 PK t2ProdGrp pk t2Cat pk t2SubCat ....other fields..... Can anyone suggest an easier or better way to skin this cat? Thanks, Hexman P.S. There are about 40 ProdGrps, each of the ProdGrps have 20 Cats and each Cat has 3 - 20 SubCats. Tag: DBMS for remote database management Tag: 128211
  - 22
    - DataAdapter.Update not actually updating my database So, this is driving me nuts. I have verified that the row that was added or modified in the datatable was indeed added or edited. The update methods return value IS 1, indicating that the row I was after was altered. And for the rest of the execution of the program, the datatable has the modified value. However, the DB does NOT get modified at all... As soon as I close and re-run the program the JobsDataTable reverts back to it's original state... it HAS to be something dumb, I am about to give up and write out a SQL statement... private void SaveChanges() { BackupDataDataSet.JobsDataTable jt = _Adapter.GetData(); object[] objArr = {_JobID, _txtName.Text, _txtDescription.Text, _txtExcludeList.Text, _txtSourceFolder.Text, _txtDestFolder.Text, _cbIncludeSubFolders.Checked, _cbCompressFiles.Checked }; jt.BeginLoadData(); jt.LoadDataRow(objArr, false); int junk = _Adapter.Update(jt); jt.EndLoadData(); jt.AcceptChanges(); _IsDirty = false; } If you want the complete application you can download the zip file (DB included) at: http://www.ats-engineers.com/filebackup.zip It's all in a project already, I am using MS VC# Express.... HELP * sobs uncontrollably * AB ** Insert Clever Signature Here ** Tag: DBMS for remote database management Tag: 128210
  - 23
    - What happened to ADO.Net business objects I remember reading in a book on Beta 2 ADO.Net that MS was comming out with their own version of O/R Mapping called Business Objects. I've been searching around for info on this, but not comming up with anything. Did MS drop Business Objects for the final release? Tag: DBMS for remote database management Tag: 128206
  - 24
    - Expression Field not working in code. I have a table with a simple expression column. I'm multiplying quantity * AveLaborRate to come up with total_labor. When I do the 'preview data' it works fine, but when I run my program, all I get is the default 0. All of the other fields have the same data as the preview. What could be causing the total_labor field not to calculate? Is there a way to view all of the contents in a table while I'm in debug mode? FoxPro has the 'Browse' command. Is there anything similar in C#? I'm using VS2005 C# and SQL 2005. Tag: DBMS for remote database management Tag: 128205
  - 25
    - Deploying Custom .NET Data Provider Hi I've written my own data provider and want to be able to deploy it so that it becomes available generally on the machine. Ideally to be able to add a data connection in visual studio's Server Explorer. I haven't been able to find anything meaningful on the web thus far to detail what it is you need to configure to be able to do this, and was wondering if anyone knew how to achieve this? TIA -aj Tag: DBMS for remote database management Tag: 128203
- Next
  - 1
    - Problems with Int64 and number in Oracle Hi I have a table in oracle like this: RecID: NUMBER Description: VARCHAR2(256) If I try to get a record which has a "big" int64 value it won't return any record. I can insert a record like this: insert into MyTable (RecID, Description) values (2821747746824216, 'Test record') I can list all rows in table with the sql "select * from MyTable". It then shows: RecID Description 2,82174774682421E+15 Test record But if I try to get the record by using the record ID: "select * from MyTable where RecID=2821747746824216" I don't get any result. I have tried by using parameters in the sql, but with no luck. If the Record ID is a "small" int64, like 282174, it works fine. Any ideas? Marius Tag: DBMS for remote database management Tag: 128202
  - 2
    - Good news to all those who are seeking for job in dotnet(Only those who are leaving in Hyderabad -India) Very Good news for all freshers and especially those who want to shift to Dotnet Technologies We have established an Training and Development Center Named Z-Axis Technologies in Our City at KPHB, Hyderabad. Early Birds get exclusive benefits like training Material, Project guidance etc Batch Starts from Monday from 1st May2006 ASP.Net with C# Regular Batch Duration: 3 Months Asp.Net:45 Minutes C#.Net:45 Minutes Batch Timings: Morning 7:15- 8:45 You can attend directly at 7:15 AM sharp Hurry! Batch Size Limited to 30 only. Address #402,4th floor,Saptagiri Complex, Behind KPHB Bus stop, Kukatpally, Hyderabad. Ph:040-40102733 Email: info@zaxistechnologies.com Interested candidates may contact Mr.Anil :9885432445 EmailID:Desayya@yahoo.com Benefits: =EF=82=A7 Free SqlServer2000 Course for this batch students only =EF=82=A7 Individual caring for students =EF=82=A7 Established with a vision of proper career guidance to develop young, dynamic technocrats =EF=82=A7 Limited Number of students =EF=82=A7 Live project Assistant by Experienced Programmers =EF=82=A7 It's very near to City U don't need to go to faraway places from Your town and get tired =EF=82=A7 Job Guidance and Placement Assistance =EF=82=A7 After the Completion of the Course a bonus course exclusively f= or this batch students only on How to satisfy interviewer and to be in Your dream Company? So Hurry Up Friends! Inform the people those who are seeking for training and placement Tag: DBMS for remote database management Tag: 128197
  - 3
    - [REPOST] SMO Table Scripts -- Defaults and Binding Rules I'm using SMO to script out some tables, but I can't figure out how to include the column default field values or how to bind the user defined rules to the columns. I'm using the options shown below: --------------------------------- _createOptions.ClusteredIndexes = true; _createOptions.Default = true; _createOptions.Indexes = true; _createOptions.NonClusteredIndexes = true; _createOptions.Permissions = true; _createOptions.PrimaryObject = true; _createOptions.SchemaQualify = true; _createOptions.SchemaQualifyForeignKeysReferences = true; _createOptions.ScriptDrops = false; _createOptions.Triggers = true; table.Script(_createOptions) --------------------------------- Here are the parts I'm missing: --------------------------------- ALTER TABLE [dbo].[PERSON] ADD CONSTRAINT [DF_PERSON_FirstName] DEFAULT ('FIRST') FOR [FirstName] GO setuser GO EXEC sp_bindrule N'[dbo].[RULE_BOOLEAN]', N'[PERSON].[Flag]' GO EXEC sp_bindefault N'[dbo].[DEF_NO]', N'[PERSON].[Flag]' GO EXEC sp_bindefault N'[dbo].[DEF_ID]', N'[PERSON].[OriginID]' GO EXEC sp_bindefault N'[dbo].[DEF_ID]', N'[PERSON].[OwnerID]' GO EXEC sp_bindefault N'[dbo].[DEF_TODAY_UTC]', N'[PERSON].[Timestamp]' GO EXEC sp_bindrule N'[dbo].[RULE_BOOLEAN]', N'[PERSON].[VerifySSN]' GO EXEC sp_bindefault N'[dbo].[DEF_NO]', N'[PERSON].[VerifySSN]' GO EXEC sp_bindrule N'[dbo].[RULE_BOOLEAN]', N'[PERSON].[WorkBadAddress]' GO EXEC sp_bindefault N'[dbo].[DEF_NO]', N'[PERSON].[WorkBadAddress]' GO setuser GO --------------------------------- Thanks. Scott C Tag: DBMS for remote database management Tag: 128193
  - 4
    - Select Distince Row Filter for dataview Is there a way to filter the rows of a Data View using the "Select Distinct" SQL statement? If so how do i use it? Thanks. Gary Tag: DBMS for remote database management Tag: 128190
  - 5
    - data reader error... I keep getting this error message...System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, 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, String srcTable) at BDB.AddressEditor.RedoData() in It happens after I perform an executenonquery, then try to reload data into a dataset based on the table i just used the non query on to insert a new row into it... nothing in this is databound, why would i get this error? i dont even use data readers in my program (i understand that ADO.NET does in the background though) so how can i go about debugging this? Tag: DBMS for remote database management Tag: 128182
  - 6
    - ADO.NET 2.0 autoincrement problem using SQL 2005 & Web Services Hi NG! I've tried the sample walkthrough: Creating a Distrubited Application with my database which includes a autoincrement value. My problem is that i don't get the current autoincrement value from the SQL Server when the table is empty. I clicked the save button whiches sends the datatable via WS to the sql server but the id in the datatable is incorrect. The problem does not occur when i connect the windows app directly to the sql server. Is there any way to get the latest autoincrement value from the sql server to set it correctly into the datatable? thx 4 any help Werner Tag: DBMS for remote database management Tag: 128175
  - 7
    - Out of Memory Exception Should be an easy one for you veterans. Have a DataSet that I'm looping through with a For Each loop. There are 500+ records in this DataSet. For each record, I'm creating a PDF by exporting an ActiveReport. So the basic logic flow is: Dim rpt As Main = New Main ' This is the activereport For Each dr In dv.Table.Rows <set rpt values here> rpt.Run(False) Dim xPDF As DataDynamics.ActiveReports.Export.Pdf.PdfExport = New DataDynamics.ActiveReports.Export.Pdf.PdfExport xPDF.Export(rpt.Document, mStream) pdfPath = Request.PhysicalApplicationPath & "\collection\temppdfs\" & dr("List_ID") & ".pdf" xPDF.Export(rpt.Document, pdfPath) xPDF.Dispose() Next I'm only able to get about 200 through before it gives me an Out of Memory exception. Seems like there is an obvious design flaw, and I'm just not sure how to structure this so it "reuses" memory. Any thoughts? Thanks! Tag: DBMS for remote database management Tag: 128172
  - 8
    - Dataset or datasource control? Sorry about the cross posting. Shouldn't have gone to aspnet. Hi all, Having moved from dotnet V1.1 to V2 I am having some difficulty understanding the new data access methods that seem to be preferred. In V1.1 the dataset did everything that I needed, and now it seems that the preferrence is the datasource control! aaarrrrgggg! I have followed several example of how to manage the modification and deletion of data from a gridview on as asp.net page and I have to say I am impressed with its simplicity, however, can anyone point be to a post or other online article that has the details of how to do this using a dataset instead of a datasource? I can bind my dataset to the gridview, but the entire edit/delete functionality has gone. What am I missing? Many thanks, Jason Tag: DBMS for remote database management Tag: 128169
  - 9
    - Q: Expressions in DataColumns Hi I've run into a problem when using Expressions in a DataColumn of a DataTable which I'm updating back to the underlying databas. That is, I'm loading data into a DataTable in which I've set some of the DataColumns to calculate their contents using the Expression property. This all works fine until I try and transfer these calculated values back to the SQL database. When I try to do this, I get the exception message: "The column mapping from SourceColumn 'Col 1' failed because the DataColumn 'Col 1' is a computed column" Is there anyway I can override this exception so the values are written back to the database? Geoff Tag: DBMS for remote database management Tag: 128168
  - 10
    - Multiple Data Source, Same Front End Hi every one!! i'm a newbe... studing about ado.net ... and i'm climbing the big wall of the .net architecture THE PROJECT: I need to build a library Catalog. The library has a lot of DataBases like "catalog1.mdb" "catalog2.mdb" .... and so on. But all of them have the same structure. So when you choose a file (.mdb), the app has to Show all the books of that file. Since the structure is the same for all the file, I guess i can create only a form that display datas (controls binded), depending on which files is selected (or opened) can anyone tell me a high-level algorithm focused on data side (ADO)? What will be the static part and what will has to change (and how) what has to happen from the opening of the file to the showing of the dates? thanks everyone Mario Tag: DBMS for remote database management Tag: 128167
  - 11
    - hierachical related client side data duplication I have a hierachical dataset brought back from a sql server stored procedure with a design as follows : StaffID <Staff Columns> AddressID <Address Columns> StaffID_FK PhoneID <Phone Columns> AddressID_FK Im using a disconnected architecture, so when I recieve the dataset , I remap the the relationship (is there no way to get this relationship from sql server - see's silly remapping). What im now looking to do is to duplicate a staff members data , if I copied a row from the Staff table will all the related data also be duplicated ? and if it wont whats the best way to achieve this result ? Jon Tag: DBMS for remote database management Tag: 128163
  - 12
    - VB Database Book Recommendation? I'm looking for an Advanced Database Programming book strictly dealing with VB 2005. I'm looking for something specific such as: Customers > Orders > OrderDetails Being able to add an order with details for a new/existing customer. Any ideas? I've looked at some reviews on Amazon.com but nothing sticks out. Thanks, Tony Tag: DBMS for remote database management Tag: 128158
  - 13
    - SMO Table Scripts -- Defaults and Binding Rules I'm using SMO to script out some tables, but I can't figure out how to include the column default field values or how to bind the user defined rules to the columns. I'm using the options shown below: --------------------------------- _createOptions.ClusteredIndexes = true; _createOptions.Default = true; _createOptions.Indexes = true; _createOptions.NonClusteredIndexes = true; _createOptions.Permissions = true; _createOptions.PrimaryObject = true; _createOptions.SchemaQualify = true; _createOptions.SchemaQualifyForeignKeysReferences = true; _createOptions.ScriptDrops = false; _createOptions.Triggers = true; table.Script(_createOptions) --------------------------------- Here are the parts I'm missing: --------------------------------- ALTER TABLE [dbo].[PERSON] ADD CONSTRAINT [DF_PERSON_FirstName] DEFAULT ('FIRST') FOR [FirstName] GO setuser GO EXEC sp_bindrule N'[dbo].[RULE_BOOLEAN]', N'[PERSON].[Flag]' GO EXEC sp_bindefault N'[dbo].[DEF_NO]', N'[PERSON].[Flag]' GO EXEC sp_bindefault N'[dbo].[DEF_ID]', N'[PERSON].[OriginID]' GO EXEC sp_bindefault N'[dbo].[DEF_ID]', N'[PERSON].[OwnerID]' GO EXEC sp_bindefault N'[dbo].[DEF_TODAY_UTC]', N'[PERSON].[Timestamp]' GO EXEC sp_bindrule N'[dbo].[RULE_BOOLEAN]', N'[PERSON].[VerifySSN]' GO EXEC sp_bindefault N'[dbo].[DEF_NO]', N'[PERSON].[VerifySSN]' GO EXEC sp_bindrule N'[dbo].[RULE_BOOLEAN]', N'[PERSON].[WorkBadAddress]' GO EXEC sp_bindefault N'[dbo].[DEF_NO]', N'[PERSON].[WorkBadAddress]' GO setuser GO --------------------------------- Thanks. Scott C. Tag: DBMS for remote database management Tag: 128155
  - 14
    - Adding a Web Reference changes DataTypes ??? Hi, I having created a simple WebService (in VS 2005) with just one WebMethod as follows : [WebMethod] public DataTable GetProducts() { DataTable objDataTable = null; // code for filling up the datatable return objDataTable; } Then, Adding the WebService as a Web Reference to a Client Application is following proxy code generated at the client for the WebMethod : public GetProductsResponseGetProductsResult GetProducts() { object[] results = this.Invoke("GetProducts", new object[0]); return ((GetProductsResponseGetProductsResult)(results[0])); } Look at the return type of the method : at the server it was defined as DataTable but at the client is it changed to an unreadable name GetProductsResponseGetProductsResult ??? What is happening here ? how can I make sure that the DataTable-type is used at the client as well ? thanks Chris Tag: DBMS for remote database management Tag: 128149
  - 15
    - Batch Update + Parent/Child + AutoIncrement/Identity = Yikes! Hi, I've seen about 2,345 messages on how to submit parent/child rows via ado.net. >From what I've gathered, the process goes: 1. Make Connection, Grab Tables/DataSet & Build CommandAdapters 2. Build relations 3. Make Changes 4. Post parent row with event handler (ms Access). 5. Grab new ID in event handler with new SQL command, 6. Post new ID into the parent Row updated in #4. 7. Watch the Cascade 8. Update the Children It's a bit of a pain - but ok...but what about the case where we have 500 parent rows and 10,000 child rows to post back to the Database? There has to be a batch process that works. i.e.: 1,2 & 3 as above. 4. Post all parent rows in a batch update. 5. Grab all the changed parent rows in one pull. 6. Apply the new Keys in 5 to the underlying parent records (that cuttenly have -1 to -100 in them). 7. Watch the Cascade 8. Update the children. I can't figure out how to do #5 and #6 without losing the relationship to the child rows. Can anyone help? I'm using vb.net and ms access. My use case is a music library. The parent table is tblArtists, with ArtistID (autoincrement, primary key) and ArtistName (string). The child table is tblTracks, with amongst 70 other things, an ArtistID field that connects to its parent. I have an inbound object that has a set of child table fields and the ArtistName. My code posts the ArtistName to tblArtists and the ArtistID that is generated to tblTracks. In a given pass, I will be creating around 500 artist rows and 10,000 track rows. Thanks in advance. Tag: DBMS for remote database management Tag: 128144
  - 16
    - Null in a Column when there is data I'm running .Net v1.1, C# against a SQL Server 2000 db. I've got a stored procedure that returns multiple columns. All but the first column are numeric(18,6). I have the standard SqlConnection/SqlCommand/SqlDataAdapter calls to retrieve the data and simply display in a DataGrid. The first three numeric columns are all null and many of the others appear to be null. However, when I run the same query in the Query Analyzer, all the data is coming back. I have even checked one of the columns (eg. dataSet.Tables[0].Rows[0][2]) and it returns System.DBNull when I know there is data there. Anybody have any ideas??? -- John Mark Howell blog: http://jmarkhowell.blogspot.com/ Tag: DBMS for remote database management Tag: 128143
  - 17
    - Missing post data in Internet Explorer (bug?) I had a really weird bug recently. I had a drop-down user control that would not fire the onselectedchange event server-side. After nearly twenty hours of debugging, I finally setup a local proxy (WebScarab, which rocks by the way) and noticed that IE was deciding not to POST the key/value pair for the event, but Firefox was. I double- and triple-checked the XHTML, and the thing is valid. Here is the post data, in summary: IE6: __EVENTTARGET=UcDDLBusinessUnit1%3AddlBusinessUnit&__EVENTARGUMENT.......=&ViewQuestion2%3AddlStatusChangePR=4 Firefox: __EVENTTARGET=UcDDLBusinessUnit1%3AddlBusinessUnit&__EVENTARGUMENT.......=&ViewQuestion2%3AddlStatusChangePR=4&UcDDLBusinessUnit1%3AddlBusinessUnit=1 If I simply moved the user control up the page, the event started firing server-side and the POST data Content-Length got longer (IE6 only). Any thoughts? (For security reasons, I cannot publish the full POST data or XHTML.) Thanks, Ian Tag: DBMS for remote database management Tag: 128140
  - 18
    - Deleting a Row from Datatable and from Database Hi, I've a Datagridview binded with a Datatable. With this code: DataTable.rows.remove(current_datarow) DataAdapter.update(datatable) ... I manage to delete the row from the DataTable, it disapears from the DataGridView, but it doesn't delete it from he database (after updating the DataAdapter). Can anyone tell me where is the problem ?! Thanks CC Tag: DBMS for remote database management Tag: 128133
  - 19
    - Built-In JavaScript-Rendering Functions Hi. What's the most elegant way, in ASP.NET 2.0, to cause certain client-side things to happen without writing my own JavaScript? Here are some of the things I'd like to be able to do... * When I'm finished doing stuff in Page_Load(), I'd like the cause the page to scroll to a specific anchor or to the top or bottom of the page. * When the page is finished loading, I want to be able to programmatically designate a text-box to have the focus for user entry. Is there any built-in server-side code I can call that will cause the appropriate client-side JavaScript to be rendered to the client to do these things? Tag: DBMS for remote database management Tag: 128132
  - 20
    - Urgent:Newbie:Autoincrement violates foreign key con1straints Hi, I'm reading an xml file into a dataset and entering the data into an SQL server express database. I've got an employee table (empid as primary key) and an employee photo table (empid as foreign key) My xml file contains an employee element and multiple employee photo elements. I'm using auto increments and setting the seed and step to -1 in both the database and in my code (Vb.net - i'm setting this using the drag and drop dataset - as i said i'm a newbie and just getting trying to get a quick solution) if i have just one one photo element, it enters into my datagrid (windows form) ok as photoid empid photofilename -1 -1 emp1.jpg i think the problem arises when i use multiple employeephoto elements the photoid will increment okay but as its still the same employee there will be a a constraint on the foreign key (at least this is guess!!) if anyone has any suggestions on how i could get around this, it would be GREATLY APPRECIATED. i've been looking at this for the past few days and getting increasingly frustrated. thanks in advance, alan Tag: DBMS for remote database management Tag: 128131
  - 21
    - DATAGRID PROBLEM First When I Bind my datagrid It returns --Unisex-- value for my GENDER_NAME field. When I click Edit , Write UNI to update UNÝSEX value and Click Update button i catch UPDATE TBL_GENDER SET GENDER_NAME='Unisex' WHERE GENDER_ID=1 with response.write .. Why it doesnt return me current value of my Text1 texbox item. What is the problem? <asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 190px; POSITION: absolute; TOP: 195px" runat="server" AutoGenerateColumns="False"> <Columns> <asp:editcommandcolumn edittext="Edit" canceltext="Cancel" updatetext="Update" itemstyle-wrap="false" ItemStyle-Width="100px" /> <asp:TemplateColumn> <EditItemTemplate > <asp:TextBox ID="Text1" Runat=server Text='<%# DataBinder.Eval(Container, "DataItem.GENDER_NAME") %>'> </asp:TextBox> <asp:TextBox ID="Label1" Runat=server Visible=False Text='<%# DataBinder.Eval(Container, "DataItem.GENDER_ID") %>'> </asp:TextBox> </EditItemTemplate> </asp:TemplateColumn> </Columns> </asp:DataGrid> Private Sub DataGrid1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.EditCommand Me.DataGrid1.EditItemIndex = e.Item.ItemIndex DataGrid1.DataBind() End Sub Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand Dim sorgu As String Dim strDestination As String = CType(e.Item.FindControl("Text1"), TextBox).Text Dim strID As String = CType(e.Item.FindControl("Label1"), TextBox).Text Dim baglantim1 As New SqlClient.SqlConnection sorgu = "UPDATE TBL_GENDER SET GENDER_NAME='" & strDestination & "' WHERE GENDER_ID=" & strID Response.Write(sorgu) Response.End() End Sub Tag: DBMS for remote database management Tag: 128129
  - 22
    - Read cvs File Fails I am using Odbc to read cvs files. Unfortunately, some cvs files are not formated correctly (out of my control). One particular problem is that a quote within an item is not put in double quotes, i.e. the file says "this "item" is bad", "this item is ok" rather then "this ""item"" is bad", "this item is ok" odbc now thinks 'this ' is the first item rather then 'this "item" is bad'. Excel reads the file just fine, though. Is there some workaround, short of fixing the file myself, to make the driver more error tolerant? If it helps anything bellow is how I read the excel file. Thanks connectionString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + Path.GetDirectoryName(filename); connection = new OdbcConnection(connectionString); connection.Open(); command = new OdbcCommand("Select * FROM " + Path.GetFileName(filename), connection); reader = command.ExecuteReader(); Tag: DBMS for remote database management Tag: 128127
  - 23
    - DataTable, SqlDataAdaptor and updating deleted rows (v1.1) Here was a scenareo I came across recently. I was using a table adaptor to handle syncing the changes from a client machine to a server. These would run stored procedures on the sql server to update the data as depending on certian conditions some values couldn't be edited by the user (the application should deny these edits anyway but I implicitly don't trust the user so the server gets the last word). For the update/insert commands this works fine as they have the ability to fetch the results of a row returned as being the results stored by the server. Unfortunatly the delet command ignores any result returned. This is understandable if it was deleting it, but in certain cases the server decides to reject the delete, but the client machine doesn't realise as it ignores any returned values from the server and I could see no way to override this automatic command behaviour. As long as the program is upto date and its logic on whether a client can remove a row this isn't a problem, but I was curious if anyone knew a way round this default behaviour in a simple way. Otherwise the only choice would be overriding the SqlDataAdapter or writing one's own data adapter. Tag: DBMS for remote database management Tag: 128125
  - 24
    - VB 2005 & SQL I am trying to write a VB.NET 2005 app using a similar setup of the infamous Northwind DB. I am using SQL 2005 Express on my laptop and will eventually upgrade to SQL 2005. My tables consists of: Customers Orders OrderDetails Category Products Suppliers My problem is: Watching the webcasts on development using databases, they show how to create a fully functional (yeah right) app with related tables. They don't show how to add orders and order details related to the customer. For example: Order Details table has a many-to-1 relationship with Orders. I have a GUI with the cutomer info, then the related table orders, and a group box with order details, how do I add Orders and Order Details to the customer? The binding navigator allows me to add a user to the screen (that's the easy part). I guess what I want to know is what code do I need to write to add Orders and Order Details to the customer. The following links are pictures of my GUI for the orders form and the related binding info for the form in VB 2005. http://www.kingenterprises.dynu.com/images/Orders.jpg http://www.kingenterprises.dynu.com/images/dataBinding.jpg Thanks in advance for the help. Tony Tag: DBMS for remote database management Tag: 128123
  - 25
    - Calling DB2 Stored Procedure with Parameters Has anyone ever called a DB2 stored procedure using the .Net OleDbDataAdapter and passed parameters to the stored procedure? Can you give an example? Thanks in advance. Tag: DBMS for remote database management Tag: 128117

I'm looking for something to change the MDB's layout on a website (of ours)
.

Would be nice to do that in the browser but some kind of ftp app would do
fine as well.
??

Top