Sql server database table from c#.net with variable table name.

When you have database and you have to create table with variable name.Then you can create like below.
protected void Page_Load(object sender, EventArgs e)
        {
           
        }
        private string GetConnectionString()
        {

            //sets the connection string from your web config file. "DBConnection" is the name of your Connection String

            return System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString;

        }
        public bool DeleteData(string TableName)
        {

            SqlConnection connection = new SqlConnection(GetConnectionString());
            connection.Open();
            string sqlStatement = "CREATE TABLE " + TableName + "" + "(stuid INTEGER PRIMARY KEY," + "stuname CHAR(50), stuaddress CHAR(255),

stubalance FLOAT)";
          
            SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
            sqlCmd.ExecuteNonQuery();
            connection.Close();
            &n

Contributions
Articles (0)	Blogs (8)	News (0)	Resources (0)
Tutorials (0)	Forum Posts (7)	Downloads (0)	Book Chapters (0)
Photos (0)	Videos (0)	Interview Questions (0)