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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Need Urgent Help in Creating a Dynamic Textboxes according to database Tables

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :ASP.Net

I need some help very urgent. I need create a table with Textboxes dynamically according to the database table.
Example: we have different articles in a database like cars, jewelery, boats. The data related to these articles is different in the tables. I have to show that data in a textboxes and let the user change those data and update. I can do the update and reading the data from database. But the problems is for each item the no.of columns and rows will differ.

My task is I need to get the data according to the use selection in the table with textboxes. I dont know which container (gridview, formview or etc) will suites for my requirement. please send me any sample code or any tutorial related to this. I am in real need guys.. I really appriciate your help.

Note: showing the data in a table should be a constraint. Because I should show data row wise (each row contains 3 textboxes and 3 labels (DB table column names))

View Complete Post

More Related Resource Links

Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

Adding Dynamic Rows in GridView with TextBoxes

I decided to write this article because this has been asked so many times before at the forums(http://forums.asp.net) . Basically, this example shows on how to generate a Row in GridView with TextBoxes when clicking a Button that is residing inside a GridView Footer.

Dynamic .NET: Creating Interactive Bing Maps with Silverlight and IronRuby


Silverlight provides support for dynamic languages such as IronRuby and IronPython. We'll walk you through the creation of a custom Silverlight control using Bing Maps and IronRuby.

Ashish Ghoda

MSDN Magazine February 2010

Data Points: Creating Audit Tables, Invoking COM Objects, and More


Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL ServerT are all common issues that developers must tackle.

John Papa

MSDN Magazine April 2004

Design Patterns: Creating Dynamic Factories in .NET Using Reflection


Design patterns are a powerful tool for designing flexible soft-ware. They provide well-tested solutions to recurring software design problems. One such widely used pattern is the Concrete Factory.

Romi Kovacs

MSDN Magazine March 2003

Uploading to SQL Server using AJAX muiltiple file uploader and dynamic SQL Server Tables


I am getting an error on the following code when trying to pload files directly to a database.  

 Incorrect syntax near ','.

 Incorrect syntax near 'image'.


    Private Sub Uploader_FileUploaded(ByVal sender As Object, ByVal args As UploaderEventArgs)

        Dim data() As Byte = New Byte((args.FileSize) - 1) {}

        Dim stream As Stream = args.OpenStream

        stream.Read(data, 0, data.Length)

    End Sub


Private Sub ButtonTellme_Click(ByVal sender As Object, ByVal e As EventArgs)


        Dim objConn As New SqlConnection("Data Source=mrpoteat.db.2798093.hostedresource.com; Initial Catalog=mrpoteat; User ID=mrpoteat; Password=Colgate23;")


        Dim strCommandText As String = ""

        For index = 1 To Attachments1.Items.Count Step 1

            strCommandText += "pic" + index.ToString() + Space(5)

Create user is creating aspxxxx.mdf database in my app_data folder


I had already setup roles for my pages and requirements call for ability to manage and create users.

So i was looking at code that allows you to do so using membership, even though i got the page to work, it was creating a database in my app_data folder.. i already have SQLExpress setup with the asp schema, but cant figure out how to get my application to use that instead of creating the db in the folder?

What am i missing or doing wrong?

I have the following setup in my web.config file..

		<authentication mode="Windows"/>
			<deny users="?"/>
        <add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

dynamic creating controls in webpart


Hello everybody,


My webpart (wss 3.0, VS2005) initialy contain a listbox. Depeding on the selection made a certain amount of textboxes are to be created and rendered. Via these dynamically created / rendered textboxes text can be submitted (via a button), for futher processing.


I am not sure how, or where in the webpart code, to dynamically create these textboxes.


Maybe somebody can give me some advise on this topic.


Thanks in advance









insert new records in tables from dataset to database


I have 2 tables in SqlServer 2008.

Table1: T1id, SomeData

Table2: T2id, T1id, SomeData

I am using DataAdapter.FillSchema to create shema of tables in DataSet. I created DataRelation on columns T1id in both tables.

Now when i try to Update Sql Database T1id in Table2 remains 0 and not the value of T1id in Table1.

I can successfully update Sql Database if i fill DataSet with records first (Using DataAdapter.Fill), but that's not what i want to do. I don't need "old" records in my dataset. I want to use dataset just to store all imputs from user until the proccess is done and then insert all those records "at the same time".

I think i'm getting it wrong with ForeignKeyConstraints, maybe UpdateRule is not set to cascade, i just don't know.

I have been trying to work this out for 6 days now and i'm about to break something on half.

Can someone please guide me to right direction, maybe post some sample, anything.... please!

My old post regarding this:

How to update Sql Server related tables from Dataset(SchemaFill)

SqlDataAdapter.Update related tables

Help with creating dynamic XAML

Hi,  I need some help creating a complex XAML. I have a HotelRoom table with the below fields, ID Hotel HotelName Date RoomType Quantity  1    34    Hilton        3/5     Single      30  2    34    Hilton        3/6     Single      30  3    34    Hilton        3/7    Double     100  4    39    Express     3/5     King         10  5    39    Express     3/6    Double      20 Now I want the UI to display as a list of different records of Hotels with room details in them and I have created an object that has all the fields from the HotelRoom table,   HILTON               Single     Double    3/5        30          0    3/6 &n

Re;Creating Dynamic Control

Hi, I have a table which stores the data like mentioned below ID Name Values 1 States Karnataka,Tamilnade,AP,UP 2 Karnataka Bangalore, Mysore, Bidar 3 tamilnadu Salem,Chennai,Pondicherry 4 AP Hyderbad,Secunderabad,Vishakapatanam 5 UP Delhi,Agra Now i have to create a dynamic controls for each and every states from the above table. A Sate Name should be dispalyed with checkbox on check of checkbox i have to enable all the cities which is again associated with the checkbox.How do i simulate this functionality using dynamic checkbox and labels. Please help me with a sample code.

Creating an database search application in VS C#

Hello everyone, I wish to create a C# application that will have a form and a text box where I can enter a text, and then ask the application to search if this text exists in a database. If it exists, I want all the information associated with this text to be displayed in a datagrid view or list box. I am able to create a database in SQL Server and I can connect to my database from VS 2005 C#. If this is possible, how do I go about it? Many thanks in advance.

Creating a user limited to a few selected tables.

Hi there!   Im facing some troubles setting up a SQL user for my system. A need to create an SQL User, whom only have read access from the view A, read/write to table B and should not be able to see the remaining tables. I have spent some time on this trying to figure out how the permission system actually works, but I havent found the configuration that actually works. What I have done is created a user without any schemas and roles and under securables granted access to read in A and read/write in B. When I use this configuration I cannot access any tables. If I give the user db_datareader/db_datawriter I can perform all actions on all tables.   Can somebody guide me through how to create a user with these limitations? I'm really stuck.   Thanks in advance, Stig Jørgensen

how to retain data in dynamic textboxes

Hello there, more than 24 hours of googling up by now but i hv'nt yet found the commendable solution of my problem. Actually what i searching is ihave a bunch of textboxes created dynamically on the basis of no. of rows in a sql table i put in some data in these textboxes and inserting in other table and here comes the actual problem i have to create the dynamic controls on every postbacks otherwise controls does disappear. other thing i can do is recreate the table on insert button click but in that way i am able to insert the data in the table and recreate the controls but this way text in dynamic textboxes does not remain there. any help in this context would be highly appreciable. thanks in advance  

Business explainfor tables and hierarchy in AdventureWorks database and REAL_Warehouse_Sample_V6 cub

AdventureWorks (ProductModel table, what is this table for) ------------------------------ REAL_Warehouse_Sample_V6 (Periodicity(only have one attribute:period)) (Replen Strategy(three level hierarchy(strategy type:backlist,frontlist);(strategy:Modeled,Buyer Managed,No replenishment,Store Managed)) Another one is what is the difference and relation between buyer and customer in cube REAL_Warehouse_Sample_V6? -------------------------------------------- I can not understand the business meaning behind these tables and architecture,can any one help explain the meaning for upper hierarchy and table? happyMan

Creating database throw exception!

When running SQL commands, it throws error information. Why is it? My env :    windows server 2003 64bit     sql server 2008 . Command :   CREATE DATABASE [AdventureWorks2009]     ON (NAME = 'AdventureWorks2009_Data', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2009_Data.mdf', SIZE = 170, FILEGROWTH = 8),     FILEGROUP DocumentFileStreamGroup CONTAINS FILESTREAM ( NAME = FileStreamDocuments, FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents')     LOG ON (NAME = 'AdventureWorks2009_Log', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2009_Log.ldf' , SIZE = 2, FILEGROWTH = 96); GO     Error information:   Msg 5120, Level 16, State 106, Line 1 Unable to open the physical file "E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents". perating system error -2147024891: "0x80070005(failed to retrieve text for this error. Reason: 1815)".

Cannot see top link bar when creating a Web Database site

Hi, I am new to Sharepoint 2010 and am very keen to start using the new Web Database site templates such as Asset Web Database and Issue Web Database. I am able to create these without issue however once i build and navigate to these sites i lose the top link navigation bar. For other sites such as Team Site this is not problem and the navigation site remains. Does anyone have any suggestions on how to show this navigation bar for these site templates?
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