Find User Mapping Option Of Database Properties?
Oct 6, 2010how to find User Mapping option of any database in sql server 2008.
so that i can change the DB_OWNER name to AdMINISTRATOR.
how to find User Mapping option of any database in sql server 2008.
so that i can change the DB_OWNER name to AdMINISTRATOR.
I am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesFor Testing x509 certificate.I expanded the Default Website node in IIS 7.5.When i right click there is no properties option in popup menu.How to include it?
View 1 RepliesCould anyone provide me more info regarding this subject because I'm clueless. Any link, tutorial or anything else would be appreciated. The problem is I don't know where to start, but what I have to do is to import data from Access database to very similar SQL database.
View 1 RepliesThere is a way to map a tree view to a database structure?
View 7 RepliesI'm using vb.net/asp.net 2005 with Ajax Accordion control.
I am trying to find out the Javascript properties of the Accordion control, how do i do this?
when I try this:
"ctl00_cphMaster_grdvNameOfMyGridview_ctl06_acrdNameOfMyAccordion.set_SelectedIndex(0);"
I am getting an error:
<ERROR>
Object doesn't support this property or method
</ERROR>
If I can get a list of supported Javascript properties of the Ajax Accordion control
I have a database table that contains list of all UserTypes(constant strings) used in the application.
What is the best way to store(what datastructure do I need) these so that code can access them ?
The need is similar to enum, but I want to associate these values to those in DB so that there will not be 2 places to edit in case of adding/removing an entry.
one other option I considered is using public static readonly string, but how to associate with those values in DB ?
As I began writing web applications with asp.net I started with small projects that used a Linq-To-SQL mapper for database access to a MSSQL Server. After gaining some expierence I switched into a classic 3 tier with Graphic Layer, Business Layer, Data Layer. The only function of the Data Layer was to provide methods insert/update/delete without any logic and logic the form of selection methods.
Over the time I realized that it would be better not to provide the database classes up to the GUI (took some time unfortunately). I switched into using Business classes in the BL that are used for all operations performed by the BL and display by the GUI in the form of getting List from the BL. A great advantage is that I can provide additional properties that are not represented by the database itself. However, I did that mapping inside the BL myself with methods that mapped the corresponding BL class to the database class.
I guess thats where O/R mapper come in handy? Until now I haven't realized their purpose, but I think I just found it. I've recently tried out using the new Entity Framework with .net framework 4, but I'm only using it like the Linq-To-SQL DataContext.
Is there a way to achieve the mapping automatically? If yes, is that something the new Entity Framework provides or do I need to look for a O/R Mapper like NHibernate?
Where can I go to find documentation about client side properties and methods of an asp:listbox controls. I need to access the control at client side but can not find any documentation of the properties and methos available a client side.
View 4 RepliesI'm using ASP.NET MVC 3.I would like to create an action filter to determine if a user can access a view. I have a User class with properties like IsAdministrator, IsTrusteeUser and IsAuditUser. How would I create an action filter to block certain users if the don't belong in some of these roles?And aslo how would I use this in my views to hide/display certain controls?
View 2 RepliesI've an application built on asp.net 2.0. There is an option for user to upload excel file. Once the file has been uploaded the data in the file is validated against some business rules. Rows that successfully validates are inserted into database as soon as it is validated.
I use ado.net to connect to excel file. And use data reader to iterate over all the records. Normally the number of records range from 5,000 to 20,000. This process takes good 8 to 10 minutes. I want to optimize this process because to my understanding it takes too long. Currently I am looking at OPENROWSET, OpenDataSource which so far is unsuccessful. Valiation that takes place on every row is very simple. I only checks for maximum length. So validation itself is not an issue.
I started using the .NET user roles authentication for my new project, but somehow I can't manage to get the profilemanager to be recognised within my website.
I already go a working authentication with userlogins & roles, but the profilemanager won't show up :( I tried adding the <profiles enabled="true"> and all the other things according to this blog:
http://www.codeproject.com/KB/aspnet/Files.aspx, but i won't see the option in my WSAT provider config... What am I doing wrong? or am I missing something?
piece of my web.config:
[Code]....
I need to create one contact us form in that I need 4 fields 'Name, Email, Subject, Message'. In this what I need is I need to store the data in database and also I want that form to be mailed to me. How can I configure that database option along with sending it to mail.
View 10 RepliesI have a folder on my web server that has hundreds of mp3 files in it. I would like to provide the option for a user to download a zipped archive of every mp3 in the directory from a web page.
I want to compress the files programmatically only when needed. Because the zip file will be quite large, I am thinking that I will need to send the zip file to the response stream as it is being zipped, for performance reasons.
I want to create an sql table with photos, and i want to use filestream data.
View 3 RepliesOn a home PC I have SQL Server 2005 installed. If I go to SQL server management studio and select my database, I can then right click on the "Database Diagrams" folder and then select "New Database Diagram" from the popup menu. I can then generate a database diagram. However on my PC at work if I follow the same steps as above, the popup menu does not show an option for "New Database Diagram". Instead my choices are "Working with SQL Server 2000 diagrams" and "Refresh". So why is the "New Database Diagram" menu option missing? Also what is odd is that the popup selection reads "Working with SQL Server 2000 diagrams" when in fact I am using SQL Server 2005 not 2000? Does anyone know why my option to create a database diagram is missing?
View 1 RepliesI have a dynamic dropdown that is populated from sql. The user is supposed to select an option from the dropdown, then click a search button on the form to return some results based on that selection. It works fine if the dropdown gets populated with more than one record. However, if only one record is returned, that one record can't be selected. Whether you select it or just leave it alone since it's the only one, when you click the form button (search button), no results are returned b/c the dropdown selection must not be actually selected.
I've included the relevant code below. First the DDL, then the datasource, and finally the C# code in the if (!Page.IsPostBack)
[Code]....
i am using mysql database connected in grid view with aspx pages how to use delete option with check boxes (like hotmail inbox).
View 5 RepliesI am new to asp development but have been around c# for a while. Basically I am trying to create a page which will pull data from a database and then for each object it creates I would like to add a user control which is built to represent that object. So basically I have tried quite a number of things to get it to work but for some reason I can't figure it out! How can I programmably add user controls and then set their properties from a 'master' page which hosts the user controls?
View 3 RepliesI have added a combobox to my page. Listview is updated based on selection from combobox. It is working great except it does not fire when Enter is pressed. User has to click on option from dropdown or has to press tab key to have Listview to populate. I want the user to be able type use arrow key to select option and then press the enter key for event to fire.
Using .net 3.5 and c#
I'm writing applications on Facebook located on an external website ASP.NET C #. The application should check whether or not a person likes my Fan Page (page) on Facebook, and if he or she doesn’t like it needs to like it before using this application. How this can be done using the Graph API and ASPSnippets Facebook API.
View 1 RepliesIm doing a project which requires me to store the survey results to database.
For the options, I am using the radio button list.
However, I have problems storing the selected option back to database.
Is there any solution to it? Im using visual studio C#! :)
how to upload file in asp.net using c# with respect to grid view as when i upload file.. den using grid view i can view all d information n get a option to download dat uploaded file from gridview....
View 1 RepliesI have used the tutorial for Save and Retrieve Files from SQL Server Database using ASP.Net It's working well for saving and retrieving on page OR on label. For the file retrieving section i want the file to be displayed as link "Download" in Gridview and when i click on download link file should start downloading.
View 1 RepliesIf in one form upload image form we enter ID in textbox againts ID label and upload an image file using fileuploadcontrol when we click on upload button image save in DB and in next form view image when we enter ID in textbox againts label enter ID. Images show in GRIDVIEW having columns (ID,images) ...
View 1 Replies