Need Little Help for create a database in asp.net

velias · Apr 28, 2012

Hi all, I had read the microsoft documentation about working with asp.net and had understanded it too. My only problem is that I hadn't understand how to Create a new Data Base to manipulate it. I know how to execute querys over a database and it contents and manipulate it too. Could anybody explaint me how to create a new Data Base in Access or Sql server?? so i'll be able to make a new connection string to show and manipulate it. Thanks a lot for your time and support and sorry if you find any gramatical errors. From Spain. Salvador Gallego.Hi There Well I can help u with Access 1)Open Access 2)select Blank Data Base 3)Then It will ask u to create database by default name db1....Change if uwant and save for e.g C: est.mdb 4)Now on next screen, Select design View..it wil show u new table...as follows fieldname datatype description say ur table consits of fields username password email so ur enter fieldname datatype description -------------------------------------------- username Text blabla password Text blabla email Text blabla on each clik u can set max characters...... now When u close Table it asks u to name the table..... save tablename as 'datatable' create primary key if u needed Thus ur Database in access is created in asp.net on Button Click event add following code Dim conEnquiry as OleDbConnection Dim cmdSelect as String Dim cmdInsert as OleDbCommand conEnquiry=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA source=C: est.mdb") cmdSelect="Insert Into datatable (username,password,email) Values(?,?,?)" cmdInsert=new OleDbCommand(cmdSelect,conEnquiry) cmdInsert.Parameters.add("@username",txtUserName.Text) cmdInsert.Parameters.add("@password",txtPassword.Text) cmdInsert.Parameters.add("@email",txtEmail.Text) conEnquiry.open() cmdInsert.ExecuteNonQuery() conEnquiry.Close() Dont Forget to Import <%@ Page Debug=True %> <%@ Import Namespace="System.Data.Oledb" %> at the top Good Luck I guess this will help u DHiraj Thanks a lot, You are the first one who had help me around the forums and so quickly, that answer will be for sure a very good orientation for me i'll try if its works now and I hope I can learn enough to help you in the future if you need... Thanks again. Salvador Gallego. [email protected] Ur welcome Well i had written tht code in giffy.........so if u can handle errors in code which i have taken care off........but still..... One Error which u may npt trace if ur beginner..... write DATA source with space.... coz i had written as one word n had found difficult way........... Good luck Dhiraj

Need Little Help for create a database in asp.net

velias

New Member