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..
Does record locking (Pessimistic and Optimistic Locking) is applicable in ASP.NET application? If so, What is the pros and cons on doing this?
View 3 RepliesI 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 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 Repliesi 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]....
In a multiuser asp.net web application that performs CRUD functions, how is a record in a listview control "greyed" out while someone else is making changes or would you consider I need a custom asp.net control,
View 1 RepliesI have a nested gridview on my page, I have to apply sorting on that grid and wants the header to be locked. Means when I scroll the grid the header should be visible all the time.I have mousehover and onclick event applied on this grid. Whenevr I try to apply some code to fix the header, it results in detaching of header and moves up the screen on every scroll.
View 1 RepliesI 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 use the app_offline.htm file to bring my site down when I have to roll a new revision. However, even after I launch I'd like to be able to play around and test my site before anyone else has access. Since almost all of my pages are available without logging in, I need to way to lock down my application to everyone but myself and obviously the app_offline.htm file won't for for this.
I have a BasePage class and I'm thinking the only way to do this would be to put code in that class's Page_Init method and I could check for my specific IP address and kick everyone whose IP doesn't match to the app_offline.htm file. However, I'm wondering if this would be the best method since my IP will change.
I'm about to begin a new web project using asp.net 4.0 (EF 2.0). I have a question on row locking...customer is concerned that if employee 1 has a record in edit mode, they want to lock the row and make it uneditable for other users, until employee 1 has saved their changes. A step further is, if employee #2 attempts to edit the locked record, a notification would appear, notifying employee #2 that "Employee #1 John Doe" has the record locked and to contact them.
View 4 RepliesI 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'm using a 3rd party web service in my ASP.NET application. Calls to the 3rd party web service have to be synchronized, but ASP.NET is obviously multi-threaded and multiple page requests could be made that result in simultaneous calls to the 3rd party web service. Calls to the web service are encapsulated in a custom object. My thought is to store the object in an application variable and use the C# lock keyword to force synchronized use of it.
I'm nervous, because I'm new to multi threaded concepts and I've read that you shouldn't lock a public object (which my application variable effectively is). I've also read that if the locked block of code fails (which it could if the web service fails), then it could destabilize the app domain and bring down the application.I should mention that the 3rd party web service is rarely used in my website and it's going to be rare that 2 requests to it are made at the same time.Here's a rough code sample of how I'd make calls to the web service:
ThirdPartWebService objWebService = Application["ThirdPartWebService"] As ThirdPartWebService;
lock (objWebService)
{
objWebService.CallThatNeedsToBeSynchronized();
}
I have an ASP.NET MVC website that uses an internal dll for some PInvoke stuff. The dll is located in the /bin folder next to the other assemblies. This works well, but if I want to replace the content of the /bin folder with the newest set of files by copying onto the existing files (this is on a test server) the PInvoke dll is locked/used by the w3wp.exe worker process and cannot be replaced except after you recycle the apppool or restart IIS.
Is this standard behavior or can I somehow instruct the ASP.NET runtime to take a shadow copy of the PInvoke dll similar to the regular assemblies?
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 multiple database running in my SQL Sever , in that I need to lock only one database is there is any inbuilt method in SQL Server 2008
View 1 RepliesI'm working on locking down some MySQL user accounts. At the moment I typically grant my user accounts execute privileges over the required stored procedures within a schema.Now I'm looking at the proc table in the mysql schema. The common wisdom that's quoted many times on various websites says "Stored procedures require the presence of the proc table in the mysql schema".By granting select access over the proc table stored procedures will work. But if I removed the above select privilege and grant the user execute privilege over the entire mysql schema the procedure will also work.
Does anyone have any ideas about the security issues by choosing one of the above over another?I would prefer to lock the proc table down all together so the user cannot see it cannot select from it.