Hi<br/>i need to connect to a SQL server database on another server - this server is not on the same domain and is not located locally - it is in another building - how would i connect to it using ADO.net??

According to msdn, a Dataset in ADO.NET is a disconnected, in-memory structure which contains all the data described. My question is, how the Dataset handles too big data that do not fit in memory? I mean, where does it keeps the data if it is to remain disconnected? if xml files stored in the hard...

Which tool would I use to view folder contents inside of one of my forms..<br/>I would want to keep it up at all times.<br/>Thanks,<br/>Chris<br/>Edit<br/>==============================================<br/>Sorry, ment to put this in VB.Net, not ADO.Net

How do I bind a radio button to a datasource?<br/>When I scroll through users in an combo box I need to set either the employee or mamager radio button to checked depending on the value in the db. The field in the db is a Yes/No field<br/>Any help would be appreciated

What am I doing wrong? I do not get any outputPrivate Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged OleDbConnection1.Open() OleDbDataAdapter1.SelectCommand.CommandText = "SELECT Location, HotelID FRO...

Hi FriendsHow are you doing?? i have a small problem..i am trying to register my component with GAC..its saying assembly added succesfully. and its showing my assembly name in C:\winnt\assembly folder..but the problem is its now displaying my assembly name in the List of Assemblies in GAC..please le...

Hi FriendsHow are you doing??i am trying to migrate my asp pages to asp.net ..so that i downloaded the Asp to ASP.NET migration wizard..but i am unable to see the option Convert from the menu File/Open..please let me know how to get that option ...Thank youSatyaGUmmadi009@yahoo.com...

Hi all.In my application i read tables from .txt files into DataTable object. It works well when table width is less then 255 columns. Whole my application is build to work with DataTable objects. Please tell me how can i work with wide tables? I hope there is the way to insert wide table into DataT...

Hi all. Iam trying to read data from .txt table delemeted with ", " and insert it into DataTable object. A problem is that only first 255 fildes pass to DataTable. Please somebody tell my why? Here is the code: string connectionString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + directo...

Hi everybody,in webform , i can dosqlcommand cmd=new ("select * from customer",cn)cn.open()sqldatareader rd=cmd.ExecuteReader()datagrid.datasource=rd;datagrid.databind()cn.close()but in Window form i can't use datagrid.datasource=rd;can you explain to me?thanks,...

Bear with me, please... :)TableA on Database1:CodCli -- Name -- Age -- SalesCod(...) (...) (...) (...)TableB on Database2:Key -- CodCli -- Date -- Value(...) (...) (...) (...) [Using Vs 2003.net Crystal Report] We need to see and print all rows from TableB th...

hi<br/>1) Version Office 2000<br/>2) VC++6, MFC<br/>I have already a table in the document<br/>and now i will copy this line and insert under<br/>i have open the word document usw, from this site<br/> http://www.a-m-i.de/tips/office/officeautomation.php<br/>thanks

Hi, I 've searched this site and some others and can't find a solution. The problem is rather basic. I have a query like this: SELECT * from orders WHERE OrderDate BETWEEN @startdate AND @enddate. the user sets these 2 variables at runtime by using datetime pickers. I can display the resul...

I need to read up on the implication of server farm AND database clustering on COM+ transaction. Any reference? Preferably URL's so I don't need to rush off to the bookstore.<br/>Thanks in advance.<br/>Norman Fung

hi,i got this table - Employees:Id | Name------1 Avi2 jack3 NULL4 NULL5 bettywhen i query this sql - "select id, name from employees"i get back a data set with 5 results.the problem is that its seems like when the query executed...

Assuming a table with "n" rows, of which "m" have been modified. Will update() and/or AcceptChanges() execution time be O(n) or O(m).In other words for a table with a LARGE number of rows, of which only a small number (or no) rows have been altered execute these methods in "zero time".Preliminary t...

what is my sql string would be if i want to open a recordset in descending order<br/>p/s: using MS Access with jet oleDB in VC++ 6.0<br/> (and i am newbie. don't get mad)

How can I lock a record using ADO .NET ??<br/>I'm beginner in .NET and using disconnected data access.<br/>Thanks.

well, i'm new to ado.net, have only done some tests and i have a few questions..any answers or feedback will be greatly appreciated!1) How do i specify a cursor in ADO.NET? I need cursors to implement certain functions and i don't want to use stored procedures.2) I use a DataReader to mani...

I have problem on stored procedure after executing itThis is the select statement inside the stored procedure:select sum(amt) as total from orders where order_Date = todayThe problem occurs when there is no record or orders on a specific date.How could I check if the value returned is null or there...

Hi!<br/>I try to connect from c# to oracle 9.2 but i get this error:<br/>System.Data.OleDb.OleDbException: Oracle error occured, but error message could not be retrieved from oracle.<br/>There is no sqlnet.log created.<br/>How to solve this?<br/>Thanks for your answer!

Hello, I'm new to ASP.Net technology and I am trying to implement crystal report 9. I have .Net setup with sql server and crystal report 9. I need to print crystal report useing crystalreportviewer controls (toolbar-printoption) on web. I tried but it's not worked. OR I just want to hide t...

Hello, I'm new to ASP.Net technology and I am trying to implement crystal report 9. I have .Net setup with sql server and crystal report 9. I need to print crystal report useing crystalreportviewer controls (toolbar-printoption) on web. I tried but it's not worked. OR I just want to hide t...

Is there a way I could fill a dataset table from a storedprocedure? I have a stored procedure that return a records. I want all these record to be placed on a toble in a dataset. How could I do it?<br/>Hope someone could help me. Thanks!!!

Hi,I am trying to connect to my (local) server to get a list of databases on that server. It doesn't work when I pass (local) as the server name, but it works if I hardcode in the actual name. My connect string is: Data Source=(local);Initial Catalog=master;User ID=sa;Password=;Integrated Secur...

Hi,<br/>What is the fastest way to copy selected columns from one DataTable to another DataTable?<br/>Thanks,<br/>Beener

Hello, my project is taking a long time do to the fact I am using a large number of stored procedures. I have seen the MSDN data application block for SQL SERVER. Is there any library that offers the same type of functionaltiy for access 2000? From what I have read, the data application block can b...

I'm wandering whether there's a way to define the path in a connection string, while working with the designer, that is relative (and not absolute which is the default).I would like it for example to be relative to my exe file: "..\..\data\db1.mdb"I know that I can change it in the designe...

Hello!I've a problem when I try to read an Excel file. In my Excel file, there is only a few numbers in two columns. I want to read it and fill a DataTable.I'm doing this: Dim oConn As New OleDbConnection Dim oCmd As New OleDbCommand Dim oAdp As New OleDbDataAdapter Dim rDT As...

Hello, I have two related tables with relationship one-to-many. If I try to update a record in a table that is on the "one" side, I get a message that this is not possible because there are related records. I am not changing the key the tables are related with. I am changing other fileds that do not...

Types Of Dataset

If We Have Relation Between Two Tables By Using Datarelation.<br/>In Such A Case If We Delete One Record From One Table Whethe Error Will Occur Or Not.

HelloI think it's possible to export a .Net dll and use it from unmanaged code, using the utility tlbexp.exe, or regasm.exe, that export and registers it. I'm trying to export System.Data.dll, that contains the most part of ADO.net, in order to use it in a MFC application. So, I do:regasm...

Hi,<br/>I would like to know how I can add/read user-defined propertied to an MS Access DB using ADO.NET. I need to add a property such as version.<br/>In DAO, one could do that using the "CreateProperty()" function, but here I'm stumped.<br/>Thanks!

I have 2 tables:table "Ships" with the fields:ID,ShipName,Capacity,Width,IdCaptain,IdLieutenent.table "Crew" with the fields:ID,LastName,FirstName,Age.in a ListView i show ShipName,Capacity,Width.on selectedindex changed i show bellow in a datagrid using a datasetthe Captain and Lieutenent of select...

Can anyone help me when using DataReader and when using Data Adapter?

Hi all!I just ran into a really strange problem (probably just due to me being totally SQL-illiterate). I have an Access database (using standard ADO from plain VC++), and I can't create a recordset from a table called "session". If I rename the table to "session2" it works as expected. Is "ses...

Hi,I am using a data grid to display records. The data grid has 22 columns. I need only 2 columns in the grid to be editable. Bcoz when I click the edit link the entire row is displayed in Edit mode (with long text boxes) ...which causes the user to do a lot of scrolling.How to display only 2 column...

Hi,I'm using a datagrid in my asp.net page, which is populated by a disconnected datatable. (This datatable is sent to me from another component). Now, I need to add / delete / edit records in the datagrid. I don't want to commit each of these transactions immediately to the database....

Hi, I have an ORACLE DB with a table, a sequence and a trigger which starts the sequence a new record is inserted in the table. How do I get the sequence number of this row after I inserted this row? I use an ADO connection with AddNew and Update. Thanks in advance, Mathias...

I have an XML file which I am reading into a Dataset.ds.ReadXml(XMLFILE)Once the Dataset is populated, it has 13 Tables based on the Structure of XML...I need to then filter out the information and show only the records where Report_ID is what User wants to see i.edv = New DataView(ds.Tables(1)) �...

This not-so-complicated query runs perfectly within MS Access, yet causes an exception without any additional information when executed as a command.Other queries in the same project are straight selects, updates or inserts.Only this one is not working.OleDbCommand cmUpd = new OleDbCommand("UPDATE "...

Hi,I've migrated from ASP Classic to ASP.NET but I'm having real trouble learning the new ADO.NET way of database programming. I used to use the following two functions for creating ASP Classic database connections:<%Function CreateConn() dim Connect dim cnDB Connect = "Provider=SQLOLE...

How do I display an Excel Spreadsheet Information into C#?<br/>I believe this is done using ADO.NET.<br/>Please help. Thanks

How to insert a null value using a parameter?string sqlQuery = "INSERT INTO xaxa VALUES(:v_num)";OracleConnection oraConnection = new OracleConnection(Localdb);OracleCommand oraCommand = new OracleCommand(sqlQuery, oraConnection); int lala = 0;// do sth complicated to calculate lala...if (lala &g...

Hi!<br/>Does anyone have a clue if you can use ADO on EXtens?

Hi everybody!I have some problem with syntax.There is code :using namespace System;using namespace System::Data::OleDb;int _tmain(){OleDbConnection * myConnection;}When I compile this code I have receive error :" error C3699: '*' : cannot use this indirection on type 'System::Data::Sq...

i can't connect to my database the OLEDB throw the following error<br/>An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll<br/>How can you handel it <br/> <br/>thanks

Hey gurus,I have a problem with ADO. I don't know if this is the right spot to post or not, because It as to with .asp and VBScript, but I figured what the hay. I tried over at the VB forum, but I didn't make any progress.I am trying to develop an asp page and connect to a Visual FoxPro...

Hi there, I'm struggling with the following problem, using VS.NET C#:I need to display automatically updated service rates on our website. The rates need to be shown in both local currency (BRL Brazilian Real) and USD.The USD rate is fixed and is pulled directly from the database (Access) and s...