I'm passing several variables thru the URL and want to use them in several SQL Queries that I want in my asp page. For example one of the (hypotetichal) is client_id and i want to use it in a query to gather other information.
View 1 RepliesI have gotten alot of help lately on my project and think I only have one more issue that I can't think of how to do. What i'd like to do is pass a login name and password from a Login.asp page to all of my other pages. So for instance if I have a successful login, I am taken to the Home.asp page. But i'm not sure how I can pass the LoginID used from Login.asp to the Home page. Ideally i'd like to use this information in the SQL connection strings, and to customize the Home page to show orders assigned to certain people that are logged in.
View 22 RepliesI'm trying to pass some variables from one page to another via the session state and then post those variables to labels on page 2. When I try to write the code for my labels on page2, I get an error of "Declaration expected"Here is my code from that page:
Partial Class Default2
Inherits System.Web.UI.Page
Dim firstname As String = CType(Session.Item("FirstName"), String)
[code]...
Am I missing a page_load event handler or what am I missing?
I have a search page which generates a GridView of results based on the search terms entered by the user. One of the columns in GridView is called a DOI (Document Object Itentifier). This DOI is used to find academic papers through [URL] when a user enters a DOI string. What I would like to do is redirect the user to the relevant webpage when they have selected the DOI in the GridView, however, the url for this page is always different. In the page, I have formatted the form tag like so: [URL] and in my GridView, I have formatted the row that I wish to have hyperlinked like so:
<asp:ButtonField DataTextField="DOI" HeaderText="DOI" CommandName="d"/>
Then, in my C# codebehind, I have the following event which aims to redirect the user to the required page, based on the tag they have selected:
switch (e.CommandName)
{
case "d":
searchResult.Attributes.Add("onchange", "window.open [URL]
break;
}
I don't think this code above makes any difference though as the form tag is already specifying the redirected url, nor do I think this task can be done with a html <table> object, as it only accepts static data, rather than a result set generated from a database, which is what I'm doing. I have also looked at the following post as a guide to this type of problem but, taking account of what it said didn't allow me to solve this problem completely. GridView with DDL and selected value
Function RenderTips(ByRef passTipName As String, ByRef passYear As String, ByRef passTipNumber As String) As String
View 10 RepliesIm having problems passing a variable from my c# code behind into my asp as part of a connection string. how do i go about passing in a variable from my code behind into my asp.
View 4 RepliesI am writing what i will call a survey system. The surveys will consist of a series of questions, split into sections. The survey definitions will be stored in a database. The questions can be of various types, that have different input methods and validation (e.g.textbox, numeric textbox, selectlist etc.) I am creating a set of user controls that map to different question types. I would like to completely abstract the survey rendering logic from the, survey definition logic. The way i thought i would do this is to use a dumb rendering control that simply takes a collection of controls and renders them out in a for each loop a super simplified version of what I am doing.
private void RenderControls()
{
foreach (UserControl CurrentControl in this.ControlsToRender)
{
MyPlaceholder.Controls.Add(CurrentControl)
}
}
This works in the sense that the correct controls get added to the place holder,however nothing renders. Presumably this is because it does not have the markup in the asxc file.
If i do something like this
private void RenderControls()
{
foreach (UserControl CurrentControl in this.ControlsToRender)
{
MyPlaceholder.Controls.Add(this.LoadControl("path to ascx file")
}
}
It will create the correct number of controls, but i don't want to instantiate the controls here because i would need to to set various properties based on cconditional logic i want to abstract away from this pure rendering layer.
what i want to do is instantiate the controls else where, set the relevant properties and then simply pass a collection of these into the rendering control to render out.
Is there a way to do this with user controls? Would i have to create custom controls instead?
I am trying to pass multiple variables between pages....
Page1.aspx (sending page)
Dim StrValue1 As String
Dim StrValue2 As String
StrValue1='ASSIGN A VALUE......
This does not work correctly. Page2.aspx is recieveing Value1 correctly but not Value2. I dont think I have the correct syntax...
Have tried the redirect with an ampersand in the middle but that does not work either...
Response.Redirect("Page2.aspx?Value1=" & Value1 & "&?Value2=" & Value2)
VS2010/VB/ASP.NET 4.0 If an error occurs in an ASP app you can redirect it to a default page which is defined in the web.config file How can you pass the variables (URL) to the error webpage then to a logfile or sent via an e-mail address?
Example: 404 Error
- Page hosting the link
- URL
- Search (if applicable)
I have an asp:hyperlink that links to an iframe. I have set the navigateUrl to the iframe page would also like to pass a variable through to the iframe depending on what button is clicked.
View 1 RepliesI need to pass variables from a script to another with POST , Not GET , and without a form ( i must do it literally )
there is the Response.AddHeader(name,value) function
then the response.redirect
But then i think the variable field has no name ( after the content lenght header ).
Is there a way to assign/pass/copy a javascript variable to a server side variable in C#? For the sake of argument, let's say that I was able to parse some JSON for variables that I want to store and assign them on the client (ie. var = FirstName and var = 25 and var = someDateTime, etc) .
View 4 RepliesI am having troubles making the code run. I have a web page with a gridview and a checkbox. I would like the button when selected to pass the category id. I have managed to get it work without paging. Once the paging kicks in see below, I am unable to run the code. see below.
In the design: ASPX
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL]">
<html xmlns="[URL]">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BorderStyle="Solid" CellPadding="4" DataKeyNames="Categoryid"
BorderColor="Silver" BorderWidth="1px" Width="300px"
DataSourceID="SqlDataSource1" AllowPaging="True" PageSize="3" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:BoundField DataField="Categoryid" HeaderText="Categoryid"
InsertVisible="False" ReadOnly="True" SortExpression="Categoryid" />
<asp:BoundField DataField="Category" HeaderText="Category"
SortExpression="Category" />
<asp:TemplateField HeaderText="Categories" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:CheckBox ID="chk1" runat="server"
Text='1' />
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:TemplateField>
<asp:TemplateField HeaderText="Hidden" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:HiddenField ID="hiddenCatIDs" runat="server" />
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:TemplateField>
</Columns> <HeaderStyle HorizontalAlign="Left" BackColor="#f0f0f0" />
<PagerSettings PageButtonCount="3" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [Categoryid], [Category] FROM [Category]">
</asp:SqlDataSource>
</div>
<asp:Button ID="Button1" runat="server" Text="Button" />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<div>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
In the ASPX.VB
[Code]....
I am designing a page for my students to practice their Latin vocabulary. I am having two problems with the design: 1) working with checkboxes, and 2) display one returned row at a time. 1) First, students select from CheckListBox1 those parts of speech (nouns, verbs, adjectives, etc.) they want to review, and then they click Button1 ("Submit"), which fires off a SELECT statement against a table named CoreVocab in a SQLEXPRESS database. How do I pass each selected part of speech from CheckListBox1 as a variable into the WHERE statement when the user clicks Button1? Do I place this code in the Button1_Click on the .cs page?
2) the table returns the first row and Button1 changes to "Next," which the student then clicks to see the next Latin word. How do I get the Repeater table to show only one row at time until the Next button is clicked? And how do I get the same button to executed two functions (fire off the SELECT statement and then show the next row)? For what it's worth, I'm using the SqlDataReader command, since data will only be retrieved, not modified.
I have a SQL Server 2000 table that has an insert trigger that e-mails the user when a record is inserted for them. i want to include a link to a page that will disply a list (datagrid) of their records only. What is the best way to do this? The trigger is already completed and currently includes a link that displays all records but I want to be able to narrow that based on the user.
View 1 RepliesFirst up i would like to apoligize for these questions that are proable realy easy. I have been put on the spot by my boss and have been told to change all my php to asp.net c so it can go in this new cms i have at work. I have just spent the last 18 hours trying to get this to work and im geting a little desperate.
Ok so my current issue is that i dont know how to add html formating to a result string i pull out of my mysql database. I have my result sheet pulling into a gridview, what i want to do is put some information drawn from each row in the gridview out side of the <Tr> tag. Is this possible? But within the Table Tag second issue is it possiple to feed data into a page and then run a mysql query like i was doing in php.
I'm fairly new to MVC and admittedly don't fully understand how data is passed between Views and Controllers. That said, here is my issue.
I am working with C#. I have a page which has a list of items. Each item has a radio button set of three associated with it and there are 15 of these sets on the page. Thus I have radio1, radio2....radio15, etc. Each of these has value 0, 1, or 2 upon submit. I can't seem to understand how to get the information out of these radio button sets from the controller without passing 15 different variables to the post method in the controller which is associated with the view; ie passing Int32 radio1, Int32
radio2,.., Int32 radio15, etc.
I tried using ViewData["radio"+i] in a loop to access the value of each radio button set, but this, apparently can only be used to pass data to the View from the Controller and not the other way around.
I have a datalist control that is querying a accessdatasource for information that populates the results based on w/e is typed in a textbox. I can't figure out how to pass the information that is populated in the datalist to another page when a button is clicked (inside the datalist item template).
I was able to peform this in Detailsview with a hyperlink using the following arguments:
DataNavigateUrlFieldsDataNavigateUrlFormatStringBut this seems not to exist in Detailsview. Could someone point me in a direction on how to acomplish this?
I'm having problem on passing parameter on odbc because it's not working at all. I tried this using sql and I have no problem at all. All are working fine. Is there a different syntax on odbc? Here's my code:
[Code]....
Or using mysql connector/net to use mysql. I'm having problem installing it because the visual studio integration is not working, so I can't find it on the data source provider.
(1) SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.CO FROM V_HIERARCHY1 a
(2) and Data is
HR HR Rec Records Leave Leave Records HRL.0001 Policy and Process for leave record. 27.06.2010 30.06.2010 WIP Edlink
HR HR Rec Records Leave Leave Records HRL.0002 Quarterly Review 01.07.2010 04.07.2010 Planned Edlink
HR HR DB Database SAL Salary DDS.0001 Calculation of Monthly salary 08.08.2010 09.08.2010 WIP Edlink
HR HR Rec Records Ind Induction Records HRI.0001 Completion of dossiers. 08.07.2010 10.07.2010 WIP Edlink
HR HR DB Database Emp Employee HDE.0001 Offer letter 06.07.2010 09.07.2010 WIP Edlink
IT Info Tech SW Software ERP.Web Web based ERP ISE.0001 Version 1 10.07.2010 12.07.2010 Overdue Edlink
I need to pass many records with number of fields(i.e 5rows and 5 columns) in either array or table form to oracle for processing. Is it possible to pass array/table from asp.net pages? If no, any solutions for this? I have been thinking of passing it as string concatenated with delimiter and split it. Seems like it is not appropriate as i have to pass 5 strings(5rows)
View 2 RepliesI get an error while passing Parameters, This is my code, OracleHelper
public static int ExecuteNonQuery(OracleConnection connection, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, connection, (OracleTransaction)null, commandType, commandText, commandParameters);
return cmd.ExecuteNonQuery();
}
My Code
DataWrapper.ExecuteNonQuery(connection, CommandType.Text, "Insert into sample values(@id,@name)",new OracleParameter("@id",OracleType.Int32,Int32.Parse(TextBox1.Text)),new OracleParameter("@name",TextBox2.Text.ToString()));
while executing i get this error ! ORA-01036: illegal variable name/number
I need to access a variable that is declared in a master page to a child page. I'm using asp.net 2.0 (vb). I'm sure this should be easy and is down to my inexperience with asp.net! A rough guide to my code is below;
MASTER PAGE
<%@ Master Language="VB" CodeFile="MasterPage.master.vb" Inherits="MasterPage" %>
<script runat="server">
Public UserNumber As Integer = 3
End Sub
</script>
CHILD PAGE
<%@ Master Language="VB" CodeFile="MasterPage.master.vb" Inherits="MasterPage" %>
I have a page wich opens a popup window. I want to pass some variables, like some textbox.text and 2 dataTables from parent window to the popup window. And then I'll have to return some vars from popup window to parent window. So what is the best way to do this,
1) using Sessions("")
or
2)passing the variables as parameteres:
LinkButton1.Attributes.Add("onclick", "window.open('popup.aspx?field1=" & value1 & "&field2=" & value2 & ......
I don't know if it's appropiated passing 8 or 10 variables as the option2 because the user will see a very long url with all the variables, but maybe is more efficient than using Sessions.... Anyway, could somebody clear me up?
I have 2 sites, one the main product site the other a secure site featuring the basket and checkout processes.
When a user clicks "add item to basket" I am creating a basket in a database and then adding the items to the basket. The theory was then to store the id from the database for the basket (the basketid) in a cookie, redirect the user to secure site, use the basket id from the cookie and display the contents in the basket.
However I am having trouble getting the secure site to use the same cookie. When I redirect the users to the secure site, the basket appears empty. I need to go back to the main site and then back to secure before the cookie appears.
Here is the code for the cookie
[Code]....
And then on the secure site this is how it gets the basket ID from the cookie
[Code]....
But like I say it's having problems. I've tried replacing the cookies with session variables as well but it didn't work.