XML Partitioning

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
    - Executenonquery I have wrote this code and my DB server is Sql Server 2000 SP4 Dim cnSql as new SqlClient.SqlConnection Dim cmdSql As New SqlClient.SqlCommand cnsql="Data Source=ced2; User ID=sa; Password=;Initial Catalog=NGN;Persist Security Info=True;" cnsql.open cmdSql.CommandText = "create view VISTAGIACENZE as select codice,sum(giacenza) as Giacenza from giacenze where magazzino='001' or magazzino='500' group by codice" cmsql.connection=cnsql cmdSql.CommandText = strsql cmdSql.ExecuteNonQuery() When I try to execute method executenonquery Visual Studio return this error System.Data.SqlClient.SqlException - Incorrect syntax near the keyword 'VIEW'. It's very strange because executing the same string in query analyzer works fine without errors. Could you help me??? Thanks in advance. Antonio. Tag: XML Partitioning Tag: 113152
  - 2
    - Sorting Child Tables in a Data View Hello folks This seems relatively quite easy but I cannot put my finger to it. I have a form with 5 tabs. I also have a dataset with 5 tables, (1 parent with 4 child). I have a data View of the dataset which is bound to the form. So my form has a listview, with first name & last name (in that sort order) so that they can be easily found. now on each tab, the records are sorted as they are entered (I guess by id). But what I want is, each tab, (which is bound to its respective child table which is in the same dataview), to be sorted based on another field. I can easily create another dataview and bind, but then I lose the binding, and when a record is changed on the main form, the records will not be changed in the tabs. So how do I do this ?! Thanks Tag: XML Partitioning Tag: 113150
  - 3
    - Code for retrieving/updating data in Oracle database using ASP.NET Can anyone help me out from the above by giving a code snippnet including the import namespace directives. Regards/CS Tag: XML Partitioning Tag: 113141
  - 4
    - Can someone please explain this behavior? I can't find any answers, I have no idea why this is happening. I have a dataset. In this dataset there are three tables RO ROParts, ROLabor ROParts and ROLabor are related to the RO table one to many relationship PKEY on RO is the RO#, ROLOC, RODATE these three fields are replicated in each of the child tables. The relationship works fine, however when I bind them to a data grid and drill to the child rows it includes all of the child fields plus all of the parent fields (in the same row as the child data). I am not sure why this is happening. Any thoughts? Tag: XML Partitioning Tag: 113132
  - 5
    - Update MS Access Database Records First of all, thanks for the help on my previous VB.NET/MS Access questions. This time I need do the following 1. Connect to a table 2. step through each of its records 3. read the value of two of the records fields 4. pass those values to a function 5. write the value returned by the function the same record in a third field Hope this makes sense. Basically I want to read records and based on values of two of their fields I want to update another of their fields. Thanks Thomas -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service ------->>>>>>http://www.NewsDemon.com<<<<<<------ Unlimited Access, Anonymous Accounts, Uncensored Broadband Access Tag: XML Partitioning Tag: 113131
  - 6
    - export dataset to excel I written myself some small generic class to export any dataset to an excel spreadsheet: public static void Export(DataSet data, String excelFileName) { System.IO.File.Delete(excelFileName); string strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.IO.Path.GetDirectoryName(excelFileName) + @"\" + System.IO.Path.GetFileName(excelFileName) + @";Extended Properties='Excel 8.0;HDR=YES'"; using (System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(strConnectionString)) using (System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("", objConn)) { objConn.Open(); foreach (DataTable dt in data.Tables) { cmd.CommandText = "CREATE TABLE [" + dt.TableName + "] ("; String valueNames = "("; Boolean first = true; foreach (DataColumn dc in dt.Columns) { if (!first) { cmd.CommandText += ",\r\n"; valueNames += ", "; } cmd.CommandText += " [" + dc.ColumnName + "] NVARCHAR(100)"; valueNames += " [" + dc.ColumnName + "]"; first = false; } cmd.CommandText += ")"; valueNames += ")"; cmd.ExecuteNonQuery(); foreach (DataRow dr in dt.Rows) { String values = "("; first = true; foreach (DataColumn dc in dt.Columns) { if (!first) values += ", "; values += " '" + dr[dc] + "'"; first = false; } values += ")"; cmd.CommandText = "INSERT INTO [" + dt.TableName + "$] " + valueNames + " VALUES " + values; cmd.ExecuteNonQuery(); } } } } This does work quite ok for my uses, the only problem is: After export the first character in every single cell of the excel spreadsheet is the quotation mark ' Somehow the export does not strip the leading quotation marks from my values - anyone can give me a hint how I do get rid of these? thanks, Sam Tag: XML Partitioning Tag: 113124
  - 7
    - DataReader and DataAdapter relation Hi All, I often get the same error when filling data adapter. There is already an open DataReader associated with this Connection which must be closed first myda.Fill(newds, "Employee") But the same type fill command is working in other forms without error. When filling data adapter it internally opens the executereader but it is not closing. How the OledbDataAdapter with fill works? When will it executes the reader. Why there is a difference in filling with datasets? Thanks in Advance ______________________________ S. Viswanathan Tag: XML Partitioning Tag: 113109
  - 8
    - Constraint error when dataset.GetChanges() invoked I'm running into a puzzling exception when I attempt to update a modified row in a table with a foreign key constraint. System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints My application has a single dataset with five tables that gets loaded from an Access database. The error occurs along the way to propagating a (trivial) change back to the .mdb file, and _seems_ to be related to my attempt to update a single row of a single table (call it TableB) which has a foriegn key constraint pointing back to another table (call it TableA). These look like the following: TableA: pk_a (autonumber primary key) [other columns, none required] TableB: pk_b (autonumber primary key) pk_a (foreign key to TableA) [other columns, none required] These tables are loaded into a common DataSet which has been set up witht he following constraints for TableB: fkc_fd_pr = new ForeignKeyConstraint( "TableATableB", dataset.Tables["TableA"].Columns["pk_a"], dataset.Tables["TableB"].Columns["pk_a"] ); fkc_fd_pr.DeleteRule = Rule.Cascade; fkc_fd_pr.UpdateRule = Rule.Cascade; fkc_fd_pr.AcceptRejectRule = AcceptRejectRule.Cascade; dataset.Tables["TabelB"].Constraints.Add(fkc_fd_pr); The dataset then is filled: dataadapter.Fill(dataset,"TableA"); dataadapter.Fill(dataset,"TableB"); ...etc. The user edits the contents of TableB through a form with lots of TextBoxen. When he/she/it clicks on a [Save] button, the code goes through the following steps: - Prompt for confirmation (Are you ReallyReallySure(tm)?) - bindingmanager.EndCurrentEdit() - If dataset.HasErrors, exit the update procedure. - If dataset.HasChanges(), then - temp_dataset = dataset.GetChanges() The exception is raised in the middle to the GetChanges method, with a stack trace that looks like the following: (Exception message) at System.Data.DataSet.FailedEnableConstraints() at System.Data.DataSet.EnableConstraints() at System.Data.DataSet.set_EnforceConstraints(Boolean value) at System.Data.DataSet.GetChanges(DataRowState rowStates) at System.Data.DataSet.GetChanges() After spending some time checking my Access table definitions, and much more time getting Google-eyed trying to find someone else who had seen a similar problem, I patched my code to try to figure out exactly what was being objected to. I added code similar to the following right after the check for .HasErrors and before invoking .GetChanges(), and then issued a simple [Edit] [Save] (no actual changes) on TableB. DataTable dt1 = dsPgtDb.Tables["TableA"].GetChanges(); DataTable dt2 = dsPgtDb.Tables["TableB"].GetChanges(); DataTable dt3 = dsPgtDb.Tables["TableC"].GetChanges(); DataTable dt4 = dsPgtDb.Tables["TableD"].GetChanges(); DataTable dt5 = dsPgtDb.Tables["TableE"].GetChanges(); Those all executed flawlessly (although all but the "TableB" result were null). DataSet ds1 = dsPgtDb.GetChanges(DataRowState.Added); DataSet ds2 = dsPgtDb.GetChanges(DataRowState.Deleted); DataSet ds3 = dsPgtDb.GetChanges(DataRowState.Detached); DataSet ds4 = dsPgtDb.GetChanges(DataRowState.Modified); DataSet ds5 = dsPgtDb.GetChanges(DataRowState.Unchanged); The first three of these worked just fine (null results, but no ConstraintException). The fourth line, the one checking for Modified datarows, tripped the ConstraintException. Still no clue as to _why_ ADO.NET is unhappy, but at least it confirms that it _is_ the one row I "modified" (opened up for editing but made no changes to) which is being objected to. This row was happily loaded from the Access .mdb file into a DataSet with constraints already in place. So why, when it gets flagged as Modified, does GetChanges have a hernia trying to locate it in one DataSet and stuff a copy into a fresh, brand-spanking-new Dataset? Does anyone see any really obvious steps I'm leaving out that might contribute to the problem? Alternatively, can anyone suggest an approach for nailing down exactly _which_ constraint I'm rudely violating? Clues, hints, and suggestions will all be appreciated. I really don't have all that much hair left to pull out... <grin?> Frank McKenney, McKenney Associates Richmond, Virginia / (804) 320-4887 Munged E-mail: frank uscore mckenney ayut minds pring dawt cahm (y'all) -- It's not what we don't know that gives us trouble, it's what we know that ain't so. -- Will Rogers -- Tag: XML Partitioning Tag: 113103
  - 9
    - Beating a dead Horse: Which Language Hi, I know that I'm an extreme newb by asking this overly beaten question, but I am leaning toward C#, becuase the perception is that it is better to learn than VB.Net. I guess it makes you cooler.:-) Anyhow, I am a novice programmer, and I will remain one as well...I have no plans to make programming my life ambition, but I think that it would be fun to make my databases do some cool tricks and maybe write a simplistic client to access the database over the LAN, and by internet as well. My programing will be centered around Data manipulation, i.e. collecting, sorting, and reporting on this data to myself..... I want to know which language you find most compelling to accomplish my mission. It may be that it doesn't have anything at all to do with the language, from my understanding they are close to equal, but everyone I come in contact with prefer C# over VB.net Please, NO FLAMES; just logic Thank you in advance! Tag: XML Partitioning Tag: 113085
  - 10
    - So, how do I monitor *open* connections? I can look at performance monitor for pools, pooled connections etc. What I don't see is a way to tell, say, of the 25 pooled connections in the pool, how many are active and open. Anyone know of any tools for this? Any ideas? Anyone ... Tag: XML Partitioning Tag: 113081
  - 11
    - DataSet not releasing memory Hello - I've developed an application which uses DataSets which are local to specific methods - so they should go out of scope when the form they are on is closed. I am finding that while monitoring the memory usage through task manager, the memory will increase while the dataset is filled, but memory is never released when the form is closed. Even when using the Dispose() method of the DataSet, as well as explicitly calling GC.Collect() and GC.WaitForPendingFinalizers(). After searching the web for hourse, I cannot find anyone who can solve this problem. Does anyone know how to fix this? Thanks, -Peter Tag: XML Partitioning Tag: 113073
  - 12
    - Data design question I have a Windows Forms applications with a SQL Server back-end. There is a main form which shows a list of selected columns from a table (all rows are to be shown), and a dialog form which opens a detailed view of the selected record in the list and lets the user modify it; I'd also like to use the same dialog to add a new record, without rewriting the same code twice. The question is: what is the proper way to handle this? Possible solutions I've devised: 1) Using a query (SqlReader or DataSet + TableAdapter) to populate the list with all the needed data, then using the selected item index to get the table ID for the record; then passing the ID to the dialog form, which will create and populate an internal DataSet and act upon it; upon clicking "OK", it will save the modified DataSet to the DB (if any modifications were made). A special ID value (-1 ?) will be used to mean "create a new record and save it if the user clicks "OK". The DataSet will be discarded as soon as the dialog form closes. 2) Same as 1), but the DataSet will be populated inside the main form and passed to the dialog form; the form will modify it (eventually), and return it back to the main form, wich will save it or reject it based on DialogResult. This approach lets me populate it with a new row and pass it to the dialog, so there is no need to handle special cases in the dialog form. The DataSet will be created, filled and then discarded each time. Both of these approaches work on single rows of data, which are to be extracted from the DB upon request; but the whole amount of data will be relatively small (one or two hundreds of records, at most), so I thought it could also make sense to fully read it, put it in a DataSet and work with it, saving modifications when they're made; so, here's approach 3: 3) Fill a DataSet with all the data, including detailed data not shown on the main form; manually build the main list with the required info (which is to be built manually anyway, since some columns are to be grouped into text rows) and use it to select the row to modify; upon clicking the "Modify" button, pass the DataSet object and the row ID (which is easy to obtain since the whole table is available in the DataSet) to the dialog form; when clicking "New" instead of "Modify", add a new row to the DataSet and pass its ID to the form. When the user clicks "OK", save the data back to the DB and do a DataSet.AcceptChanges(); otherwise, if "Cancel" is clicked, do a DataSet.RejectChanges(). This seems to be the better approach, but there are some points I don't quite understand. First: I can't do AcceptChanges() or RejectChanges() inside the dialog form, since the main form would be unable to know if rows where modified; so, I must either save the changes inside the dialog form (which I don't want to do, since DB update logic doesn't belong there as in #1) or have the main form guess what happened using DialogResult; this last one seems OK, but is this good OO practice? The form receives a DataSet, shouldn't it be its responsibility to modify it or leave it untouched? Can I solve this using EndEdit() or CancelEdit() on the single row? Second: what happens if the user clicks "New" and then decides he doesn't want to add a new record and clicks "Cancel"? Will RejectChanges() delete the new row, or should I manually handle this? More generally: will RejectChanges leave the DataSet exactly as it was when the last AcceptChanges() was called? Side question: I have to use the same approach (main form with summary data, dialog form with detailed data) in some other parts of the application; again, the whole database will be quite small (maybe five tables, at most one-two hundred records each, plus some smaller ones (10-20 records)); also, some of these tables are linked with relations, which I'd like the program to enforce before trying to update the DB. Will it be a good design to put all of the tables into one big DataSet, fill it and use it as in #3? What is the practical limit for using a single DataSet, and when is it better to partially fill small ones with ad hoc queries? Thanks for any suggestion. Massimo P.S. I'm using Visual Studio 2005 beta with SQL 2005, so the framework version is 2.0; I don't think this should be of any relevance to this design question, but if the new framework offers better approaches than the other ones, feel free to let me know :-) Tag: XML Partitioning Tag: 113071
  - 13
    - SQL server 2000 transation deadlock in a cluster environment hi all got a situation here, there are 3 app server that are running this application to delete records in the sql server periodically. what happen is that they all start up at the same time.(this could be fixed by varying the start up time on each app server for that application, but it's not a good solution.) to delete records on the same table. so there is: transaction (process ID #100) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction." now I have read some article online saying putting a "with (UPDLOCK)" after the FROM <some table> will fix the problem. does anybody have the similar experience? what would be a perfect fix? thx Kevin Tag: XML Partitioning Tag: 113070
  - 14
    - A quick question: How to use variables in the SQL insertion string Hello, I am new to ADO.NET and SQL. What I am trying to do is very basic - to insert some variable values into database. The following is the C# code: private static void InsertIntoSqlDb(OleDbDataReader reader) { string insStr = ""; string list_no = reader.GetString(0); string item_no = reader.GetString(1); string description = reader.GetString(2); string priceStr = reader.GetString(3); insStr = "INSERT INTO dliTestDb (list, item, description, price) VALUES (list_no, item_no, description, priceStr)"; SqlCommand cmd = new SqlCommand(insStr, conn); //Insert // try { cmd.ExecuteNonQuery(); } catch(Exception ex) { Console.WriteLine(ex); } } Upon execution of the above, I got exception: System.Data.SqlClient.SqlException: The name 'list_no' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names ar e not permitted. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() Doesn't any one know how to use variable names exactly in the SQL insertion string? Thanks. Tag: XML Partitioning Tag: 113069
  - 15
    - Time is Stripped off When Saving DateTime to MS Access All, Using C# with ADO.NET I am trying to save a date time to an Access database. After the saving occurs I open Access database and only see the date not the time. I know the time was part of the DateTime object prior to saving it. Also while in Access I tried changing the format of the date time field to see the time, which showed it as 12:00 AM and is incorrect. See code snippet below: DataRow newRow = dataSet12.Table1.NewRow(); newRow["Index"] = 5; newRow["Column1"] = "Added"; newRow["MyDateTime"] = DateTime.Now; // <== Time is in object dataSet12.Table1.Rows.Add(newRow); Does anyone know who to have the time saved ad well? Thanks in advance for any help. Scott Tag: XML Partitioning Tag: 113059
  - 16
    - need help on basic save!!! I am having some problems with getting squgglie lines under stringbuilder and ConfigurationSettings what am I doing wrong, is this even close to working? help. ------------------------------------------------------------------------------------ Imports System Imports System.Data Imports System.Data.SqlClient Imports Microsoft.VisualBasic Public Class Locations Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click Dim mySQLConnection As New SqlConnection(ConfigurationSettings.AppSettings("DSN")) Dim strSQLCommand As New StringBuilder, mySQLCommand As SqlCommand strSQLCommand = New StringBuilder With strSQLCommand .Append("INSERT INTO Locations (Loc_Name, Address, ContactName, Phone) ") .Append("VALUES ('" & txtName.Text & "', '" & txtAddress.Text & "', '" & txtContactName.Text & "', '" & txtPhone.Text & "');") End With mySQLConnection.Open() mySQLCommand = New SqlCommand(strSQLCommand.ToString, mySQLConnection) mySQLCommand.ExecuteNonQuery() mySQLConnection.Close() End Sub End Class -- -- Adam S Tag: XML Partitioning Tag: 113054
  - 17
    - Unable to reconnect to SQL Server after the server is restarted I am using C#, SQL Server 2000 and ADO.NET in my application. The Database Server and the application are running on seperate physical machines. If the database server and the application lose connection (possibly because the server was restarted, or a network failure of some sort) the application fails to re-connect. The application will periodically attempt to re-connect to the server. It seems that I am unable to connect for a period of time after the server is restarted. I receive the error message "SQL Server is unavailable or access is denied". I have seen this error message for as long as 45 minutes after the server has been restarted. Does anybody have any ideas on the cause of this? I am using connection pooling with the default connection pool size. Sample code is provided below. Thanks in advance for your help, Trevor SqlConnection conn = new SqlConnection( conString ); if ( waitForConnection && AllowWaitForConnection ) { // Retry the connection to the database periodically until successful while ( conn.State != ConnectionState.Open ) { try { conn.Open(); } catch ( SqlException e ) { conn.Close(); ThreadSupport.Sleep( connectionRetryInterval ); } catch ( InvalidOperationException e2 ) { conn.Close(); ThreadSupport.CheckAbort(); } } } else { ... } Tag: XML Partitioning Tag: 113052
  - 18
    - Pivoting DataSet- Hyperlinkcolumn+Sorting http://weblogs.sqlteam.com/jeffs/articles/5091.aspx provided an excellent insight for pivioting DataSet. As things stand, the example could happily pivot Something SQLServer returns as: frmInstanceID frmName Department Status 1 formA IT Complete 2 formB IT Complete 3 formC IT Incomplete 4 formA HR Missing 5 formB HR Inomplete 6 formC HR Complete with the invocation of Pivot(dataReader,"frmInstanceID","frmName","Status"), pivotted data into frmInstanceID Department formA formB formC 1 IT Complete 2 IT Complete 3 IT Incomplete 4 HR Missing 5 HR Incomplete 6 HR Complete What I really really want is: Department formA formB formC IT Complete Complete Incomplete HR Missing InComplete Complete With each of the form status being a hyperlink with the frmInstanceID as a parameter: e.g. <a href="showStatus.aspx?id=7">Complete</a> I managed to "fool" the system into displaying the above with the invocation of Pivot(dataReader,"Department","frmName","Status") (i.e. changing the keyColumn parameter to the Pivot method). Could someone assist with helping me set a hyperlink column and managing sorting with this example at http://weblogs.sqlteam.com/jeffs/articles/5091.aspx ? Many Thanks Tag: XML Partitioning Tag: 113047
  - 19
    - clear connection pooling i face prob. of connection pooling, i want to know how to clear the pool size in ado.net, i know that there is a facility in ado.net to clear the max pool size, Any one can give me the code about that. thanks. *** Sent via Developersdex http://www.developersdex.com *** Tag: XML Partitioning Tag: 113042
  - 20
    - Concurrency violation where there shouldn't be one I have the following error message and I can't see where in code it could of came from or what could of caused it. It happened randomly for one of our users and no one else ever, and I am unable to reproduce it at all. System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records. Now this was caused during the update method of a data adapter that is tied to a table alled Categories... On the form where the data entry takes place we have a brand new record called coverage, This is stored in the dataset's coverage table. At this point this is in thet table as a new record with a uniquely generated ID Primary key that gets changed when the dataset is updated to the database (that part works fine, SQL Server returns the new ID and the local dataset updates approperiatly to match)... the problem though seems to of occured on the referenced table Categories... This table has records that are dynamically generated based on what a user checkes in a check listbox. So if the user unchecks an item, the corresponding record is removed from the datatable in teh categories table, if they check one a record gets added... here is an example piece of code... Private Sub chklstCategories_ItemCheck(ByVal sender As Object, ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles chklstCategories.ItemCheck ' update dataset in memory to reflect changes If Me.b_refillingData = False Then Select Case e.NewValue Case CheckState.Checked Dim dr_catItem As DataRow = ds_formData.Tables("CoverageJunCategories").NewRow If Me.fs_FormViewState = bdb.Business.FormStates.AddNew Then 'dr_CoverageRow dr_catItem("coverageid") = Convert.ToInt32(dr_CoverageRow("CoverageID")) Else dr_catItem("coverageid") = Convert.ToInt32(Me.lstvCoverages.SelectedItems(0).Tag) End If dr_catItem("categoryid") = DirectCast(Me.chklstCategories.Items(e.Index), CategoryItem).ID ds_formData.Tables("CoverageJunCategories").Rows.Add(dr_catItem) Debug.WriteLine(ds_formData.Tables("CoverageJunCategories").Rows.Count) Case CheckState.Unchecked Dim rowKeys(1) As Object If Me.fs_FormViewState = bdb.Business.FormStates.AddNew Then rowKeys(0) = Convert.ToInt32(dr_CoverageRow("CoverageID")) Else rowKeys(0) = Convert.ToInt32(Me.lstvCoverages.SelectedItems(0).Tag) End If rowKeys(1) = DirectCast(Me.chklstCategories.Items(e.Index), CategoryItem).ID Dim dr_catitem As DataRow = ds_formData.Tables("CoverageJunCategories").Rows.Find(rowKeys) dr_catitem.Delete() Debug.WriteLine(ds_formData.Tables("CoverageJunCategories").Rows.Count) End Select End If End Sub as you can see this is a junction table which joins the list of categories and the list of coverages together.. In our dataset we also have the coverages and this table referenced like this ds_formData.Relations.Add("CoveragesJunCategories", ds_formData.Tables("Coverages").Columns("CoverageID"), ds_formData.Tables("CoverageJunCategories").Columns("CoverageID")) to me this code all seems to be correct, but I can't figure out what is wrong... prior to this we were getting a "Missing update command" error for the data adapter that handles the coveragesjuncategories table's... I figured since all I was doing was adding and removing rows I only would need a Select, Insert, and Delete command... Since it seemed like no real updateing was occuring (unless when coverages gets its new primary key from the server when a coverage row is created, it changes the category junction's table also since they are referenced together with a primary/foreign key, but if this is a update how would the row be created to start with? just a little confused on the procedure for a new row in one table that references a new row in another when the primary key gets updates on the parent, what happens to the row the foreign key is on is it still an insert or is it now an update (i assumed insert because the row does not exist yet in the database only locally in the data table since the update method as not been called yet on the categorys junction table (child table) but only on the coverages one (parent table))... anyone that can help me out would be great! thanks! Tag: XML Partitioning Tag: 113040
  - 21
    - concurrency violation where it makes no sense to have one I recieved the following error pretty much randomly (haven't been able to reproduce it or see what caused it in code at all) Tag: XML Partitioning Tag: 113039
  - 22
    - =?Utf-8?Q?Is_there_a_way_to_set_=22Jet_OLEDB?= Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: XML Partitioning Tag: 113027
  - 23
    - Dynamically Populating a SqlParameter object I'm using the SqlHelper object model from MDAAB, which requires that I pass in a SqlParameter object if I have more then parameter when calling a Stored Procedure. My current code seems verbose in the setup of this parameter and I'm trying to figure out if there is a better approach to populate this object. Here is a sample in VB that uses SqlHelper to call a Stored Procedure: Public Shared Sub GatewayRecordCreate(ByVal GatewayName As String, _ ByVal ResponseString As String, _ ByVal UserEmail As String, _ ByVal TranAmount As String) ' Public Consts used to store element position in String Array, used in other classes Const PositionGatewayName As Short = 0 Const PositionResponseString As Short = 1 Const PositionUserEmail As Short = 2 Const PositionTranAmount As Short = 3 Const PositionMaxElement As Short = 3 Dim returnVal(PositionMaxElement) As String ' String Array returned by function Dim parms() As SqlParameter = New SqlParameter(PositionMaxElement) {} 'Used to hold Details from DB ' @GeneratedBy Input Parameter parms(PositionGatewayName) = New SqlParameter("@GatewayName", SqlDbType.VarChar, 200) parms(PositionGatewayName).Direction = ParameterDirection.Input parms(PositionGatewayName).Value = GatewayName ' @ResponseString Output Parameter parms(PositionResponseString) = New SqlParameter("@ResponseString", SqlDbType.VarChar, 5000) parms(PositionResponseString).Direction = ParameterDirection.Input parms(PositionResponseString).Value = ResponseString ' @UserEmail Output Parameter parms(PositionUserEmail) = New SqlParameter("@UserEmail", SqlDbType.VarChar, 100) parms(PositionUserEmail).Direction = ParameterDirection.Input parms(PositionUserEmail).Value = UserEmail ' @TranAmount Output Parameter parms(PositionTranAmount) = New SqlParameter("@TranAmount", SqlDbType.VarChar, 20) parms(PositionTranAmount).Direction = ParameterDirection.Input parms(PositionTranAmount).Value = TranAmount ' Call ExecuteNonQuery static method of SqlHelper class ' Pass in database connection string, command type, stored procedure name and an array of SqlParameter object SqlHelper.ExecuteNonQuery(Global.ConnectionString, CommandType.StoredProcedure, "spGatewayTranInsert", parms) End Sub My primary goal is to improve the code so that I don't have to setup Constants and hard code the PositionMaxElement value which is used SqlParameter object. Any thoughts? Please post or point to VB source code if you are replying. I learn best by example. Thanks. Tag: XML Partitioning Tag: 113025
  - 24
    - The asp services blocked I have a problem about asp.net and databases in Access. Every time the asp service is blocked. When this happens i must phone to my ISP provider of hosting in order to begin the service again. The tell me it is a problem of access with asp.net. ¿How can i solution it? I detail below the connection line of the web.config, maybe I am doing wrong. Thank you very much. <add key="Connection" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\bd\bd1.mdb;Persist Security Info=True" /> Tag: XML Partitioning Tag: 113020
  - 25
    - debug suggestion for connection pool problem with Oracle using daa Hi We have a asp.net web application with oracle 9.1. Data access layer we use is DAAB 2.0. We use connection pool and set max pool size = 150. But we always get the following error almost every month ( we have to restart web server to make it work): Timeout expired, The timeout period elapsed prior to obtaining a connection from the pool. This may have occured becasue all pooled connections where in use and max pool size was reached. As many perople said, after I went though whole implementation, I did not find any connections we did not close. Anyone have good advice for how to debug such issue? or recommend some tool? I have seen lots of similar questions and topics, and found many answers are extremely confused. Can anyone make clear for my some questions? 1. We use USING to dispose connection and OracleDataReader in most cases, but also there are some exceptions, we use close() to close connection in Catch block of try-catch. here is example: ============================================== OracleConnection cn = new OracleConnection(connectionString); cn.Open(); try { return ExecuteReader(cn, null, commandType, commandText, commandParameters, OracleConnectionOwnership.Internal); } catch { cn.Close(); throw; } ========================================== Is anything wrong for these pieces of code? 2. In many cases, we opened connection in one function, and call another to process the real operation of DB., example: =================================================== using (OracleConnection cn = new OracleConnection(connectionString)) { cn.Open(); return ExecuteNonQuery(cn, commandType, commandText, commandParameters); } =================================================== if ExecuteNonQuery() got exception, the USING still can dispose connection? 3. =================================================== using(OracleDataReader r = OracleHelper.ExecuteReader(ConnectionManager.GetConnStr(), CommandType.Text, sql.SQLString, pa)) { ArrayList al = QueryResultsParser.Parse(r, request); r.Close(); //Force the OracleDataReader to be closed return al; } ==================================================== (we have add For these pieces of code, we use datareader to get data, I wonder: 1. is it necessary we explicitely close the datareader? 2. if answer yes for 1., and if OracleHelper.ExecuteReader() falied, does it mean we cannot close connection? 4. for some objects, do we need to displose them as soon as it is not used? example: ================================================= OracleCommand cmd = new OracleCommand(); PrepareCommand(cmd, connection, (OracleTransaction)null, commandType, commandText, commandParameters); //create the DataAdapter & DataSet OracleDataAdapter da = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); //fill the DataSet using default values for DataTable names, etc. da.Fill(ds); cmd.Dispose(); da.Dispose(); ======================================= Tag: XML Partitioning Tag: 113017
- Next
  - 1
    - datagrid webcontrol in C# Hi, I just have a simple question regarding dataGrid in ADO.NET. I developed the web application by ASP.net and C#. I want to implment a dataGrid for the product list. The product list display the product name, size, type, price .... But for the specfic product category, its size column may not has any data. So i want to write the code in back-end by C# to determin whether every item in the size column in dataGrid has data. How I can write it in C# ? is there methods I can use to determin every item in size column contains data ? Thank you, H. Tag: XML Partitioning Tag: 113016
  - 2
    - Add Record to MS Access Database Is there anyone that knows how to add a record to a MS Access database with VB.NET. I have search for 3 days for some code that works. I have gathered bits and pieces of code and put it together, but I have not found a solution that works. If anyone has some code that works please reply. Thanks Thomas The following gives an Invalid SQL Statement at: oAdapter.Update(ds, "LCMR") Dim oAdapter As OleDb.OleDbDataAdapter Dim cb As OleDb.OleDbCommandBuilder Dim dr As DataRow Dim ds As DataSet Dim strSQL As String = "Select * from LCMR" Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strAppPath & "TAM.mdb;Persist Security Info=False" ds = New DataSet() oAdapter = New OleDb.OleDbDataAdapter(strSQL, strConn) oAdapter.Fill(ds, "LCMR") Try dr = ds.Tables("LCMR").NewRow() dr.BeginEdit() dr("ID") = 1000 dr("ADate") = "6-JUN-5" dr("ATime") = "01:00" dr("POO") = strPOO dr("POO_Alt") = 22 dr("POI") = strPOI dr("POI_Alt") = 22 dr("Distance") = 1000 dr("Direction") = 100 dr("Target_NO") = "KT1001" dr("Weapon Type") = "sasdf" dr("Confirmed") = 1 dr.EndEdit() ds.Tables("LCMR").Rows.Add(dr) cb = New OleDb.OleDbCommandBuilder(oAdapter) oAdapter.InsertCommand = cb.GetInsertCommand oAdapter.Update(ds, "LCMR") ds.AcceptChanges() Catch oException As Exception MessageBox.Show(oException.Message) End Try -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service ------->>>>>>http://www.NewsDemon.com<<<<<<------ Unlimited Access, Anonymous Accounts, Uncensored Broadband Access Tag: XML Partitioning Tag: 113008
  - 3
    - Oracle transaction rollback problem I have problem with transaction. When I try to rollback transaction commit happend and record is updated. Can anybody tell me, where I made a mistake. Thanx, S. Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types private sub mWriteOnOra() Dim inFile As System.IO.FileStream Dim binaryData() As Byte inFile = New System.IO.FileStream(p_datoteka, _ System.IO.FileMode.Open, _ System.IO.FileAccess.Read) ReDim binaryData(inFile.Length) Dim bytesRead As Long = inFile.Read(binaryData, _ 0, _ inFile.Length) inFile.Close() Dim cnStr As String = "Data Source=Oracle8i;User ID=" & gsUser & ";Password=" & gsPwd & ";Data Source=" & gsDs & ";" Dim sErr As String Dim cn As OracleConnection Dim myTrans As OracleTransaction Dim cmd As New OracleCommand("SP_LOAD", cn) cmd.CommandType = CommandType.StoredProcedure With cmd.Parameters .Add("BLOB_LOAD", OracleDbType.Blob, binaryData.Length, ParameterDirection.Input).Value = binaryData End With Try cmd.ExecuteNonQuery() myTrans.Rollback() ' file shouldn't be in the table, but it is there ' myTrans.Commit() Catch ex As Exception myTrans.Rollback() DoLog(1, ex.Message) Finally If cn.State <> ConnectionState.Closed Then cn.Close() End Try end sub Tag: XML Partitioning Tag: 113005
  - 4
    - Query Result Paging with different Ordering Hi, I have posted to multiple groups - I hope this is ok. For the past week or so I have been trying to find out how to perform a search against SQL Server, and have the results sorted on a choice made by the UI (ASP.NET), and supports paging. I have trawled the net a number of times, and have spent hours looking through peoples examples which just dont seem to cut it, due to all their caveats. Can someone offer good, useful links on how I can do this type of functionality? Vry much appreciated, after so much reading and playing I am still little further forward. I am not a DB person, which is causing part of the problem. Thanks j.r Tag: XML Partitioning Tag: 113003
  - 5
    - problem in uploading and downloading files from DB in ASP.Net hi, Can anybody tell me that thru asp.net using c#, how can we upload and download physical files in any table of SQL Server Database. the uploading part is running successfully but the problem arises in the retriving part of the code. i am not getting that how will i able to download the file which is there in the SQL Server database in the field type "image". here is the code by which i am uploading any file to the my SQL Server database private void btnUpload_Click(object sender, System.EventArgs e) { HttpPostedFile filPosted = filUpload.PostedFile; int intFileLength = System.Convert.ToInt32(filPosted.ContentLength); byte[] byteData = new byte[intFileLength]; filPosted.InputStream.Read(byteData, 0, intFileLength); Conn.OpenConnection(); string sql="Insert into HRRecruitmentMaster(CandidateName,HighestQualificationID,JobFieldID,TotalExperienceInYears,CandidatePresentLocation,FileName,CandidateResume,type,length) Values (@CandidateName," + cmbHighestQuali.SelectedValue + "," + cmbJobField.SelectedValue + "," + txtTotalExp.Text + ",'" + txtPresentLoc.Text + "',@FileName,@CandidateResume,@Type," + intFileLength + ")"; SqlCommand Cmd = new SqlCommand(); Cmd.CommandText=sql; Cmd.Connection =Conn.Cn; Cmd.Parameters.Add("@CandidateName",txtCandidateName.Text) Cmd.Parameters.Add("@FileName",System.IO.Path.GetFileName(filPosted.FileName)) Cmd.Parameters.Add("@CandidateResume",System.Data.SqlDbType.Image,intFileLength); Cmd.Parameters["@CandidateResume"].Value=byteData; Cmd.Parameters.Add("@Type",filPosted.ContentType); Cmd.ExecuteNonQuery(); Conn.CloseConnection(); } so pls. help me out in this matter i'll be very much grateful to u Regards Himanshu Saxena Sahara India India Tag: XML Partitioning Tag: 113001
  - 6
    - Using UPDATE I con't write the dataset back to datasource It works fine with the datagrid but with the sqlAdapter. Here is the code I was using. if State is always undefined. so it skips the logic, but the Textboxes hold the changed information. I am learning, please advise. Thanks Tag: XML Partitioning Tag: 112995
  - 7
    - ODBC Data Sources Hi All, Is there a method that I can call to return a list of available database drivers? If so, is there then a way to get the list of fields that are required for those the database drivers? L. Tag: XML Partitioning Tag: 112989
  - 8
    - TNSPING Doesn't Do Much I have TNSPING on my Windows laptop, ver 8.1.7.3.0. It was showing good when the database was down for maintenance. Looking at the output, it doesn't appear to be sending a SID as the later versions do. Is this so? If so, then its just checking for a port? Won't it miss a large class of outages? Thanks. Tag: XML Partitioning Tag: 112985
  - 9
    - Connection Won't Die Application - give Oracle DB connection status on an ongoing basis Technique--thread is fired off by a timer every minute. It attempts to open a connection. It catches an open error as a failure, and otherwise indicates success. It then disposes the connection and ends. The status indicated seems to be good the first time. However, subsequently, it seems to get stuck in the old status, and doesn't always see the connection as transitioning to good from bad or vice-versa. Here's a snippet --- private void testDev(Object state) { try { oracleConnection1.Open(); oracleConnection1.Dispose(); devStatus.ForeColor = Color.Green; devStatus.Text = "DEV UP"; devErrorTxt.Text = ""; } catch (Exception e) { errorMsg = e.Message.ToString(); try { oracleConnection1.Dispose(); } catch (Exception e2) { errorMsg += (" Dispose: " + e2.Message.ToString()); } devErrorTxt.Text = errorMsg; failureMode = true; devStatus.ForeColor = Color.Red; devStatus.Text = "DEV DOWN"; } TimerCallback timerDelegate = new TimerCallback(testDev); t = new System.Threading.Timer(timerDelegate,null,60000,-1); } Suggestions?? Tag: XML Partitioning Tag: 112982
  - 10
    - Convert _Recordset to DataSet/DataTable I have a Visual C++ .NET function that is calling an unmanaged function that returns an ADO _Recordset* object. I want to be able to convert that into an ADO.NET DataSet (or DataTable). I tried to use the OleDbDataAdapter.Fill method, but I could only get that to work if I gave it an ADODB::RecordsetClass object. I couldn't figure out how to get an ADO _Recordset into an ADODB::RecordsetClass. Any ideas? I don't want to have to rewrite all of our existing unmanaged code. - Brad Tag: XML Partitioning Tag: 112981
  - 11
    - There is a way to set "Jet OLEDB:Transaction Commit Mode"? Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: XML Partitioning Tag: 112977
  - 12
    - Could not find installable ISAM Using William Ryan's articles as a guide (excellent help, is William) I am trying to connect to my Excel data source. However, I am running into a "Could not find installable ISAM." error message trying to connect to the datasource. Does anyone have any tips as to how this is overcome? Thanks! Tag: XML Partitioning Tag: 112975
  - 13
    - How DataRelation object is updated After the VS 2003 creates a strongly typed DataSet object that contains a couple of tables and serveral many-to-may data relations among all the tables, and the data got populated, I am wonder how the DataRelation object of the DataSet object is updated when some new rows are added to some of the tables. Do I have to update the relation of the added rows or in somewhere the relations are added automatically? Can someone explain this for me or point me to some resources? Thanks a lots. Tag: XML Partitioning Tag: 112967
  - 14
    - ADO or String.Format bug ? ...... Hi It seems that String.Format method, when use a ***ZERO VALUE*** object coming from a SqlDataAdapter Fill method works fine, while if the same query is runned using an SqlDataReader ExecuteReader method, the formatted result is wrong .... For my tests i've used the Sql Server 2000 Northwind database and i've updated the Orders.Freight Column to zero (UPDATE Orders SET Freight=0). My general objective is to format all significative decimal values (value > 0)using a mask: #####0.00 and format all zero values using another mask: #####.##. This is obtained with: String.Format("{0:#####0.00;-#####0.00;######.##}", VALUE-TO-FORMAT) The VALUE-TO-FORMAT is obtained either using a server-side cursor (DataReader) and a client-side cursor (DataTable). In the first case it display ",00" (!!! ???) .... ... while using a DataAdapter it (correctly) display "" ..... The complete VB.net code is the following: ============================================================================= Dim Cn As New SqlClient.SqlConnection("uid=sa; pwd=; database=northwind; server=xdev99") Dim Cmd As New SqlClient.SqlCommand("SELECT Freight FROM orders", Cn) Cn.Open() Dim Dr As SqlClient.SqlDataReader = Cmd.ExecuteReader If Dr.Read Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dr.Item("Freight"))) End If Dr.Close() Dim Dt As New DataTable Dim Da As New SqlClient.SqlDataAdapter("SELECT 0 FROM orders", Cn) Da.Fill(Dt) If Dt.Rows.Count > 0 Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dt.Rows(0).Item("Freight"))) End If Cn.Close() ============================================================================== What's your idea ? Thanks. Nicola. Tag: XML Partitioning Tag: 112963
  - 15
    - "Object is no longer valid" exceptions Hi, we have a .NET application that uses ADOMD to query a MS analysis OLAP cube. In a typical query, we get data for about 3 dimensions (800 x 15 x 2 entities) and then iterate over the resulting cell set to extract information. Occasionally, we see "Object is no longer valid" exceptions being thrown. The object (whose access usually throws this error) is of the type "ADOMD.Position". Sometimes the error appears while executing Cell.Get_Item(). We have a mechanism to retry the query if these exceptions are thrown in a (vain) hope that on the retry the whole thing will go off successfully. This works sometimes, but not always, so this isn't satisfactory. Does anyone have any idea why this would be happening? Is this something to do with garbage collection? Are there any workarounds/fixes? I would be grateful to know. Thanks, Ramanand [P.S. Apologies if this is the wrong newsgroup for purely ADOMD queries] Tag: XML Partitioning Tag: 112957
  - 16
    - connection question I'm getting an error while running an aspx page on a production server. The error is that either the server can not be found or the access is denied. The following code fails at line 36. Line 34: str = "Driver={SQL Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra" Line 35: C.ConnectionString = str Line 36: C.Open() Line 37: Dim R As New ADODB.Recordset Other aspx pages that don't talk to the data server run correctly. The same page run on the development PC (WinXp Pro) connects and dispays the data correctly. (SQL server is on another box) If I alter the code to run in an Access 2000 database on the same production server, it runs correctly. Thus I'm not sure how to go about getting this up and running. Any thoughts would be appreciated. Cheers Mike Tag: XML Partitioning Tag: 112936
  - 17
    - MSDE, ASP.NET, Visual Studio .NET, and connectionstrings I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not know much about connection strings, I am not sure what it should look like. Can someone please help me determine what my connection string should look like? I am using the version of IIS that comes with XP Pro. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: XML Partitioning Tag: 112929
  - 18
    - ODP.NET Publisher Policy? We recently started running into a problem. We had a .NET winform application built with ODP.NET 9.2.0.4. We rolled out a new OS image that had only the 10.1.200 Oracle client and ODP.NET. The existing application stopped working, as it wanted a 9.2.0.4 client. After doing some further research, I've discovered that publisher policies are my answer. All our machines are currently running 10.1.0.200 of ODP.NET, however, and that build did not seem to install or include publisher policies. 10.1.0.400 both includes, and installs by default these policies into the GAC. I'm hoping there's some way I can get or build publisher policies for 10.1.0.200. That way, I could get a script run that simply installs these policies into the GAC of all machines on site. Otherwise, it seems my other option is to uninstall all the 10.1.0.200, and reinstall 10.1.0.400. >From what I've managed to learn about publisher policies, they're done by the publisher of the component. I think I need access to the .key file in order to generate my own, which of course, I do not have for the Oracle.DataAccess assemblies. Anyone know if these publisher policies are available for 10.1.0.200 somewhere? Tag: XML Partitioning Tag: 112923
  - 19
    - datatable.select("Distinct") or such to string? I am hitting a bit of a wall - I am building a table - public DataTable theTownships = new DataTable("AdjacentTownships"); public DataTable buildTownshipTable() { DataColumn tscolumn; //Townships-Range Field tscolumn = new DataColumn(); tscolumn.DataType = System.Type.GetType("System.String"); tscolumn.ColumnName = "TSR"; tscolumn.ReadOnly = false; tscolumn.Unique = false; theTownships.Columns.Add(tscolumn); return theTownships; } This table is built from another query where each coloumn in that row is turned into a row here. So I can have between 1 and 0 rows, some can be duplicates. What I need to do is then select the distinct rows from this table and pass them to a for loop that I can then parse/process each of the distinct rows. Any and all suggestions would be greatly appreciated!! -- D @ premierdata Tag: XML Partitioning Tag: 112922
  - 20
    - Using System.GUID in a RowFilter I have a table in SQL server that has a column of type UniqueIdentifier. I use a DataAdapter to fill a typed DataSet with rows from the table. (Interestingly, when I look at the typed dataset, the datatype of this column has magically changed to STRING). Anyway, I need to use this column value in a DataView.RowFilter. However, when I try to create the RowFilter="ColumnName='" & value & "'" I get a runtime error that says I there's no operator that will contatenate (&) a STRING and a SYSYEM.GUID. Apparently, when I fill the typed dataset, the datatype changes to SYSTEM.GUID (I assume the same as UniqueIdentifier), even though the datatype in the typed dataset says STRING. So, how do I use a SYSTEM.GUID in a RowFilter when there doesn't seem to be a way to convert it into a string? -- Michael Hockstein Tag: XML Partitioning Tag: 112921
  - 21
    - Dataset Relationship I have a grid that is bound to a typed dataset. Three fields make up the key in the parent table and those same three fields are also in the child tables with a 1 to many relationship. When I bind this dataset to a grid it displays it hierchalily (which is what I want) when I drill to the child rows however it has the child row data plus the same data that is on the parent row. I only want to see the child information in the child row. I have looked in the Dataset and found no extra fields in the two sub tables so it is my assumption that it's doing this at runtime. Any ideas how I can get this to stop? Thanks, Justin Tag: XML Partitioning Tag: 112920
  - 22
    - Using Rollup operator in Sql Server 2000 Guys, I need some advice on displaying Rollup results this is the query (SP). select Org_lvl_2,level_one,doe,sum(RegHours),sum(OtHours) from ZT where Ppe= @PERIOD GROUP BY level_one,org_lvl_2,doe WITH ROLLUP HAVING sum(RegHours) >0 or sum(OtHours) >0 ORDER BY level_one,Org_lvl_2,Doe the Results: NULL NULL 53.0 0.0 NULL CANM 53.0 0.0 HQJ CANM 53.0 0.0 HQJ CANM 32.0 0.0 HQJ CANM 13.0 0.0 HQJ CANM 8.0 0.0 what i'd like to display in a datagrid is:(with the Grand Total @ the bottom & leaving out the Nulls) HQJ CANM 32.0 0.0 HQJ CANM 13.0 0.0 HQJ CANM 8.0 0.0 HQJ CANM 53.0 0.0 i've been able to gain a little control putting the returned dataset into a dataRow and using IsDBNull(myRow.Item(0)) -[like that] - to weed out those null values. but,i've only had success if i then use a Listbox.item.add(myRow.Item(0) & myRow.Item(1)) - like that and i do have control, except for the Grand Total appears at the top of the list, not the bottom. i'm a little lost how to do this same thing in a datagrid, but a repeater or datalist control would be fine too if that's possible. i've worked the sql to death trying to get subTotals & then Grand Total, so if anyone knows another way in sql, i'd appreciate some help on that. other wise any advice on a good asp.net Control to use and maybe the method to display this would be very helpful. i've tried using templates in the datagrid but it doesnt seem to recognize the aggregate columns. thanks again rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: XML Partitioning Tag: 112918
  - 23
    - SQL queries and datasets etc As only an occasional ado.net user I'm realising that there's something important and basic that I don't understand: I can obviously perform SQL queries on a database, but sometimes the data I need to access is in a bare datatable. So the question is whether there is a mechanism for performing a query directly on a bare datatable or, failing that, if add the table to a temporary dataset will that do? Or do I need to go the whole hog and integrate it into a full database? (In VB.Net if it makes any difference) Thanks JGD Tag: XML Partitioning Tag: 112913
  - 24
    - Error saving data from dataset with expression column Hi, I have a dataset created by dragging table from database explorer. Then I have added a column in dataset with expression cant * price in order to get calculation from two columns. This work fine. But when I try to save data into database using datadapter.update method i get the error: Cannot change ReadOnly Property for expression column. Anyone can help me? Thanks. Tag: XML Partitioning Tag: 112902
  - 25
    - Loss of datetime precision when attaching parameters to an ADO.NET command Hi, I am encountering some strange losses of datetime precision when calling a stored procedure through ADO.NET. I'm using ExecuteNonQuery in the Microsoft Data Access Application Block for .NET, which simply creates an ADO.NET command, and attaches each of the parameters, before calling cmd.ExecuteNonQuery(). I have a stored procedure that does nothing but take a whole load of input parameters and insert them into a table. Calling the SP directly from Query Analyser works fine. However, calling the SP from code as follows: ... parameters[5] = new SqlParameter("@Time", SqlDbType.DateTime); parameters[5].Value = time; ... SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, "MyStoredProc", parameters); ...results in the time entry made into the database always having a zero value for the seconds. Similarly, if I execute: SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.Text, "EXEC MyStoredProc ..., @Time, ...", parameters); ...the same thing happens. However, if I dump the INSERT statement that's in the stored procedure into a string called sql in the code, and then execute: SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.Text, sql, parameters); ...then everything works just fine and I don't get the rounding error. Does anyone have any ideas as to why this may be? Many thanks in advance for your help, Chris. Tag: XML Partitioning Tag: 112900

hi,
i have a problem ,
I have a database which inserts bulk of data onto the sql and oracle
database from excel sheets ,

I was juss planning to create threadpools and activate multiple threads
to insert data onto the database from the excel.

i am thinking of creating a XML sheet for which first gets inserted
from excel sheet and and from there use XML sheet to insert onto the
database as we can never work efficiently with excel as with XML,

Now i need to know...how can i partition a XML sheet , i mean i need to
create 3 or more threads for a single process which partitions the
process as 1st half and 2nd half and excutes two threads simultaneusly,

I ll appreciate if u guys can help me in this

Thanks
Mahesh Manas

Top

Re: XML Partitioning by William

William
Tue Jun 28 12:03:12 CDT 2005

You could have picked a slower way to move the data... but I don't know how.
Check out BCP or DTS. It can move data from any source to SQL Server and
Oracle.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

<polur.venkat@gmail.com> wrote in message
news:1119977471.007997.299060@g44g2000cwa.googlegroups.com...
> hi,
> i have a problem ,
> I have a database which inserts bulk of data onto the sql and oracle
> database from excel sheets ,
>
> I was juss planning to create threadpools and activate multiple threads
> to insert data onto the database from the excel.
>
> i am thinking of creating a XML sheet for which first gets inserted
> from excel sheet and and from there use XML sheet to insert onto the
> database as we can never work efficiently with excel as with XML,
>
> Now i need to know...how can i partition a XML sheet , i mean i need to
> create 3 or more threads for a single process which partitions the
> process as 1st half and 2nd half and excutes two threads simultaneusly,
>
> I ll appreciate if u guys can help me in this
>
> Thanks
> Mahesh Manas
>

Top