Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- oledbdataAdapter
- HiI am trying to set up a oledbDataAdapter to do a basic select from an Access database and I get the following error:IErrorInfo.GetDescription Failed with E_FAIL(0x80004005)What can I do to fix this?Verify your connection status to the database. Probably your connection is fault. Try to build a valid connection string.
- Tags: Storage, Databases
- Q&A 2005-11-25
- XPath provides an easier way to select information in Jet database
- If you're a power user or developer familiar with Microsoft Access or other products that use the Microsoft Jet database engine, you probably think of the SQL language when thinking about queries. In a traditional Access application, SQL is the language that you write queries in, and knowing SQL is...
- Tags: Databases, .NET, Lark Group, Inc., XPath, Dataset, XmlDataDocument, XML, OleDbDataAdapter
- Technical articles 2003-09-18
Additional Resources
- ADO Provider Query Explorer and VB.Net Code Writer (zip)
- This simple and powerful program not only creates connection strings, and sql statements but also writes copy and paste code into a text file. Imagine being able to visually select databases, tables and realign fields effortlessly so you have total control over the way the information is viewed. In less...
- Tags: SQL, Microsoft Visual Basic.Net, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-02-21
- Using parameters in C# OleDBCommands
- Hello all,I have this problem:I need to get data from a table giving some parameters. The parameter list can be very long, like this:string SelectStatement = "select unidade, numero, date " +"from _dsa_ihs_table " +"where unidade in ('1234', '1235', '1236', '1237', ..., '9999') " +"order by unidade" ;And if i...
- Tags: Programming languages, C#, joaquimc, numero, parameter list
- Discussion threads 2007-05-18
- Unable to add date to access database
- Hi I am trying to add a date field from vb 2005 to access database. However when I try to run the following code I gets error message that reads "Syntax error in INSERT INTO statement." Any help regarding this is highly apprecited. [code]Imports System.DataImports System.Data.CommonPublic Class Form1 ...
- Tags: Databases, database, hemant.mukherjee@..., Table1, ByVal
- Discussion threads 2007-10-28
- ASP.Net Oracle Connection
- Dear all, Please let me know, how to connect oracle with asp.net web application.My code below:public WebForm1 { InitializeComponent; ConnStr="Provider=msdaora.1;DSN=assetmgr;User Id=scott;Password=tiger;"; conn = new OleDbConnectionConnStr; conn.Open; dataadpt = new OleDbDataAdapter("Select * from tblast",conn); cbuild = new OleDbCommandBuilderdataadpt; dataSet1=new DataSet("tblast"); dataadpt.Fill(dataSet1,"tblast"); }i had created the assetmgr in ODBC datasource Administrator. But it was not asking any test connection.in which I gave...
- Tags: Please Let, Data provider, bsmgopal1984@..., programming, Microsoft ASP.NET
- Q&A 2006-07-13
- ASP.Net Databind in DropDownList
- I tried to display the values from oracle table into a dropdownlist which is in asp.net.I used the below code to bind the data.When I debug,the page loads completely.But it doesn't show anything in the dropdownlist.How can I get the Oracle table values in asp.net dropdownlist.I used the below code:private...
- Tags: bsmgopal1984@..., ConnStr, database, DropDownList, Microsoft ASP.NET, programming, tblPay, tblTest, TBLTEST *It
- Q&A 2006-07-25
- Build a data-bound grid with C# and ADO.NET
- Data access is the basis of any application. In thisarticle, I will show you how to access SQL Server-based data using C# andADO.NET, as well as how to display the data in a data-bound grid control. I usea simple C# application as an example.ADO.NET architectureADO.NET allows you to work without...
- Tags: C#, data access, data source, grid, Irina Medvinskaya, Microsoft ADO.NET, Microsoft SQL Server, namespace, server
- Technical articles 2006-08-30
- How to handle optimistic concurrency violations in ADO.NET
- In database-locking parlance, the term optimistic concurrency means that your application assumes that no one else will be making changes to the same record that it is currently editing. I explored this concept in detail in a previous article, along with how ADO.NET automatically supports this locking method at the...
- Tags: .NET, Microsoft development tools, Databases, Programming languages, Craig Utley, Data Adapter Configuration Wizard, concurrency violation, optimistic concurrency violation, sample application, Microsoft ADO.NET
- Technical articles 2003-02-10
- An introduction to ADO.NET concurrency
- ADO.NET is Microsoft’s new technology for working with data. One of the most trumpeted features of ADO.NET is the DataSet object, which is an object that stores data in an in-memory schema, complete with DataTable and DataRelation objects. The ability to store an entire schema in memory allows the DataSet...
- Tags: .NET, Databases, Microsoft development tools, Craig Utley, Dataset, concurrency, concurrency violation, optimistic concurrency, Microsoft ADO.NET
- Technical articles 2003-01-17
- << Previous
- page 1 of 1
- Next >>
