|
Hi all,
I have been assigned a weird project of all times.Its basically a form thats used for creating tables in the database. This is scenario...
There are three panels viz left ,right,bottom. The left panel contains a listbox containing the name of the controls(HTML/Server). Once he selects a control the right panel displays what properties that can be set for the controls and the constraints on that field(Primary key,Identity..).Once properties are set and the user hits add button, the selected control with selected properties is added to the bottom panel.
Once all contols are added,the user fills in the fields generated (textbox,dropdown.datepicker..) and on submit a database table should be created on the server with column names as the entered values and with constraints provided by the user.
Problems ..
>How to go about this stuff(.. only hint will do)
>retaining entered values during postback
>Setting database constraints
any help will be highly appreciated....
When you fail to plan, you are planning to fail.
|
|
|
|
|
www.Developerof.NET wrote: The left panel contains a listbox containing the name of the controls(HTML/Server)
 For creating a database table and setting the attributes, why user has to select ASP.NET controls and add it dynamically ?
www.Developerof.NET wrote: Once all contols are added,the user fills in the fields generated (textbox,dropdown.datepicker..) and on submit a database table should be created on the server with column names as the entered values and with constraints provided by the user.
How about putting the required controls in a DataGrid/GridView ? Then you don't need to bother about managing the state on postbacks. I guess this will be enough.
In first columns put a textbox where user can enter field name, next column could be a dropdown where he can select the attributes like primary key. When add button is pressed, iterate through all the rows, find the controls and create a table creation statement and pass it to ExecuteNonQuery() method.
www.Developerof.NET wrote: retaining entered values during postback
Applicable when you are not using the DataGrid/Gridview method : You can create dynamic controls in any event before viewstate is loaded. Init() would be an ideal place for dynamic controls, and ASP.NET will maintain state for that.
www.Developerof.NET wrote: Setting database constraints
Create a table through design view (Enterprise manager). Right click on the table and choose copy which copies table creation statements to the clip board. Paste it somewhere and learn how constraints are applied through a query. Formulate your query in a similar way.
Hope it helps
|
|
|
|
|
N a v a n e e t h wrote: Applicable when you are not using the DataGrid/Gridview method : You can create dynamic controls in any event before viewstate is loaded. Init() would be an ideal place for dynamic controls, and ASP.NET will maintain state for that.
Sorry, just jumping in on seeing that: will it maintain custom attributes I add to controls if I do there and not in Load?
Calling all South African developers! Your participation in this local dev community will be mutually beneficial, to you and us.
|
|
|
|
|
Will it be possible to generate dynamic controls on a button click(which causes postback) and add the newly created controls in a panel/div.
Since the init event is called only once i cannot use it on a button click event. Is there any other way round to manage the viewstate
When you fail to plan, you are planning to fail.
|
|
|
|
|
hi
i want know how i can save user Session For part of time that in this time
data that store in session for user not remove if close or leave the web site
but if the same user again open and browse same address can retrive data and information for user
i think and know that i can save sessionID in cookie for client and Session data in database for same ID and can retrive info but firs i know asp.net 2 have any default way for this and second my way is true or false
for example:
i want save user basket for almost 20 min that if user leave or close can retrive data if user come back in this min
Please Help Me
thaks
|
|
|
|
|
scorpion_man1982 wrote: i want save user basket for almost 20 min that if user leave or close can retrive data if user come back in this min
Which is your session mode. inproc ? When will you restore the data ? Immediately after user opens your site, or he/she has to login ? If you are restoring the data immediately after he/she took your site, another user can see the shopping cart of this user if he is using the system within the specified 20 minutes.
Alternatively, you can store the cart details in a table, and access it with user id. Make sure user has logged in and take the records from this table depending on the user id. Put a scheduled job in SQL server which checks this shopping table and removes old data (over than 20mins). This will be ideal and secure.
|
|
|
|
|
thanks N a v a n e e t h
i can use all session mode that help me
but i want other shop and site can get shop & accounting service from my site
and all of user when come my site is GUEST and no id
only way to khnow and save data for user use sessionID but i want use way that can retrive shopping data for user if user close your browser window and come back in 20 min
can you help me or any guide for solve this problem?
|
|
|
|
|
can any one help me to display images in datalist
|
|
|
|
|
|
hi,
i want to enable a html element while the checkbox is in checked state.The following code works fine in IE but not in Firefox.
...
and my script is.......
function findselective()
{ if(document.getElementById("findOption").checked==true)
{document.getElementById("findBy").disabled=false;
}
else{
document.getElementById("findBy").disabled=true;
}
}
Pls help me to solve this problem.
by
siva
|
|
|
|
|
sivarajanb wrote: document.getElementById("findBy").disabled=false;
Can you change the "findBy" to "findby" ( small letter "B") and try again??
I have tested with the code below. I works well.
function findselective()<br />
{ <br />
document.getElementById("findBy").disabled = !document.getElementById("findOption").checked;<br />
}
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
thanks Michael its working...
regards
siva
|
|
|
|
|
I want to create a pdf file using asp.net using C#. I also want to create some link in the pdf file e.g Table of contents.
Any suggestion....
Thanks in advance.
Do good and have good.
|
|
|
|
|
Silent Eagle wrote: I want to create a pdf file using asp.net using C#
1 - Use any third party libraries offering PDF creation.
2 - Use crystal reports and export options (recommended)
|
|
|
|
|
iam using file upload control to upload the file but when iam selecting the zero bites size file then i want to get the message that u have selected zero bytes file how can it be possible.
|
|
|
|
|
if (FileUpload1.PostedFile.ContentLength == 0)
{
}
|
|
|
|
|
sir this can i write in button click event or where i can write sir
|
|
|
|
|
Hi,,,
U write the code in button click
Aswini
|
|
|
|
|
i want to learn the regular expression .i mean the meaning of each character in the regular expression.can somebody please refer me a site that belongs to the detail overview of the same.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
|
Miss,
open the site.. www.google.com and in search write regular expression C#.
U will be having lots and lots of information..
Thanks,
Sun Rays
Rate this post if you like answer.
|
|
|
|
|
i have gone through such sites . i want detailed view(meaning of each letter)
u know any site that gives the e-book free fo the same ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Hi...
See basic rules are simple..
for range.. of characters use [ ]
for repeating the characteres use { }...
or undefined times means use *..
eg: [a-z]{5} -- means...
5 characters from a to 5
Aswini
|
|
|
|
|
i want detailed view(meaning of each letter).u know any site that gives the e-book free fo the same ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Sonia Gupta wrote: u know any site that gives the e-book free fo the same ?
What's wrong? Why not buy a book - it's great, you get a handy paper based reference which you can take anywhere. The book "Mastering Regular Expressions" here[^] is a great place to start.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
