sorry...

hello sir tell me one thing more,is it posible to create d datbase at page load in ASP.net....cz if no database exists..then how we open connection..& without opening connection,how can we craete...

thx owesome...hey tell me one thing if i want to check that database already exists or not, 'U' for table,'F' for function ..wats for database????

soory from the next time i rember,But sir its not working.


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;...

hey frnds, I m creating the database at page load,I m able to do dat.I just want to do check that if the table is already existing,then do not create the table.below code create table-


using...

Can u Paste the tables & specify which column to retrieve, so that I can help u out.

create table name1(name varchar)
insert into name1 values('A')
insert into name1 values('B')

create table name2(name varchar)
insert into name2 values('B')
insert into name2 values('C')
...

create table student9(roll int)
insert into student9 values(1)
insert into student9 values(1)
insert into student9 values(2)
insert into student9 values(3)
select distinct * from student9