.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Create table dynamically in SQL Server

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server
 

hi all,

i want to create temparory table dynamically in sql server,

well, it depends on the fields that are passed from front end as comma seprated value..

and that table shoud contain only that fields that are passed  from front end,

help me on this if it is possible,

 

Thanx in advance,

Sagar Joshi




View Complete Post


More Related Resource Links

generate create script of table using c# and SQL server 7.0, can anyone help me?

  


I want to generate create table script using c#.net, I want to connect sql server 7.0 and generate table create script. Its urgent kindly help me urgently.


Want to Create Table Dynamically With text Control in WinForm Csharp

  
Hello To All... from Many Days i m tryng to create a simple table using csharp in WinForm.Which will include textbox in each cell according the Passed No of Col & Row. but not getting the proper result. Actually i want to trace each cell data and want to save each cell data to data base : eg. in cell 11(1col & 1row) i m having Combobox which having some item list and when the user select the list item the data will save to the database. Regards, Praveen    What is the Key of Life ... Its Sharing Your Thought & Knowledge ...

sql server 2005 express - don't allow to create table

  
i have downloaded sql server 2005 Express version from the web and use domainname\SQLEXPRESS as server name but now i can't create table seems every create by sa user, what is the password of this user or how to grand right to my window login user so that i can modify/create something in database.

How to create a view in my database from a table in another server/database

  
Is there a way to create a view in my database referencing a table in another server/database if I have the connection information.  I know how to do it in Oracle, simply create a database link, but have never done so in sqlserver.

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

  
i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

Unable to create table dynamically in database

  

I am able to create database through script generated by SQL Server 2008 but unable to create tables from generated script. Please indicate if any step is missing.

 

************* Code *******************

 public bool CreateAppTables(string DatabaseName, string ConnectionString)
    {
        string DatabaseScript;
        DatabaseScript = Activity.readTextFile(HttpContext.Current.Server.MapPath(".") + "/functionalscripts/CreateTablesonly.sql");
        DatabaseScript = DatabaseScript.Replace("DatabaseNametoChange", DatabaseName);
      
        return ActionQueryDB(DatabaseScript, ConnectionString);

    }

 public bool ActionQueryDB(string SQLStatement, string ConnectionString)
    {
        //  SqlConnection cn;

        OleDbConnection cn = new OleDbConnection();

        cn.ConnectionString = ConnectionString;
        try
        {
            cn.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = SQLStatement;
            cmd.Connection = cn;
            cmd.ExecuteNonQuery();
            cn.Close();

            return true;
        }
        catch (Exception ex)
        {

            cn.Close();
            return false;
        }
    }

 

****************** Contents of text file appe

How to create a Table of content in .rdl design in BIDS dynamically according to the Page no wise..?

  

hello,

well i am able to create the TOC statically by using the Document Map properties as describe in my older post issue 

but now i just want to create the Table of contents dynamically generate using the page no wise..is it possible...how can we do it while designing the .rdl in BIDS..

Thanks 

Anil


SSIS 2005 - Dynamically generate create table statement from source

  

Hello

I have a requirement where i had to migrate the table structure and data from ODBC database to SQL Server. I have dynamic source reader that uses sql query from variable to get the data and the next step is to get the create statement and create table and then to insert data. how can i get Create Statement the destination produces and use sql task to create the table and then insert the data using data flow task.

Please suggest

Regards

 


Can not create table in SQL server 2005 Express

  

hello !

I have database in SQL server Express 2005,  I just create table Customer and table Employee , table Product .They are OK , I want create table Bill and table DetailBill , but they are wrong,

create table Bill
(
 IDbill char(10) primary key not null,
 IDcustomer char(10) foreign key(IDcustomer) references Customer(IDcustomer),
 IDemployee char(10) foreign key(IDemployee) references Employee(IDemployee),
 StartBill datetime default getdate() not null,
 
 EndBill datetime not null
 constraint checkendbill
 check

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

Dynamically Create Controls in ASP.NET by Using Visual C# .NET

  
This article demonstrates how to dynamically create a control for an .aspx page. The sample project does the following:
Creates two TextBox controls.
Verifies that the contents (TextBox.text) and the attributes of the TextBox are saved across posts to the server.
Illustrates handling events that are posted by a dynamically-created control

Dynamically Create Controls in ASP.NET with Visual Basic .NET

  
This step-by-step article describes how to dynamically create controls for an ASPX Web page.

The sample project does the following:
It creates two TextBox controls.
It verifies that the TextBox contents (TextBox.text) and attributes are saved across posts to the server.
It describes how events that are posted by a dynamically created control are handled.

Temporary tables in SQL Server vs. table variables

  
When writing T-SQL code, you often need a table in which to store data temporarily when it comes time to execute that code. You have four table options: normal tables, local temporary tables, global temporary tables and table variables. I'll discuss the differences between using temporary tables in SQL Server versus table variables.

dynamically adding sql server columns based on number of files in fileuploader

  

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.

 

I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!

 

Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")

objConn.Open()

Create new sql table at runtime VB.Net

  

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")

objConn.Open()

Create/add table from code to database

  

Hi,

I create table:

                  DataSet data=new DataSet();

                  DataTable myTable = new DataTable("NewTable");


                   DataColumn[] keys = new DataColumn[1];

                   // create column
                   keys[0] = new DataColumn();
                   keys[0].DataType = System.Type.GetType("System.String");
                   keys[0].ColumnName = "PointID";
                  
                   myTable.Columns.Add(keys[0]);    &nb

Bulk Copy From Datatable To SQL Server Table

  

 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
    {
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;
        
        con.Open();
        bulk.WriteToServer(dt);
        con.Close();

        return true;
    }

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.

 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend