My pages work with a SqlDataSource and an Access Database but returns an error when I'm using a SQL Server database.
ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'sid'
[Code]....
I need to get a querystring in a select parameter
datasource.selectparameters.add("PostId", request.querystring("PostId"))
Something like that...but...i cant get the snytax right.
Encrypt request.querystring and Descrpt request.querystring
View 1 RepliesI'm running into trouble deploying an ASP.NET 4.0 web page. The error is
System.InvalidProgramException: Common Language Runtime detected an invalid program
The error occurs on IIS7 on a 64 bit Windows Server box. The same page works on IIS7 on my development box (32bit Windows 7) and in the Visual Studio Development Environment. I'm not aware of any differences in the IIS7 configuration.
I've used PEVerify to validate the dll's in the application's bin directory.
I can reproduce the problem by using an Entity Framework query to populate a DataGrid.DataSource. It is not a particularly heavy query.
what could be causing this? My next step is to try and simply the queries used.
We're trying to implement functionality that intercepts, inspects, and alters if needed data in the Request.QueryString and Request.Form collections.
Since Request.QueryString and Request.Form are readonly, is it possible to use a HttpModule to do this without Reflection or Response.Redirect?
We're thinking that we can construct a new HttpRequest, and replace the original one. Would there be any implications in doing this?
I know mocking this object is impossible without using HttpRequestWrapper, but wasn't sure whether ASP.NET sets other things beyond the constructor.
i have problem white Object datasource. i have a multi-tier Application that include common layer ,DAL Layer,business logic and persantation layerwhen i add a object datasource to my page, it bring me only common layer classes . but i want use bisuiness layer classes what do i do ?
View 1 RepliesI am trying to use curl to access 3rd party webservice, I used the following code which works well if I try it on my own linux server, the data is being sent ok, but the IIS on the 3rd party server returns an error.
$longdata is a long string of data, maybe over 1000 characters long the 3rd party has many working clients with various implementations so the problem is on my side. what do I need to add to the request in order to get this through ?
<?php
$c = curl_init();
// curl_setopt($c, CURLOPT_HTTPHEADER, array('Expect:'));
curl_setopt($c, CURLOPT_URL, 'http://XXX.com/test/index.asmx');
curl_setopt($c, CURLOPT_POST, 1);
curl_setopt($c, CURLOPT_HEADER, 1);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
$post = array('param1' => 'XXXX', "param2" => "Y", "Param3" => $long_data);
curl_setopt($c, CURLOPT_POSTFIELDS, $post);
$response = curl_exec($c);
echo $response;
/*
Response:
HTTP/1.1 100 Continue
HTTP/1.1 500 Internal Server Error
Date: Tue, 05 Apr 2011 14:11:51 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
X-AspNet-Version: 2.0.50727
Cache-Control: private
Content-Type: text/plain; charset=utf-8
Content-Length: 100
Request format is invalid: multipart/form-data; boundary=----------------------------5d738237d9e0.
*/
?>
i have 5 methods in classA. each and every methods i have open the sqlconnection and close it, instead of that is there anyway to create a sqlconnection at one time if its opened then no need to create a new connection, if its closed then we have to connect.
View 5 RepliesI'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?
In my ASP.NET application I am using a lot of ObjectDataSource controls. I want to set the following three properties globally for all ObjectDataSource controls:
EnableCaching="true"
I get the above error using this code. What am I missing?
[Code]....
[Code]....
in my page am having one dropdownlist,Textbox and Search Button.Dropdownlist consists of Problem id,Phone No,Email,CardNo. when i select any of the above and enters a related string in textbox and click on search button a gridview will appear with related details. Everything is fine. but my challange is to display this gridview in next page.. how itz possible. i think request.Querystring helps me.but i dnt know how to write dis.Here am Pasting my code. Aspx.cs
[Code]....
Aspx code:
[Code]....
I am using LINQ to SQL files in my class libray since every LINQ to SQL sources file is a seprate file and i have to set database connection string in each class library. Now, i have total 7 class libraires in my project how connection string be passed from web.onfg to LINQ file, so that i don't need to manually change the connection string. lke we did in asp.net 2.0 using connection string property in class file library.
How could we pass the same in LINQ's designer file.
I am using a Datapager in my project with a ListView control. The Datapager is set to use a querystring value Page, so that a typical URL looks like: [URL]. The problem is that the ListView throws an ugly error if the pageview is invalid (0, for example).
The error is:
Specified argument was out of the range of valid values.
Parameter name: startRowIndex
The error originates in the ListView SetPageProperties method. What is the best way to address this? Can I override the SetPageProperties method in some way, to check the startRowIndex parameter? Here's a very simple page that replicates the error: [URL]. A copy of a simple webapplication project demonstrating the error: [URL]
How can I get common columns from two intersecting datatable inside dataset?
View 2 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??
Ok forced to use IIS7.5( begin puke puke puke end) and of course nothing works. Let's take it from start.I created a project and i started IIS7 and created a new website,added the host and checked the security permissions of the folders.I saw most of the features are done automatically so thought this won't work the first time.
I looked at the application pool and changed it to use 32 bit app's (it is a vs2008 app on server 2008 64),i cannot enable isapi but i don't know if it's needed.What else,ehm,checked authentication for anonym also ip address was left to any,ah and changed the port (it's not running on 80) and also checked the binding's set to that port and also used 80 port + myport for a test and also 80 alone just to piss me off more.
Let me state here that the same application works perfect on IIS6 with just using the host i want and my port and of course changing the security.
Also the 2008 log is very useful, showing logs of 3 hours ago. So is it something i must do or the admin messed the dns redirection to this machine.
In aspx I have a querystring - www.mysite.com/enter.aspx?dest=#. When I click "enter" I go to main.aspx. I want to get this "?dest=#" in main.aspx with a request.querystring or something in javascript. I need to use the querystring in javascript in main.aspx for another action.
let me explain in detail - I have enter.aspx page that shall load with a querystring - www.mysite.com/enter.aspx?dest=#. Now when i click the Enter button on Enter.aspx page, it shall goto Main.aspx page. When main.aspx page loads i want to write small javascript in main.aspx that shall get the querystring from the previous enter.aspx page and give it an if condition. so if (request.querystring('dest=') > 0 window.open ('a1.jpg') this above code needs to be redesigned so it can work. how can i do this. i tried window.location.href.indexof('dest') , nothing happened.
(asp.net 2.0, c#) I have a page requesting a qyerystring looking like this ?test=b%E4st, %E4 is the url-encoded letter ä. I can't change how this looks and encodes since I have no access to the page doing the request.
Problem: string strTest = Request.Querystring["test"].ToString();
If I then, for instance, just Response.Write(strTest) the character ä (%E4) is broken. Displayed as a question mark. I have in my web.config the requestEncoding and responseEncoding set to utf-8. That is the way I need to have it, and I can't change that.
I've looked around for a solutions for this and the issue seems to be iso-8859-1 vs utf-8 in the querystring and url-decoding. It seems the Request.Querystring automatically url-decodes the string using the default encoding, in my case utf-8. I need it to url-decode using iso-8859-1 instead. I can achieve this by altering the web.config, but as I said earlier this is not an option.
I have tried to do this:
Encoding enc = Encoding.GetEncoding(28591);
string strTest= Request.QueryString["test"];
strTest= HttpUtility.UrlDecode(strTest, enc);
Not working, since the Request.QueryString already has url-decoded the value using utf-8.
I have url being passed to my page something like /default.apsx?id=123&user=justinIn my code I already have a request.querystring running to grab the id but I need also to grab the user how would i do this.
View 2 Replieshow can i modified the querystring?
I have capture the query string like this
qs = Request.QueryString["flag"].ToString();
and then rebuilt the query string with modified values and response.redirect(url & qs) to it
I'm passing a variable between pages and want to print the value of the variable on my page and don't particularly want to try to get into figuring out the codebehind stuff. I can't figure out the syntax. I'm trying:
Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs" Inherits="WebApplication2.WebForm2" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<script runat="server">
Request.Querystring("letter")
</script>
I know I'm passing the variable correctly because it works in a query further down the page, so I suspect I'm just not using Querystring right.
I have the following URL: /Login.aspx?ReturnUrl=Default.aspx#/mydesign
Request.QueryString["ReturnUrl"] only returns "Default.aspx".
Why doesn't it return "Default.aspx#/mydesign"?
I have vendors who are passing customers to us via an encoded URL. The problem is that Request.QueryString["FieldName"] is returning NULL on some of them and I can't fiqure out why?
For Example, one vendor is sending : http://.....ViewListing.aspx%3FListingID%3D1187721%26Source%3D6"] which returns a NULL value when Request.QueryString["ListingID"] is used.
Using Server.UrlDecode(Request.RawUrl.ToString()), however, will decode itpProperly as /ViewListing.aspx?ListingID=1187721&Source=6
How do I get the Request object to properly retrieve the values?
Anyone else have the issue where you use javascript to stuff variables into the querystring and then when you call Request.Querystring, the value is still UrlEncoded?Example, I've used a javascript function to encode the string "dBskf6fm+ac=" into the UrlEncoded string "dBskf6fm%2Bac%3D".Usually when I set a breakpoint at the call to Request.Querystring(), the value displayed is the UrlDecoded string, but in this case, the value is still UrlEncoded.
View 1 Replies