excel formulas and visual c# .net

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
    - max pool size reached on dev workstation In the course of debugging applications on my development workstation (ASP.NET 1.1.4322, SQL Server 2000, ADO.NET) the app will sometimes be unable to establish a database connection when I choose Debug->Start. (When stopped during debugging, the code does not always reach the Finally {} block where the connections typically get closed.) I get a timeout error indicating that max pool size may have been reached. Stopping and restarting SQL Server does not clear this problem, and so I have been rebooting. Is there another service that maintains the connection pool, which can be bounced to free the stuck connections? Thanks Timo Tag: excel formulas and visual c# .net Tag: 106774
  - 2
    - Commit/Rollback Transaction generates an error. I have table Employee - Code varchar(5) Name varchar(100) Age int Using Ado.Net 1) Create a SQLConnection Object and open the connection. 2) Create a SQLCommand object using that connection. 3) Create a Transaction using SQLConnection.BeginTransaction(System.Data.IsolationLevel.ReadCommitted) 4) Attach the Transaction to the SQLCommand (ie. SQLCommand.Transaction= TransactionObject) 5) Execute an insert statement on the Employee Table using SQLCommand.ExecuteNonQuery() (ie. SQLCommand.CommandText = "Insert into Employee(Code, Name, Age) Values('ABC', 'ABCDEFG', '213')" SQLCommand.ExecuteNonQuery() ) 6) Call another function (eg: test()), which again inserts a record in the same table. This function would raise an sql exception, but we would ignore it in the function. (ie. Private Sub Test(ByRef oCmd As SqlCommand) Try oCmd.CommandText = "Insert into Employee(Code, Name, Age) Values('XYZ', 'XYZDEFG', '213a')" 'This would raise an error since Age is of Type Int oCmd.ExecuteNonQuery() Catch ex As Exception 'Ignore the error and return MsgBox(ex.Message) End Try End Sub ) 7) Issue Commit Statement (ie. TransactionObject.Commit()) This statement raises an error "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION." Source Code : ----------------- Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form Private oConn As SqlConnection Private oCmd As SqlCommand Private oTran As SqlTransaction #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents Label1 As System.Windows.Forms.Label Friend WithEvents Label2 As System.Windows.Forms.Label Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents txtName As System.Windows.Forms.TextBox Friend WithEvents txtAge As System.Windows.Forms.TextBox Friend WithEvents txtCode As System.Windows.Forms.TextBox Friend WithEvents Label3 As System.Windows.Forms.Label <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.txtName = New System.Windows.Forms.TextBox Me.txtAge = New System.Windows.Forms.TextBox Me.Label1 = New System.Windows.Forms.Label Me.Label2 = New System.Windows.Forms.Label Me.Button1 = New System.Windows.Forms.Button Me.txtCode = New System.Windows.Forms.TextBox Me.Label3 = New System.Windows.Forms.Label Me.SuspendLayout() ' 'txtName ' Me.txtName.Location = New System.Drawing.Point(112, 40) Me.txtName.Name = "txtName" Me.txtName.Size = New System.Drawing.Size(128, 20) Me.txtName.TabIndex = 0 Me.txtName.Text = "Edward Fernandes" ' 'txtAge ' Me.txtAge.Location = New System.Drawing.Point(112, 80) Me.txtAge.Name = "txtAge" Me.txtAge.Size = New System.Drawing.Size(128, 20) Me.txtAge.TabIndex = 1 Me.txtAge.Text = "123" ' 'Label1 ' Me.Label1.Location = New System.Drawing.Point(16, 40) Me.Label1.Name = "Label1" Me.Label1.Size = New System.Drawing.Size(80, 24) Me.Label1.TabIndex = 3 Me.Label1.Text = "Name" ' 'Label2 ' Me.Label2.Location = New System.Drawing.Point(16, 80) Me.Label2.Name = "Label2" Me.Label2.Size = New System.Drawing.Size(80, 24) Me.Label2.TabIndex = 4 Me.Label2.Text = "Age" ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point(40, 136) Me.Button1.Name = "Button1" Me.Button1.Size = New System.Drawing.Size(144, 23) Me.Button1.TabIndex = 5 Me.Button1.Text = "Add to DB" ' 'txtCode ' Me.txtCode.Location = New System.Drawing.Point(112, 8) Me.txtCode.Name = "txtCode" Me.txtCode.Size = New System.Drawing.Size(128, 20) Me.txtCode.TabIndex = 6 Me.txtCode.Text = "E1111" ' 'Label3 ' Me.Label3.Location = New System.Drawing.Point(16, 8) Me.Label3.Name = "Label3" Me.Label3.Size = New System.Drawing.Size(80, 16) Me.Label3.TabIndex = 7 Me.Label3.Text = "Code" ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 272) Me.Controls.Add(Me.Label3) Me.Controls.Add(Me.txtCode) Me.Controls.Add(Me.Button1) Me.Controls.Add(Me.Label2) Me.Controls.Add(Me.Label1) Me.Controls.Add(Me.txtAge) Me.Controls.Add(Me.txtName) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False) End Sub #End Region 'Employee Table Defintion : 'Code varchar(5) 'Name varchar(100) 'Age int Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click oConn = New SqlConnection("Server=Localhost;user id=sa;password=sa;Initial Catalog=Northwind") oConn.Open() Try oTran = oConn.BeginTransaction(IsolationLevel.ReadCommitted) oCmd = New SqlCommand("", oConn) oCmd.CommandText = "Insert into Employee(Code, Name, Age) Values('" & txtCode.Text & "','" & txtName.Text & "','" & txtAge.Text & "')" oCmd.Transaction = oTran oCmd.ExecuteNonQuery() Call Test(oCmd) 'Call this method which generates an exception, which is ignored. oTran.Commit() 'This will raise an error "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION." Catch ex As Exception MsgBox(ex.Message) Try oTran.Rollback() 'This will raise an error "This SqlTransaction has completed; it is no longer usable." Catch ex1 As Exception MsgBox(ex1.Message) End Try Finally oConn.Close() End Try End Sub Private Sub Test(ByRef oCmd As SqlCommand) Try oCmd.CommandText = "Insert into Employee(Code, Name, Age) Values('ABC', 'ABCDEFG', '213a')" 'This would raise an error since Age is of Type Int oCmd.ExecuteNonQuery() Catch ex As Exception 'Ignore the error and continue MsgBox(ex.Message) End Try End Sub End Class Tag: excel formulas and visual c# .net Tag: 106769
  - 3
    - Replacing internal with public in typed dataset? Hi! I would really like to use some of the internal constructors and properties in my typed dataset from another assembly. Does anyone know of a way to do this without writing proxy classes or manually changing the dataset.cs-file everytime it's been generated? Tag: excel formulas and visual c# .net Tag: 106766
  - 4
    - Is it possible to set CommandTimeout at connection level? Our app uses third party component and we do not have source code. That component requires as parameter Connection object only and we do not have access to the Command object it creates inside. So if query it generates exceeds 30 seconds timeout exception occurs. Is it possible to set CommandTimeout at connection level? May be there is undocumented ConnectionString options? I can`t find it in MSDN. Please help Thanks in adv Serg Tag: excel formulas and visual c# .net Tag: 106761
  - 5
    - Migrating SQLServer DBs to Sybase Hi there, i have to move a bunch of SQLServer DBs onto SYbase. My VB.NEt code uses all the functions in System.Data.SqlClient... do i need to change all my code now for sybase? And do I have to use ODBC? My expeerience here is limited! thanx iva ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>yhOJtDrRzECG6dxKq4vRlQ==</Id> Tag: excel formulas and visual c# .net Tag: 106750
  - 6
    - Controls inside textbox Hi, I have a situation to place the Label controls inside the textbox or rich textbox in winforms. I have done that work using textbox.controls.add method. But when i was typing the characters inside the textbox, the label control is overlapping and this should not happen. Is there any way to work the label as text in the textbox or could any one give me the solution for this situation. Tag: excel formulas and visual c# .net Tag: 106739
  - 7
    - Concurrently violation Hi All, I use CommandBuilder to create UpdateCommand. But it raise a "Concurrently violation" error. Could you tell us how to solve this problem. This error rarely happen. private static int Update(string name, DataRow row, string connection) { using(OleDbConnection cn = new OleDbConnection(connection)) { cn.Open(); OleDbCommand cmd = new OleDbCommand(name, cn); OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); cmd.CommandType = CommandType.TableDirect; OleDbCommandBuilder sqlBuilder = new OleDbCommandBuilder(adapter); adapter.UpdateCommand = sqlBuilder.GetUpdateCommand(); return adapter.Update(new DataRow[]{row}); } } Thanks, Hung Tag: excel formulas and visual c# .net Tag: 106737
  - 8
    - System.Data.SqlClient.SqlException: Timeout expired. I had large database (transaction record > 1 million) at SQL Server and I trying to load data from SQL Server into Datagrid via ASP.Net 1.1 and ADO.Netx. However, it give error message as below during processing. While I checked at Query Analyser, it take 2 minutes + for search this record and it is working fine. Questions? - What wrong at my coding? How about web.config? - How to resolve this issue? - Why ADO.Net / ASP.Net 1.1 does not support large connection pooling? Please advise. Many thanks. Error Message --------------- Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source Error: Line 90: Try Line 91: rptcon.Open() Line 92: Dim okrd As SqlDataReader = rptcmd.ExecuteReader() Line 93: Line 94: ReportDataGrid.DataSource = okrd ASPX Coding -------------- Dim rptcon As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) Dim rptcmd As New SqlCommand() rptcmd.CommandText = "Select GLDOC, GLDCT, gldate, GLEXA, GLEXR, account_num, amount from f0911" rptcmd.Connection = rptcon Try rptcon.Open() Dim okrd As SqlDataReader = rptcmd.ExecuteReader() ReportDataGrid.DataSource = okrd ReportDataGrid.DataBind() okrd.Close() Finally rptcon.Close() End Try End If Web.Config Coding ---------------------  <configuration> <appSettings> <add key="ConnectionString" value="server=SQLSVR;database=ERP;uid=User;pwd=User;" /> </appSettings> <system.web> <compilation debug="true" /> <authentication mode="Forms"> <forms name="ERP" loginUrl="authentication.aspx" protection="All" path="/" timeout="20"/> </authentication> <authorization> <allow users="user1,user2"/> <deny users="*"/> </authorization> <customErrors mode="Off" /> </system.web> </configuration> Tag: excel formulas and visual c# .net Tag: 106736
  - 9
    - DataView rows - filtered hello, so the DataView object is confusing me. i have a dataset of a bunch of rows, some of white my page needs to filter out before binding. no problem, i make a new dataview, set a filter and then bind the dv to my page. ala: DataView myDV = New DataView(myDS.Tables[0], "Show=1", "ID DESC", DataViewRowState.CurrentRows); myRepeater.DataSource = myDV; ...this is cool and it only shows what its supposed to. however, what confuses me is... when i try to get the first row of my filtered view, i do this: someLabel.Text = myDV.Table.Rows[0][0]; ...i am getting a row that was filtered out! (the first row happens to be one i dont want to show). i had thought the DataView was a new collection of criteria-matching rows. whaaa? guess not. so i have two questions: 1) how does a DataList/Grid/whatever know to exclude binding filtered out items 2) how can i call up a single item from *only* the list of criteria-matching rows? thanks! matt Tag: excel formulas and visual c# .net Tag: 106735
  - 10
    - Access query parameters not auto-created in Server explorer Hi all, I'm using an Access DB with a bunch of queries. I've created a web service in VS 2003 and have drag/dropped the queries onto the workspace. This works fine, but the parameters are not auto-created as they are with SQL Server, for example. Does anyone have an idea on what the problem is?? Thanks -------------------------------- From: Tim Young ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>XYHanVmXq0+rcAwYDhEtkQ==</Id> Tag: excel formulas and visual c# .net Tag: 106734
  - 11
    - vb.net 2003 (Type your message here) I want to put the data I enter in my form using vb.net into a database using microsoft access -------------------------------- From: Derrick McDaniel ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>X5zGJFw8V0mMijW0TaBbmg==</Id> Tag: excel formulas and visual c# .net Tag: 106725
  - 12
    - Fast retrieval of BLOB data Hello All, I am trying to retrieve blob data from the database using ADO=2E I= tried using the ADO streams and appendchunk/getchunk methods=2E= These work fine for data upload to the database=2E When I try to= download/retrieve data from the database it is very slow=2E BLOB= objects upto 1=2E5 MB can be downloaded pretty fast but I am= looking at storing/retrieving some large BLOB objects (upto= 20-40 MB) Is there any efficient and fast way that would save me on the= memory and give a good performance at the same time? Thank you very much=2E Best Regards, Purvi -------------------------------- From: Purvi Dholakia ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>G70qHPWVMEy2z+5uGHMcEA=3D=3D</Id> Tag: excel formulas and visual c# .net Tag: 106716
  - 13
    - Sending data to access query from Visual .net form Hi There, I have made a query called "Schedule",in access using few tables. Has fields like Order #, Required Date, Quantity ordered etc.. Depending upon the Required date field I provide on the input of the query. The query filters and displays results based on that. I want to use a form using Visual .net. The form would have a calender on it, when the users clicks on a particular date. I want that date to be sent as an input to the Required date field for my "Schedule" and display the result on the form. I have been trying to use Ado.net, but not sure how to send this date information to the query in access. I will really appreciate if somebody can tell me how I can do this. thanks a million. -K Tag: excel formulas and visual c# .net Tag: 106711
  - 14
    - Using IDataAdapter to fill a strongly-typed dataset We're using abstract interfaces for the data access in our classes. We're using strongly-typed datasets when using data adapters. We can use a SqlDataAdapter to fill a strongly-typed dataset using the Fill method, but we can't get the same result if we've cast the object to an IDataAdapter's fill method. Is it possible to fill a stronly-typed dataset using the interface? Thanks. --ROBERT Tag: excel formulas and visual c# .net Tag: 106706
  - 15
    - Cannot open a password protected access database I am unable to open a password protected Access Database programtically. I have office 2003 installed on my machine. I am using the OleDb namespace in C#. I can open the database in access. I can open the database programatically if I remove the password. Here are the last 3 connection strings I've tried, with the Execption text that was generated for them. Tag: excel formulas and visual c# .net Tag: 106702
  - 16
    - DataGrid paint exception when size too small I have a .NET windows forms application with one form displaying data. I have a tree view on the left side and the datagrid on the right side. Tree view allows the user to select verious items and based on that selection the datagrid is bound to the appropriate datasource and table from the database. This works well. The problem comes when I resize my form and the grid portion is not visible or just barely visible. Now when I perform the same operations by selecting various items in the tree I get an exception System.ArgumentException with Message : '0' is not a valid value for 'value'. 'value' should be between 'minimum' and 'maximum'. Source : System.Windows.Forms. This happens when I call SetDataBinding method. When I again resize the form so that the grid is more visible this problem goes away. I have also seen a bizzare display with red cross over the entire grid area when I resize the grid again. Is this a known issue in the datagrid ? Can somebody help me ? Thanks Tag: excel formulas and visual c# .net Tag: 106701
  - 17
    - Default Value in Typed Dataset Hello in a strongly typed dataset, we can set defaults for each field. How can we set default for a datetime type field ? If I set it either to: now; Now; Now(), now() or DateTime.Now - it doesn't work. So how do I set it ? Thanks Tag: excel formulas and visual c# .net Tag: 106700
  - 18
    - Parameter ?_1 has no default value I'm using the HierCube .net OLAP component from rainbowsoft (http://www.rbwsoft.com/) in a vb winform application (vs2003). The data source is an MS Access 2000 table; the data adapter is of the oledb type; and the sql string has two parameters ala =? At runtime the app provides values for the params like so: oledaPivotData.SelectCommand.Parameters("Conversion").Value = cboConversion.SelectedValue oledaPivotData.SelectCommand.Parameters("Year").Value = cboYear.SelectedValue The cube works fine. However the cube control won't let me access the Dimension Mapping facility, it complains that "Parameter ?_1 has no default value". I'm not sure how to solve this. I've written to the control developers, but they can be slow to respond...and this issue seems to be more generic than specific to this control. I've not been able to find a discussion here that deals with my situation, most other cases are using SPs. Tag: excel formulas and visual c# .net Tag: 106698
  - 19
    - Oracle Pipeline function I have a VB.Net application that currently access an Oracle 9i database. We use ref cursors called from stored procedures to pass back recordsets.. I was wondering if it is possible to pass back the data through an Oracle Pipeline function instead? Thanks Tag: excel formulas and visual c# .net Tag: 106693
  - 20
    - Question about DataSet.WriteXML method. I have a DataSet in which one row contains a column with a string that has CR or LF characters in it. I am converting this DataSet to XML by calling DataSet.WriteXml(). I would have expected CR and/or LF characters to be translated to numeric character entry values. Instead, they are written out as absolute. How can I ensure that all special characters are translated properly when calling WriteXml? -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- Tag: excel formulas and visual c# .net Tag: 106692
  - 21
    - When to use MSDE/Sql Server (when using VB.NET) Hi, I'm just wondering when I better should use an Sql Server or when a MSDE. Whet are the advantages of one to another en the limits etc. And this espacially when using them as databases for VB.NET-applications. Any information would be great! Thanks a lot in advance, Pieter Tag: excel formulas and visual c# .net Tag: 106687
  - 22
    - Problem with Delete Query and DateTime parameter I want to delete some rows from database table by way: DELETE FROM DOSTEPNE_MIEJSCA WHERE ID_STANOWISKA = 66 AND GODZINA BETWEEN '2001-01-01 08:00:00' AND '2001-01-01 18:00:00' connection.Open(); string zapytanko = "DELETE FROM DOSTEPNE_MIEJSCA WHERE ID_STANOWISKA = 66 AND GODZINA BETWEEN '2001-01-01 08:00:00' AND '2001-01-01 18:00:00'"; OleDbCommand command = new OleDbCommand(zapytanko, connection); command.ExecuteNonQuery(); connection.Close(); where column GODZINA has DateTime data type... Why I get this Except?: "OleDBException was unhandled - Unsuitable type of data in expression of criterion" When I ry this query through the QueryBuilder - ExecuteQuery - I get properly ressult ... Thanks for help... Tag: excel formulas and visual c# .net Tag: 106685
  - 23
    - Error... Dear developer, I have experience this error message: System.NullReferenceException: Object reference not set to an instance of an object. at GreenBid_mobile.LoginProc.ValidateLogin(String EmailAdd, String Password) in c:\inetpub\wwwroot\greenbid_mobile\loginproc.asmx.cs:line 108 Here is the code: public string ValidateLogin(string EmailAdd, string Password) { int result; sqlCommand1.Parameters["@usr_Email"].Value=EmailAdd; sqlCommand1.Parameters["@usr_PW"].Value=Password; try { sqlCommand1.Connection.Open(); result=(int)(sqlCommand1.Parameters["@usr_session"].Value); } catch(Exception ex) { return (ex.ToString()); } sqlCommand1.Connection.Close(); if(result==1) return "Login Successfully"; else return "Login Failed"; the error is fall on "result=(int)(sqlCommand1.Parameters["@usr_session"].Value)", my database connectivity no problem.. but the problem keep on occur. Thanks advance whoever tell me the problem.. thanks cheers, Wong CS Tag: excel formulas and visual c# .net Tag: 106676
  - 24
    - about GetDate(T-SQL) SELECT GETDATE() July 29 1995 2:50 PM (1 row(s) affected) ---------------------- how can changed this format: 1995-29-05 14:50, Just in storeprocess ? Tag: excel formulas and visual c# .net Tag: 106668
  - 25
    - MSSQL - ON DELETE SET NULL Hello NG, Does SQL Server support "ON DELETE SET NULL"? I have a couple of CREATE TABLE / ALTER TABLE commands that are all in one string, separated by ";\r\n", and send them to SQL Server (without transaction context). The SQL itself is created dynamically, but here is a sample (for simplicity, I scrapped irrelevant stuff). I always get an SqlException with as many SqlErrors in it as there are ON DELETE SET NULL occurances. The same thing works with Access, though (with Jet-SQL syntax of course). Or (being a consumer product) is Jet just "fault tolerant" and ignores that? CREATE TABLE TFoo ( ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY, Bar UNIQUEIDENTIFIER); CREATE TABLE TList ( ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY ); CREATE TABLE TBar ( ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY, Foo UNIQUEIDENTIFIER, List UNIQUEIDENTIFIER, FOREIGN KEY (Foo) REFERENCES TFoo(ID) ON DELETE SET NULL, FOREIGN KEY (List) REFERENCES TList(ID) ON DELETE SET NULL); ALTER TABLE TFoo ADD FOREIGN KEY (Bar) REFERENCES TBar(ID) ON DELETE SET NULL; Many thanks, Phil Tag: excel formulas and visual c# .net Tag: 106667
- Next
  - 1
    - Which one is better one SQL or DataSet Transactions I am developing a project, in that i use SQL Transactions to begin a transaction like if i want to save the details of the user along with the Address first i will save the details of the user and then the address. in my database i have these type of files: Person, user, Address, userAddress : person will have the details like personID, firstName, LastName, SSN . . . and user will userid, PersonID, . . . . and in the same way Address will have a unique AddressID and this adddress id will be corelated in UserAddress. for this type of transactions i use SQL transactions. but when i was going thorough a Micorsoft Enterprise Example : Duwamish i came accross DataSet Transactions. in that, if there are any transactions he first performs all the transactions in the DataSet and then update the database. SQLDataAdapter.Fill(Destination, Source) from the above scenario which one is most reliable. . . Thankyou, Raghuram. Tag: excel formulas and visual c# .net Tag: 106666
  - 2
    - Which one is better one SQL or DataSet Transactions I am developing a project, in that i use SQL Transactions to begin a transaction like if i want to save the details of the user along with the Address first i will save the details of the user and then the address. in my database i have these type of files: Person, user, Address, userAddress : person will have the details like personID, firstName, LastName, SSN . . . and user will userid, PersonID, . . . . and in the same way Address will have a unique AddressID and this adddress id will be corelated in UserAddress. for this type of transactions i use SQL transactions. but when i was going thorough a Micorsoft Enterprise Example : Duwamish i came accross DataSet Transactions. in that, if there are any transactions he first performs all the transactions in the DataSet and then update the database. SQLDataAdapter.Fill(Destination, Source) from the above scenario which one is most reliable. . . Thankyou, Raghuram. Tag: excel formulas and visual c# .net Tag: 106665
  - 3
    - about the storeprocess ALTER PROCEDURE Login @LName nvarchar(50), @Pwd nvarchar(500) AS declare @myID int SET NOCOUNT ON if exists ( select @myID = ID from kylin_user where lname=@lname and pwd=@pwd ) begin insert into kylin_log(UID,TLogin)values(@myID,Getdate()) end RETURN but it mind that @myID=ID wrong ! what't the errors ? Tag: excel formulas and visual c# .net Tag: 106664
  - 4
    - SQL View How to use SQL View via ado.net in asp.net? Any reference at website? Please advise. Tag: excel formulas and visual c# .net Tag: 106663
  - 5
    - dispose() how to dispose connection pooling when aspx is discontinued? In VB, the syntax is unload but how about aspx ? Tag: excel formulas and visual c# .net Tag: 106662
  - 6
    - How to read from DataReader and Update using DataAdapter I am looking for example of reading one table using datareader and updating another with the values using a dataadapter. Tag: excel formulas and visual c# .net Tag: 106658
  - 7
    - CLOB - IN OUT PARAMETER PROBLEM (Type your message here) PROCEDURE dal_get_clob_data ( i_dal_string IN VARCHAR2, io_dal_clob IN OUT CLOB ); An exception threw when I tried to use IN OUT CLOB inspite of the usual work around I did. When it is IN CLOB or OUT CLOB it worked fine but not in case of INOUT CLOB. Is there anyway to do with this? I am using MDAC 2.7 -------------------------------- From: Naren Srini ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>V9J2gtoMqU6p5kL9A86XGA==</Id> Tag: excel formulas and visual c# .net Tag: 106642
  - 8
    - SqlDecimal MaxValue Has anyone noticed that the doc for this says: The value of this constant is 79,228,162,514,162,514,264,337,593,543,950,335 but that it is actually 99,999,999,999,999,999,999,999,999,999,999,999,999? Just thinking that Microsoft has a (minor) documentation error that should be fixed. Tag: excel formulas and visual c# .net Tag: 106640
  - 9
    - Master-Detail records I wrote an application in .NET 2003, everything worked fine for several weeks. This application has several text boxes and a detail grid. I put navigation buttons on the form to move to the next record, which will also change the data in the grid. I didn't make any changes to the application, but all of a sudden, the detail grid quit updating with changes to the position of the master. If I just did it wrong in the first place and it should have never worked, then that's the way it is, but I would like to know what I did wrong, and maybe some ideas of why it would all of a sudden decide to stop working. Thank you Kalvin Here is my code: '***** CODE STARTS HERE Public Function GetAllLabs() As DataSet Dim DS As DataSet DS = SqlHelper.ExecuteDataset(ConnectionString _ , CommandType.StoredProcedure _ , GET_ALL_LABS) DS.Tables(0).TableName = LabsTable DS.Tables(LabsTable).PrimaryKey = New DataColumn() {DS.Tables(LabsTable).Columns("LabID")} GetChild(DS) DS.Relations.Add("LabsToPVS" _ , DS.Tables(LabsTable).Columns("LabID") _ , DS.Tables(CHILD).Columns("LabID")) Return DS End Function Public Sub GetChild(ByRef DS As DataSet) SqlHelper.FillDataset(ConnectionString _ , CommandType.StoredProcedure _ , GET_CHILDREN _ , DS _ , New String() {CHILD}) DS.Tables(CHILD).PrimaryKey = New DataColumn() {DS.Tables(CHILD).Columns("ChildID")} DS.Tables(CHILD).Columns("ChildID").AutoIncrement = True DS.Tables(CHILD).Columns("ChildID").AutoIncrementSeed = -1 DS.Tables(CHILD).Columns("ChildID").AutoIncrementStep = -1 Return End Sub Private Sub BindFields() uiLabID.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "LabID") uiLabName.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "LabName") uiStreet.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Street") uiCity.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "City") uiState.DataBindings.Add("SelectedValue", Data.Tables(LabsTable).DefaultView, "State") uiZip.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Zip") uiProvince.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Province") uiCountry.DataBindings.Add("Text", Data.Tables(LabsTable).DefaultView, "Country") Dim PhoneNumberBinding As New Binding("Text", Data.Tables(LabsTable).DefaultView, "PhoneNumber") AddHandler PhoneNumberBinding.Format, AddressOf FormatPhone uiPhoneNumber.DataBindings.Add(PhoneNumberBinding) Dim FaxNumberBinding As New Binding("Text", Data.Tables(LabsTable).DefaultView, "FaxNumber") AddHandler FaxNumberBinding.Format, AddressOf FormatPhone uiFaxNumber.DataBindings.Add(FaxNumberBinding) AddHandler Me.BindingContext(Data.Tables(LabsTable).DefaultView).PositionChanged, _ AddressOf UpdateStatusForPosition End Sub 'Handles the Format event for the Phone and Fax numbers Protected Sub FormatPhone(ByVal sender As Object, ByVal e As ConvertEventArgs) If e.Value Is System.DBNull.Value Then Return End If If CStr(e.Value).Length = 10 Then e.Value = "(" & Strings.Left(e.Value, 3) & ")" & _ Mid(e.Value, 4, 3) & "-" & _ Strings.Right(e.Value, 4) End If End Sub Private Sub frmLab_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try Data.Tables(LabsTable).DefaultView.Sort = "LabName ASC" BindFields() ChildData.DataSource = Data.Tables(LabsTable) ChildData.DataMember = "LabsToPVS" With ChildData .Cols("PVSID").Visible = False .Cols("LabID").Visible = False .Cols("DateEntered").Caption = "Date" .Cols("StreckOperator").Caption = "Streck Operator" .Cols("PipetOperator").Caption = "Pipet Operator" .Cols("LotNumber").Caption = "Lot Number" .Cols("KitNumber").Caption = "Kit Number" End With FirstRecord() Catch exc As Exception MessageBox.Show(exc.Message.ToString, "Error Opening Form", MessageBoxButtons.OK, MessageBoxIcon.Error) Me.Close() End Try End Sub Private Sub FirstRecord() Me.BindingContext(Data.Tables(LabsTable).DefaultView).Position = 0 End Sub Private Sub UpdateStatusForPosition(ByVal sender As Object, ByVal e As System.EventArgs) ShowCurrentRecord() End Sub '***** END CODE Tag: excel formulas and visual c# .net Tag: 106637
  - 10
    - Combining multiple datatables on a unique ID Hi, Using VB .NET I want to combine app 100 different ADO.NET datatables, each with app 50,000 records which have been populated from SQL. They share a common ID, and I would like to group by this ID and sum up the other 4 columns to give me one master table. I understand how to populate the datatables but don't know what the best/fastest way to query across different datatables is. Any advice on querying one datatable with another on a common ID is much appreciated. Tag: excel formulas and visual c# .net Tag: 106630
  - 11
    - Deploy applcation VBNET and Sql Hello friends i have a question. Is about the deployment an application net over a pc. I installed the netframework 1.1 and i copied the applicattion . The problem es when the application tried to connect Sql. Dont do it Thanks -- Message posted via http://www.dotnetmonster.com Tag: excel formulas and visual c# .net Tag: 106617
  - 12
    - Data Adapter Problem? The following is an issue using ado.net in an asp.net page using SQL Server.... I have a Statement that when executed from my asp.net dataadapter takes about 24,000 reads according to SQL Profiler. I think the read count is accurate as it grids a long time. The same statement when executed from Query analyzer takes only 116 reads and it executes quickly. Why the Difference? Same table, same server. The statement as it executes is as follows: exec sp_executesql N'SELECT Amount, InvoiceNum, Job FROM Unpaid_Bal WHERE (InvoiceNum = @InvoiceNum) AND (Job = @JobNum)', N'@InvoiceNum varchar(50),@JobNum varchar(11)', @InvoiceNum = '100488RS', @JobNum = 'ABCE-036245' thanks, G Tag: excel formulas and visual c# .net Tag: 106613
  - 13
    - FTP a text file guys, i need some help on this one. i need to set up a program that will create a text file (done that). then ftp that file to an IP address, say IPAddress=204.23.144.21 IPLogin=ftpmylogin IPPassword=mypwd this program can be in VB.NET or ASP.NET - doesnt really matter. whichever is the easiest. im a little lost as to where to turn on this one. thanks again rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: excel formulas and visual c# .net Tag: 106611
  - 14
    - bound comboboxes I have three comboboxes on the form. When the record is displayed, all the three combo boxes are blank. If I select a value in the first combo box, and click save, the first value in the other combo box is displayed automatically. However, if I go to the next record and come back, those 2 combo boxes are correctly shown as blank. Is this a known issue? Any workarounds ? Thanks Tag: excel formulas and visual c# .net Tag: 106610
  - 15
    - Trying to use Nile Oracle DAAB in VB I am trying to use the Oracle DAAB found in the Nile application at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp. I am trying in VB 2003 to call an Oracle 9i stored procedure with parameters but I cannot seem to get past the compiler. Oracle procedure: CREATE OR REPLACE PROCEDURE insertNonQWP (repText IN VARCHAR2,repID IN NUMBER) IS BEGIN UPDATE TESTNONQ SET TXTFIELD = repText WHERE TID = repID; COMMIT; END; What am I doing wrong in my parameter assignment? One of the examples in C# looks like: OracleParameter[] ps = {new OracleParameter("CUSTOMERID",customerId), new OracleParameter("SESSIONID",sessionId), new OracleParameter("NETAMOUNT",netAmount), new OracleParameter("TAXAMOUNT",(Decimal.Multiply(netAmount, (Decimal)0.05))), new OracleParameter("TOTALAMOUNT",(Decimal.Multiply(netAmount, (Decimal)1.05))) }; OracleHelper.ExecuteNonQuery(m_connectionString, CommandType.StoredProcedure, "SP_PURCHASECARTFORSESSION", ps); How do I do it in VB? I tried: Dim ps() As OracleParameter = {New OracleParameter("REPTEXT", "Junk"), New OracleParameter("REPID", 2)} Dim rowAffected As Integer rowAffected = OracleHelper.ExecuteNonQuery(connectString, CommandType.StoredProcedure, "insertTestNonQ", ps) and I get an ?Overload resolution failed because no accessible ?ExecuteNonQuery? can be called with these arguments.? ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: excel formulas and visual c# .net Tag: 106609
  - 16
    - Wierd Occurrance I have an intermittant problem that occurs a couple of times a week in a handful of places in the code (the same places at different times). The error is 'Object reference not set to an instance of an object'. After much research (it's not my code), I've found that it is occuring when a datareader is being used after being returned from a another method that queries an Oracle database. Here is the method: Public Function GetDataReader(ByVal strSelect As String) As OleDbDataReader Dim rc As Integer Const FUNCTION_NAME As String = CLASS_NAME + ":SelectSQL" Try objConn = New OleDbConnection(strConnectionString) objCmd = New OleDbCommand(strSelect, objConn) objCmd.Connection.Open() GetDataReader = objCmd.ExecuteReader(CommandBehavior.CloseConnection) Catch ex As OleDbException If oLogFile Is Nothing Then oLogFile = New clsLogFile() rc = oLogFile.LogErrorMessage(FUNCTION_NAME, ex.ErrorCode, ex.Message + " SQL Statement: |" + strSelect + "|") GetDataReader = Nothing Finally objConn = Nothing objCmd = Nothing End Try End Function As I mentioned above, the error is occurring the first time the returned datareader is used in the calling code. The first thing the calling code does is check to see if the returned datareader is closed. When this statement executes the datareader object does not exist. Here is an example of the calling code: oDatabase = New ICPT.clsDatabase(oSession.ApplicationConnectionString, oSession.DatabaseType) strSQL = "SELECT * FROM TransactionCodes" rdrTranCode = oDatabase.GetDataReader(strSQL) 'verify the datareader is open and contains a record If rdrTranCode.IsClosed = False Then '' bomb on this line 'do something End If I've checked the application log files and there is no indication that the GetDataReader() method is trapping and logging an error. Any of you guys see a problem with this code? It looks as if a database connection and subsequent query are being done successfully (nothing in error logs), but when the datareader is returned the reference to the datareader is lost. I can tell you that most of the things this application does involve at least a few calls to GetDataReader(), and sometimes there are quite a few calls to perform a certain function. I've checked the Oracle log and trace files and there is no indication of anything flaky. Any ideas? Thanks, Todd Tag: excel formulas and visual c# .net Tag: 106607
  - 17
    - How to select distinct values I have a DataSet filled from a previous query to the database. I need to get the distinct values from a field in the DataSet. Is there a way to acheive this without going through the DataTable or by hitting again the database? TIA Tag: excel formulas and visual c# .net Tag: 106604
  - 18
    - REGISTERED CAD/CAM/GIS softwares! hi all ! see my site and you understand all. www.michaeliusis.narod.ru Hi all ! I provide CRACKED engineering and technical software at this topics: 1. Civil and Structural 2. 2. Survey , GIS , Rock , Soil and Water 3. Architectural 4. CAD-CAM 5. FEA , CFD and CAE 6. Electrical , Electronic , Control and Power 7. Chemical 8. Industrial and Control Project 9. HVAC and Piping 10. Mathematics , Statistics and Accounting 11. Engineering and Technical Standards and Databank Such as ISO , DIN , BSI ,ASME , ASTM ,... 12. Graphics and Animation 13. Busines and Financial 14. And other technical topics. Making cracks for your desire , any program. All soft I offer have been completely cracked and tested carefully by expert in corresponding field. All programs are full copies of originals (not demo, evaluation, trial or educational version) including English or multilanguage tutorial and crack or license file that makes program work as registered software from the house. Here is just a part of our software list.For getting the additional information Contact e-mail: danielhtools@yahoo.com Actel Designer V5.2 Adina System v7.5 Adobe Video Collection Pro V2.0 Agilent ADS 2003C ALGOR V15 Altium Protel 2004 Ansoft Ensemble v8.0 Ansoft HFSS 9.1 ANSOFT.SIMPLORER.V6.0 ANSYS CFX V5.7 (c) SAS IP INC, ANSYS Workbench 8.1 ArcView 9.0 Autodesk Architectural Desktop 2005 Autodesk AutoCad 2005 Autodesk AutoCad 2005 LT AUtodesk Building Systems 2005, AutoDesk Composer 2005, Autodesk invision 8 AutoDesk Land Desktop 2005, Autodesk Mechanical Desktop 2004 AutoDesk OnSite Enterprise 2.5, Autodesk Pre-Plan AutoDesk Raster Design 2005, Autodesk Revit 6.0 AutoDesk Revit 6.1, AutoDesk Survey 2005, Autodesk VIZ 2005 (c) Autodesk, AUTODESK.Inventor Professional 9 AUTODESK.INVENTOR SERIES V8 AUTODESK.VIZ.4.2 AutoManager Meridian 2004 AutoManager TeamWork 2004 Axum v6.0 (MathSoft) BENTLEY Descrates v8.1.2 NT2KXP Bentley Explorer 2004, BENTLEY GEOPAK REBAR 2004 Edition BENTLEY HVAC V8.01.01.05 BENTLEY IRAS B v8.1.2 NT2KXP BENTLEY MicroStation GeoGraphics v8.01.02.03 BENTLEY MicroStation Triforma v8.1 BENTLEY MicroStation TriForma v8.1.1. BENTLEY MicroStation V8.5 BENTLEY PowerDraft Database Server v8.01.02.20 BENTLEY PowerDraft v8.01.02.20 BENTLEY Redline v8.01.02.18 BENTLEY TriForma v8.01.01.24 BENTLEY.INROADS V8.4 BENTLEY.MICROSTATION.V8.1 BobCAD-CAM Version 19.0 Cadence Allegro v13.6 Cadence PSD rev 15.0 CADKEY Workshop EX v21.5 SP2 CAESAR II ver 4.4 Calcmenu 2004 CAM350 Release 8.5 Catia CAA V5R12SP3 Catia Rade tools V5R12SP3 Century Software TinyTERM Plus v4.40, CFDlab.v2.2 CFX v5.6 ChemOffice Ultra 2004 v8.0 ChemOffice Ultra v8.03 (C) CamSoft Cimatron 13 CIMATRON IT v 13.1 Cinema 4D ver. 8.503 CNC Plus V5 CNC Professional V15 Coade CadWorx Pipe V2004 COADE CodeCalc 2004 Build 040607 COADE PVElite 2004 Build 040607 COADE TANK 2.50 Build 040510 Cocreate NET MODEL EXPLORER 2004 V12 COSMOS Works 2004 SE Cosmosworks 2004 CSI ETABS NonLinear v8.13 CSI Sap2000 Nonlinear v8.2.3 CST Microwave Studio 5 DASSAULT SYSTEMES CAA CATIA P3 V5R13 DASSAULT SYSTEMES CAA ENOVIA LCA V5R13 DASSAULT SYSTEMES CAA ENOVIA PORTAL V5R13 DASSAULT SYSTEMES CAA RADE V5R13 Dassault Systemes CATIA v5R13 DASSAULT SYSTEMES DELMIA VMAP D5R12 SP4 Dassault Systemes Enovia 3d com v5.0 R13 Dassault Systemes Enovia DMU Navigator v5.0 R13 DASSAULT SYSTEMES ENOVIA DMU V5R12 DASSAULT SYSTEMES ENOVIA USER COMPANION FOR DMU V5R12 Dassault Systemes Enovia VPM Navigator v5.0 R13 DASSAULT SYSTEMES SMARTEAM V4.0 SP5.5 DEFORM 3D v 4.03 Deform 3D v5.0 (c) Scientific Forming Technologies Corporation DELCAM ARTCAM PRO V5.509C Differential Calculus (CrashCourse) Division Visual Collaboration Services 6.4.8, EdgeCAM V8.0 EdgeCAM V8.75 EdgeCAM.v7.5 EDS Design Shop 2004 Email Spyder V1.9 Empire v4.00 LICENSE FIX (c) IMST Erdas Imagine 8.6 Erdas Imagine V. 8.7, ESRI ArcGIS 9 ESRI ArcGIS Desktop v8.3 ESTOS PROCALL 2.2.17 Expert Moldbase Extension 4.1 DatecodeM150(2004120), FASTSHIP V6.1 FEM DESIGN V4.2 FIDES.Drill.v2003.336 FIDES.Erddruck.v2004.041 FIDES.Flow.v2004.036 FIDES.Gleitkreis.v2004.041 FIDES.Grundbruch.v2004.041 FIDES.KEM.v2003 FIDES.KEM.v2004.041 FIDES.Pilepro.FEM.v2003 FIDES.PILEpro.v2004.043 FIDES.Setzung.25D.v2004.042 FIDES.Setzung.v2004.041 FIDES.SteelCON.v2003.308b FIDES.Walls.Bemessung.v2003.288 FIDES.Walls.FEM.v2003 FIDES.Walls.FEM.v2004.041 FIDES.Walls.v2004.033 FIDES.WinIGEL.v2004.043 FileMaker Developer 6 Flexisign 7.5 FLOWPHASE.POWER.SUITE.V1.02 FLOWSCIENCE.FLOW.3D.V8.2 FormZ 4.2 (c)Auto·Des·Sys,Inc. FORMZ RADIOZITY V4.0.3 GIBBSCAM 2004 V7.07 Goelan 5.5 GoSteel 4.1 GravoStyle 98 v4.1 Dynamic version HEAL V8.1 - ANSYS, Hydraulicdesign Form vs Shape Rhino Tutorial v2, HyperSteel v7.0 HYPERSTEEL V7.1 SP1 HYSYS V3.2 - HYPROTECH, Image Processing Ext Pack for MathCAD 2000/2001 3.0 (Mathsoft) Intergraph PDS v 7.2 INUS TECHNOLOGY RAPIDFORM V2004 JewelCAD v5.0 LabVIEW 7.0 Lasergene version 5.08 Liscad.v6.2 LOGIC DESIGN AND VERIFICATION V5.1 (c) CADENCE Ls-Dyna V 970 Maple 8 (Waterloo Maple) Maple 9.5 Mathcad v11.A Enterprise (Mathsoft) Mathematica 4.2 (Wolfram Research) MATHWORKS MATLAB V6.5 Mathworks Suite v13 With Matlab v6.5 (Mathworks) MAXNC 15 CL & RAMS CAM Software Maxon Cinema 4D Maxon Cinema 4d v 8.5 MECHSOFT.INVENTOR.SERIES_6.0 Medisoft Network Professional Version 9 Mentor Boardstation C4S Metrowerks CodeWarrior HC(S)08 V3.0 MicroSim 8.0 MICROWAVE STUDIO V5.0 - CST, MODELSIM.SE.V5.8A Modelsim5.8B SE MPSIII v4.0 (Ketron) MSC.Fatigue for MSC Patran 2004 MSC.FEA-MSC.AFEA 2004 (C) MSC.Software MSC.Patran 2004 Documentation (c) MSC.Software, MSC.SuperForm 2004 with MSC.SuperForge 2004 NCSS 2002 (NCSS) NCSS 2004 STATISTICAL ANALYSIS SYSTEM NE NASTRAN V8.3, Nemetschek Allplan Ft v17.0 Nemetschek Allplan v2004 Nemetschek PlanDesign V2004 Nemetschek Vectorworks 10 Spotlight incl Renderworks NUMECA.FINE.TURBO.DESIGN.3D.V6.0 ORCAD 9.23 CADENCE OriginLab Origin Pro 7.0 PCB DESIGN STUDIO V15.1(c) CADENCE PENTALOGIX CAM MASTER 8.4.50 PLanit Millennium 8.3 Plaxis 8.0 Pointwise.Gridgen.V15 POWERCAD.PRO.V5.0 Primavera Expedition 8.5 Pro/DESKTOP Express 8 Pro/E Wildfire Date Code 2002490 Pro/ENGINEER Wildfire 2.0 Datecode F000 (2004110), Pro/INTRALINK R3.3 Service Pack Datecode M021, Pro/INTRALINK Release 3.3 DateCode 2002471 (c) PTC ProgeSOFT IntelliCAD 4.8 Progressive Die Extension 2.1 DatecodeM140(2004030), PROSTEEL 3D V16.2 Protel 2004 SP2 Protel DXP 7.0 PTC Pro Engineer Wildfire v2003 QuarkXPress 6.0 Quartus II v4.0 for PCs (c) Altera QuickBooks pro 2004 Radimpex ArmCAD v2.3.3 Radimpex software Tower 5.0 Radimpex Tower 4.3.8 Ram Advanse v5 Ram Structural Steel V8.0 REBIS AUTOPIPE V6.2 Rebis AutoPIPE v6.20 SAS v8.2 Scientific Notebook 3.5 (MacKichan) SDD 2004 (c) Mentor Graphics, SDS/2 v6.325 SESCOI WorkNC V16-12 Sescoi.WorkNC v16.0 Multilanguage ShipContructor2005 (c) ARL Softplan 11 Solid Edge v15 (c) Unigraphics Solutions Solidworks office 2004 SOLIDWORKS V2004 SP3 SolidWorks2004 SP 2.1 SPECCTRA ShapeBased Automation Software V15.1 SPSS v12.0 Staad PRO 2003 Synopsys.Core.Synthesis.v2002.03 Synopsys.Core.Synthesis.v2003.03 TANNER L-EDIT PRO V10.0 with LVS V10.0 TANNER S-EDIT V8.1 Teamcenter Visualization 5.1 (c) EDS, Tebis 3.2 r2 TECPLOT.V9.0 With CFD Analyzer 2.0 Tekla Structures V10.0. TEKLA XSTEEL v9.0 TEKLA XSTEEL V9.1 TEKSOFT PROCAM II V2003 T-FLEX CAD 8.0 TkSolver v4 Interactive Roark's Formulas (UTS) TurboCAD Deluxe Version 10.1 TurboCAD Professional v10.1 Unigraphics 18.0 UNIGRAPHICS NX 1.0.3.2 UNIGRAPHICS NX V2.0 VectorWorks LANDMARK v 10 Virtual Gibbs 6.1 Visual Mill 5.0 VisualMill 5.0 WASP-NET V5.4.3 (C) MiG WG2004 (c) Mentor Graphics, Wilcom 8.0 Wizetrade v 7.0 Working Model 2D 2004 v6.0 (c) MSC Software Zuken 6.04 ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: excel formulas and visual c# .net Tag: 106603
  - 19
    - Performance Problems with filtering in Dataview Hi all! I would really appreciate getting some help on the following problem: I use a cached dataview as a source for my datagrid. The user selects items from controls and based on the selections a filter is applied on the dataview and the datagrid re-databinded. Now the problem: when I test the application on the server it works extremely fast, the filtering processes within 2 to 3 seconds on a datatable with 4000 rows! When I try to access the same site on the server from a client-Computer in the business network the filtering takes about 40 to 60 seconds!!! Does anyone have a clue how to explain these extreme performance differences? THANKS in advance, Robert Gregory -- Message posted via http://www.dotnetmonster.com Tag: excel formulas and visual c# .net Tag: 106601
  - 20
    - SPs, sqlCommand and Terminal Services Hi all, I just ran into something very, very strange.. I have this application which fires of a series of SQL Scripts using the sqlCommand Object. One of the statements executes the procedure "sp_addMergePublication" on the server. If I do this on a local machine, everything works fine. But if I run my application on a server using Terminal Services then the application will Halt on that statement saying that "A severe error has occured." and that any changes should be discharged. Note. This happens ONLY when I run the application remote and it is not an error bound to a specific machine. I can recreate the problem on any given server. Has anyone ever had this problem, or perhaps even knows why this happens? B Tag: excel formulas and visual c# .net Tag: 106595
  - 21
    - DataSet Filter Hello all. I'm trying to filter a dataset using the below snippet, however, it's returning 2 rows and it should only return 1. Can anyone please hel?p DataView dv = new Customer().GetCustomerFiles(4).Tables[0].DefaultView; dv.RowFilter = "FileType = 'Company Info'"; int b = dv.Table.Rows.Count; string a = dv.Table.Rows[0]["Title"].ToString(); Thanks all, Jon Tag: excel formulas and visual c# .net Tag: 106593
  - 22
    - SqlCommand fires too soon..... I have the following: ___________________________________ Dim cmdSaveUser As New SqlCommand cmdSaveUser.Connection = con 'con has been configured previously cmdSaveUser.CommandType = CommandType.StoredProcedure cmdSaveUser.CommandText = "spInsertUser" cmdSaveUser.Parameters.Add("@FirstName", "Joe") cmdSaveUser.Parameters.Add("@Navn", "Brown") cmdSaveUser.Connection.Open ..... ___________________________________ What happens is this: As soon as i .open the connection, it seems that the command is fired. I don't want this to happen, as I want to call executeScalar and get an object in return. Any ideas? Jeppe Jespersen Tag: excel formulas and visual c# .net Tag: 106592
  - 23
    - Losing records in a transaction I'm currently using .NET 1.0 and MS .NET provider for Oracle to connect to my Oracle9i R2(9.2.0.5) database. I have a piece of code which in essence is as given below Try m_Conn = New OracleConnection(strDBConnString) m_Conn.Open() m_Trans = m_Conn.BeginTransaction() 'Here I have a series of inserts and updates on huge tables. I am using ExecuteNonQuery function of the OracleCommand object for all these operations. InsertTb1() InsertTb2() UpdateTb3() 'If all goes fine I commit the whole transaction m_Trans.Commit() Catch ex as Exception 'Here I catch all exceptions and rollback the whole transaction m_Trans.Rollback() Finally m_Conn.Close() End Try I have similar code doing different actions on the same tables, running through out the application. Off late I have been getting database locks and subsequent slowness in the application. My DBA tracks down the holding statements and kills the session. Now, if the script used in InsertTb1() happens to be the statement of the assocated session that was killed, I expect Oracle to throw an exception, which inturn should be caught in the catch block and the whole transaction shoud be rolled back. But, it looks like I do not get an exception, due to which the code proceeds to fire the subsequent statements (InsertTb2(), UpdateTb3()) and I end up with incomplete records in the database. I have had an instance before, where Oracle database was throwing a 'No Data found' exception, but the exception never bubbled to my code i.e. The .NET provider ignored the excepton. Could this be a similar case? -- Message posted via http://www.dotnetmonster.com Tag: excel formulas and visual c# .net Tag: 106591
  - 24
    - changing the table a dataadapter accesses changing the table a dataadapter accesses If I want to change the table a dataadapter accesses, can I remove the former table from the dataset's xsd file by simply deleting it? Thank you in advance. dennist685 Tag: excel formulas and visual c# .net Tag: 106590
  - 25
    - DataTable.Select question Hi! An application adds DataRows into DataTable in random period of time, and after adding new rows saves DataTable as XML-file. DataTable contains DateTime Field named as "SaveTime", and some other fields... About "SaveTime" field, schema looks like... <xs:element name="SaveTime" type="xs:dateTime" minOccurs="0" /> Q: Is it possible to retrieve easily only those rows where rows are for example at least 10 minutes old according "SaveTime"? I mean something like... Dim drArr As DataRow() = dt.Select("SaveTime >= 10min") ...so how to make filterExpression correctly if it is possible? -- Thanks in advance! Mika Tag: excel formulas and visual c# .net Tag: 106586

Hi,

I developed an application in visual c# .net
This application reades an excel file and displays its contents into a dataGrid (OleDbDataAdapter).
What I discovered is that if a cell in excel has a constant, then i can retrieve its contents. Also, if a cell has a formula (e.g. =K10) and K10 has a constant then it is also fine.
But if the cell's properties are of Custom type, with type, say hh:mm, then i cannot get the contents to the dataGrid.

Do you know why this is happening? Has anyone found a workaround for it?

Thanks in advance
Kostas

--------------------------------
From: Kostas Alifantis

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>ICkne+DCCUWlYeHpuluf+w==</Id>

Top

Re: excel formulas and visual c# .net by Paul

Paul
Fri Mar 11 10:53:59 CST 2005

On Fri, 11 Mar 2005 06:22:32 -0800, Kostas Alifantis via .NET 247 <anonymous@dotnet247.com> wrote:

¤ Hi,
¤
¤ I developed an application in visual c# .net
¤ This application reades an excel file and displays its contents into a dataGrid (OleDbDataAdapter).
¤ What I discovered is that if a cell in excel has a constant, then i can retrieve its contents. Also, if a cell has a formula (e.g. =K10) and K10 has a constant then it is also fine.
¤ But if the cell's properties are of Custom type, with type, say hh:mm, then i cannot get the contents to the dataGrid.
¤
¤ Do you know why this is happening? Has anyone found a workaround for it?
¤

Could you post your connection string? It's possible that the addition of the IMEX parameter may
resolve your problem.

Paul
~~~~
Microsoft MVP (Visual Basic)

Top