I am trying to use this query in a form view "Select * from actions where emp_id = " & session("emp_id") for the select command. This is the format I am used to in classic asp. How can I acheive the same results in asp.net.
View 2 RepliesI am trying to use this query in a form view "Select * from actions where emp_id = " & session("emp_id") for the select command. This is the format I am used to in classic asp. How can I acheive the same results in asp.net.
View 2 Repliescan we grab a global variable or Session or View State variable in the javascript or using jquery?
I'm creating a session variable in my .vb file and I'm able to display it in my .aspx but I can't seem to use it as a control in my asp:CompareValidator. The only way I can think to reference it on the .aspx page is with <%=Session("MyVariable") %> but
such constructs are not allowed in a validator with runat="server". But it seems like the validator must have that attribute and value.
Really what I'm trying to do is validate a user-entered number in a textbox against the one populated in that same textbox from the database. If the user replaces the textbox value with a smaller one I want to show an error message and prevent submit.
I am using a from view for data entry. I need to verify that a check box is true or false after editing a record.
I have been accessing label text using the following|
CType(FormView1.FindControl("RespDeptLabel"), Label).Text
How can I access the state of a checkbox in the form view to determine if it is true or false
I need to get the value from a field in a GridView and and set that to a Session variable, however, it does not seem to be working...
Here is what I have:[Code]....
I am getting System.NullReferenceException: Object reference not set to an instance of an object.
I have a page with 2 dropdown menus and 2 datagrids.
The datagrids get populated by a database based on a dropdown menu slection.
This page links to another page which in turn links back to the original.
If the user leaves the first page and then returns back I want to keep the dropdown menus and datagrids populated.
I tried doing this with session variables but can't get the datagrids to stay populated ...
[Code]....
Is it possible to use a session variable in the markup aspx page ?
Cause I have a gridview that use an sqldatasource and in the UpdateCommand I want to include a the session variable : session("username").
Ex :
UpdateCommand="UPDATE departments SET DEP_name = @DEP_name, DEP_active = @DEP_active, DEP_date_stamp = CONVERT (CHAR(8), GETDATE(), 112) + ' ' + CONVERT (VARCHAR(8), GETDATE(), 108),
DEP_user_stamp = <% session("username") %> WHERE (DEP_mnc = @original_DEP_mnc)">
This give me an error :
Server tags cannot contain <% .... %> constructs.
I have dropdown and I have to bind that dropdown on the basis of user login so that when the page load the drop down should show only one item on the basis of user login and i may have use that dropdown item as a search parameter.I have a objectdatasource named TblFltReg having one of the fields named "Owner" which is the SectionId.
There is a table named TblSections having "SectionId" and "Description".User can be selected in a Session variable.I have another table "Users" having "UserName", "UProfile", "SectionId".Actually I dont know how can I get SectionId from Users table into Session variable.So I have two tasks: one to get SectionId into Session Variable and another is to show dropdown item on the basis of User login.Hope you understand.
How can I perform that task?
I am working with a repeater control for a reporting purpose.
I have 2 repeaters one inside another , i hvae to bind the second repeater with the help of function which is having two parameters to pass in it
<asp:Repeater
ID="Rptgsaaccount"
runat ="server"
DataSource ='<%#bindcourse(Eval("Session_Id"),2nd parameter)%>'>
the first parameter is i am easily getting from outer repeater, but the second parameter value is exist on the server side and in a session variable
i have to pass this server side session variable value in above mentioned function as a second parameter .
i want to store Session["Name"] into databse "name" column. how to do this ?
View 1 RepliesCurrently in an .aspx file, I am storing a value (filename that was created in that session) in an hidden text box. When the user clicks on the "Print" labeled Hyperlink control, it opens the file that was stored in the hidden text box control. But when the user goes to different screen (in the same session), I loose the filename value that is stored in the hidden text box control. So I would like to store the filename variable in a session variable. So that if the user leaves this .aspx file and comes back to this .aspx file I can load the value into the hidden text box from the session variable.
View 11 RepliesHow can I Change Password in windows here we don't have Sessions... In update query we need use the Sessions .....
View 1 Repliesim having difficulty with a project I'm working on. The project has many data tables however it's three that im concerned with. The tables are applicants, position applied for and positions. In one part of the project I have created a formview which inserts users to our applicants table. This is working fine however now I want the option within the formview for users to be able to select from a checkbox list the positions that they are applying for. I want to pull data from the positions table and the current formview and insert that information to the position applied for table. The primary key for "Applicants" is CSVC, PK for "Positions" Table is PositionID, Key for "Position applied for" is CSVC and PositionID.
View 5 Repliesi have create a simple form using form view...
in my form i have use DropDownList..(Id = DropDownList1)
when am trying use that dropdownlist in my cs page i can't get id..
I have a form view with a couple of text boxes on them. I want to make the text values available elsewhere on the form I have been trying
Are they any special Insert Paramters I shoud/need to use on a formView. I currently have the below datasource but when submitted it only inserts <NULLS> intot he required table.
[Code]....
The fields that aren't being inserted are already pre-populated via the following used FormViews:
[Code]....
The following works fine and is how I expect:
[Code]....
[Code]....
I want to add a formview on the page using C# code.
View 1 RepliesWith reference to the following link: [URL]
I have a column on Page1 gridview which holds Edit and Delete button.My question is how can i remove or hide the Edit and Delete button column on Page2 gridview so that the buttons are not visible?NB: The Gridview is tied to a session which was from page1. So on Page2 the buttons should not be seen...
I wrote a linq code to read from database if its value is equal to textBox that user enters.
I dont wanna show the result in Gridview,so jz I wanna use that value. The code I wrote is
var sql = from x in db.Managers
where x.M_Name == TextBox1.Text.ToString()
select x.M_Name;
in this code I'm selecting only the name that user entered in textBox
so i want to do like tis
String Name = sql.ToString();
means to store the value in string. so the problem is i can not assign the var to string.
I have using Static Variable in My project.i want Change Static variable value because of transfer the value b/w two Forums... and I want Change value at run time...provide solution
Or else Any other way transfer value b/w two forms......
I am using a "Detail View" to edit the data in my "Customer" table. The fields are "CompanyName", "ContactPerson", "StreetAddress", and "City". If I type data into the first field ("CompanyName") and then press the "tab" key, control moves to the second field "ContactPerson". However, if I type data into the first field ("CompanyName") and then press the "Enter" key, instead of control moving to the second field ("ContactPerson") the program closes the form.
Is there someway that I can control the action of the "Enter" key so that this will not happen?
Also, is there any way that I can have control move from the first field ("CompanyName") to a field other than the seconc field ("ContactPerson") if the content of the "CompanyName" field contains the value "Internal"?
I have a form that shows simple table and let the user select a row. when user select a row the record shows in a formview below the gridview. After I update the formview changes take place in database but shows in gridview ONLY the next time I load the page.
[Code]....
I have a database with a 1 to many relationship in SQL Server 2008. I have created a formview in VS2008 to insert records into the child table. However I can't set the foreign key to automatically insert this value. If I manually type in a value the insert works but I need it to pick up the fk ID automatically from the master table. How can I do this?
The master table: tblTopic has ID int auto increment primary key and the child table has ID int auto increment primary key and TopicID int allow duplicates no nulls, foreign key. I have set updates to cascade in the relationship.
My insert statement is INSERT INTO tblTopic (TopicID, Comment, SubmittedBy) VALUES (@TopicID, @Comment,@SubmittedBy). The TopicID keeps throwing the error, this is the foreign key.
This is the first time I have tried to do this, so apologies if it's really obvious but I'm on a bit of learning curve.