I need to bind a menu with the databse, the problems is i need to define roles so that the menu will only contain links to pages that are allowed to the login user,user can only view pages allowed to him, what is the best choice for this purpose, and what control will give me best performance in this scanerio of dynamically generating menus???
View 2 RepliesHow to bind Menu and their submenus from database for example like this menu
Home page Departments Contact Us
-Accounting
-IT
-Engineering
i have create a form..and i generate ID using dropdown list for user for registration before they save the page..the ID will appear when click "signUp" button.("ID" not saved yet into database)
i want the "ID" lock into databse when click "signUp" button..
Is it possible to bind a sitemap to an accordion for a simple menu?
View 3 RepliesI have an asp.net3.5 app. It has multiple client folders in the root folder. There are multiple web.config files. One is in root folder and one each in client folder. The web.config in client folder contains connection string for the database to be connected. I am using FORMS authentication. Each client has a specific page which are lying in root folder. This page redirects to the client specific folder and user logs in the application using the one more login page which is in client folder. And this page uses the connection string which in this client specific folder web.config.Now my problem is that I am not able to connect to the database using the client specific web.config on my live server. Live server is a Windows 2008 Datacenter and IIS7 machine. And my local system is XP IIS6 machine.Please help me to resolve this issue. Or how can I configure my application on IIS 7 &Win2008 DC system in WINDOWS authentication mode?
View 2 Repliesis there is any control in asp.net to mange for creating menu using database and mange when it's click link it open in iframe
View 1 RepliesI have an accordion menu like this :
Builder ( Main UL , without href )
Create Builder ( Navigates to CrtBuilder.aspx)
Remove Builder ( Navigates to RmvBuilder.aspx)
Supplier (Main UL)
Create Supplier ( Navigates to CrtSupplier.aspx )
Remove Supplier Navigates to RmvSupplier.aspx
Now if a user clicks on CreateBuilder Menu then the user must see the site map in my breadcrumb like this :
Home > Builder > Create Builder
same way for supplier :
Home > Supplier > Create Supplier
remember ( on clicking Home the page must navigates to abc.aspx)
i m want to bind asp.net menu control from database and some of static value both, i know how to bind menu from DB and also know how to static bind the data in Menu, but i want two add two static record in menu control and after that i want to bind data from DB in menu control, and than again three static record bind in menu..... i think a lot about this and finally i thought to add my static data in dataset at particular positons, but problem is that i dont know how to bind static data in dataset at particular 1st 2nd and 4th,5th,6th pos.
View 1 RepliesIn my project i have a navigation bar which shows the different types of recipes e.g: Healthy Recipes, Desserts, etc...
In the same page i have a gridview which is binded by database (RecipeTable) to show the list of recipes available.
My problem is how should i bind gridview with the navigation bar selection.
e.g: when a user clicks on Healthy Recipe the gridview should show the recipes saved under healthy recipes type.
i m using Datalist control on that i have one section as a "Qty" which come from database .now how i can pass two values in <asp:parameter from database
look at my code
<asp:Parameter DefaultValue="<%#DataBinder.Eval(Container.DataItem, "ItemID")%>"Name="mItemNo" Type="String" />
if i write anywhere in datalist then it worlks , but not in this DefaultValue parameter , coz whenever that datalist item get bound one by one row then DefaultValue may get change and depend on that Default value my Quantity section also get changenx
I am new to asp.net (I may use some incorrect termology while I explain my issue...) and need some help with DropDownList in Gridview. Currently I have a GridView set up with three Columns bound to a database: Column1 - some kinda of index, Column2 - string, Column3 - DropDownList(called Active). So far when I build the page, all the columns show up and the DropDownList appears and the values are bound correctly. I want to change a value in the DropDownList and automatically update that value in my database.
I have set AutoPostBack = true and I made a DataObject (called UpdateActive) to update the database (it takes 2 inputs, the Column1 index and Column3 DropDownList value).However, I don't know how to find the row that I am changing, is there a way to figure out what row it is (like finding the Column 1 index?). Also, I don't want to have to click a button to update the data.
[Code]....
I am trying to get value from the databse and assign it to the label using the below line:
lblQuestion.Text = ds.Tables[0].Rows[0]["Question"].ToString();
but it assigns as label.
if (ds.Tables[0].Rows.Count > 0)
{
lblQuestion.Text = ds.Tables[0].Rows[0]["Question"].ToString(); ;
}
i m developing web application in asp.net .Trying to deploy it.i m doing first time.I have uploaded my folder on plesk.But now hot to connect with database?How to connect physical server to database server on plesk 9.5?
View 3 RepliesI'm using Visual Web Developer 2010 Express with SQL server 2008 Express and I'm wondering if it is possible to query the database from within a VB subroutine located within pagename.aspx.vb, rather than just using the asp databound controls on the main page ?
I want to do something like this in the page load routine:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim username As String
username = GetUserName() 'calls function to get current username
Now connect to database and perform SQL command (SELECT FirstName FROM dbo.USERS WHERE UserName = username)
Assign the retuned data to a label: lblFirstName.Text
End Sub
Is it possible ?
here is my function
Public Shared Function GetData(ByVal strQuery As String) As DataTable
Dim dt As New DataTable
Dim cmd As New OracleCommand(strQuery, conn)
cmd.CommandType = CommandType.Text
Try
conn.Open()
da.SelectCommand = cmd
[Code]....
here im calling above GetData function
[Code]....
it is not accepting date i was try to use CDate(BDPLite2.SelectedDate) also but not working but when i use store procedure then this cdate method work but when i use inline code then no work....plz let me know where im doing mistake.
i want to get data from my database and dispaly it in my web page using json with webservicei'm going to post my code i create a webservice and add method which return string to get all data so my code like this
[Code]....
and in my page
[Code]....
I have two tables in my database
using "innerconnect" i have show table content in grid view as INV_NO INV_DT DN_NO DN_DT LR_NO LR_DT .
where LR_NO is null .
I want to update it from grid view.
here DN_NO and INV_NO are primary keys
[Code].....
when i have fill the null values through grid view and click on button1 it shows data saved but it not saves to my data base tables
I have inherited a very old SQL Server Database for a live site, but have been asked to add a new table for invoice recording to it. Fairly easy to do for any new record added from now on, however I run into some issues with selecting older records.I need to find a way to select from 3 tables, see if a record exists in the new table and if not insert a new record to it.My stored procedue so far is (The new table is [Invoicing]:
[Code]....
I am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.
this is my page view
[Code]....
This my vb code
I want to list all images in a horizintal way form the database where the id = number.ASP.NET, C#, SQL Server.
View 2 RepliesI have button, which fires an event, that deletes a record from the database. This is the source of the button:
<asp:Button ID="btnDelete" runat="server" Text="Delete" onclick="btnDelete_Click" />
But how can I make a confirm box appear before the deletion?
I have been asked to develop an ASP.Net application which will directly connect (store and retrieve) to the ACT! databse already functional. I am new to ACT and looking for a starting point to integrate it with ASP.Net application. In particular I am looking for answers to the following questions:1. What database technology is used by ACT? Is SQL Server? In that case, I should be able to connect just like any SQL Server database?2. Is there any class library or API for .Net from ACT which will help achieve this?3.
View 1 RepliesI have a bunch of controls like the following in the EditItemTemplate of a ListView, with LINQDataSource:
[Code]....
I'm curious to know why the database won't update on the click of the Update button:
[Code]....
According to all I've read, the above code should be sufficient. Since CommandName is set to Update, it would seem that no code-behind is necessary.
Is there a way to add/delete/update the default classes (for instance AspNet-Menu-WithChildren,AspNet-Menu-NonLink ) of the html generated by the asp.net menu or treeview control? I am using CSSAdapters so the menu control renders in a list format instead of table format.
View 1 RepliesCurrently I have a menu control on my webform in ASP.Net 4.0 :
<div class="PNMenu">
<asp:SiteMapDataSource ID="PNSiteMap" runat="server" ShowStartingNode="false" />
<asp:Menu ID="PNMainMenu" runat="server" DataSourceID="PNSiteMap" RenderingMode="List" Orientation="Horizontal" CssClass="PN-PrimaryNavMenu" >
</asp:Menu>
</div>
I am trying to style the menu control to allow the menu items to float to the right of the container, however I am unable to do so as whenever I am styling the a, ul or li it keeps getting overidded by asp.net and floats everything left.
.PNMenu
{
clear:both;
[code]...