using vs2008 writing a asp.net.vb application. I have a datasource on my asp page wich is connected to a gridview. I want to use a cookie value as an input parameter to a stored procedure whose ouput will populate the gridview.
View 7 RepliesI have a datasource with parameters for the SELECT clause and I want to use an asp:CookieParameter but my cookie has several subkeys. For example, the main cookie is named "teres_soft" and the subkey I want to use is "branch_code" so I get this value using a Request.Cookie("teres_soft")("branch_code"). I can easily set such a parameter if my cookie does not have any subkeys but, is it possible to use a cookie's subkey in the SELECT asp:CookieParameter?
View 1 Repliesasp:querystringparameter assign value how to ...
View 1 RepliesHow do you use the http POST method with a Grid View on another page. I am trying to use the POST method to send the ID from the selected row of a Grid View, I am using a link button set to fire the select command and it has the Post Back URL set, from one page and then retrieve the ID value on another page using an Object Data Source. Also, under the Defining Parameters, I am setting the ID parameter to Form Parameter Source and have entered the Grid Views name in the Form Field.
View 4 RepliesI am busy building a shopping cart with cookies. I have datalist which I populate from the cookies with a delete button next to each cookie
[Code]....
Now the problem is that when I hit the delete / remove button to expire the cookie, what happens when repopulating the datalist is that it shows the original cookie with all it's values as well as a new entry where all the values are blank.
I want to change the value in a cookie:
HttpCookie hc = new HttpCookie("HiddenColumns");
hc.Value = customView.HiddenFields;
hc.Expires = DateTime.Now.AddDays(365);
Response.SetCookie(hc);
Or this way:
Response.Cookies["HiddenColumns"].Value = customView.HiddenFields;;
Response.Cookies["HiddenColumns"].Expires = DateTime.Now.AddDays(365);
But when I retrieve the cookie value, it is still old, unless I do postback. I don't want to use Redirect.
I Have an InsertTemplat in FormView that has a DD List.
I also have an Insert Parameter in a SQLDataSource that tries to reference it but can't.
Is my only solution to use event code to move the data to the SQL Parameters?
[Code]....
I have an objectdatasource that accepts 1 parameter and fills a Gridview control.
Above this I have a details view control. Within one of the template fields I have placed a button. I have some code that captures this event.
What I'm trying to do is when a user clicks the button I would like to pass the contents of textbox (also held within the same template field) back into the SQL and refresh the Gridview control.
My ultimate goal is to allow the user to then edit the contents of the Gridview control.
I'm trying to use a webservice that first expects the clients to login, to retrieve a cookie to re-use.
This is done through a login(string user, string pass) method on the webservice.
Doing this through a browser works fine, we get a cookie, and we can see the cookie via Fiddler or whatvever proxysniff thingy.
Time to do the same in ASP.Net, so we use the WSDL and generate a nice proxy class, and it works fine to call the login() method, but Never Ever does a cookie get set !
I already used the "cookiejar" technique - which means i create an instance of a CookieContainer and assign it to the proxyclass like this;
var cookies = new CookieContainer(3);
i am passing two parameter in javascript and open popup window.... but geeting mid value "undefined" here is my code:
<asp:TemplateField HeaderText="comments">
<ItemTemplate>
<a href="javascript:replycomments('<%# Eval("projectid")%>'),('<%# Eval("milestoneserial")%>')">Reply comments</a>
</ItemTemplate>
</asp:TemplateField>
and
function replycomments(id,mid)
{
window.open("replymilestone.aspx?id="+id+"&mid="+mid,"mypage","width=400,height=500,scrollbars=0,menu=0","");
}
this is working fine if i am passing single value like:
<asp:TemplateField HeaderText="comments">
<ItemTemplate>
<a href="javascript:replycomments('<%# Eval("projectid")%>')">Reply comments</a>
</ItemTemplate>
</asp:TemplateField>
and
function replycomments(id)
{
window.open("replymilestone.aspx?id="+id,"mypage","width=400,height=500,scrollbars=0,menu=0","");
}
WHEN I USE IS NULL VALUE DIRECTLY INTO MY QUERY IT WORKS GREAT BUT WHEN I TRY TO ASSIGN IS NULL VALUE FROM A PARAMETER ITS WORKING BUT NO ROW RETURN.MY SP LOOK LIKE THISITS WORKING
AND Profile.MarketID IS NULL
AND Profile.SourceID IS NULL
AND Profile.NationalID IS NULL
AND Profile.CRMLanguagesID IS NULL
AND Profile.MarketID LIKE @PMarketID
AND Profile.SourceID LIKE @PSourceID
AND Profile.NationalID LIKE @PNationalID
AND Profile.CRMLanguagesID @CRMLanguagesID
I am trying to use the datadesigner for a project I normally have written the datalayer by hand seems to me you have much more control over whats going on , however , I am starting a project which is going to have the datalayer done in the data designer but I cannot get past the most basic of tasks .Parameter name: Original_LastName
[ArgumentNullException: Value cannot be null.Parameter name: Original_LastName] DAL.northwindTableAdapters.EmployeesTableAdapter.Update(String LastName, String FirstName, String Title, String TitleOfCourtesy, Nullable`1 BirthDate, Nullable`1 HireDate, String Address, String City, String Area, String PostalCode, String Country, String HomePhone, String Extension, Byte[] Photo, String Notes, Nullable`1 ReportsTo, String PhotoPath, String test, Int32 Original_EmployeeID, String Original_LastName, String Original_FirstName, String Original_Title, String Original_TitleOfCourtesy, Nullable`1 Original_BirthDate, Nullable`1 Original_HireDate, String Original_Address, String Original_City, String Original_Area, String Original_PostalCode, String Original_Country, String Original_HomePhone, String Original_Extension, Nullable`1 Original_ReportsTo, String Original_PhotoPath, String Original_test, Int32 EmployeeID) in C:Users
[code]...
I am facing a small issue in using a DropDownList that has only two values (AND and OR) which i want to use to configure a SQL Query in a SqlDataSource. How can i use this thing by passing the value in a SqlDataSource Select Query in such a way to Bind the Result to a GridView. I want something like this -
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen @Option InvoiceNo = @invoiceno where @Namen is from a DropDownList and InvoiceNo is from a TextBox
I m having a problem in specifying this @Option parameter from a DropDownList which contains only two list items - AND and OR. On the Basis of the Selected Value from this DropDownList i want to execute query like
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen AND InvoiceNo = @invoiceno
or
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen OR InvoiceNo = @invoiceno
Using the Query with @Option gives me a Parsing Error. Why is that so. How can I implement this scenario.
How do I set a select parameter from a value in a DetailsView?
View 6 RepliesI have a problouw with a listview connected to a object datasource, when I try to edit a record and hit the save button without changing anything I got a error : Cannot convert value of parameter 'BirthDate' from 'System.String' to 'System.DateTime' The birthdatevalue is presented in a masked textbox, my data access layer is not reached so the error is in the listview itself How can I edit date values in a listview?
View 1 RepliesI am trying to pass a URL parameter to a web page that contains a Gridview to make that query dynamic
The URL is http://localhost:3036/people2.aspx?ArvDate=01/03/2011
I would like to add that parameter to the Select statement below (bolded)
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlConnection %>"
SelectCommand="SELECT NumPeople, Date1,Time1,Venue FROM People_Count WHERE Date1=XXXXXXXXXX and c
I already have this code to capture from the URL
Dim strPar As String
strPar = Request.QueryString.Item("ArvDate")
If strPar = "" Then strPar = DateTime.Now.ToString("d") [code]....
I just don't know the syntax to get it in that SQL Select statement
I have a listview that has a hiddenField in the ItemTemplate. I want to pass this hidden control as control parameter when inserting a new record.but i get the errorCould not find control 'hiddenFieldID' in ControlParameter 'ID'.I also tried to access it in the ItemCommand event of the list view but it returns null.
<ItemTemplate>
<asp:HiddenField ID="hiddenFieldID" runat="server" Value='<%# Eval("reviewID") %>' />
</ItemTemplate>
[code]...
I have grid view and i want to pass parameter value for it from where clause...
my parameter value is not control, or session or cookie.its a variable ...how can i pass this variable to grid view parameter?
I have a DDL in templatefield of a details view. Its datasource pulls its parameter from a session field which is boolean. I've placed another DDL on the page that changes the session boolean in order to change the data displayed in the DDL in the template field. Whenevr I do this I get an error that states:"There is no source code for the current location."And when I click okay I get:"Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."Here is my code:
[Code]....
and
[Code]....
[Code]....
in asp.net how to fill a dropdown using stored procedure,the sp has one input parameter.
View 4 RepliesHiI am trying to send null value from my combobox and check it if its null in sp.
IF @Param1 IS NOT NULL
BEGIN
SET @Param1=@Param1
END
ELSE
BEGIN
SET @Param1=' IS NULL'
END
mmsDataContext mms = new mmsDataContext();
RadGrid1.DataSource = mms.SON(Country.SelectedItem.Value);
RadGrid1.DataBind();
I have a [Code]....
with showing all A table C column.
[Code]....
My A table has two column.
B-->Primary Key
C--> Every C has a unique B.
I have an SQL like this for my Gridview Source;
[Code]....
Something like that. My SQL syntax isn't very well. I hope i can tell what i want..
What REALLY want is, When i click a button, showing in Gridview with second SQL , BUT only i selected in CheckBoxList.
Is there any way adding to parameter in SQL? How can i do that?
When a gridview is rendered, its RowCreated event is called. When it is called, what is contained in the second parameter which is of type System.Web.UI.WebControls.GridViewRowEventArgs ?Means, which type of information can we get from that ?
View 2 Repliesi m using Datalist control on that i have one section as a "Qty" which come from database .now how i can pass two values in <asp:parameter from database
look at my code
<asp:Parameter DefaultValue="<%#DataBinder.Eval(Container.DataItem, "ItemID")%>"Name="mItemNo" Type="String" />
if i write anywhere in datalist then it worlks , but not in this DefaultValue parameter , coz whenever that datalist item get bound one by one row then DefaultValue may get change and depend on that Default value my Quantity section also get changenx
here's my url: http://nathan/mail/incomingmail.aspx?dc=8250&bg=-617370170
gridview code:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px"
CellPadding="4" DataSourceID="SqlDataSource1" [code]...