Results for "Category: String Manipulation"

If you're an old ADO programmer, you may be frustrated by not knowing exactly how to check for NULL. Here's a 1 second tip on how to do it in ADO.NET.

upload image(jpg) create thumbnail and store both in a database. Also can view images in database

This Project is an example of a Simple Multitier Application using a Business Rules Layer and Data Access Layer, to provide scalability to your applications. It uses SQLDataAdapters, DataSets and SQLCommands to Achieve the DataTransfer. The GUI Uses a Listview to Display the Dataset.

***UPDATED 01/22/2003*** This is the same as my VB6 program only it's been adjusted to compile in the .NET environment. It does as stated below. To retrieve a list of jobs on a given SQL Server (7.0 or 2000) and track it's progress through it's numerous jobsteps. This is typically a nice little app to have if you have many jobs that run throughout the day and you want to see if one of those steps has hung up. To make this app truly useful I added a monitoring timer that refreshes every ten seconds or so. The Restart Jobs button is not activated at this time, but the coding should be a snap someone wanting the ability to stop and start jobs from this application. This application is in it's infancy at this moment since I've been working on it for only a couple of days, but is useful even now as far as I'm concerned. Please vote if you like it...

A very small example of how you can using Access databases within your applications. I made this little demo after searching for hours on the net for an example and failing. Firstly I created A simple database in Access using 1 table called "people" with 3 columns, id, fname and sname. The app allows you to add new records to the database, remove them or change them. Excellent for beginners.

SQL Web Query using ASP.Net with VB.Net code behind. This is my first project with the new studio; I think this shows the intention of separating the presentation code from business logic. I have previously never done any ASP work so this is from a VB programmer. USES: ASP.Net, VB.Net, ADO, SQL DataAdapter and the web Data Grid. SETUP: Pretty simple really, all you really need to do is modify the connection string and you should be able to use it. For development I was using the Northwind DB from an SQL server. In the readme.txt I give more info on the setup. If anyone has a problem let me know, I hope I included all the right files. Enjoy

Professional programmers in the industry use serious project management software tools to coordinate development efforts. This is not one of those tools. Of course, it won't put you back several thousand dollars either. The main value to be had here is that Project Notebook is an excellent demonstration of data-binding in C# (something I was unable to find elsewhere). DataGrids, DataSets, Listboxes, Combo Boxes, Edit controls are all wired up together with very little explicitely-written code. Data is persisted as XML using a schema built in the .NET GUI. While all this database-related stuff is kind of dull - this is exactly the kind of thing that you would want to know about if you were writting any editting tools for game development.

UPDATED - May 17,2002 - I just added a SQL INSERT example VIA web form! Enjoy! Please leave comments and vote. Thanks! The zip file contains 6 working examples of various things dealing with the SQL Server. In the package, I also included a file that you can import into your database to use the same tables,columns and rows that I have used. Other Notes: - Examples One, Two, and Three have extensive comments. The examples following those contain no comments because they are exactly the same, except for different control names and types. - In each file, make sure you change the connection information. (Username,Password,Server..etc) I will update this with new examples, such as inserting, updating, using stored procedures and more! This took hours so please vote and leave comments!! Note: It is recommended that you know something about ASP.NET.

DataEasy_VB: is an application written in Visual Basic.Net (converted from the c# similar submission as some of you requested) which would allow the user to load any Microsoft Access file (file format '.mdb'). This application uses OleDb as a backhand communicator with the file to allow the user to : select, delete, insert and modify the database and then save all the changes to the original file. Along with the Data Grid control TextBoxs and Labels are generated automatically and dynamically at run time to allow easy and efficient data input according to the data in the .mdb file loaded. If the file has more than one table in its database, a combobox in the application will allow the user to choose which table to work on. By right clicking column headers who’s data type is either ‘integer’ or ‘DateTime’ the user can opt for either inserting Automatic numbering based on previous cell’s value incremented by 1 or insert that day’s date automatically in their respective column on adding new data. Also provided a Search and Filter capability, by right clicking the search form’s column headers the user can filter in the element (of the column clicked) he\she wants to view. Multiple filtering can be done by filtering more than one column. The user can also use a simple search, by typing in the search textbox to find data in the database. I have included a database file ‘textbooks.mdb’ file with the application so you can try the program. I hope this program will be useful in learning how to load and modify databases and link to ‘mdb’ files, your votes will be highly appreciated :).

This example showes you how to access a Microsoft Access Table using a C# class. Any feed back will be appreciate. Do not forget to vote !!!

If you're just wondering how to use MySQL with VS.NET or are having problems, give this a try.

This article tries to explain how to perform aggregate functions on your Datatable.

This project builds menus by reading from an Access Database. It creates a pure HTML dropdown menu and a treeview which uses HTML and one tiny Javascript function. It will show basic database functions using the new OleDB functions and objects of dot net.

This is a Dynamic Data Layer class library that would be used on a Web based multiple tiered application in conjunction with SQL Server. It includes a TSql Script for three supporting stored procedures as well as source containing several classes. Basically it queries the parameters of stored procedures and holds a static dataset with multiple tables to populate the parameters collection automatically while the web application is running. These can be updated by calling the update method for new or change parameters. During the development cycle no parameters ever have to be recoded due to changes in the requirements and new components never have to be coded.Bottom line is this library cuts 33% of development time on a Multi Tiered application.

This system will teach you how to: Populate the DataSet programmatically instead of with a wizard, Using stored procedures, fill a DataSet with complete tables from the database and then create relationships between the tables, Write the business logic to dynamically build a SQL statement to fulfill the user's criteria given on the Search Screen, Fill a DataSet with the results of the SQL query, Verify in the Output window that the data in the DataSet correctly reflects the user criteria entered on the Search Screen, Simple and complex data binding, Building the Add/View/Edit Products and Suppliers Screens, Using the ErrorProvider control to validate user input, Using DataViews to filter and sort data in the DataSet, Using the DataReader to return a single record, Updating a DataSet based on user input, Allowing the user to add, edit, and delete data in the DataSet on the Add/Edit/View, Products and Suppliers screens, Creating a second dataset that contains all changes made by invoking the GetChanges method, Checking for errors in the changed dataset by checking the HasErrors property, Saving the changes in the DataSet back to the database using Stored Procedures, Accepting or rejecting the changes made based on whether the updates were successful and Handling any errors that occur. Using Northwind SQL database

Datagrid with sorting, paging, highlighting cols when mouseover, stylesheet, change fontcolor of dataitems when a if then function is true.

This example shows how you can use OleDbSchemaGuid in ADO.NET to fetch Schema information from database. It also shows, how you can use DataGrid control, to fill records from dataset, and also how to update records from DataGrid to database using OleDbDataAdapter and OleDbCommandBuilder. In this example List box is filled with Table names of a Specified Database, and by clicking on the table name, you can fill records in the DataGrid. The wonder of the ADO.NET is that it is total disconnected scenario, and this helps a lot in Web Applications.

Photo Album Database Using Xml. This program demonstrates various things in C#; Xml Serialization, Storing Binary Data into XML file, using MemoryStreams to handle images. u can add albums and add photos in an album and give descriptions for both albums and photos. It's not finished yet, needs some easy touches; Edit and Delete for albums and Images, Input validation. I'm working on them beside seeking for a better method to handle XML instead of In-Memory to boost the performance. Read the ReadME.txt file for more information on how to use the program Hope u enjoy it :)

Simple Data Entry application using untyped datasets. Shows add,delete,edit,find,update,cancel,navigation and databinding procedures.

This class provides an easy way to access OLEDB Datasources (you can change the code very easy to access SQL-Server). It shows you how to work with destructors, constructors, dataset, stored procedures, own stuctures, Oledbcommand, datarelations, overload subs(functions). Download this at www.visualsoft-net.de under VB.Net Code