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


Post New Web Links

MY SQL( DYNAMIC TABLE CREATION ).

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

HI, I NEED  SOME  HELP.  I  AM  SHAILANDRA  SHARMA   ,  I  AM MAKING  A PROJECT,  THE  NEED  OF THE  PROJECT  IS  THE "DYNAMIC  TABLE  CREATION  ON  THE  CLICK OF  A BUTTON".  I  HAVE  A "  TEXT-BOX " AND A " BUTTON "  THE NAME  OF  THE  TABLE IS THE  INPUT IN  THE " TEXT-BOX" , THE INPUT OF THE  TEXT-BOX IS STORED IN THE VARIABLE  AND THAT VARIABLE IS USED IN THE QUERY  OF  TABLE CREATION  , BUT  THE  SQL  TELLS  TO  SEE THE  SYNTAX.

              SO, TELL ME THE PROPER SOLUTION OF THE ABOVE PROBLEM.

 

THANKS.

 

 




View Complete Post


More Related Resource Links

Need help regarding C# / AJAX Dynamic Controls creation

  

radiobuttons is assigned before page init.. 

public partial class Default : System.Web.UI.Page
{
//Assign values as a specific Dynamic WebControl Creation.
List<RadioButton> radioButtons = new List<RadioButton>();
List<CheckBox> checkBoxes = new List<CheckBox>();




Then I created a class that would dynamically create a table containing the available flights depending on session.. (See CallPageLoad())

The placeholder and button is inside the UpdatePanel...

on the button inside the update panel, (btnSelect)

i have this code which works... 


protected void btnSelect_Click(object sender, EventArgs e)
{

Label1.Text = Convert.ToString(radioButtons.Count);


It detects the number of radiobuttons that were dynamically created...

But when I use the following code inside the BtnSelectClick event...

//PLS HELP.......
foreach (RadioButton button in radioButtons)
{
if (button.Checked == true)
{
Label1.Text = "You select... " + button;

CallPageLoad();
}

}


It does not work even though t

create and insert into a dynamic sql table at runtime

  
Below I have a bunch of SQL statements that creates a table at runtime and the "pic" column is a dynamic column and the code creates the number of "pic" columns depending on the count of the uploader control.  the problem comes when I try to insert into that table and I am trying to say for every "pic" declare variable @pic.... it works well for just one file in the uploader but for multiple files i get the following error The name "pic1" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.Directory.CreateDirectory(MapPath(".") & "\port\" & clientname.Text & "\")        Dim objConn As New SqlConnection("Data Source=xxxxxxxxx.hostedresource.com; Initial Catalog=mrpoteat; User ID=xxxxxxx; Password=xxxxxxxxx;")        objConn.Open()        Dim strCommandText As String = ""        For index = 1 To Attachments1.Items.Count Step 1            If String.IsNullOrEmpty(strCommandText) Then                strCommandTex

Custom component Table name dynamic table name

  
Hi All How to i call the table dynamiclly in to C# class library. I can able to call the columns names.. but i unable to call the table name.. please suggest it Example:   IDTSOutputColumn100 column = output.OutputColumnCollection[x]; columnInfos[x] = new ColumnInfo(); columnInfos[x].columnName = column.Name; columnInfos[x].Column_reference = column.CustomPropertyCollection[ "Column_reference"].Value.ToString(); columnInfos[x].bufferColumnIndex = BufferManager.FindColumnByLineageID(input.Buffer, column.LineageID); columnInfos[x].lineageID = column.LineageID;   geting the columns names .. how to i get table name...?? Regards Ram

Need suggestion on table creation

  
Hi All    I want to create a DB in production server. In the DB 5 tables will consists lakhs of records.    We are using SQL Server 2005 Enterprise Edition    To produce the better performance i want to create 5 Data Files for 5 tables.Is my approach is    right or wrong.    Waiting  for valuable replies.

insert into dynamic SQL Table at runtim

  
the follow ing is supposed to create a table and insert the columns into the table at runtime.  It also has picture column and creates the amaount of picture columns based on the amount of files in the multiple file uploaer.. it works fine with just one file in the uploader.  The problem comes when there  are two or more files in the uploader and intead of adding the second image right after the first image is added, it instead adds the first image then goes back and trys to create the table again, and i get an error saying the table already exsits.I want it to add the second image right after the first image, not go back and create the table then add the second imageDirectory.CreateDirectory(MapPath(".") & "\port\" & clientname.Text & "\")              Dim objConn As New SqlConnection("Data Source=xxx")        objConn.Open()        Dim strCommandText As String = ""        For index = 1 To Attachments1.Items.Count Step 1            If String.IsNullOrEmpty(strCommandText) Then                strCommandText = "

Dynamic method creation using code snippet

  
Hello, I am looking to map a method from php to .NET. There are various methods I am targeting, and most don't satisfy a one method-to-one method conversion; alot of the mapping really requires a few lines of logic thrown in, and not just "this .NET function call for this php function call." Anyway, I've defined the mappings as strings, and all I need to do is plug them into a dynamic method that will create, run the code, and return the appropriate value. I do not want to create an assembly in the process, which I think leaves CodeDomProvider out of it. And I don't want to generate my code in IL, which I think leaves MethodBuilder and DynamicMethod out of the running. Can anyone lead me in the right direction here? Is there a way to do what I am asking?   Thanks!

Need help with dynamic table generation

  
I am building a test script to help myself figure out dynamic SQL.  My goal is to generate column names from an existing table query.  To work in this direction I made the following test: declare @sql varchar(1000) declare @int int set @int = 1 set @sql = 'declare @test table (' set @sql = @sql + 'testfield varchar(10),' while @int < 5 begin  if @int < 4   Begin    set @sql = @sql + ' field' + CAST(@int as varchar(10)) + ' varchar(10),'   end  else if @int = 4   begin    set @sql = @sql + ' field' + CAST(@int as varchar(10)) + ' varchar(10))'   end  set @int = @int + 1  end select (@sql) exec (@sql) insert into @test (testfield, field1, field2, field3, field4) values (1,2,3,4,5) When I run this query I get the following from the select (@sql) query: declare @test table (testfield varchar(10), field1 varchar(10), field2 varchar(10), field3 varchar(10), field4 varchar(10)) This looks good.  When I run the exec statement, this returns 1 Row affected, so, that seems to work.  However, when I run the insert I get this error: Server: Msg 137, Level 15, State 2, Line 23 Must declare the variable '@test'. I know that GO statements will effectively create batch dividers between statement groups, but, I haven't yet learned

Cannot call Table Valued Function from Dynamic stored procedure statement

  
Hello,  I have a table-valued function that splits string into a table column. I can easily call this function from a stored procedure within a regular SELECT statement: SELECT * FROM Table1 WHERE Code1 = '1' AND Code2 IN(SELECT * FROM [dbo].[fnSplitValues](@Code2String))   However when I try to use the same logic for a dynamic SELECT statement: ‘SELECT * FROM Table1 WHERE Code1 = '1' AND Code2 IN(SELECT * FROM ' + [dbo].[fnSplitValues](@Code2String) + ')’ I get an error ‘Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnSplitValues", or the name is ambiguous.’ Any idea what is wrong with my dynamic SQL?   Please help, Lana

Get value of dynamic textbox in dynamic table with masterpages

  
Public Sub createtable() Dim b as Integer = 1 For i As Integer = 1 To b Dim tbl As New Table() Dim tr0 As New TableRow() Dim tr1 As New TableRow() Dim tr2 As New TableRow() Dim trh As New TableRow() Dim th As New TableCell() Dim td As New TableCell() Dim td0 As New TableCell() Dim td1 As New TableCell() Dim td2 As New TableCell() Dim td3 As New TableCell() Dim td4 As New TableCell() Dim td5 As New TableCell() Dim td6 As New TableCell() Dim td7 As New TableCell() Dim td8 As New TableCell() Dim td9 As New TableCell() Dim td10 As New TableCell() Dim td11 As New TableCell() Dim title As New DropDownList() Dim fname As New TextBox() Dim mname As New TextBox() Dim lname As New TextBox() Dim address As New TextBox() title.ID = "txtTitle" title.Items.Add("Mr.") title.Items.Add("Ms.") title.Items.Add("Mrs.") fname.ID = "txtfname" mname.ID = "txtmname" lname.ID = "txtlname" address.ID = "txtaddress" th.

Dynamic Text Boxes Creation Problem

  
Hi all, I am creating 5 textboxes in a row. A new creates when user press enter in the last textbox. I have taken a hidden text field and in OnKeyDown of last textbox I am assigning the combination of last textbox Id with the table count  to the hidden field and in VB Code I am checking whether the tableCount + Last textbox Id is equal to the hidden field or not then only I am generating the new row. here is the code In JavaScript On KeyDown of remarks textfield. function funcNewRow(id,count,e) {    var e = event || evt;    var charCode = e.which || e.keyCode;    if(charCode == 13){      e = cancelKey(e);      htxtBox.value = id + count;    } }   In VB Page_load method calling getTableRow() method   if htxtBox.value = "remarks" & (Tbl.Rows.Count + ViewState("TotalClearedItems")) Then  Tbl.Rows.Add(GetTableRow(Tbl.Rows.Count + 1 + ViewState(Panel1.Controls.Add(Tbl))  Panel1.Controls.add(Tbl) htxtBox.Value = "" end if   Here I have to implement a clear functionality such as each row at last contains a check box when user click the check box and press clear button the checked rows have to deleted .   The clear button code as follows : cnt = CInt(Tbl.Rows.Count)  For i = cnt To 1 Step -1 c = Pag

dynamic table name linq-to-sql query

  

I am writing a function in which i generate autocode in specific format i want to make this function generalize so that i send tablename and columnname  parameter and function return the next code. I am using linq to sql with MVC e.g. i want to make table name and column name dyanamic

from m in db.<tblnameparam> 
                       orderby m.<colnameparam> descending
                       select m.<colnameparam>



can dynamic sql be used against a table variable?

  

This Works

create table #tmp1(rowID int)
declare @rowID int
set @rowID = 1
exec('insert into #tmp1(rowID) SELECT ' + @rowID)

This does not work

Declare @tmp1 table(rowID int)
declare @rowID int
set @rowID = 1
exec('insert into @tmp1(rowID) SELECT ' + @rowID)

Error Msg:
Msg 137, Level 15, State 2, Line 1
Must declare the variable '@tmp1'.

Is there a way to use Dynamic Sql against a Table var -- @tmp1?
How to do this?

The goal is to be able to pass in a string param like this to a proc

s1 = 'aa'',''bb'',''cc'

declare @s1 varchar(20)

Begin As

declare @tmp1(...)
exec('Insert Into ' + @tmp1 + ' (...) Where fldx In (''' + @s1 + ''')')
...

Thanks


Dynamic Div Creation.. or something?

  

Hello,

I need some advices please.

I'm trying to build a website for real estate listing. now the data would look like a datagrid. and while clicking on it, it should open under the clicked row the dynamic data related to the specific row. (like an AJAX accordion).

I will try to explain myself in a better way. this website for example ( ignore the language, couldnt find any better example LOL)

http://www.yad2.co.il/Nadlan/rent.php

Now, i've been told that this works by using "Dynamic Div Creation" which i have no idea how it should work this way. Is it possible to make it work by using an Accordion inside a datagrid? or what?!!

If anybody can advice me or give me a sample code of doing such a thing i would be REALLY grateful.


Add very dynamic controls to a asp:table

  

 Hi all. I want to create a TableRow with a TextBox. I want when click a Button a TableRow add to asp:table. in Button_Click event code I can add a row by a TableRow & TableCell & TextBox Objects and with help a HiddenField.
My problem is that: after add first row that has a textbox, next row doesn't add by click button. I think Controls delete after post back in server and first textbox delete and new textbox add same position. what is solution after every click, a row with textbox add to the table?

            TableRow tr = new TableRow();
            TableCell tc1 = new TableCell();
            TableCell tc2 = new TableCell();
            TableCell tc3 = new TableCell();
            TextBox txt1 = new TextBox();
            TextBox txt2 = new TextBox();
            DropDownList drp = new DropDownList(); drp.Width = Unit.Pixel(100);
            tc1.Controls.Add(txt1);
            tc2.Controls.Add(txt2);
            tc3.Controls.Add(drp);
            tr.Cells.Add(tc1);
            tr.Cells.Add(tc2);
            tr.Cells.Add(tc3);
            tblAccessories.Rows.Add(tr);


 


Pivot table query dynamic column.

  

Hello All,

 

I want to export my data to excel sheet. The logic to export data in excel is clear.

Now my query is I have 3 tables and I want to generate the data jst like below.

 

 

Company Name

Company Email

Telephone

Create Date

Age

Fax No

XYZ

abc@pqr.com

131546

22-04-2000

20

11111

AAA

Abc1@pqr.com

131546

30-09-2004

22

123456

 

And so on.....

 

The data will come from 3 tables I.e

 

  1. Master Table for Company

  2. controls in dynamic html table

      

    hi,

     I have a dynamic htmltable, in which I can add rows at runtime.

    Code:

    using System;
    using System.Collections;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Web;
    using System.Web.SessionState;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Web.UI.HtmlControls;
    using System.Configuration;
    using System.Web.Mail;
    using System.Web.UI.WebControls.WebParts;
    using System.Web.Security;
    using System.Data.OleDb;
    using System.IO;
    using System.Text;

    public partial class HR : System.Web.UI.Page
    {

        //   private int numOfColumns = 4;

        private int ctr = 0;

        HtmlTable HtmlTable = null;
           
        protected void Page_Load(object sender, EventArgs e)
        {

            if (!IsPostBack)
            {

                HtmlTable = new HtmlTable();
                HtmlTable.ID = "tableBuild";
             

Dynamic table based on current viewers

  

Hi,

Using MS Visual Web Developer 2010 Express, I'm trying to create a simple site where I can view how many people are currently viewing the page. So far I've added a Web Form called 'home.aspx' this will be the only page and it will contain the gridview that displays how many people are viewing (using the sql COUNT function). There's also the default web.config file which I havn't modified yet.

I've added a sqlexpress database called 'Users' and created a Table called 'viewers'. 'viewers' has collumns IP (varchar(50)) and Time (datetime).  The goal is for the table to grow (INSERT users) each time a viewer views the page, and get smaller (DELETE the user) when each person leaves.

I'm kinda stuck now:

1) I dont know what I have to put in my web.config file to create my connection string to my database (all the tutorials are written for people who know all the system.web mumbo jumo).

2) What do I write in my VB code behind file to INSERT users (I'm guessing I just need their IP and Time?) when they come to the site.

3) What do I write in my VB code behind to DELETE users if they leave. (I think this is the harder part. I dont know how to tell the database to constantly be checking to see if some IP address is still viewing, and then delete t

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