I want the users to login and have the app only display their data on the main page. The login control works perfectly...it displays the data...but it displays ALL of the users records instead of just the user that is logged in. I'm still learning how to use SQL...
View 5 Replies
What I am trying is, whenever user enters his Name and Address into the textbox on the webpage, I am going to displaying it in a Gridview. Now if second member will do the same thing thing the GridView will be updated and his Name and Address will display in second row and likewise for other users. But what happened in my code is when second user will try to add his record, it remove the record of first user and add the record of second at row1. I want the record should be added one after another. below is my code
[code]...
I have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.
Here is my code:
[Code]....
I am new to NHibernate and have just started right now.I have very simple table contain Id(Int primary key and auto incremented), Name(varchar(100)), Description(varchar(100))
Here is my XML
<class name="DevelopmentStep" table="DevelopmentSteps" lazy="true">
<id name="Id" type="Int32" column="Id">
</id> [code].....
I am wanting to insert a record into a table in SQL then retrieve its key at the same time, the key is a int that is automatically generated, I read something about the '@@Identity' function, is this what I need? How could I then bind this to a label in the ASP.net page?
View 12 RepliesIn the stord procedure below. I am retreiving all the records for that 1 deal. What I want is to retrieve the most recent record hence the one with the most recent in the AddedDate field.
How can I accomplish this?
(
@DealID int)
AS
SET NOCOUNT ON
SELECT deals_Comments.CommentID, deals_Comments.AddedDate, deals_Comments.UserID, deals_Comments.AddedByEmail, deals_Comments.AddedByIP, deals_Comments.DealID, deals_Comments.Body, deals_Comments.SBody,
ROW_NUMBER() OVER (ORDER BY deals_Comments.AddedDate DESC) AS RowNum
FROM deals_Comments
WHERE deals_Comments.DealID = @DealID
I'm having a question about retrieving data. I'm using VS 2008 and I have to create a new consultation record for a patient and I've already created a database with 3 tables, which are doctor, patient and consultation.
I have 10 records saved in consultation table, and I've made a aspx form which contains a DetailsView that ask for new consultation details to be added. But I have to be able to get the doctor and patient information from the database and put in the DetailsView, then fill in the rest of the consultation details. The information entered have to be written to the database in the consultation table. But I don't know how to get doctor and patient information from database and apply them into the DetailsView so that doctor who wants to add new consultation details can select patient and doctor information from the database.
I was thinking maybe I need to do a query with insert statement and apply into the DetailView,this is the query i have:
INSERT INTO [Consultation] ([ConsultationID], [GPname], [PatientFirstName], [PatientLastName], [Height], [Weight], [IllnessDescription], [Diagnosis], [Date]) VALUES (@ConsultationID, @GPname, @PatientFirstName, @PatientLastName, @Height, @Weight, @IllnessDescription,
@Diagnosis, @Date)
as you can see, I need to get the GPname, PatientFirstName and PatientLastName from the database tables and the rest will be filled in by the doctor.
I have the edit and delete enabled in the gridview and using footer to add new record. There is a validation control on one of the fields in the footer row.When a row is in edit mode and update is clicked the validation is called for the footer row when it isn;t being used.How do I get the validation in the footer row to only validate the footer row and not the others?
View 1 RepliesI have a panel (ID=Panel1) holding a user control (ID=QuizMC)
This in turn holds a Label, Textbox and Submit button.
How do I retrieve the value entered into the textbox after postback?
P.S. I'd like a link to a resource which covers this subject (dynamically generated controls etc...).
i have an asp.net project in vs2010 i have a db and table inside the app_data folder, i have created a deployment package and have imported the package into an iis server that is installed on my local mechine.
now i get this error message while trying to preform an insertion.
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed
the connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|survey.mdf;Integrated Security=True;User Instance=True
when running it inside VS2010 it`s working fine.
Into below code which is working fine, but the last section which started from using (SqlCommand SendMailcmd ... update it as i want when the user click on the button the code take the AdsID and (QAdsEmail "the user email") and send an e-mail to user depending on QAdsEmail and inside the email create a link to URL... so the user when he receive the mail he can click on it and move to the page to edit his Ad info ...
The table where below info will store in is called "ads" and the column that's need for sending email with ad info/the E-mail part of the code below i just copy it from another part of my application ...
protected void adNewQdadsbtn_Click(object sender, EventArgs e)
{
string FileExtentio = System.IO.Path.GetExtension(RegInteFileUploadImg1.FileName);
string FileExtentio2 = System.IO.Path.GetExtension(RegInteFileUploadImg2.FileName);
string FileExtentio3 = System.IO.Path.GetExtension(RegInteFileUploadImg3.FileName);
string FileExtentio4 = System.IO.Path.GetExtension(RegInteFileUploadImg4.FileName);
string FileExtentio5 = System.IO.Path.GetExtension(RegInteFileUploadImg5.FileName);
[code]...
i need to record the screen of the user. basically what the flow is,
1). the application will capture the user's screen
2). store it on server( images)
3). convert the images in avi
4). display the avi to the end user
I am developing a Login Screen and I want to Print the name of User at the page who have login last in all users (just like Hotmail).I dont know how to do it.
View 1 RepliesI have web service on server! This service is calling from the clients applications!
Now how i can get user name and computer name of clients that using this service, for example if application from Clint1 calling this service i want to get computer name and user name of Clint1?
I need to create a public string that reflects the "Distinguished Name" of the logged in user in Active Directory. I have the ADSI Edit program open and I can see the distuished names right there and they have the information I need. But I just need my program to pull it.If someone could provide code that shows how to do this I would appreciate it. I have tried the "codeproject" but I can't find it there.
View 9 RepliesI have multiple user controls on the page that are used primarily for data entry purposes. When a product is loaded, I need to load the product data into all those user controls and retrieve data when I need to save the product. The user controls are not visible to the user directly, instead user would click on a link and the user control will open up in a modal popup.
Currently the way I'm doing this is, I've loaded all the user controls on the page in separate div controls, and showing the modal popup when the link is clicked. I'm sure loading all the user controls on the page is not a good idea. Is there a better way to handle this? I think we can show the markup using JSON with jQuery - but how can I load and retrieve the data using that?
Using C#.NET and VWD 2008 Express
I'm looking for a hand with:
When inserting, i would like to check if the record exists in the table, then if it doesn't, insert it, else either redirecting to a different page, or showing a message box saying "Record already exists" ...
I want to return only the record or records from one table "tblUserInfo" to my details control where the records are related to the currently logged in user. I have a field in the "tblUserInfo" table named "UserName" that contains the value that is displayed as the current user name when the user logs in. My connections string is located in the WebConfig file and is being recogonized by VWD as being a connteciton string.
I have the following Select statement defined and also tried to set the parameter value to pass to the select statement. Obviously I missed something:
[Code]....
I have a pre-existing app that allows me to display detailed record results from a database,and I've made a custom mod to it to limit the type of results(i.e. show me just THESE three tables instead of all tables associated with a record).I would like to make a hyperlink from the abridged version of the record to the full version of the record,but I can't for the life of me figure out how to do this!I know that the code in the .aspx file should look something akin to:
<asp:HyperLink ID="hyp1" runat="server" NavigateURL="http://server/file.aspx?d=" text="Full Report" target="_blank" />
I need to be able to insert a record ID in order to get the end-user to the appropriate results page,so I need to find a way to insert a field Record_ID at the end of that keyword string call (d=).
Any ideas of what I'm doing wrong and/or what I need to do to the code behind file?
I'm sure that this is one of those "can be done in 5 minutes" types of things once I know what I'm doing.
Having trouble with a web page and connecting to SQL DB. Basically I have a form view table connected up to a SQLDataSourceControl and what I want displayed in the form is only data that has been assigned to the user that is logged on now. I have a "ViewAll" page, which lists EVERY field, regardless of who it is assigned to, but the "MyTasks" page should only retrieve the data of the current user.
I have two tables in my DB, the "Users" table, with user data (including an ID number) - this is used again in the "Tasks" table as a foreign key called "AssignTo". Therefore if user Joe Bloggs with ID number 5 logs on, whenever someone assigns a task to him, they will select number 5 in the "Task" table, as this relates to his User ID.
We are moving some applications from Server 2003 to Server 2008R2 (IIS 7.0)
Have following code that does not seem to work on 2008:
Code:
If InStr(1, UCase(Request.ServerVariables("LOGON_USER")), "") > 0 Then
Dim Splits() As String = UCase(Request.ServerVariables("LOGON_USER")).Split(""c)
Session("@User_Id") = Splits(1) 'this will be second part
End If
We are using the 'log on' to check whether a user is authorized to an application. This working fine in 2003.
Is there an equivalent in 2008 or even better, something that works both in 2003 and 2008?
Article : Encrypt and Decrypt Username or Password stored in database
The whole thing works very well but my issue is, after entering and encrypted password how does the user then log into the database?
When a user types in his password, the typed in password will not match the ecnrypted value in the database.
So how do I decrypt what is in the database and compare with what the user typed in and then validate the user.
I'm building a user control to display detail information on a parent record. The user control will be displayed via an Ajax Modal Popup. The user control works and is displayed when expected. The problem that I'm having is that I'm not able to pass in the primary key for the parent. The control is displayed via the _ItemCommand event of a Repeater. In the markup for the user control, I explicity set the ContactId to 0 to avoid an error when the control loads (its still underdevelopment, eventually that I'll check if the value is valid).
I was assuming that I could change the property in the _ItemCommand event, but obviously its not working.In the Page_Load event this code successfully sets the ContactId property of the control. The _ItemCommand event appears to set the value. However when I set a test label on the user control to the Me.ContactId, its showing '0' as if it was never passed in.
[Code]....
I am using one datalist control for uploading multiple images.I hv used one Asp:FileUplaod Control and one button in one itemtemplate.I am using reqired field validator and regular expression validator for file upload cntrl I am assigning validation group for both of them on ItemDataBound event of my datalist so that each upload cntrl hv same validaton group as required field and regular expression validator.Now what i want to do is - i want to show my error message in validation summary which is right at the top of the page.I want one know how to write javascript that will assign validation group of my control in datalist on which i click ?
View 1 RepliesI have a page on this page I have multiple user control and one of the control is on the user control.
on a button click event I can check all the validatoin which are on the main page, but I can't apply the validation on the user control which is not on focus. On the button click even if that particualar tab is on focus , the validaiton works otherwise it just ignores it.
