.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

Best approach to save options data

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :ASP.Net


On my home page, I have up to 10 logos that I want to allow administrators (via a back office) to turn on and off. Depending on which logos are 'on' these are then displayed.

But what is the best approach for storing this information in an SQL database, and then recalling to load as per the options selected?

Many thanks

View Complete Post

More Related Resource Links

server side does not save data when using POST data to another URL using WebRequest


 I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).

  1.  The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line

   response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?

The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.

Client side codes: // also run on my local computer

public string PostIntegrationXml(XmlDocument xmlSubmitDoc)




so many data access options, what to use ?


I always have used Enterprise Library DAAB with stored procedures for data access with 4 seprate layers (presentation layer, custom types layer, business logic layer and data access layer).

My feeling is that this development approach wasts much time.

I have not worked with other ways of accessing data but sure there are many ways that save development time. While searching I read about these:

  1. Data Adapters they generate whole DAL with stored procedures
  2. Linq with different flavers
  3. Entity Framework
  4. Using data controls like SQLDataSource and Dynamic Data
  5. Other mappers, code generaters and utilities

So much options and my little knowledge, I am confused in making decision what development patern I should adopt considering that my development may be fast, extendable, re-usable and up to the standard. Also I want to go for a way in which my code libraries can be used with other technolgies like silverlight, mvc framework, services if I ever need to use.

Kindly guide me and help.


How to save form data to delimited file?

I tried searching, but maybe I was putting in bad keywords =\How do I go about saving form data into a delimited file?

What are my options when I need to create a report with data from multiple sources?

Hello all,  What are my options when I want to create a report that will get records from multiple data sources based on data from a parameter? The user will enter the customer ID, I have to check that ID against 5 different data sources. Have you guys done anything similar? Should I leverage SSIS on this request, adding an extra layer of complexity? Should I do this all from SSRS? What are my options?

DataFormWebPart and DVDropDownList no save data

Hello,  Sorry likely noob mistake. I have spend a whole week in this: I have a CustomEditForm.aspx for a DocumentLibrary. In my DataFormWebPart, y change a FormField for DVDropDownList, in order to catch SelectedIndexChanged, and get values from other list, and update de values of the DataFormWebPart. Every think work right, BUT when i want to save de data, my DVDropDownList  is not Saved. All others field work perfect, EXCEPT my control, WHY?????   Thanks in advanced   <SharePoint:SPDataSource runat="server" DataSourceMode="List" SelectCommand="&lt;View&gt;&lt;/View&gt;" UseInternalName="True" ID="ChangesDefinitionDS"> <SelectParameters> <WebPartPages:DataFormParameter ParameterKey="ListName" PropertyName="ParameterValues" DefaultValue="Changes Definition" Name="ListName"></WebPartPages:DataFormParameter> </SelectParameters> </SharePoint:SPDataSource> <SharePoint:DVDropDownList runat="server" id="FormFieldChangeDefinition" AutoPostBack="true" DataSourceID="ChangesDefinitionDS" DataTextField="Title" DataValueField="ID" __designer:bind="{ ddwrt:DataBind('u','FormFieldChangeDefinition'

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?

Need advice to display data in DataGridView, then edit dan save the data

I am Winform Beginner. To display data using DataGridView is ok with me. How the best way to select row in DataGridView, then edit and save. Did this DataGridView can editable? or Once row in DataGridView is selected, then popup another form to perform edit transaction. Really need advice and good example

Best practice: Where to save data from application pages?

Hello, I have a feature scoped at site level which contains some application pages, where I need to save some "settings data" from. I'm thinking I should use some hidden lists in the root of the site collection to save this data. For example one of the application pages registers timer jobs that should then use information entered in the application page. I'm wondering if this is, in your opinion, the right approach? Thanks.

Problem to save infopath form data in database.

Hi i have a win application which host infopath forms. i want to save infopath form data in database. to do this, in my table, i have xml dataType which store infopath form data. my problem is when i load xml form into string variable and save to database, i got this exception : XML parsing: line 1, character 38, unable to switch the encoding Here is my sample infopath form data in xml format : <?xml version="1.0" encoding="UTF-8"?><?mso-infoPathSolution solutionVersion="" productVersion="12.0.0" PIVersion="" href="file:///C:\Users\Hamed\Documents\customForm1.xsn" name="urn:schemas-microsoft-com:office:infopath:customForm1:-myXSD-2010-09-11T10-56-47" ?><?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?><my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-09-11T10:56:47" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us"> <my:txtFirstName>b</my:txtFirstName> <my:txtLastName>c</my:txtLastName> <my:txtFatherName>d</my:txtFatherName> <my:txtNationalCode>e</my:txtNational

how to save radiobuttonlist data into database when they are in disable position

hiiiiiam using 2 radio buttonlist controls in web application they are FIRST      Yes    NoSECOND  Yes    NoInitially  SECOND radio button list is in disable position.when i was click on yes of FIRST radio button list, then SECOND radio button list is enables otherwise it is in disable mode only.here my problem is when i am inserting data into the database the disable radio button list gives error as System.NullReferenceException: Object reference not set to an instance of an object.code written for inserting isprotected void Button1_Click(object sender, EventArgs e)    {                    SqlConnection con = new SqlConnection(@"Data Source=STS2\SQLEXPRESS;Initial Catalog=STS;Integrated Security=True");            string sql;            sql = "insert into Table1(";            sql += "First,Second)";            sql += "values('";            sql += rbl_first.SelectedItem.Value.ToString() + "&

Which is the best approach for applying business rules and basic validation like data types?

Hi Everybody   Please suggest me the best approach for applying the business rules and data type validations .Here is my choices : 1)Sequential work flow 2)State machine work flow 3)Work flow rule engine 4)Rule engine without workflow Out of above choices ,which is the best approach? Please provide me the reasons or senarioes for which is the best approach for applying the business rules and also performancewise. My requirement is : After getting the reports ,need to apply the datatype validations like valid or invalid date ...etc to the reports .And stored into Database.In the next step,need to apply the business rules to that reports in such a way that data should be good quality. Thank you very much

how to open a subform model Form,Sub Window form using jquery that save the data ajex

how to open a subform model Form,Sub Window  form using jquery that save the data ajex

How to get table value and output save in data base using jquey ajex


how to get value this table output is
row 1, cell 1
row 1, cell 2
row 2, cell 1
row 2, cell 2

and save automatically in database no any where click

<table border="1">
<td>row 1, cell 1</td>
<td>row 1, cell 2</td>
<td>row 2, cell 1</td>
<td>row 2, cell 2</td>

Save a page only when user changes any data



 I my application in need to save web page data only when user changes any loaded data?If not should promt a message

No data to save ! how to do it.Please help me

Various Data type save in One Field


I use a ntext data type for all kind of data save in one field, but when i save  byte (that converted from image) follwing message is shown "Operand type clash: varbinary(max) is incompatible with ntext". Is ntext suitable for all kind of data type or what will be compatible for all data type support?

Binary Data Problem....save and retrive image data from sql database


hello friends...please help me to solve this problem....

i have created crud (create, retive, update and delete)form and it's running... here i want to add images for each record(sql database)....

i'm using image datatype in sql table for picture.....

Q 1: how to save and retrive binary data(image) from sql table in asp.net form using vb coding?

Q2: can i create sql table which store binary(image url) data direct?

thank you

unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

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