SqlDbType.Date 


string dobStr = ddlMonth.SelectedValue + "/" + txtDay.Text + "/" + txtYear.Text;
SqlParameter dob = new SqlParameter("DOB", Convert.ToDateTime(dobStr));
dob.SqlDbType = SqlDbType.Date;
cmd.Parameters.Add(dob);

Comments

Post a Comment

Popular posts from this blog

Install the Northwind Sample Database

Image
If you look on the web you will eventually find an example that refers to the Northwind sample database in one of the their examples.  What they fell to tell you is where to find this sample database and how to add to your database. Follow these steps to add the Northwind sample database to your SQL Server: 1. Go the URL  http://www.microsoft.com/en-us/download/details.aspx?id=23654  and download the Northwind and pubs sample database from Microsoft. 2. Double click on the SQL2000SampleDb.msi file, then click "Run" 3. After you finished with the installer you will have the sample databases in the "SQL Server 2000 Sample Databases" folder in the C drive 4. Log onto SQL Server using SQL Server Management Studio 5. Right-click on the "Databases" node inside the "Object Explorer" window, then select "Attach" 6. Click on the "Add" button, in the "Attach Database" window 7. Select the "NORTHWND.MDF" file inside t...
Read more

Docker : Adding Non Root Users To The Docker Group In Ubuntu

Image
One of the most common task you have to do as a Linux administrator is to add a new user.  Especially developers who always wants root access. Docker needs root access, however the person who is administering Docker is probably not the system administrator.  Most likely it will be the application developer. To accomplish this task you can use the useradd command in the Terminal session then add the new user to the Docker group.  Follow the steps below to add a new user to Ubuntu. 1.  Switch into the root user using  sudo su -  command
Read more