|
|
|
|
|
|
| | Total Hits: 7 | Today: 0 | Author: Nipun Tomar | Rating:  |
| | 
JDBC (Java DataBase Connectivity) is the specification of the standard application programming interface that provides a standard library for accessing relational databases like MS-Access, Oracle or Sybase. It also provides a common base on which higher-level tools and interfaces can be built. It is an application programming interface that defines how a Java programmer can access the database in tabular format from Java code using a set of standard interfaces and classes written in the Java pro... |
| | Total Hits: 9 | Today: 0 | Author: Evoluteur | Rating:  |
| |
With this article, I would like to share a simple but useful little tool: ExportWizard, a Step Wizard for Database Export.
It guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats CSV, HTML, XML, or SQL.... |
| | Total Hits: 8 | Today: 0 | Author: mikvos | Rating: |
| |
Some time ago, I was thinking about starting my own business and registered a domain etc., but then I was made an offer I couldn't refuse, and so I put these plans on hold. I still had my domain (http://www.bid4binary.com) and was paying for hosting, so I thought I would do something, and blogging seemed to be the natural choice. I therefore wrote myself a blog system and started using it. Shortly thereafter, one of my readers asked me where my RSS feed was, and I realised that while I had heard... |
| | Total Hits: 8 | Today: 0 | Author: Ashish Tripathi | Rating: |
| |
DALC4NET is an Open Source data access layer built for Microsoft .NET projects. It enables us to access data from databases including SQL Server, Oracle, MySQL, MS Access, and MS Excel. DALC4NET was developed using C#.NET. Microsoft .NET Framework 2.0 is required to use DALC4NET. Users can freely modify the source code as per their needs. For any feedback/ suggestions, you can mail the author at ak.tripathi@yahoo.com.... |
| | Total Hits: 11 | Today: 0 | Author: Shirsendu Nandi | Rating: |
| |
In this article I will describe how to create a list of documents under the parent documents using C# .Net and a Mongo Database.... |
| | Total Hits: 9 | Today: 0 | Author: Amit | Rating: |
| |
Create new asp.net website in your solution. Now add new project as class library named as Business Layer. Add a new project again and name it DAL.
Add the reference of BusinessLayer to the asp.net website project. Similarly add the reference of DAL project to BusinessLayer. This all we are doing as we are trying to create a layered architecture for the sample application.
Now right click on DAL project and add new item -> ADO.NET Entity Model click ok.... |
| | Total Hits: 7 | Today: 0 | Author: Vamshi Krishna | Rating:  |
| |
If we want to develop a web project, we need "Front End" and "Back End".
Front End is Microsoft Visual Studio (MS .NET 3.5/4.0).
Back End is Microsoft SQL Server 2005/2008 (Database).
Front End is also called the "Client". That means that .Net is the client.
Back End is also called the "Server". That means that SQL Server 2005/2008 is the server.
If we want to establish a connection between the client and the server, we need an "Application/Program".
The application is divided ... |
| | Total Hits: 8 | Today: 0 | Author: rperetz | Rating: |
| |
The first part of the article will show you how to get the return value from ExecuteDataSet. The second part of the article will show you how to get a return value and output values from ExecuteNonQuery.
This article will show you how to use Microsoft Application Blocks and be able to get your Stored Procedure's return value and output parameters. You will find many articles on the web about calling a Stored Procedure and getting the return value and output values using ADO.NET... but if ... |
| | Total Hits: 8 | Today: 0 | Author: Kishore Kumar.N | Rating: |
| |
Nowadays error logging becomes mandatory and there has been lots of techniques/API's to log the errors. We develop a ASP.NET application and it works fine on your development machine, and when we deploy the application to the production we set the compilation debug="false" ... element in your web.config , of course it is the best practice, which makes the error not visible to the end users.
Well, now, we got some exception and we wonder what is that error and you don't have any clue about err... |
| | Total Hits: 8 | Today: 0 | Author: abhigad | Rating: |
| |
On one of my projects I used LINQ. Since this was my first LINQ project, I decided to use Linqdatasource to fetch data from database. Another reason for using LinqDatasource is because of its in-built support for grid view paging and sorting functionality.... |
| | Total Hits: 12 | Today: 0 | Author: Govind Bhanushali | Rating: |
| |
The small utility tool has been developed for rapid development of Data Access Layer and Entity Layer.
I am a Software Programmer and I have to make Data Access Layer and Entity Layer for the procedures I made in Oracle. For each parameter in Procedure, I have to create a property with get and set in Entity Layer Class and have to build oracleParameterCollection in DAL. For the procedures that have 30 to 40 parameters, I have to code around 600 lines, which is very boring and time consumi... |
| | Total Hits: 9 | Today: 0 | Author: Mike Baldini | Rating:  |
| |
If you are experiencing 'Out of Memory' issues with Access 2003 SP3 when you save code/forms, please download Hotfix KB945674 from Microsoft. This hotfix was developed for us specifically to remedy the 'Out of Memory' issues. This does not completely resolve them, but it does help a little.... |
| | Total Hits: 11 | Today: 0 | Author: Pramod S Kumar | Rating:  |
| |
This article explains the concept of the ASP.NET AdRotator control fetching ad information for Flash from a database and rotating the ads with Previous/Next button clicks. This article also explains how to store Flash (.swf) files in a database and display the ads in a specific order.... |
| | Total Hits: 12 | Today: 0 | Author: Petr Bríza | Rating: |
| |
If you are working on software which accesses a Paradox database, you are probably using BDE (Borland Database Engine). This article shows how to use Paradox database files and read some data from them directly. You can also use the primary index to find specific records you need. This could be useful if BDE doesn't cooperate with you or there is another reason why you cannot or don't want to use BDE.... |
| | Total Hits: 10 | Today: 0 | Author: loveyou999 | Rating: |
| |
Excel is so powerful that it can easily successfully open not only excel itself, but also CSV format files, Tab format, website table format and other file formats. It’s so smart that it can automatically recognize number, character string and can easily automatically transfer 11+ digital natural numbers to scientific notation. For example, if you input number ”123456789012” in a cell, the number will be changed as “1.23457E+11”.... |
| | Total Hits: 9 | Today: 0 | Author: Scott Mitchell | Rating: |
| |
Compared to default paging, custom paging can improve the performance of paging through data by several orders of magnitude, making custom paging the de facto paging implementation choice when paging through large amounts of data. Implementing custom paging is more involved than implementing default paging, however, especially when adding sorting to the mix. In this tutorial we ll extend the example from the preceding one to include support for sorting and custom paging.... |
| | Total Hits: 9 | Today: 0 | Author: Osama Abbas | Rating: |
| |
I've been using the excellent VS2003 add-in called DataSet QuickWatch by Mohammed Barqawi, and also its enhanced version by Fahad Khalil, for a long time now. Visual Studio 2005 has Visualizers, but the default one for DataSets is too simplistic. So inspired by DataSet QuickWatch, I decided to create an advanced Visualizer for large DataSets.... |
| | Total Hits: 9 | Today: 0 | Author: Amir Mahfoozi | Rating: |
| |
Tree structures are very useful in implementing hierarchical structures which are helpful for software developers to develop applications which are more realistic and tangible to the customers who will use them. For example, in implementing "departments structures" or "products tree" or "organization charts" with unknown level of depth tree nodes, it's inevitable to use these structures in database.... |
| | Total Hits: 9 | Today: 0 | Author: Satnam Singh | Rating: |
| |
I was recently asked to set up Transactional Replication comprising of 29 publishers as well as same number of subscribers. One interesting challenge was that the size of the distribution database suddenly increased from few MB’s to around 62 GB and as a result the disk on which the production database was hosted quickly filled up. The DML operations on the tables on the replicated database was continuous. After investigating this, I noticed there was a table named MSRepl_Commands present in the... |
| | Total Hits: 9 | Today: 0 | Author: Handshakeit | Rating: |
| |
There is a simple problem faced by many developers, when there are two controls on a form which are bound to the same tables. Suppose there are two combobox on a form having same bound tables. If one user selects a value in one of them it will be automatically selected to other control also.
The reason for this is by default all controls share forms bindingcontext, to prevent it simply change the bindingcontext of one of the control to new context... |
|
|
|
|
|
|