Inserting values from TextBox ComboBox NumericUpDown and DateTimePicker to database C#.Net

Inserting values from TextBox ComboBox NumericUpDown and DateTimePicker to database C#.Net: This article explains you that how to save the data from the multiple controls to the database.In dot net we have different data entry controls.We can use them depending upon the data we have to enter.Here i have mentioned some controls how they will insert to database. TextBox control data always will be in string format, so it will take Text value.ComboBox willalso works like a TextBox.ComboBox is a editable DropDown box.NumericUpDown will take the integer value

How to save data from Dynamic DataTble object to database c#.Net

    Dynamic DataTable to SQL Server c#.Net:
   This article will resolve you how to save the data from dynamic datatable to the database.First thing is the datatable will have the datarows. So you have to save the values from that data rows to the database. The datatable will have multiple rows so you have to run a loop to save all the rows data to SQL database. If you want to see the data of the dataTable object bind the DataTable object to the DataGridView control.

Creating dynamic dataTable object and columns in C#.Net

Creating dynamic DataTable and Columns

    DataTable is a good control for storing data from any control or source. With it we take objects from memory and display the results in controls such as DataGridView textbox and what ever it may be, we can show the data from the data table to those controls.We have two ways to create the datatable in c#. One is Creating object dynamically. Another one is darag drop the DataTable control from visual studio toolbox to the form. Creating the dynamic datable using code is easiest way. The code to create the datatable dynamically is like bellow. By write this code you will get a dynamic datatable. Now you can use the datatable to save the data and to display it in any control as we discussed above.

Adding Values to ComboBox dropdown list from database CSharp(C#)

ComboBox Control in C Sharp

Combobox is a editable DropDownBox.DropDownBox is a ASP.Net controler but here in the C#
combobox will works as a dropdownbox.Adding values to the ComboBox dropdown list from the database is a simple process.Basically ComboBox will have three dropDown styles.Those styles will make the ComboBox three different styles. Those are Simple,DropDown and DropDownList.If you select the Simple DropDownStyle the combobox will appear as a textbox.Another one is DropDown, in this DropDownStyle the combobox will able to take the text from the user and the shows the drodown of perticulars those contain in DataBase.And the DropDown list property will not allow the user to enter the

Autocomplete mode for textbox in C# .net

AutoComplete Mode for TextBox control in C#

               Textbox control have the AutocComplete mode in C Sharp language.When one perticular field will be with related data that time we can set the autocomplete mode to the textbox.This feature does not there in the VB.Net language.When using the vb.net code user must enter the entair field.Autocomplete mode is very usefull feature to the user. Autocomplete mode will work like Google search engine. While user entering the data, the word completion will come as a dropdown to the textbox from a perticular field from database.For that you have to write the select statement from that perticular database.

Inserting values from DataGridView to database C#

Inserting datGridView all rows to database:

We know to inserting values from textboxes and other data entry controls to database
but the values enter from dataGridView to database is little different than those ways
because here we have to insert all the rows which contains in dataGridView to database.
Click here for inserting values from textboxes to the datagridview control.So for the we
have to run a loop to to collect all the data from the all the rows from the database.