Oracle connection via an IP Address

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
    - Switch to GUIDs - changing the way I code? When using Integer as PK, I would often have functions that would return the Integer when searching for a specific row in a datatable. I am trying to switch to GUID. Before, if the function returned a zero, I would assume the PK didn't exist. Now, if I make a call to lookup the GUID, and that row doesn't exist yet, I can't seem to figure out the simplest way - without doing a redundant function to check if exists first - causing two loops. Simple Example of my Integer based Code: Table1 - TableID(Int), Description(Nvarchar) Private Function GetTableIDByDescription(sDescription as String) as Integer Private iID as integer = 0 For each row If Description = sDescription Then iID = Row.TableID Return iID Private i as integer = GetTableIDByDescription(id) If i = 0 then ' New Record - insert Else ' Use the ID With GUID?: Table1 - TableID(GUID), Description(Nvarchar) Private Function GetTableIDByDescription(sDescription as String) as GUID Private iID as New Guid ' ?? For each row If Description = sDescription Then iID = Row.TableID Return iID Now, without two functions (one for Exists, one for GetID), is there a way that I can rewrite all these code sections? Masa Tag: Oracle connection via an IP Address Tag: 92693
  - 2
    - Binding a datareader to a grid Is there a Winforms grid to which I can readily bind a datareader (purely for read-only visualisation of the datareader data and using the 1.1 framework)? Or is this in some way not regarded as a legitimate use for the datareader? JGD Tag: Oracle connection via an IP Address Tag: 92683
  - 3
    - xml and csv with ado.net Hello everybody out there, I got a problem with a db-format, the metadata is written in XML (such things like tables names, paths, fieldnames and delimiter etc.), the data is written in .csv-files. How can I put this two thinmgs together in one dataset? Thanx Lars Tag: Oracle connection via an IP Address Tag: 92677
  - 4
    - FillDataset only fills the first two tables. All, I have a typed dataset DS contains 4 tables (say TA, TB, TC,TD). I have one stored procedure contains 4 select (no relationship) SELECT * FROM TA SELECT * FROM TB SELECT * FROM TC SELECT * FROM TD I use MS Application block FillDataset as follow DS ds= new DS(); sp = "sp_SelectFour"; string[] tables = {"TA", "TB", "TC", "TD" }; SqlHelper.FillDataset(connString, CommandType.StoredProcedure, sp, ds, tables); but i only see TA and TB are filled with data. I checked sp using SQL Query Analyzer, it does return 4 result sets. To make sure I can get TC and TD filled: I change sp to only select TC and TD. and change tables = {"TC", "TD"}; I am able to fill TC and TB. So, Is there a limit that only two result sets can be fetched at a time? TIA. John Tag: Oracle connection via an IP Address Tag: 92668
  - 5
    - Can't find primary key I have a dataset that I first do a FillSchema(dataset, SchemaType.Mapped, "Table") on, and yet it still throws System.Data.MissingPrimaryKeyException when I do a dataset.tables("Table").Rows.Find(key). The column is marked as a primary key in the table and the sql statement is just "SELECT * FROM tableName" Anybody have any idea why this can happen? P.S. Sorry if I didn't give enough info, but I am patching together someone else's mess, so I haven't gotten a chance to read it all yet. -Thanks Tag: Oracle connection via an IP Address Tag: 92662
  - 6
    - How to merge two DataView objects Hi, I have two DataView objects sharing the same DataTable. I want to merge these two. Ideally the DataView class would have a Merge(DataView dv) method, but it doesn't. Does anyone know how to do this? Here is what Im trying to accomplish. Say I am using the Northwind database and I want to display 2 DataGrids, one representing the Customer table and one for OrderDetails table. Everytime I select a customer in the Customers table I would like to show all the order details in the Orders table for all the orders for that customer. So say the DataRowView representing the customer is customerDataRowView, then I will get all the children in the Orders table for that customer by ordersDataView = customerDataRowView.CreateChildView(CustomerToOrdersDataRelation); Then I want to say: orderDetailsDataView = new DataView(); foreach(DataRowView drv in ordersDataView.Rows) { DataView dv = drv.CreateChildView(OrdersToOrderDetailsDataRelation); orderDetailsDataView.Merge(dv); } Thanks in advance for all your help. Nima Tag: Oracle connection via an IP Address Tag: 92661
  - 7
    - Inserting string into SQL Server image column I have a stored procedure in SQL Server that inserts a row into a table. One of the columns of the table has the "image" data type, which maps to a byte array in ADO SqlClient. The problem I have is that the data that I'm adding as a parameter when calling the stored procedure comes from a TextBox on the web page, which is of type string. As a result, I keep getting errors because it can't convert a string to a byte array. I cannot seem to find any kind of method that would do that for me. Does anyone know what would be the correct procedure to pass data for inserting into a column of type image, when the data is coming as a string from a text box? Or, if nothing else, how could I convert a string to a byte array? Thanks Tag: Oracle connection via an IP Address Tag: 92660
  - 8
    - Problem with DatatableMapping I have a number of tables in my dataset and each is mapped as follows With mSQLDA .TableMappings.Add("tblClassificationResource", "tblClassificationResource") .TableMappings.Add("tblResourceProperty", "tblResourceProperty") End With but when i set the insert/update and delete commands for the dataadapter and run an update nothing happens, unless i clear the tablemapings and add a new one as follows mSQLDA.TableMappings.Clear() mSQLDA.TableMappings.Add("Table", "tblResourceProperty") then the update works Can someone please explain what i'm missing here? Thanks John Tag: Oracle connection via an IP Address Tag: 92653
  - 9
    - No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D)??? I have recieved this error message when trying to open a connection to an access database. What I don't understand is why earlier in the submit_click method the connection opened properly, yet in the loadTable method it throws the error "No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D)". I have included my code to help visualize what I am tryin to to. using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.OleDb; namespace dynamicAccess { /// <summary> /// Summary description for WebForm1. /// </summary> public class WebForm1 : System.Web.UI.Page { //declares the object that are in the web application protected System.Data.OleDb.OleDbCommand oleDbCommand1; protected System.Web.UI.WebControls.Button Submit; protected System.Data.OleDb.OleDbConnection myConnection; protected System.Web.UI.WebControls.Button LoadTable; protected System.Web.UI.WebControls.DropDownList DropDownList; protected System.Web.UI.HtmlControls.HtmlInputFile File1; protected System.Web.UI.WebControls.DataGrid DataGrid1; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.myConnection = new System.Data.OleDb.OleDbConnection(); this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand(); this.Submit.Click += new System.EventHandler(this.Submit_Click); this.LoadTable.Click += new System.EventHandler(this.LoadTable_Click); // // myConnection // this.myConnection.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Mode=Share Deny None;Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"; this.Load += new System.EventHandler(this.Page_Load); // // oleDbCommand1 // this.oleDbCommand1.CommandText = "SELECT * FROM"; this.oleDbCommand1.Connection = this.myConnection; } #endregion /* after the user finds the database they wish to open they must hit the submit button to * populate the dropdownlist. The Submit_Click populates the drop down list and updates * the command text.*/ private void Submit_Click(object sender, System.EventArgs e) { myConnection.ConnectionString += ";Data Source=" + File1.PostedFile.FileName; myConnection.Open(); DataTable schemaTable = myConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null,null,null,"TABLE"}); myConnection.Close(); DropDownList.DataSource=schemaTable; DropDownList.DataTextField = "TABLE_NAME"; DropDownList.DataValueField = "TABLE_NAME"; DropDownList.SelectedIndex = DropDownList.SelectedIndex; DropDownList.DataBind(); DropDownList.Items.Insert(0, new ListItem("Select a Table")); DropDownList.SelectedIndex = 0; oleDbCommand1.CommandText += " " + DropDownList.SelectedItem.Text; } /* This event fills the data grid so that the user can see the contents of the table selected. * At this time I am recieving an error when trying to open the connection. * (No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D))*/ private void LoadTable_Click(object sender, System.EventArgs e) { myConnection.Open(); System.Data.OleDb.OleDbDataReader Reader; Reader = oleDbCommand1.ExecuteReader(); DataGrid1.DataSource = Reader; DataGrid1.DataBind(); Reader.Close(); myConnection.Close(); } } } Tag: Oracle connection via an IP Address Tag: 92646
  - 10
    - Help with SqlDataAdapter Update command (C#) This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C470C1.0AB15790 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am pulling my hair out over this one. I have done this same kind of = thing in VB.Net but in C# it doesn't work. I dont' receive any errors = either, it just won't update the pubs.Authors table. Here is the code: private void CodedDataGrid_Load(object sender, System.EventArgs e) { //create a new connection object String ConnectString =3D "Server=3D" + "MyMachine" + "; " + "User ID=3D" = + "sa" + "; Password=3D" + "password" + "; initial catalog =3D " + = "pubs" + ";"; conn =3D new SqlConnection(ConnectString); //create a new adapter adp =3D new SqlDataAdapter("Select au_id,au_lname,au_fname,contract FROM = authors",conn); //creat ea new dataset ds =3D new DataSet(); adp.Fill(ds); this.dbGrid.DataSource =3D ds; } private void btnNew_Click(object sender, System.EventArgs e) { AdapterInsert(); =20 //add a new record to the dataset, but first try { adp.Update(ds,"Table"); } catch (System.Data.SqlClient.SqlException sqlEx) { MessageBox.Show(sqlEx.Message); } catch(System.Exception ex) { MessageBox.Show(ex.Message); } } private void AdapterInsert() { insComm =3D new SqlCommand(); adp.InsertCommand =3D insComm; adp.InsertCommand.Connection =3D conn; adp.InsertCommand.CommandType =3D=20 CommandType.StoredProcedure; adp.InsertCommand.CommandText =3D "InsertAuthor"; SqlParameter MySqlParam1 =3D new = SqlParameter("@au_id",SqlDbType.VarChar); MySqlParam1.Value =3D this.txtID.Text; MySqlParam1.SourceColumn =3D "au_id"; adp.InsertCommand.Parameters.Add(MySqlParam1); SqlParameter MySqlParam2 =3D new = SqlParameter("@au_fname",SqlDbType.VarChar); MySqlParam2.Value =3D this.txtFName.Text; MySqlParam2.SourceColumn =3D "au_fname"; adp.InsertCommand.Parameters.Add(MySqlParam2); SqlParameter MySqlParam3 =3D new = SqlParameter("@au_lname",SqlDbType.VarChar); MySqlParam3.Value =3D this.txtLName.Text; MySqlParam3.SourceColumn =3D "au_lname"; adp.InsertCommand.Parameters.Add(MySqlParam3); SqlParameter MySqlParam4 =3D new = SqlParameter("@contract",SqlDbType.Bit); MySqlParam4.Value =3D "1"; MySqlParam4.SourceColumn =3D "contract"; adp.InsertCommand.Parameters.Add(MySqlParam4); } What the heck am I missing here? Thanks. =20 ------=_NextPart_000_000A_01C470C1.0AB15790 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.2900.2162" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>I am pulling my hair out over this one. = I have done=20 this same kind of thing in VB.Net but in C# it doesn't work. I dont' = receive any=20 errors either, it just won't update the pubs.Authors table. Here is the=20 code:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>private void CodedDataGrid_Load(object = sender,=20 System.EventArgs e)<BR>  {<BR>  //create a new = connection=20 object<BR></FONT><FONT face=3DArial size=3D2>String ConnectString =3D = "Server=3D" +=20 "MyMachine" + "; " + </FONT><FONT face=3DArial size=3D2>"User ID=3D" + = "sa" + ";=20 Password=3D" + "password" + </FONT><FONT face=3DArial size=3D2>"; = initial catalog =3D "=20 + "pubs" + ";";<BR></FONT><FONT face=3DArial size=3D2>conn =3D new=20 SqlConnection(ConnectString);</FONT><FONT face=3DArial=20 size=3D2>   //create a new adapter<BR>adp =3D new=20 SqlDataAdapter("Select </FONT><FONT face=3DArial=20 size=3D2>au_id,au_lname,au_fname,contract FROM = authors",conn);<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2>   //creat ea new=20 dataset<BR>   ds =3D new=20 DataSet();<BR>   adp.Fill(ds);<BR>   this.d= bGrid.DataSource=20 =3D ds;</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>   }</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>  private void = btnNew_Click(object=20 sender, System.EventArgs=20 e)<BR>  {<BR>   AdapterInsert();</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial = size=3D2>   <BR>   //add a new=20 record to the dataset, but first</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial=20 size=3D2>   try<BR>   {<BR>  &nbs= p; adp.Update(ds,"Table");<BR>   }<BR>  &nb= sp;catch=20 (System.Data.SqlClient.SqlException=20 sqlEx)<BR>   {<BR>    MessageBox.Show(= sqlEx.Message);<BR>   }<BR>   catch(System.= Exception=20 ex)<BR>   {<BR>    MessageBox.Show(ex.= Message);<BR>   }</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>  }<BR>  private = void=20 AdapterInsert()<BR>  {<BR>   insComm =3D new=20 SqlCommand();<BR>   adp.InsertCommand =3D=20 insComm;<BR>   adp.InsertCommand.Connection =3D = conn;</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial = size=3D2>   adp.InsertCommand.CommandType =3D=20 </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial=20 size=3D2>CommandType.StoredProcedure;<BR>   adp.InsertComm= and.CommandText=20 =3D "InsertAuthor";</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>   SqlParameter = MySqlParam1 =3D new=20 </FONT><FONT face=3DArial=20 size=3D2>SqlParameter("@au_id",SqlDbType.VarChar);<BR>   M= ySqlParam1.Value=20 =3D this.txtID.Text;<BR>   MySqlParam1.SourceColumn =3D=20 "au_id";<BR>   adp.InsertCommand.Parameters.Add(MySqlParam= 1);</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>   SqlParameter = MySqlParam2 =3D new=20 </FONT><FONT face=3DArial=20 size=3D2>SqlParameter("@au_fname",SqlDbType.VarChar);<BR>  &nbs= p;MySqlParam2.Value=20 =3D this.txtFName.Text;<BR>   MySqlParam2.SourceColumn = =3D=20 "au_fname";<BR>   adp.InsertCommand.Parameters.Add(MySqlPa= ram2);</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>   SqlParameter = MySqlParam3 =3D new=20 </FONT><FONT face=3DArial=20 size=3D2>SqlParameter("@au_lname",SqlDbType.VarChar);<BR>  &nbs= p;MySqlParam3.Value=20 =3D this.txtLName.Text;<BR>   MySqlParam3.SourceColumn = =3D=20 "au_lname";<BR>   adp.InsertCommand.Parameters.Add(MySqlPa= ram3);</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>   SqlParameter = MySqlParam4 =3D new=20 </FONT><FONT face=3DArial=20 size=3D2>SqlParameter("@contract",SqlDbType.Bit);<BR>   My= SqlParam4.Value=20 =3D "1";<BR>   MySqlParam4.SourceColumn =3D=20 "contract";<BR>   adp.InsertCommand.Parameters.Add(MySqlPa= ram4);</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>}<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2>What the heck am I missing = here?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2> </DIV></FONT> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_000A_01C470C1.0AB15790-- Tag: Oracle connection via an IP Address Tag: 92645
  - 11
    - can u set a SQL table constraint from within VS.NET? Hi I have an table on an SQL server and need to set a constraint like do not allow an insertion of a record of the first field (a varchar) matches any of the existing records. Just wondering if this can be done from within .NET? I think it can be done from the enterprise manager tool but not sure. Thanks. -- Paul G Software engineer. Tag: Oracle connection via an IP Address Tag: 92642
  - 12
    - Data adapter UPDATE command not working I'm trying to either modify or insert new records in a database with the code listed below. I tried adding the RowUpdating and RowUpdated events and put breakpoints there, but it never gets there. I'm not sure why. I've checked the dataset and it gets modified after the LoadDataRow command executes. Any help would be appreciated. Thanks, John --------------- code snippet from the btnSave_Click event ------------- object[] objRow = new object[7]; if (mode != "NewRecord") {objRow[0] = lblOrganizationID.Text;} objRow[1] = txtOrganization.Text; objRow[2] = txtAbbreviation.Text; objRow[3] = cboParent.SelectedValue; objRow[4] = cboHierarchy.SelectedValue; objRow[5] = cboSector.SelectedValue; objRow[6] = cboIndustry.SelectedValue; DataRow rowUpdate; dsOrganizations1.Tables["Organizations"].BeginLoadData(); rowUpdate = dsOrganizations1.Tables["Organizations"].LoadDataRow(objRow,true); dsOrganizations1.Tables["Organizations"].EndLoadData(); this.daOrganizations.Update(dsOrganizations1,"Organizations"); Tag: Oracle connection via an IP Address Tag: 92635
  - 13
    - ERROR: ORA-00162: external dbid length 17 is greater than maximum (16) QUESTION: I am receiving this error when I open a connection " ORA-00162: external dbid length 17 is greater than maximum (16) " What is wrong? ANSWER: If you are using System.OracleClient.dll version 1.0.5000.0, you can modify your TNSNAMES.ORA and make alias shorter. TNSNAMES.ora is in oralcle/network/admin directory. For example: tnsnames.ora file has... short122.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 133.231.113.280) (PORT = 1521) ) (CONNECT_DATA = (SID = ORAQ38) ) ) NOTE: If you are using the System.OracleClient.dll version 1.0.3300.0, you don't get this problem. EXAMPLE: In .NET Winforms, populate the datagrid upon button1 click. private void button1_Click(object sender, System.EventArgs e) { Cursor.Current = Cursors.WaitCursor; OracleConnection objOraConn = new OracleConnection("user id=yourid;data source=\"short122.world\";password=password"); objOraConn.Open(); string commandString = " SELECT * FROM A_MYTABLE" ; OracleCommand cmd = objOraConn.CreateCommand(); cmd.CommandText = commandString; cmd.Prepare(); OracleDataAdapter da = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); objOraConn.Close(); // Execute the statement dataGrid1.DataSource = ds.Tables[0].DefaultView; Cursor.Current = Cursors.Default; } Tag: Oracle connection via an IP Address Tag: 92634
  - 14
    - Can't get value from DataSet without explicity type casting? Hey guys, got a question! I've got a DataSet/DataTable, created by using a DataAdapter.Fill call. I'm writing a C# class that handles all the ADO.NET work I need, and a different class will call the public methods of this class. So; I've created the two public fields I need- Public String _custId and Public DateTime _orderDate. But, I can't get the values out of the DataSet/DataTable/DataColumn without doing (in my mind) useless casting! For instance, this doesn't work: _custID = dsOrders.Tables["tblOrd"].Rows[iCurrentRow][0]; I get the message "Cannot implicitly convert type 'object' to 'string' ". To make it work, I have to do: _custID = (String)dsOrders.Tables["tblOrd"].Rows[iCurrentRow][0]; ....or.... _custID = dsOrders.Tables["tblOrd"].Rows[iCurrentRow][0].ToString(); I'm confused as to why? The following line displays "System.String": Console.WriteLine(dsOrders.Tables["tblOrd"].Rows[iCurrentRow].Table.Columns[ 0].DataType); So, shouldn't that mean that I don't have to do anything else? Why do I need to use (String) or .ToString() ? And I also can't get the DateTime into a variable. Trying _orderDate = dsHousing.Tables["tblOrd"].Rows[iCurrentRow][1]; gives me "Cannot implicitly convert type 'object' to 'System.DateTime' ". And, again, if I display the value for Columns[1].DataType, it shows me "System.DateTime". Worse, there's no ".ToDateTime()" method of the Column object, so the only way I can get the DateTime field out is to cast it to a string, and then convert it back to a DateTime. Compared to my problem with the String column, I'm doing twice the un-necessary work just to get the DateTime column! Is this really what's supposed to happen? If the DataType shows string, why do I need to perform an explicit conversion from object to string? It seems like I'm doing un-necessary work; if the value is stored as a certain datatype, I should be able to pull it out of the DataTable and put it into a variable of the same type. I even toyed with the idea of .NET assuming I wanted the DataColumn being put into a String- but I can't find a property of DataColumn that just gives me the value. In classic ADO, there was a Field object, which had a Value property. I can understand "DataColumn" being an object, but is there a specific property for pulling the value out of DataColumn? For instance, if those code samples I just gave would be in classic ADO, I would be trying to say _CustID = rs.Fields(x).Value. Oh I'm using VS 2003.NET EA, with WinXP, .NET 1.1, and have "Using System.Data" and "Using System.Data.OracleClient" at the top of my C# class definition. At first I thought this might be Oracle related, but DataSet/DataTable/DataColumn is part of the System.Data namespace. Thanks! -Thomas Tag: Oracle connection via an IP Address Tag: 92627
  - 15
    - Creating a DataRelation Hi, Creating a DataRelation among two tables seems to be pretty simple (according to ADO.NET Core Reference). However, I'm not sure of the best time to create it. Is it better to create the DataRelation between the tables after the tables have been filled, or is it better to create ForeignKeyConstraints when creating the columns of each table? Roshawn Tag: Oracle connection via an IP Address Tag: 92621
  - 16
    - Re: Microsoft Data Access Block for .NET and the "like" statement I am a little confused by your response. In your example you show a select based on the CustomerID, in this case "ALFKI." I don't see how this would produce a 'like' statement. In this case there is only one customer in Northwind..Customers whose id is like 'ALFKI%'. To use a specific example from the Customer table I would like to create a query similar to: select * from Northwind..Customers where ContactName like 'Maria%' Paul =?Utf-8?B?RGF2dWQgQnJuY2g=?= wrote: > Yes here is a sample: > System.Data.SqlClient.SqlParameter[] parms = new System.Data.SqlClient.SqlParameter [1]; > DataSet ds; > parms[0] = new SqlParameter( "@CustomerID","ALFKI"); > ds = SqlHelper.ExecuteDataset(ConnectionString,CommandType.Text,"Select * >From Customers where CustomerID= @CustomerID",parms); > return ds; > > David > > > > "Paul Wolpe" wrote: > > > Is there a way to use a like statement with a SqlParameter and the > > Microsoft Data Access Block? > > > > I would like to be able to do this: > > > > int CustomerID = (int) SqlHelper.ExecuteScalar( > > ConfigurationSettings.AppSettings["connectionString"], > > CommandType.Text, > > @"select CustomerId > > from Northwind..Customers > > where ContactName like '%@customer_name%'", > > new SqlParameter("@customer_name",CustomerName) > > ); > > > > Since the DAB already quotes my SqlParameter, SqlServer ends up seeing > > extra quote signs. Something like: > > > > where ContactName like '%'John Doe'%' > > > > Any thoughts? > > > > -Paul > > > > Microsoft Data Access Block: > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp > > Tag: Oracle connection via an IP Address Tag: 92618
  - 17
    - Issues with connecting from .NET to Sybase ASE 12 If anyone out there has been successful in connecting to Sybase ASE 12 from Visual Studio .NET 2003 either in a Windows Forms or Reporting Services project, can you please help me. .... In summary, I wish to: (a) create a Windows Forms application using VB.NET (Visual Studio .NET 2003 and .NET Framework 1.1) that will connect to Sybase ASE 12.0 to execute stored procedures. (b) create a SQL Server Reporting Services report using Visual Studio .NET 2003, .NET Framework 1.1 and SQL Server Reporting Services that will connect to Sybase ASE 12.0 also via stored procedures. I have Sybase 12 Client installed on my development machine and am able to connect to a test server from this machine using SQL Advantage. My code for (a) is: >>>>> Dim sybaseconn As System.Data.OleDb.OleDbConnection Dim sybaseconnstring As String = "Provider=Sybase.ASEOLEDBProvider;Server Name=XXXXXX;Initial Catalog=YYYYYY;User ID=UUUUUU;Password=PPPPPP;" Try sybaseconn = New System.Data.OleDb.OleDbConnection(sybaseconnstring) sybaseconn.Open() Catch ex As Exception MsgBox(ex.Message) Finally Select Case sybaseconn.State Case ConnectionState.Broken, ConnectionState.Closed Case Else sybaseconn.Close() sybaseconn.Dispose() End Select sybaseconn = Nothing End Try >>>>> When I run this, I receive the following message on the Open() line: "The 'Sybase.ASEOLEDBProvider' provider is not registered on the local machine." and this is the exception: ?ex {System.InvalidOperationException} [System.InvalidOperationException]: {System.InvalidOperationException} HelpLink: Nothing InnerException: {System.Data.OleDb.OleDbException} Message: "The 'Sybase.ASEOLEDBProvider' provider is not registered on the local machine." Source: "System.Data" StackTrace: " at System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) at System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) at System.Data.OleDb.OleDbConnection.Open() at Sybase_Stuff.Form1.Button1_Click(Object sender, EventArgs e) in C:\Documents and Settings\allchini\My Documents\Visual Studio Projects\Sybase Stuff\Form1.vb:line 98" TargetSite: {System.Reflection.RuntimeMethodInfo} My problem with (b) is as follows: In my Reporting Services project in Visual Studio .NET 2003 I attempt to set up a shared data source by selecting Add New Datasource. This displays the Data Link Properties dialog. On the Provider tab, I select "Sybase ASE OLE DB Provider". When I press Next or OK, I receive the following message: Microsoft Data Link Error Provider is no longer available. Ensure that the provider is installed properly. Can you tell me how to achieve (a) and/ or (b)? Thanks Ian Allchin Tag: Oracle connection via an IP Address Tag: 92615
  - 18
    - testing try/catch when filling a data adapter Hello. This may be a dumb question, but it's driving me crazy. The function is supposed to to fill a datatable. It works just fine, but I'm testing to make sure my error handling works so I changed the name of the stored procedure so I know I will get an error. However, for some reason, my try/catch does not catch the error. Instead, the program seems to stop. Does this make sense? Do you have any ideas why this happens? Thank you! Protected sub Run(ByVal sprocName As String, ByVal parameters() As SqlParameter, ByRef dataTable As DataTable) Dim command As SqlCommand command = CreateCommand(sprocName, parameters) Dim dataAdapter As SqlDataAdapter dataTable = New DataTable dataAdapter = New SqlDataAdapter dataAdapter.SelectCommand = command dataAdapter.Fill(dataTable) End Function Tag: Oracle connection via an IP Address Tag: 92611
  - 19
    - cSharp ADO.NET sample .. plz.. Hi.. I am new to Csharp.. I would like to get some source for SELECT , UPDATE , DELETE , INSERT samples .. I need it states from Declaration of Connection Object to displaying selected Records... Is there anyone to help me?. Plz let me get out of .NET hell.. TIA Tag: Oracle connection via an IP Address Tag: 92608
  - 20
    - dev connections work, test does not VB .net 2002 crystal reports 9 .net framework 1.1 All connections worked on my box. Having compiled the application and run the .exe on a test box, I find all three db connections now fail. The MS documentation advised to include "Imports Microsoft.Data.Odbc" but that was not an option in my environment, so I tried "Imports Microsoft.VisualBasic.OpenAccess" in my vb file. It didn't work. My connections to the 3 dbs are: 1. An odbc system connection using the format ... Dim crDatabase As Database Dim item As String Dim crTables As Tables Dim crTable As Table Dim crTableLogOnInfo As TableLogOnInfo Dim crConnectionInfo As ConnectionInfo Dim subrpt As New ReportDocument() With crConnectionInfo .DatabaseName = "" .Password = "xx" .ServerName = "xxx" .UserID = "xx" End With 2. Dim m_cnADONetConnection As New OleDb.OleDbConnection() m_cnADONetConnection.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=YYYYYYY\yy\ABC.mdb" 3. Dim m_cnADONetConnection2 As New OleDb.OleDbConnection() m_cnADONetConnection2.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;DataSource=BBBBBBBBBBB\bbbbbbbbbb\CC.mdb;" Please help! What do I need to do now to make this work? Much appreciated, -Helen Tag: Oracle connection via an IP Address Tag: 92607
  - 21
    - Odd error messages Hi When I open some asp.net pages (VB code behind) in VS2003 I am getting the errors below. Funnily enough the project will compile and run. I am just curious as to what they are and how to fix them. Note the errors refer to the page's class (the code behind page): * The DataTableMappingCollection only accepts non-null DataTableMapping type objects. Parameter name: value * Exception has been thrown by the target of an invocation. The other thing is if I try and open the tablemappings property of a data adapter, I get the following messagebox: "Unable to retrieve the schema from the database table. Source column mapping information will not be available. Would you like to continue? Any pointers? Note I am running VS2003, DNF 1.1, SQL Server 2000. Thanks Alex Tag: Oracle connection via an IP Address Tag: 92606
  - 22
    - multiple instances of named argument has anyone ever experienced this when calling a stored procedure from oracle? when i open up the form and type in my variable to be used in the stored procedure, IT WORKS JUST FINE ONCE. but, to, say, change the variable and look for something else causes this and the only recourse is to close the program - re-open it and make another call. since the arguments come from the client side, i hardly think its an oracle problem and in the stored procedure, i do close the cursor. is there a step im missing? thanks this forum is great rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Oracle connection via an IP Address Tag: 92601
  - 23
    - DataSet/DataTable to Excel Hi, Is there any similiar way to transfer data from DataSet/DataTable to Excel Worksheet providing there is not need to copy each row/column cell individually from DataTable/DataSet into individual cells on excel worksheet. Ideally ADO function CopyFromRecordset would be suitable but my data is in the DataSet/DataTable in .NET app. Thank you, Nataliya Tag: Oracle connection via an IP Address Tag: 92598
  - 24
    - Access timeout? Is there something in the connection string that will timeout a MS Access connection if left open? The ldb doesn't ever seem to disappear, even no one is using the file. Thanks! Tag: Oracle connection via an IP Address Tag: 92596
  - 25
    - Insertion of a nodelist using DataSet.WriteXml method. I have created an XML file using DataSet object, in my application. My Dataset consists of 2 tables. I want to insert a set of nodes in the second table. Which means I want to make the child rows of the table 2 of my dataset. The table will be 2 only , but the second table should have a new rowset in the last column. For this if I use WriteXml object, the insertion is at the last, means the insertion being done after the second table. it makes another table. So, i am not able to solve it properly. Actually , how to write the code to create update the XML document by inserting the node set, by using DataSetName.WriteXml method. Tag: Oracle connection via an IP Address Tag: 92593
- Next
  - 1
    - Optimistic concurrency Hi group. Hope there are some gurus out there that can help me understand this topic. I am about to design a rather large department solution in .NET, utilizing ADO.NET, ASP.NET and XML WebServices. How do ADO.NET handle optimistic concurrency? From what I have read it is built in. But only if you use the CommandBuilder or construct your UPDATE stament/prodcedure so, that every column is checked against, right? I am having trouble finding out on what level the concurrency check is done. This is the "architecture" I plan to use: WebForm->DataBound component->DataSet->DataAdapter->DataSource I understand that if I only use one table, the CommandBuilder can be used to build select, update, delete and insert statements of the DataAdapter. On update all colums are checking against in the WHERE clause, to check if some of them have changed since the DataSet was filled by the DataAdapter. In this scenario it seems like the concurrency is handled at the database level. When not using the CommandBuilder, do I have to provide a "similar mecanism" myself, when writing the code for select, update, delete and insert statements? Sorry for the rather long post...But I hope someone has just a bit of the answers to my quesions.. Thanx in advance Best regards Henrik Tag: Oracle connection via an IP Address Tag: 92591
  - 2
    - "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." I'm trying to do a INSERT in a table with this code: protected int RunProcedure(string storedProcName, IDataParameter[] parameters, out int rowsAffected){ int result=0; rowsAffected = 0; try{ Connection.Open(); OleDbCommand command = BuildIntCommand(storedProcName,parameters); rowsAffected = command.ExecuteNonQuery(); result = (int)command.Parameters["ReturnValue"].Value; Connection.Close(); } catch(OleDbException e){... } private OleDbCommand BuildIntCommand(string storedProcName, IDataParameter[] parameters) { OleDbCommand command = BuildQueryCommand(storedProcName,parameters); command.Parameters.Add(new OleDbParameter("ReturnValue", OleDbType.Numeric, 4, ParameterDirection.ReturnValue, false, 0, 0, string.Empty, DataRowVersion.Default, null)); return command; } private OleDbCommand BuildQueryCommand(string storedProcName, IDataParameter[] parameters) { OleDbCommand command = new OleDbCommand(storedProcName, Connection); command.CommandType = CommandType.StoredProcedure; foreach(OleDbParameter parameter in parameters) { command.Parameters.Add(parameter); } return command; } My DataBase is Access 2000 and the called store is: PARAMETERS [@ID_INTERVENTO] Long; INSERT INTO TABLE_NAME(FIELD1) VALUES ([@PARAM1]); On command.ExecuteNonQuery() i have always this error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." Have you got any solutions?? thanks Tag: Oracle connection via an IP Address Tag: 92587
  - 3
    - Access MSysRelationship Hi How to get access to Access database table MSysRelationship. Thanks Konrad Tag: Oracle connection via an IP Address Tag: 92581
  - 4
    - Oracle update command and timestamp - how to get it back? To all you Oracle gurus out there, I'm updating an Oracle table with an OleDbDataAdapter (win forms). I'm using a timestamp column rather than comparing all the values to determine concurrency violation. The way I set the timestamp column is within the actual dataAdapter update/insert statement. SYS_TIMESTAMP = SYSDATE ..... equivalent of Now() in SQL I believe? Screenshot of update query builder: http://www.insightgis.com.au/web/stuff/update_qry_builder.gif This works fine, when an update is posted to the db it will write the current SYSDATE to the timestamp column. However, the currently displayed record on my form doesn't know about the new timestamp value, therefore if you make a subsequent edit to that same record and try to post changes to the db you get a concurrency violation error. Question is, when the dataAdapter makes the update to the db, can it refresh the local copy of the timestamp with the new value? Or do I have to fish out the whole record from the db again? One of my tables has 160 fields, so I'd rather not have to fish the whole record out again for obvious reasons :-) How do you Oracle people get around this problem? Cheers, PeterZ Tag: Oracle connection via an IP Address Tag: 92579
  - 5
    - ComboBox, OleDb's, DataBinding I've got the following code in my form's Load event handler: OleDbConnection oleDbConnection = new OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}", databaseFilename)); string sqlstr = @"SELECT * FROM Companies"; companyOleDbDataAdapter = new OleDbDataAdapter(sqlstr, oleDbConnection); companyOleDbDataAdapter.Fill(companyDataSet, "Companies"); DataView dataView = companyDataSet.Tables["Companies"].DefaultView; companyComboBox.DisplayMember = "CompanyName"; companyComboBox.DataSource = dataView; After Fill is executed, the dataset contains the 1 table with 1 row. Setting DisplayMember and DataSource both succeed without errors. This is the end of the method. When the control is displayed, nothing is in the combobox. Am I missing a databinding step? T. Ford Tag: Oracle connection via an IP Address Tag: 92577
  - 6
    - Oracle Problems I have posted a query before on this particular issue but no one had ever heard of this issue, and I find it difficult to swallow as well, but this is what is happening. When a read an Oracle table and I have a column which has the exact same value in the first row and the second row, the second row part of the row has "garbage" after about 4 characters. So if the first record has the value of "Happy Birthday", the second row will show "Happ\0\0\0". If I look at this same information using the same query and using Toad to execute my query, all is well both the first and the second record say "Happy Birthday". This happens for each and every table that I read and it is repeatable without exception. The column type that I am having problems with is "VarChar2". I am reading the column as follows: String myField = dr.GetString(3). I see there is a method of "GetOracleString(3)" and I have tried this method with the same results. I am using the "System.Data.OracleClient" namespace, which is the Microsoft version of the drivers. I am accessing an Oracle 8I table (or atleast this is what I am told). I am thinking of installing the Oracle version of the drivers or using the standard oledb drivers to get around the problem. Can anyone point me in the right direction on this issue? Tag: Oracle connection via an IP Address Tag: 92572
  - 7
    - Constraints question I am using VS.net 2003 with SQL Server 2000 as the backend in a desktop application. My question has to do with constraints. The books seem to indicate that the best place to place a constraint is at the table level in SQL Server 2000. Maybe so but if there is no way to get data into SQL Server except through a VS application I wonder if it is really necessary to place a constraint in the SQL Server table if you have record or field validation in your code. What would be the purpose of that? Anyone Tag: Oracle connection via an IP Address Tag: 92569
  - 8
    - Creating multiple columns in a DataTable based on Relationships I have three tables in a DataSet ds: MainTable, FK1Table, and FK2Table. MainTable has columns Name FK1_ID FK2_ID FK1Table has columns FK1_ID FK1_Name FK2Table has columns FK2_ID FK2_Name I have added a relationship to the dataset to match up MainTable to FK1Table and FK2Table. Now I want to add two new columns to MainTable called FK1_Name and FK2_Name and populate them with the "joined" data from the FK tables. The key lines looks like this: ds.Tables["MainTable"].Columns.Add("FK1_Name", typeof(System.String), "Parent(FK1Relation).FK1_Name"); ds.Tables["MainTable"].AcceptChanges(); ds.Tables["MainTable"].Columns.Add("FK2_Name", typeof(System.String), "Parent(FK2Relation).FK2_Name"); ds.Tables["MainTable"].AcceptChanges(); Now here's my problem. Both columns get added to MainTable, but only the first column ("FK1_Name") gets populated. If I reverse the order (i.e., add FK2_Name before FK1_Name) then FK2_Name gets populated but FK1_Name doesn't. Any ideas? Tag: Oracle connection via an IP Address Tag: 92565
  - 9
    - Data Access Layer I am writing a fairly large database application for the first time, and am finding it difficult to decide on how to create the data access layer. I have tried reading as much as I can find about them on MSDN, but have found conflicting views, and am now really quite confused. For example, I am using typed datasets to store my data in. I have created a data access layer class, that basically has a set of procedures that accept a dataset, and fill it with some sort of data. These functions are basically static and stateless. Should the data access layer be stateful? Should I instantiate a data access layer in my main() method at the start of my application that basically fills my dataset when I first load my app, and then just pass a reference to the data layer into my various forms? I am finding it hard to know how to split up my database tables into datasets - just for the part I am working on now, I have about 20 tables, all of which are accessed from a single form. Should these just be in a single dataset? Or should I split them into smaller subgroups. The problem I see with this is that any relations between them will no longer exist! Also, if I have other forms that want to use just one or two of these 20 tables, should I create a separate dataset for them, or just use the reference to the data access layer and return the relevant tables? Sorry about the length of this post, but any help with any of the issues here would be greatfully received. Any links to good reference material would be useful too. Pete Tag: Oracle connection via an IP Address Tag: 92561
  - 10
    - XML Filter I was assigned to a project where the main database is XML files instead of RDBMS. One of my primary responsibilities is to create Crystal Reports using .Net. We are having performance issues when we open and view reports. The reason is because Crystal Report that uses XML as a data source pulls all of the data into the report and I just have a filter inside the report. The XML files are loaded into a strong-typed dataset. Then this dataset is passed to Crystal Report. Is there away to filter XML data before I pass them to the Crystal Report? Thanks for any ideas! Cesar Tag: Oracle connection via an IP Address Tag: 92559
  - 11
    - ODBC DataSource Dialog Hi, Is it possible to programaticly show and configure odbc drivers by standard ODBC DataSource Dialog. Regards, Olo. Tag: Oracle connection via an IP Address Tag: 92554
  - 12
    - Error Com+ and ADO.NET Hi, I built a Com+ component that access a stored procedure and returns the data into a datareader. The component return the error below: " An unhandled exception of type 'System.Runtime.Remoting.RemotingException' occurred in mscorlib.dll Additional information: This remoting proxy has no channel sink which means either the server has no registered server channels that are listening, or this application has no suitable client channel to talk to the server. " Any ideas out there? public SqlDataReader ReturnReader() { SqlConnection objConn; objConn = new SqlConnection(); objConn.ConnectionString = "Server=Server1;DataBase=Db1;uid=sa;pwd=;"; SqlDataReader objReader; SqlCommand objCommand; objCommand = new SqlCommand(); objCommand.Parameters.Clear(); objCommand.CommandText = "STO_RETURN_DADOS"; objCommand.CommandType = CommandType.StoredProcedure; ObjConnMovimento.Open(); objCommand.Connection = objConn; objReader = objConn.ExecuteReader(); objConn.Close(); return objReader; } tks. Fabiano Tag: Oracle connection via an IP Address Tag: 92553
  - 13
    - Update with SQL Data Adapter I have two tables in my sql database with the same structure. One table has 5 records and the other has 1 record. I want to take the 5 records into 1 dataset, and the 1 record into another dataset, merge into the data into one dataset (the first) and update the table with 5 records so now it has the additional 1. Everything works fine with code below with the merging, however when I run the Update method with my sql adapter, the table does not get the additional record...what is going on? ----------------------------------------------------------- Try Dim strConn As String strConn = "data source=" & ServerName & _ "; initial catalog=" & Database & _ "; uid=" & UserName & ";pwd=" & Password Dim conn As SQLConnection = New SQLConnection(strConn) Dim strSQL as String strSQL = "SELECT * FROM PDABookMarks" conn.Open() Dim cmdGetProfile As SqlDataAdapter = New SqlDataAdapter (strSQL, conn) Dim profileCB as SqlCommandBuilder = New SqlCommandBuilder(cmdGetProfile) cmdGetProfile.InsertCommand = profileCB.GetInsertCommand() cmdGetProfile.UpdateCommand = profileCB.GetUpdateCommand() Dim dsProfile As DataSet dsProfile = New DataSet() cmdGetProfile.Fill(dsProfile) conn.Close() strSQL = "SELECT * FROM PDABookMarks2" conn.Open() Dim cmdGetProfile2 As SqlDataAdapter = New SqlDataAdapter (strSQL, conn) Dim myData As DataSet myData = New DataSet() cmdGetProfile2.Fill(myData) dsProfile.Merge(myData) cmdGetProfile.Update(dsProfile) conn.Close() Return (dsProfile) Catch Return (Nothing) End Try Tag: Oracle connection via an IP Address Tag: 92552
  - 14
    - Schedulers Components. Hi there, Does any body know where can I find a good Scheduler components (for appointment scheduling) for .NET.? I'm developing a scheduling application and I need to either build one from scratch, which I have no idea how to do that, or get a prebuild scheduler component that I can just include it in the application. Any advices, ideas, hints would much appreciated. Manuel. Tag: Oracle connection via an IP Address Tag: 92550
  - 15
    - How to remove the time portion from a texbox Hi I have textbox in VB.Net that is bound to a Date/Time field in an Access database. The date in Access database only has the date and no time. When you load the dataset into the VB.Net application though, 12:00 time shows up. I realize this is the default but time is meaningless to our application and makes it look bad. Can anyone please let me know if there is a way to format a text box bound to a date field so that is automatically doesn't show the time part of the date. I saw a post or two about formatting using substring, but what event could be used to call this? I know this is a workaround, but is there a property to just display the date?? There must be an easier way!! Any help would be greatly apprecitated!! Tag: Oracle connection via an IP Address Tag: 92547
  - 16
    - after .doc (word) creation it downloads the file but i want it to be opened On my dev PC the website that i wrote auto creates a word document and it auto-opens in my webbrowser. Whenever i visit the site with another PC the website ask if the user wants to download the .doc document of open it. Why is this and how can i make sure it opens in the browser only. my code: --------------------------------------------- Sub butMaakWord_OnClick(Sender as Object, e as EventArgs) Dim myConnection As OleDBConnection = New OleDBConnection(AppSettings("DigifanDatabaseCon")) myConnection.Open() Dim ds As DataSet Dim sXSL As String ds = New DataSet("klantenkaart") Dim ContactsDA As OleDBDataAdapter = New OleDBDataAdapter("SELECT * FROM Klantenbestand WHERE klantnummer="& Request.QueryString("ID") & "", myConnection) ContactsDA.Fill(ds, "Klantenbestand") ' XSLT to use for transforming this dataset. sXSL = "klantenkaart.xslt" ' Close the connection to the data source. myConnection.Close() ' Transform the dataset by using the appropriate stylesheet. Dim xmlDoc As XmlDataDocument = New XmlDataDocument(ds) Dim xslTran As XslTransform = New XslTransform xslTran.Load(Server.MapPath(sXSL)) ' Stream the results of the transformation to Word. Response.ContentType = "application/msword" Response.Charset = "" Response.ContentEncoding = System.Text.Encoding.Default xslTran.Transform(xmlDoc, Nothing, Response.Output) End Sub ---------------------------------------------------------------- thx in advance Tag: Oracle connection via an IP Address Tag: 92542
  - 17
    - creating typed dataset Hi How to create typed DataSet with relations from a database. Is it possible with VS.NET 2003 or there is a tool doing this? Thanks Konrad Tag: Oracle connection via an IP Address Tag: 92540
  - 18
    - executing join query on dataset Hi All I have a dataset having multiple tables. I have following queries. 1. Is there a way to execute join query on dataset 2. One alternative is to create the flat table with all the columns. For creating this table do i have to loop over each column in each table and then add that column to new table or is there any other way? How to take care of foreign key columns? 3. After creating the new flat table how to add the data from each table to the flat table? Any link or code will be a great help for me. Thanks in advance. Regards gagan Tag: Oracle connection via an IP Address Tag: 92536
  - 19
    - Syntax to retrieve rows by datetime value I have a table in an Access DB with a datetime column, from which I'm trying to retrieve values before/after/between various date values, but I'm getting a syntax error in the SELECT command. I'm trying eg "SELECT * FROM mytable WHERE datetimecol > 29/6/04" The datetime values also have specific time values. Sometimes I'll want all values after a certain day (as the example above tries to do). Other times it will be a certain datetime range, maybe just within a single day. Anyone able to help with the correct syntax. (Maybe I've got the wrong form of the Select command altogether?). JGD Tag: Oracle connection via an IP Address Tag: 92534
  - 20
    - How to Unload and de-map DataSet from XMLDocument?? I have a dataset that i use to create an XMLDocument. I later want to add a table to thee Dataset and the following error occurs. "Cannot add or remove tables from the DataSet once the DataSet is mapped to a loaded XML document" I have been unsuccessful finding a way around this has anyone else seen this or have a recomendation on how to load a DataTablee into a DataSet after an XMLDocument was instantiated??? Thanks Tag: Oracle connection via an IP Address Tag: 92533
  - 21
    - Ccan't filter integer column in DataView Hello, I can't filter integer column in DataView I have one TextBox that I retreive the value and one ComboBox where I select column; When column is string (LastName) everything working very well, but when I select integer type (AccountNumber) generate an excpetion: System.Data.EvaluateException: "Cannot perform 'Like' operation on System.Int32 and System.String" Thanks in advance This is my source code: private void SetUpFilter() { this.dvList.RowFilter = null; if (this.txtFilterName.Text.Length != 0) { try { if (this.cmbFilterColumns.text.Length == 0) { MessageBox.Show("Select column"); return; } string filter = "["+ this.cmbFilterColumns.Text + "] LIKE '" + txtFilterName.Text.ToString() + "%'"; this.dvList.RowFilter = filter; } catch (Exception ex) { MessageBox.Show(ex.ToString()); ExceptionManager.Publish(ex); } } } Tag: Oracle connection via an IP Address Tag: 92530
  - 22
    - Add Row Manually to DataGrid Hi, I have a DataGrid to which I want the program add from time to time a new row, without redrawing the whole DataGrid. So I don't want to add the new Row to the DataSource and than do a Refresh, but I want it kind of directly add it to the DataGrid so it only adds the new row. Does anybody knows how to do this? Or what I'd better use for this? The reason I want it is that repainting the (Custom)DataGrid takes some time, and I don't want to repaint it the whole time when I Add a new Row (every 5-6 seconds a new Row should be added). Thanks a lot in advance, Pieter Tag: Oracle connection via an IP Address Tag: 92522
  - 23
    - Addnew Hi, I am new to vb.net and have a question. I created a dataform using the .NET wizard. When I click the "Addnew" command a new row is added but the bound textbox fields do not clear to allow user to enter the new fields values. Am I missing something? the form does display and allow user to edit and save changes. Thank you in advance. Tag: Oracle connection via an IP Address Tag: 92521
  - 24
    - DataGrid + BeginUpdate/EndUpdate Hi, I found on the net that it is possible to use the BeginUpdate end EndUpdate-methods with a DataGrid: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformsdatagridcolumnstyleclassbeginupdatetopic.asp Unfortunately it doesn't work with me: In some way I should make a derived class from the DataGridColumnStyle but I'm not able to do it. Des anybody knows how to do this? Thanks a lot in advance! Pieter Tag: Oracle connection via an IP Address Tag: 92519
  - 25
    - Creating a Queried DataTable From an Existing DataTable I am manually creating a datatable in memory, creating columns etc for it and then populating it by importing data from files and various databases. Once I have the datatable in memory (which consists of around 10000 records) I need to be able to perform queries on it. I'm not talking about merely filtering or sorting it which I could do with a DataView, but performing real queries on it like grouping and counting. I can obviously do this by saving the datatable to a database and then using the OleDbDataAdapter to perform these kind of queries, but I don't want to have to save the data to a database, firstly because I don't need to store it and secondly because its incredibly slow saving 10000 records across a network. Is there a way I can perform SQL queries on a datatable that exists only in memory? Thanks Lee Tag: Oracle connection via an IP Address Tag: 92503

With SQL Server, you can enter an ADO.NET connection string using an IP address such as "Data Source=190.190.200.100,1433;...." to connect to a remote server.

Can you do something similar with the Microsoft managed provider for Oracle such as "Data Source=190.190.200.100,1521;.." attaching to a remote Oracle database using either ports 1521 or 1526 similar to the 1433 for SQL Server?

Top