I have trouble using 2 access dbs.
From gridview i use querystringparameter "title" to open new page and show in detailsview the selected data. It get it right. In the detailsview page i want to show also data from another db wich also have "title". Since i use querstring parameter for the first data, how can use the same querystring for the second?
[Code]....
I need to find out the parent/root report when dealing with drillthrough reports, is there an easier way of doing this ? I've had no success in trying to retrieve the ReportStack from the querystring, vs.net debugger shows Nothing even though the value is set to 1.
View 1 Repliesmy Requirement is: when user clicks on search button ,i need to call a ajax post method from client side and have to access the request.querystring(to get some info of logged customer) in static web method?
Tried things:
1.unable to access the request.querystring in static web method
2.saving the request.qerystring data into viewstate/hidden filed,but unable to access non static fileds in static method?
I put a link on a datagrid that when loaded is attacehd to a url from the DB. Well when the Db holds nothing for that URl I need to be able to redirect to antoher page. Here is what I have so far. But It does not work, still using asp.net 1.1. Am i doing this correct or is there a different way.
<asp:TemplateColumn HeaderText="Fix Page">
<ItemTemplate>
<a href="<%# DataBinder.Eval(Container.DataItem, "strFilterPage") %>" target="_blank">Fix Page</a>
</ItemTemplate> [code].....
How can i use querystring for this-
Here in below code i have used querystring for sending imagename from this page to another page. Now i just want that with this imagename in also want to send span element's text with same querystring.How can i achieve this?
[Code]....
The following code works well as long as I pass a querystring value to the datalist.
Private Sub BindGrid()
Dim id As Integer = Integer.Parse(Context.Request.QueryString("id"))
Dim strConnString As String = ConfigurationManager.ConnectionStrings("Conn").ConnectionString
Using con As New SqlConnection(strConnString)
Using cmd As New SqlCommand()
cmd.CommandText = "select Id, Name from tblFiles where Id=@Id"
[Code] ......
However, the page errors with the message "Value cannot be null." if I don't pass a value. I know that DataList does not have an EmptyItem Property like a Gridview control. I do not want the page to error if I don't pass a value. Need info to deal with empty values in a datalist.
Most websites have pointed me to this code to use:
<FooterTemplate>
<asp:Label ID="lblEmpty" Text="No Result" runat="server"
Visible='<%#boolean.parse(([b]list[/b].Items.Count=0).ToString())%>'>
</asp:Label>
</FooterTemplate>
The 'list' throws an error. The error is "Too few type arguments to 'System.COllections.Generic.List". I am not sure if the code is written in C# and that is what is causing the error. It seems that it should work but I can not figure out the 'list' error.
I'm intermittently seeing this exception being thrown:
A potentially dangerous Request.QueryString value detected
However when I look in the IIS logs I can see that the request that failed has no querystring logged against it.
How could this be? Are "dangerous" query strings being stripped from the log or something?
Encrypt request.querystring and Descrpt request.querystring
View 1 RepliesIs there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
Here's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
I have a code to link to sql can anyone give me the same code for microsoft access....
try
{
int videoID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection conn = new SqlConnection("server=WEBDESIGN-PC;database=Credentials;uid=sa;pwd=Azeem;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM videopath WHERE videoID=" + videoID, conn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
FlashVideo1.VideoURL = Convert.ToString(dtr["Filepath"]);
Label1.Text = Convert.ToString(dtr["Filename"]);
conn.Close();
}
catch (Exception ex)
{
Label1.Text = Convert.ToString(ex);
}
finally
{
}
I have a url like this :
[URL]
I want to get [URL] from it . Can you tell me how can I get it ?
I use Request.QueryString["var"] to pull the value of http://test.com/test.aspx?var=test into a stringthe same thing doesn't work for test.aspx#var=testhow can I get it from that version of a querystring?
View 3 RepliesADO.NET and have a query about reading a unique data value from a table.
PHP Code:
<%@ Page Title="" Language="C#" MasterPageFile="~/Dorknozzle.master" AutoEventWireup="true" CodeFile="BlogEntry.aspx.cs" Inherits="BlogEntry" %>
<%@ Import Namespace = "System.Data.SqlClient" %>
[code]...
this is my problem
i have a link like this .
[URL]
its fine with the above link
but if we delete the querystring part page should be redirected.
[URL]
Im having problems passing a value through a querystring that is split by a '&' eg :
?value=Apples & Pears
Only the "Apples" part is being picked up by response.querystring("value"). I have other values which are split by a space eg:
?value=red shoes which I can successfully extract "red shoes".
How can I add values to querystring?
I'm trying to do this:
String currurl = HttpContext.Current.Request.RawUrl;
var querystring = HttpContext.Current.Request.QueryString.ToString();
var PrintURL = currurl + (String.IsNullOrEmpty(querystring)) ?
HttpContext.Current.Request.QueryString.Add("print", "y") : string.Empty;
But I keep getting this error:
Cannot implicitly convert type 'string' to 'bool'
all i'm trying to do is get current url and add ?pring=y to querystring
how to get the url without querystring values in asp.net?
View 1 RepliesThe first time the user navigates to my page there will be no query string in the url.
The page will display them 10 posts, and at the bottom there will be a 'next page' button that will call the same page but this time pass the page a pageNumber in a query string and the next ten posts will be displayed.
how can I detect if there is a QueryString in the url so that only when the page is called by the 'next page' button and there is a QueryString is my code exicuted?
string emailfield=txtEmail.Text.ToString();
string url = "http://localhost:3076/user/Authenticate-Users.aspx?email="+emailfield;
I want to encrypt the querystring and then decrpyt. Is there any way to do this in C#?
i wanna convert querystring like : product.aspx?productID=12345 to 12345.aspxis there a way to do a convertion like that
View 2 RepliesI have a datalist that I want to list the Products that are comming from the Querystring. It works like this: Default.aspx/?ProductID=1
I get 1 product like I want.But I want to add more products like this Default.aspx/?ProductID=1,15,25 and get three products back. How do I make that to work?
<asp:DataList ID="DataList1" runat="server">
<ItemStyle VerticalAlign="Top" />
<ItemTemplate>
<a href="../Product/Default.aspx?ProductID=<%#Eval("ProductID") %>">
[code]...
I am trying to get the QueryString value like this Request.QueryString("SYSTEM") from a UrlReferrer. I see i can use this Request.UrlReferrer.Query() but it doesn't allow me to specify the exact parameter I could parse the Query() value, but I want to know if it is possible to do something like this Request.UrlReferrer.QueryString("SYSTEM")
View 1 Repliesi want to know how to hide the values in query string in ASP.net. here i want to send the values from one page to another page through query string with out explicitly visible the values in the query string. i want the solution with the response.redirect method. example : [URL] but i wan the link is [URL] only. I dont want use Session, or cache.
View 7 RepliesI have a page that I wish to pass an ID in a querystring to another page
eg
Response.Redirect("~/Account/Login.aspx?CertificateID="+ CertificateTextBox.Text);
but the value in the CertificateTextBox is in the format of Encoding.UTF8
so it can contains character like "ZnbiS69F2g22OeupHw+Xlg=="
When the receiving page gets the QueryString
CertificateTextBox.Text = Request.QueryString["CertificateID"];
the "+" and possible other querystring chars like "?" are stripped!!
so I end up with
Request.QueryString["CertificateID"];
returning
"ZnbiS69F2g22OeupHw Xlg=="
the "+" strinpped!
Is there a way to encode these chars so they are not striped by QuesryString()or do I have to use a session variable??