downloading from web mail

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
    - Why ImportRow is causing NullReferenceException & Rows(0) <> NULL Hello, I am receiving a System.NullReferenceException error when the ImportRow is executed. However, as you can see there are rows in the table and I can see the data in Rows(0) in the dsetTempPlaceInfoFromPt.Tables("Places").Item.ItemArray of QuickWatch. Thus it is not null. The dSetPlaces (where I am trying to copy the row to) does not have any tables or rows; is that the problem? Does the ImportRow automatically create the table "Places" in the dataset dSetPlaces if it is not there? Maybe that's my problem. If dsetTempPlaceInfoFromPt.Tables("Places").Rows.Count = 1 Then dSetPlaces.Tables("Places").ImportRow(dsetTempPlaceInfoFromPt.Tables("Places").Rows(0)) I am using .NET 2.0 framework and there are values in the ItemArray of the Rows(0). Help! -- Thank you. Tag: downloading from web mail Tag: 132200
  - 2
    - Provider Factories We are moving our software to the web using ASP.NET 2.0 and are researching ways to enable our software to connect to multiple databases, specifically Oracle, SQL Server, and ASA. We have used ODBC in a client-server environment in the past, but have now stumbled upon Provider Factories in .NET 2.0. Could you please provide us with the pros and cons of using provider factories? Tag: downloading from web mail Tag: 132194
  - 3
    - ORA-03113 exception thrown Background - VB.NET v1.1 SP-1. Query Oracle database using Microsoft .NET provider for Oracle (System.Data.OracleClient). Exception is thrown using both get data methods: 1.) OracleCommand.ExecuteReader() 2.) OracleDataAdapter.Fill() Problem - A certain query which happens to contain a Group By and Sum throws an ORA-03113 exception. We traced through alert.log and other logs within Oracle and determined an internal exception of ORA-07445 was thrown when query was executed in the database. I can take the same query and execute it from other query tools fine: sqlplus, plsqldeveloper and etc. I noticed a hotfix that addressed something similar to this, but reading through the documentation this hotfix was included in .NETv1.1 SP-1. I've confirmed that I have SP-1 by looking in registry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v1.1.4322\1033\SP value is 1. My TestOracleQuery project runs fine for all other Select statements except ones similar to one described earlier. Any help with this ORA-03113 is greatly appreciated. Tag: downloading from web mail Tag: 132192
  - 4
    - Why does a DataTable serialize so large If I create a simple collection with say 20 columns and 5000 row and a DataTable with the same and serialize both, the DataTable file is at least 2 times the size as the simple collection. What is all the overhead with the DataTable? -Joe Tag: downloading from web mail Tag: 132189
  - 5
    - Nullable types in strongly typed DataSet Hello, I have a nullable DATETIME column in my SQL Server table, and I have the nullable type DateTime? in my .NET 2.0 application - but how do I make the DateTime field in my strongly typed dataset nullable? When trying to manually enter System.DateTime? in the DataType property of the DataSet, I get "Column requires a valid DataType" - and when trying to change the NullValue property to (null), I get "For columns not defined as System.String, the only valid value is (Throw exception)" - which make it seems to me that I cannot use the nullable datatypes in my DataSet? Is this right? Regards, Nils Magnus Englund Tag: downloading from web mail Tag: 132182
  - 6
    - poor OracleClient performance? Hi all, in the process of migrating from 1.1 to 2.0 iÂ´m experiencing massive performance losses within the database access to a oracle database (same effect on 9 and 10) the following code is built in 1.1 and 2.0 (except the stopwatch of course). The 1.1 application is finished in less than the half time than the 2.0 app. (talking of 2.1 seconds instead of 4.4 seconds). table1 is a table of about 12000 rows and 35 columns, running well in a production environment. // test button handler: string result = ""; label1.Text = "test running... pls wait"; label1.Refresh(); Stopwatch w = new Stopwatch(); w.Start(); using (OracleConnection oc = new OracleConnection("Data Source=XXXXX.world;Persist Security Info=True;User ID=XXXXX;Password=XXXX;Unicode=True")) { oc.Open(); using (OracleCommand cmd = new OracleCommand("SELECT * FROM table1", oc)) { using (OracleDataAdapter ada = new OracleDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { ada.Fill(dt); } } } } w.Stop(); result += " r: "+w.ElapsedMilliseconds; System.Diagnostics.Debug.WriteLine(result); label1.Text = result; The performance loss can be reproduced with other sql statements and different tables in different Oracle databases. ItÂ´s just the OracleClient assembly that makes the difference. Can anyone confirm this performance loss? --- thanks in advance a Tag: downloading from web mail Tag: 132179
  - 7
    - GetOleDbSchemaTable throwing an unexpected OleDbException Hello, I have an app that uses this statement to retrieve the procedure name of an Access database: DataTable dbSPS = cnx.GetOleDbSchemaTable(OleDbSchemaGuid.Procedures, null); It's working nicely. However, in a specific database, the same code throws this exception: System.Data.OleDb.OleDbException: The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.GetSchemaRowset(Guid schema, Object[] restrictions) at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions) Compacting and repairing the database has not helped. I've researched a lot in internet but I haven't found anything related. Any ideas? Thanks in advance, Jos Tag: downloading from web mail Tag: 132176
  - 8
    - Sql2005 Express in Win2000 pro Hi, When I install Sql2005 Express in Win2000 pro, it failed with : This system did not have the correct version of MDAC installed. Which version is needed for Sql2005 Express when installed in Windows 2000 professional? Tag: downloading from web mail Tag: 132174
  - 9
    - Connection Pooling With ASP.NET 1.1 Does ASP.NET with ADO connecting to MS SQL Server use connection pooling by default if the connection string is always the same? If not, how does one go about evoking connection pooling ? Tag: downloading from web mail Tag: 132173
  - 10
    - Can DataSet or DataTable be the "DataSource" of crystal report? I program using ADO.NET and plan to generate a crystal report. Can DataSet or DataTable be the "DataSource" for a crystal report (just like DataGridView) which simplify display of rows and columns? What make up the data source for crystal report? Replies are appreciated... -- Message posted via http://www.dotnetmonster.com Tag: downloading from web mail Tag: 132172
  - 11
    - Update joined TableAdapter This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6C716.4EDB4A40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! (Read this with font courier new or equal) I have a table adapter which fills a datatable with data from two sql = tables: Properties, and PropCompanyInfo: tbl1.PropertyID pk identity(0,1) tbl1.PropertyName tbl2.ID pk identity(0,1) tbl2._PropertyID tbl2.CompID tbl2.Comment Selected with the query SELECT tbl1.PropertyID, tbl1.PropertyName, = tbl2.ID, tbl2._PropertyID, tbl2.CompID, tbl2.Comment from Properties=20 left outer join PropCompanyInfo on tbl1.PropertyID =3D tbl2.PropertyID = and tbl2.CompID =3D @CID The result is all rows from Properties, joined with PropCompanyInfo = where found. I have a datagrid where the user should add or edit comments (the rows = amount is static). Could look like: PropertyID PropertyName ID _PropertyID CompID Comment 7 Birdland =20 12 Fireland =20 As you can see in this example there are no rows with comments for this = company. Now I want to update tbl2 with all rows that have a comment added. I get = the message that ID don't allow null. I also have to set the _PropertyID = to the same as PropertyID, and the CompID has to be set somehow. Since I have a dataset with a datatable, I think this could be made = without events for the grid and other code? I'm not a full time developer, so I think there are some fundamental = things I don't get here? HELP! Regards Magnus ------=_NextPart_000_0006_01C6C716.4EDB4A40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.3790.2759" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff background=3D""> <DIV><FONT face=3D"Courier New" size=3D1>Hi!<BR>(Read this with font = courier new or=20 equal)<BR>I have a table adapter which fills a datatable with data from = two sql=20 tables: Properties, and=20 PropCompanyInfo:<BR><BR>tbl1.PropertyID      pk = identity(0,1)<BR>tbl1.PropertyName<BR>tbl2.ID    &nbs= p;    =20     pk=20 identity(0,1)<BR>tbl2._PropertyID<BR>tbl2.CompID<BR>tbl2.Comment<BR><BR>S= elected=20 with the query SELECT tbl1.PropertyID, tbl1.PropertyName, tbl2.ID,=20 tbl2._PropertyID, tbl2.CompID, tbl2.Comment from Properties = </FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D1>left outer join PropCompanyInfo = on=20 tbl1.PropertyID =3D tbl2.PropertyID and tbl2.CompID =3D = @CID<BR></FONT><FONT=20 face=3D"Courier New" size=3D1>The result is all rows from Properties, = joined with=20 PropCompanyInfo where found.</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D1><BR>I have a datagrid where the = user should=20 add or edit comments (the rows amount is static).<BR>Could look=20 like:<BR>PropertyID  PropertyName  ID =20 _PropertyID  CompID =20 Comment<BR>7           = Birdland       </FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D1>12         =20 Fireland      <BR></FONT><FONT = face=3D"Courier New"=20 size=3D1></FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D1>As you can see in this example = there are no=20 rows with comments for this company.<BR>Now I want to update tbl2 with = all rows=20 that have a comment added. I get the message that ID don't allow null. I = also=20 have to set the _PropertyID to the same as PropertyID, and the CompID = has to be=20 set somehow.</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D1>Since I have a dataset with a = datatable, I=20 think this could be made without events for the grid and other=20 code?</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D1>I'm not a full time developer, = so I think=20 there are some fundamental things I don't get here? HELP!</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D1></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D1>Regards = Magnus</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C6C716.4EDB4A40-- Tag: downloading from web mail Tag: 132170
  - 12
    - Restore fail in Asp.Net I use asp.net to restore a SqlServer database. I use the code: Restore database MyBase from disk = 'c:\xxx.bak' with Replace But after execute, it display an error message: Restore fail, the user did not have the previllage to RESTORE DATABASE 'MyBase' How can I do? Tag: downloading from web mail Tag: 132169
  - 13
    - Accessing ODBC DSNs Way back in the old ASP days, it was possible to open a Database connection by providing only the name of the ODBC DSN that I'd created earlier. I didn't need to indicate which driver, whether the connection was to SqlServer or something else, etc. It looked like: Conn = Server.CreateObject("ADODB.Connection") Conn.Open "MyNamedDSN" In C#.Net, I'm trying to figure out what connection string I provide when I do Conn = new OleDbConnection(ConnString); if I want to connect via an ODBC DSN instead of specifying the details in the ConnectionString itself. Can you help with this? Thanks. Alex Tag: downloading from web mail Tag: 132168
  - 14
    - DeriveParameters throws NummReferenceException Hi, I am coding under .Net compact framework and using System.Data.SqlClient connect to MS SQL server through PDA USB cradle. I can execute stored procedures and sql select or updates statements. But I always get NullreferenceException when I try to use DeriveParameters function of SQLCommand to get parameters of my stored procedure? Any idea? I tried the same function under .Net framework, it works fine. I am using SQLHelper the function is DiscoverSpParameterSet(SqlConnection connection, string spName, bool includeReturnValueParameter) And I got exception on this line SqlCommandBuilder.DeriveParameters(cmd); Anybody has experienced this before. Is it a bug for .NET CF(cannot use DeriveParameters function)? Do I have to explicit assign those parameters for my stored procedures (that would be a painful coding) thanks in advance -rockdale Tag: downloading from web mail Tag: 132166
  - 15
    - Please tell me what is wri=ong using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Data.Common; namespace trial_a { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { string connect_string = "SELECT * FROM Customers, Invoice"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "server = fred\\sqlexpress; database = newdb;integrated security = true"; using (SqlDataAdapter da = new SqlDataAdapter(connect_string, conn)) { using (DataSet ds = new DataSet()) { da.TableMappings.Add("Table", "Customers"); da.TableMappings.Add("Table1","Invoice"); da.Fill(ds,"Table"); try { DataTable dt1 = ds.Tables[0]; DataTable dt2 = ds.Tables[1]; textBox1.Text = dt1.Rows[0].ItemArray[0].ToString(); textBox2.Text = dt2.Rows[0].ItemArray[0].ToString(); } catch (Exception x) { MessageBox.Show(x.Message); } } } } } } } Tag: downloading from web mail Tag: 132162
  - 16
    - 1:1 Relation I have created a DataSet out of an SQL Server DB. In the server, there are several 1:1 relations, in the graphical representation of the DataSet in Visual Studio, it seems as if there were just 1:n relations. Why? Is it a bug in VS 2005 or is it impossible for an autogenerated DataSet to understand those relations? Tag: downloading from web mail Tag: 132160
  - 17
    - First connection to the database (Oracle) from a .Net console application takes 6 sec Dear All, I am using Oracle Client 8.1.7.0.0. My .Net (c#) console application makes a connection to Oracle database and has following code Console.WriteLine(DateTime.Now.ToString()); OracleConnection NDPConnection = new OracleConnection("User ID=<Username>;Data Source=O801;Password=<Password>;"); NDPConnection.Open(); Console.WriteLine(DateTime.Now.ToString()); NDPConnection.Close(); It is observed that the Open method takes almost 6 sec the first time it is executed. Next all instances of the application opens the connection very fast. Next time again when the code is executed after restarting the machine, opening the connection takes almost 6 sec. Is there something to improve this? Have I missed something? Please help. Thanks & regards Sunil Tag: downloading from web mail Tag: 132158
  - 18
    - subquery is not working for CSV files HI, this is my query, I am using C# , OleDB, ADO.NET and CSV files. SELECT [GATEWAY],[IPADD], SUM(MOBILE),SUM(NWD), TOTAL FROM [rawdata.csv] where CVDate([START]) >= '7/29/2006' AND CVDate([END]) <= '8/23/2006' AND [GATEWAY] IN (SELECT [GATEWAY] FROM [gateways.csv] WHERE [CLIENT]='MR. XXX') GROUP BY [GATEWAY],[IPADD] ORDER BY [GATEWAY] it returnes no rows. but I have done it in mysql with same data file and same query. it worked. why it's not working ? is there any problem in subquery syntax ? please give me a solve. Tag: downloading from web mail Tag: 132156
  - 19
    - Avoid hardcoding DataKeyField property of DataGrid... Hi, How can I avoid hardcoding the name of the DataKeyField property of a DataGrid ? Like: datagrid.DataSource = someSource; datagrid.DataKeyField = "employeeId"; The above works but it's not what I want, because whenever the name of the field changes, I'm screwed. Avoiding this is the purpose of strongly-typed datasets (or using collections or whatever data layer abstraction mechanism you like) as I understand it, but I'd like to know what you n-tier gurus do in this case ? Thanks, - Jeff Tag: downloading from web mail Tag: 132149
  - 20
    - Can not find SQL Server Management Studio Hello, today I installed the Microsoft SQL Server 2005 Standard Edition but after insatallation I can not find the SQL Server Management Studio (Enterprice manager) Need I to install it separately? Regards, Alfred M. Tag: downloading from web mail Tag: 132139
  - 21
    - Problems with using ODP.NET provider Hello All I'm using this query Select Distinct(prj.Name) as PrjName, prj.oid as PrjOid From SITE61.PRJMGTProjectRoot prj, SITE61.CORERELATIONDEST ic, SITE61.PRJMGTDatabase pd Where prj.oid=ic.oidTarget And ic.oid=pd.oid And pd.oid= :plant_oid and getting a data-reader like this: Dim cmdSQL As New OracleCommand Dim conSQL As New OracleConnection Dim drSQL As OracleDataReader conSQL.ConnectionString = oRequest.ConnSetting conSQL.Open() cmdSQL.Connection = conSQL cmdSQL.CommandText = oRequest.Command cmdSQL.CommandType = oRequest.CommandType cmdSQL.BindByName = True AddParameters(cmdSQL, oRequest.Parameters) 'Add the prm with name plant_oid and 'a RAW value. So far so good 'I then get an exception when I try to do the ExecuteReader 'Invalid parameter binding 'Parameter name: plant_oid return cmdSQL.ExecuteReader(CommandBehavior.CloseConnection) Any ideas what might be wrong here ? thanks Sunit Tag: downloading from web mail Tag: 132136
  - 22
    - Accessing Data Source of SSAS Project from within an SSAS Assembl Hi all, within an SQL Server Analysis Services project we are using an assembly to retrieve dimension permissions based on data stored in a adminstration database. Currently we store the connection string used to access in the administration database within the assembly: Dim locCon As New SqlConnection ... locCon.ConnectionString = "data source=eira; database=ServiceAdmin; Integrated Security=SSPI;" ... Obviously this is not a nice solution. As I understand it is not possible to access a application.config file from a DLL, because the DLL will use the config file belonging to the corresponding application. I wonder if it is not possible to access one of the data sources deployed with the cube from the assembly. somthing like: locCon.ConnectionString = "data source=cubedatasource" with cubedatasource beeing the name of the data source used in the cube Well, it doesn't seem to work that way. Any help is appreciated Thanks bjh Tag: downloading from web mail Tag: 132127
  - 23
    - DataTable Edit Rows I've searched and tried a few of the things I seen but nothing really helped me. I am in visual studio 2003 and using visual c++. I created a table by typing in the data inside the IDE. Inside the load event for the form I added rows to the table ataRow *myRow; myRow = dataTable1->NewRow(); myRow->Item[COL_COMPONENTS] = S"X-Axis"; myRow->Item[COL_UNITS] = S"Inches"; dataTable1->Rows->Add(myRow); myRow = dataTable1->NewRow(); myRow->Item[COL_COMPONENTS] = S"Y-Axis"; myRow->Item[COL_UNITS] = S"Inches"; dataTable1->Rows->Add(myRow); Now I want to edit a row. Change a column that was previously set to a null value. What I have so far is myRow = dataTable1->Rows->Item[rowNum]; myRow->BeginEdit(); myRow->Item[COL_CURRPOS] = tmp; myRow->EndEdit(); dataTable1->AcceptChanges(); Where rowNum = a known index number of the row I want to change, and COL_CURPOS is the column I want to make changes to. tmp is the variable holding the value I want to post to that column of said row. I have tried without the begin/end edit and without the acceptchanges... nothing seems to result in the column on my table being changed? Tag: downloading from web mail Tag: 132125
  - 24
    - Writing a Memo field to an Access DB with OleDB Hello, I have big problem on updating an Access Memo field with OleDb. While the InsertCommand works, then UpdateCommand raises an exception: Syntaxerror in UPDATE-Statement. I tryed various work arounds (the last 3 days) with and without the CommandBuilder with allways the same result. The last attempt was: Public Function WriteMemoToAccess(ByVal Pars As String) As Boolean 'Parameters is the ColumnName of the Access Memo field Dim AccessCommand As New OleDb.OleDbCommand("UPDATE DocH SET Parameters=? WHERE IdNum = 1") Dim QueryParameter As New OleDb.OleDbParameter("@Parameters", _ OleDb.OleDbType.LongVarWChar, Len(Pars), ParameterDirection.Input, True, _ Nothing, Nothing, Nothing, DataRowVersion.Current, Pars) AccessCommand.Parameters.Add(QueryParameter) AccessCommand.Connection = Me.Connection Me.Connection.Open() Try AccessCommand.ExecuteNonQuery() WriteMemoToAccess = True Catch ex As Exception End Try Me.Connection.Close() End Function Is there a way to do this?? Best regards Alfred Malleier (South Tyrol) Tag: downloading from web mail Tag: 132118
  - 25
    - Why Must I Have "SET DATEFORMAT dmy" in Stored Proc? I'm calling a stored proc from C# and the call includes a datetime. The exe can run on machine A or B but the database is on machine C. When I run on machine A I need SET DATEFORMAT dmy in the proc or I get an 'out-of-range datetime value' message. I need to comment this statement out when the call is made from machine B. It seems as though I have a UK locale on machine A and a US locale on machine B and the swapping of days and months causes the error. Is this locale setting per machine possible? If so then how to change it? TIA, jeb. Tag: downloading from web mail Tag: 132116
- Next
  - 1
    - saving datatable as new table in database i am creating a Datatable in memory and would like to save the DataTable as a new table in the database when i am done. How can I do this? thanks m Tag: downloading from web mail Tag: 132112
  - 2
    - dataset safety? Hi, I am currently looking at re-writing a payroll/timesheet application that is currently in Access. The users need to enter timesheet hours for numerous employees. Up till now I have been experimenting and using strongly typed datasets as generated by VS. However as these provide a disconnected model, how can I prevent the loss of user data if the user PC crashes or dies for whatever reason. I imagine it would be inefficient to be performing writes to the database using datasets after every record is inserted. I like the binding and coding efficiency of using strongly typed datasets, however it would seem like there can be big overheads and risk in not updating to the database regularly. Can anyone recommend a better way? thanks Tag: downloading from web mail Tag: 132107
  - 3
    - OCI.DLL: The specified module could not be found + OCIEnvCreate fa In VS2005 (Version 8.0.50727.42), I'm trying to create a "Data Connection" in the "Server Explorer" window ... I right click on "Data Connections" ... and choose "Add Connection" ... In that window, I change the "Data Source" to "Oracle Database" ... Then for "Server Name" I enter "newbisd.world", which corresponds to an entry in my TNSnames.ora file ... and I type in my Username and Password ... Then, when I hit either "OK" or "Test Connection", I get an error box titled "OCI.DLL" that says "The specified module could not be found" ... and after I click "OK" to that, another one comes up saying "OCIEnvCreate failed with return code -1 but error message text was not available." Where do I start? Thanks for any tips / pointers ... other info ... - I'm running Windows 2000 5.00.2195 (SP4) - I'm running Oracle 9.2 ... have upgraded to this - I can connect to the database with Oracle SQL*Plus ... and TOAD - I've read Paul Clement's reply to MikeB from 7/22/2005 and gave Authenticated User privelege to the ORACLE_HOME ... - According to my registry (when viewd by Regedit), in the HKEY_LOCAL_MACHINE folder + SOFTWARE folder + ORACLE folder, the variable ORACLE_HOME = C:\oracle\ora92 (... and I have a similar entry in a subfolder called HOME0) ... and in this folder's "bin" directory, I've got a file named "oci.dll" that's 112KB dated 05/01/2002 8:40pm Tag: downloading from web mail Tag: 132103
  - 4
    - Oracle 10g Float and Double Database Datatypes are not supported Greetings, I have data values that are inherently of type Double. Current we are using Oracle Column Datatype NUMBER. When I create a TableAdapter in VS2005, the database table column information is read from Oracle and a new Table is created. However, the detected datatypes are always Decimal. Even if I change the datatype in the Database to a lower precision that would not exceed the precision of a Double, it is always detected as a Decimal. This forces me to cast everywhere, making the strongly-typed dataset, not as useful. Option 1: Now you might wonder, why not just change the datatype after the table is created. This does in fact work, but if you alter the Select statement later, the table is regenerated and since the datatypes no longer match what was found in the database, new columns are added with a "1" appended to the column name, which wrecks everything. So, I have to delete all the columns first, then make my SQL change, then go back and change all the datatypes back to what I need them to be. This sucks. Option 2: Use the new Oracle 10g BINARY_DOUBLE column datatype. This would be the preferred solution, but Microsoft apparently does not support it. Even though this may be perfectly matched with the precision of a System.Double. Option 3: Microsoft should detect the Precision and Scale of the NUMBER datatype in Oracle and use the appropriate .NET datatype instead of always using Decimal. I believe this is done is other MS products via ODBC, but not here... Question: Is there ANY numeric datatype I can use in Oracle that will be detected by the the MS Oracle Data Provider as a System.Double in the Strongly-Typed representation? I fear this answer is no. If it is, Microsoft should provide a hotfix to allow Option 2 or Option 3 to work. Without one of these solutions, maintenance will be a big pain. Other developers on my team, should be able to go into the Query Builder, check off a new column for the Select statement, and this should just add the new column, but this doesn't work. It makes a mess, and can go almost unnoticed until you build and a list of cast exceptions appears... Hence the big pain. -Valkyrie-MT Tag: downloading from web mail Tag: 132102
  - 5
    - multi threaded database access with transactions I have a program that runs on multiple threads working with database sproc calls... these need to be all ran in transactions.... how can I get something similar to parallel transactions or at least to the point where they dont cause each other to crash? They all work with the same database connection...thanks! Tag: downloading from web mail Tag: 132099
  - 6
    - MySQL database connection Hi, All This is the first time that I code asp.net against mySQL database. I am confused that which connector should I use 'cause I do not want make the wrong choice and have some problems later on? one is from mySQL official website http://www.mysql.com/products/connector/net/ or ODBC/OleDB driver come with MS .Net? Any experience can share with? Thanks a lot -rockdale Tag: downloading from web mail Tag: 132093
  - 7
    - Global Cancel I want to create a single Cancel method to cancel all changes made to any fields in a UserControl. I have a method that creates a Binding object, adds it to a collection and than adds the Binding to the control. textBox1.DataBindings.Add(CreateDataBinding("Text", myobject, "Caption") ); public void Cancel() { foreach (Binding b in this.Bindings) b.BindingManagerBase.CancelCurrentEdit(); // This never changes the value back } Is there anyway to create something like I want? Thanks, Joe Tag: downloading from web mail Tag: 132089
  - 8
    - Retrieving database schema Hi Everyone: Iâ??m new to the VB.NET development platform, and Iâ??m trying to understand how to retrieve database schema information from either of these databases: Microsoft Access, Microsoft SQL Server 2000, or Oracle. I recently bought a reference book titled â??Beginning VB.NET Databasesâ?? by Thearon Willis from WROX press. From this book I have found a way to dynamically connect to any database and check to see if the connection was successful. What I would like to do is once the connection to the database is established, show a list of the tables contained in the selected database. If the user needs to add data to a specific table he would select the table he needs to add the data too and the application would create a datasheet with the columns (Fields) of the database shown in the order they where created in the table. I would also like to label the primary key of the table and any foreign keys that table references. Iâ??m having difficulty in finding examples of these types of operations. Can anyone show me where to go to find this information. Thank you, -- Mark Tag: downloading from web mail Tag: 132088
  - 9
    - Count rows in dataset WHERE ... Hi, I am attempting to do a number of count functions on a single table of data for presentation in an ASP webpage. The functions are number today, number this week, number this month etc. As the Database table is large it does not make sense to query it directly a number of times. My idea is to create a dataset containing the table "ApplicationForms". I then want to query this and perform the various count functions. If I were querying the database the query would be: SELECT COUNT(DISTINCT fkiBatchNumber) AS 'YearCount' FROM tblApplicationForms WHERE (dtDateScanned < dtYear) dtToday is a datetime predefined in C# code. I have no idea how to query the dataset in an equivilent manner. Is this the most suitable method of acheiving my requirement? If so, any help in doing so is much appreciated. Thanks. Tag: downloading from web mail Tag: 132081
  - 10
    - Oracle TransactionScope Rollback issue I am having problems re-openning closed Oracle connections (System.Data.OracleClient.OracleConnection) when using TransactionScope and using the Rollback feature (i.e. not calling Complete on TransactionScope). I create a simple for loop with a TransactionScope statement inside. All that happens inside the TransactionScope section is an open and close of an OracleConnection object, and no call to Complete on the TransactionScope object (Rollback). The second iteration or the loop will hang when calling Open on the OracleConnection object. If you include the Complete call on the TransactionScope, it will work fine. If you exclude TransactionScope, it will work fine. If you step through the code, it will work fine. If you put a System.Threading.Thread.Sleep(50) statement at the beginning of the loop, it will work fine. I thought it might be a disposing/garbage collection issue, so I tried putting GC.Collect at the start of the loop, but that didn't work. If I use Oracle's provider, it will work fine (Oracle.DataAccess.Client). If you leave the connection open when iterating through the loop, it appears to work fine. I have the 9.2.00.54 Oracle client installed. I have some sample code listed below. We would really like to use the System.Data.OracleClient as opposed to the Oracle.DataAccess.Client. So, any suggestions would be greatly appreciated. Thanks. using System; using System.Collections.Generic; using System.Text; using System.Transactions; using System.Data.OracleClient; //using Oracle.DataAccess.Client; using System.Data; namespace ConsoleApplication2 { class Program { const string DATASOURCE = "Data Source=test_db;User Id=sam;Password=sam;"; static OracleConnection cn; static int i; static void Main(string[] args) { cn = new OracleConnection(DATASOURCE); for (i = 0; i < 100; i++) { TransactionScopeTest(); //TransactionScopeCompleteTest(); //TransactionScopeTestWithSleep(); //ConnectionTest(); } Console.ReadLine(); } static void TransactionScopeTest() { using (TransactionScope ts = new TransactionScope()) { OpenClose(); } } static void TransactionScopeCompleteTest() { using (TransactionScope ts = new TransactionScope()) { OpenClose(); ts.Complete(); } } static void ConnectionTest() { OpenClose(); } static void TransactionScopeTestWithSleep() { using (TransactionScope ts = new TransactionScope()) { System.Threading.Thread.Sleep(50); OpenClose(); } } static void OpenClose() { if (cn.State != ConnectionState.Open) { Console.WriteLine("ConnectionState: " + cn.State.ToString() + "; openning " + i.ToString()); cn.Open(); Console.WriteLine("ConnectionState: " + cn.State.ToString() + "; openned " + i.ToString()); } if (cn.State != ConnectionState.Closed) { Console.WriteLine("ConnectionState is " + cn.State.ToString() + "; closing " + i.ToString()); cn.Close(); } Console.WriteLine("ConnectionState is " + cn.State.ToString() + " " + i.ToString()); } } } Tag: downloading from web mail Tag: 132078
  - 11
    - dataset - Insert-query with stored procedure using wizard Hi all, I don't know where to publish this question but hope this newsgroup is okey. I'm working in Visual Studio 2005 and are now creating a dataset file where I will do all the transactions with the database. I have a consumer table where I want to insert, update and delete consumers. In the database I use uniqueidentifier on the primary key and said that it is a rowGuid - (newid()). When I try to generate a stored procedure to insert new consumers I have to insert without adding the primary key because it is automatically generated on a new insertion. However when using the wizard to generate the stored procedure the wizard fails when I remove the primary key. After the insert query the wizard created a select query with a where - clause like the primary key variable. (uidConsumerID = @uidConsumerID). Here I changed to SCOPE_IDENTITY( ) instead to get the databaserow from the current scope. But this fails. So what's wrong? What is the best way to make an insertion to a row using RowGuid on the primary key? Until further I will try to create the sp manually in the database and force dotnet to use my own stored procedure. In advance thanks a lot for your help! Kind regards, Jon Haakon Tag: downloading from web mail Tag: 132069
  - 12
    - Newbie needs help Hi everyone, I'd like to access a database using C#. I've installed the Visual Studio 2003 and mysql essential and mysql administrator. On Visual Studio I go on server view and right click on SQL Servers, then I click on Register SQL Server Instance. It will prompt me to enter the instance name and login information but I'm getting this error - [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. I'm sure that my username and password are correct. The only thing I'm not sure of is the instance name? Is the instance name the same as service name - such as MySQL in Services? Any help? Thanks, Clayton Tag: downloading from web mail Tag: 132068
  - 13
    - Keyword similar to App(VB6.0) in VB.NET Hello all, Can anyone here suggest me the keyword App similar to that in VB.NET? Iam developing a application which uses MS-Access as the database. In vb6.0 I use App to find the path and connect to the database example: dbname = App.Path & "\XXXXXX.mdb" Could anyone here please suggest me a way similar to that of App I know how to connect to database. example dbname = "C:\Temp\xxxxx.mdb" con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbname & ";Persist Security Info=False") Thanks in advance Jack Tag: downloading from web mail Tag: 132065
  - 14
    - OleDb vs. Sql Interoperability I'm building a lot of ASPX pages and business objects that consume and interact with database data. Some of this is done with data-binding, some is done with programmatic calls to Stored Procedures, Views, etc. I've created a DB class that I use to simplify and make consistent my inteaction with the database, and for all of the aspects of connecting to the database, building the call (query, Stored Procedure, Stored Procedure with Parameters, etc.) that works just fine. But here's my problem: Data that is returned comes back in objects like XXDataReader (OleDbDataReader or SqlDataReader). If I use one of these in my .aspx Pages, it means I've committed to using either OleDb for my database access of SqlClient for my database access. What if I don't want to have to decide? What if I want to set things up so that, if I want to switch from a SqlServer to some other database backend, I can just change my DB class, but not have to touch all of my pages and other objects? What's the most elegant and prefered way to do this? I know that I *could* just use OleDb for everything (including SqlServer), but that seems like such a shame in that I understand that the SqlClient access for SqlServer is supposed to be *way* more efficient. Alex Tag: downloading from web mail Tag: 132054
  - 15
    - Strange error message I am inserting a new record into a table which has 4 columns, the first being an identity column. I am adding three strings to the other 3 columns using an ExecuteNonQuery. I have set the values of the parameters for the InsertCommand. The error I am getting is that the Input is not in the correct format for SqlCommand.ExecuteReader(CommandBehaviour cmdBehaviour, RunBehaviour runBehavious, Boolean returnStream) My SelectCommand insert the three values and returns all 4, including the Identity column. My command is: this.sqlInsertCommand1.CommandText = "INSERT INTO Customers(CustName, CustAddress, CustPhone) VALUES (@CustName, @CustAddress, @CustPhone); SELECT CustID, CustName, CustAddress, CustPhone FROM Customers WHERE (CustID = @@IDENTITY)"; The only parameter I had to create was the @CustID parameter and it is the same type and size as the CustID column in the table I created. Can anyone suggest why I am getting this error? Tag: downloading from web mail Tag: 132053
  - 16
    - Insert Date into SQL c# - Correct Format Hallo guys, I am getting bonkers (sorry). i have sql2005express/c#. I have calender and i get the dates right DateTime DeployDate = Convert.ToDateTime(Calendar1.SelectedDate); i tried putting the deployed date as a string and having Calendar1.SelectedDate.Convert.ToString as well after this i have a insert string which is giving me all i need..... String getSYS4Table = "SELECT DISTINCT gdsSITE.SiteID, gdsSITE.SitePriority, gdsSITE.SiteGroup AS SITEGROUPS, gdsSITE.TimeID, gdsSITE.ZoneID, gdsSITE.Hours, gdsSITE.SystemID, gdsAssignedGuardSYS4.ForceNumber, gdsAssignedGuardSYS4.Nationality, gdsAssignedGuardSYS4.PriorityID, gdsAssignedGuardSYS4.FullName, gdsAssignedGuardSYS4.SiteGroup FROM gdsSITE INNER JOIN gdsAssignedGuardSYS4 ON gdsSITE.SiteGroup = gdsAssignedGuardSYS4.SiteGroup"; all is fine! thats right. mys string works though until the dates is 12. because in mys sql serever i can seach and get dates. WHERE DeployDate='19/08/2006' it refuses so i need to change the date to be yyyyMMdd but i have been looking and trying and failing on this part. i need to enter the DeployDate as yyyyMMdd only that. can someone help me before the doctors come and collect because iam going nuts. thanks in advance Tag: downloading from web mail Tag: 132051
  - 17
    - Databinding a check list box Hi I have a check box list box on a windows form. How can I data bind it to an access table. I don't need a multi-tier solution. Just a solution. Thanks Regards Tag: downloading from web mail Tag: 132045
  - 18
    - Need some help on forms Hey, YO...., I NEED SOME HELP HERE ! Actually, I got some info from a good guy called ScottT, but I need more. You see, I'm kind of stuck in here. I need to connect two forms. But the problem is... I don't know the codes. What I wanna do is click a button from the first form to go to the second form & then click a button from the second form to go to the third form & then etc etc. Also I wanna have a certain form which connected to all the other forms & can click a button from that certain form to go to all the other forms. That's all. Why can't anybody just help me ? I'm a newcomer to the field & I need help so ...so ...much. Tag: downloading from web mail Tag: 132040
  - 19
    - StoredProc commits results in QueryAnalyzer but not in ADO.NET I'm hoping someone can help! I have a stored procedure in an MSDE database. When I use Query Analyser to run this stored procedure the correct results appear in the database. My stored procedure returns resultCode. The stored procedure includes a single BEGIN TRANSACTION [...] COMMIT TRANSACTION Within my application, I execute the follow code I recieve the correct result code but the information is NOT updated in teh database. I have tried with and without ADO transactions. public int CreateFrame(string BRKEY, string INSPKEY, string USERKEY) { //System.Data.OleDb.OleDbTransaction frameTransaction; int returnValue = 0; _command.Parameters["@brkey"].Value = BRKEY; _command.Parameters["@userkey"].Value = USERKEY; _command.Parameters["@inspkey"].Value = INSPKEY; try { if (_command.Connection.State == System.Data.ConnectionState.Closed) _command.Connection.Open(); } catch (Exception ex) { System.Diagnostics.Trace.WriteLine(ex.Message); returnValue=-99; } if (returnValue !=0) return(returnValue); //frameTransaction = _command.Connection.BeginTransaction(); //_command.Transaction = frameTransaction; try { _reader =_command.ExecuteReader(); _reader.Close(); returnValue = (int)_command.Parameters["@returnCode"].Value; //frameTransaction.Commit(); _command.Connection.Close(); _command.Dispose(); } catch (Exception exception) { //frameTransaction.Rollback(); System.Diagnostics.Trace.WriteLine(exception.Message); returnValue=-99; } finally { if (_command != null) _command.Dispose(); } return(returnValue); } my parameters and my command and connection objects are created in the initializer to my class My users begin testing in 2 days and I'd like to have this functionality working. HELP! 8-) Tag: downloading from web mail Tag: 132039
  - 20
    - CSV header conating "." dot and after loading it into dataset its converting into "#" CSV header conating "." dot and after loading it into dataset its converting into "#" LIKE. First.Name First # Name waiting for your reply Tag: downloading from web mail Tag: 132037
  - 21
    - How to know the first sheet name of an Excel I use the codes below to import the first sheet of an Excel file into a DataSet. But if the name of the first sheet is not "Sheet1", the SelectCommand will fail. How can I know the sheet name of the first Sheet in an Excel file? string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + savePath + "; Extended Properties=" + (char)34 + "Excel 8.0;IMEX=1;" + (char)34; string sSelect = "SELECT * FROM [Sheet1$]"; OleDbConnection objConn = new OleDbConnection(sConnectionString); objConn.Open(); OleDbCommand objCmdSelect = new OleDbCommand(sSelect, objConn); OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(); objAdapter1.SelectCommand = objCmdSelect; objAdapter1.Fill(ds, "XLData"); objConn.Close(); Tag: downloading from web mail Tag: 132034
  - 22
    - How to determinate if a string in the Field names of a dataTable? Hi, I have a dataTable with some fields. How can I determinate if a string in the Field names of a dataTable? Tag: downloading from web mail Tag: 132032
  - 23
    - Using Oracle.ClientAccess.Data with System.Data.Common I am trying to return a datatable using the Oracle driver. In order to return a dataset from the stored proc I need a cursor type to receive the data. How is this possible with the Common namespace since it does not have a cursor or refcursor type? John Tag: downloading from web mail Tag: 132029
  - 24
    - Trying to restore a .bak in C# Can I run a SQL command like: RESTORE DATABASE NewDB FROM DISK = 'ApplicationStartupPath\SQLSE2005\DevDB.bak' WITH RECOVERY, MOVE 'DevDB_Data' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\NewEB_Data.mdf', MOVE 'DevDB_Log' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\NewDB_Log.ldf' while connected to the master db installed by default in SQLSE 2005? If not how the heck do I run this command to restore this db for the client when they install the app? Tag: downloading from web mail Tag: 132024
  - 25
    - SqlTypes Decimal Hi, I'm using .Net Framework 2.0. I Querying an Sql 2000 Database to fill a Dataset, the user dynamically choses what tables to query to fill the dataset. I need to provide information to the user about the tables, information such as the type and size of the columns. Though at start this seemed to be quite simple to do, I have now came to a problem when working with decimal columns. how can I get the number of digits that a decimal column suports? I have tried using sqlTypes when filling the table but not have been able to get this info. Can SomeBody Help me Please. Carlos Pedro Tag: downloading from web mail Tag: 132022

Hi,
I have one problem . we have implemented overriding of IDownloadManager
of Internet explorer. it was working fine. If we give any files which have
direct hyperlink i.e from geocities or like ... . But what's the problem i
am facing is it was not downloading attatchement files from yahoo mail. any
one help. The code of Same way or differently implemented downloading of
attatchments from yahoo or any suggestions will be given is very help ful.
Thanks in advance.

Top