|
or if you are using a form on the page, set the post method to "GET"
eg
<form method="GET">
<input name="something" type="text" value="sometext">
</input></form>
the querystring name will correspond to to the name of the inputs
for this example it would be ?something=sometext
|
|
|
|
|
For multiple use:
Pagename.aspx?Temp1=Value1?Temp2=Value2?Temp3=Value3
|
|
|
|
|
Bardy85 wrote: Pagename.aspx?Temp1=Value1?Temp2=Value2?Temp3=Value3
Should be like this
Pagename.aspx?Temp1=Value1&Temp2=Value2&Temp3=Value3
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
its not work.
the type name 'aspx' does not exist in the type 'NewScore'
this type error come.
Gayatri
|
|
|
|
|
Bardy85 wrote: Pagename.aspx?Temp1=Value1?Temp2=Value2?Temp3=Value3
Thjis is the correct way
Pagename.aspx?Temp1=Value1&Temp2=Value2&Temp3=Value3
The Developer - CEH
|
|
|
|
|
In my Project there were 3 master page.
one for login
second for Menu
third for All WebForms like NewScore.
i want Login name in all masterpages.
and when login is valid then second menu page will be open.
when we click on menu page then webform open that webform i want login name.
pls help me
its urgent.
Gayatri
|
|
|
|
|
but the very simplest way instead of using querystring u can use
Page1.aspx
session("value")="Hi"
& use this session on another page Like
Page2.aspx
TextBox1.text=session("value")
Darshana Pathak
|
|
|
|
|
hi,
I m trying to get values from three tables.
1) its has the sale id and product id
2) it has the product details based on id from 1st table,
3) it has the quantity of product being selected by the query.
My problem is I need to check the count of the product based on various sizes and if its more than 0 i need to display available else sold out.
I tried the following query.
if I remove the count it works well to get the details but If I m gonna get the count it throws error.
any suggestion where this query is wrong??
SELECT SaleProduct_tb.ProductId, Product_tb.BasePrice, Product_tb.SalePrice, Product_tb.PName, Product_tb.Image1, COUNT(ProductSizeQty.Quantity)
AS Expr1
FROM SaleProduct_tb INNER JOIN
Product_tb ON SaleProduct_tb.ProductId = Product_tb.ProductId INNER JOIN
ProductSizeQty ON Product_tb.ProductId = ProductSizeQty.ProductId
WHERE (SaleProduct_tb.SaleId = @SaleId) AND (SaleProduct_tb.CatId = @CatId) AND (SaleProduct_tb.SubCatId = @SubCatId) AND
(Product_tb.BrandId = @BrandId) ORDER BY saleProduct_tb.ProductId
after this count is found I will need to check if its more than 0 then the text should be available else not available.
any suggestion. I m using asp.net 2005
Vijay V.
Yash Softech
|
|
|
|
|
VijayVishwakarma wrote: I m using asp.net 2005
This has nothing to to do woth ASP.NET. Ask in the SQL forum.
|
|
|
|
|
please check the bottom of the question too.
I need client side way to check this value if its greater that 0 or not.
Vijay V.
Yash Softech
|
|
|
|
|
VijayVishwakarma wrote: I need client side way to check this value if its greater that 0 or not.
Are you actually being paid to do this work?
Sorry, if you don't know how to read data from a database then you really ought to consider a career change.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thanks for the suggestion but I solved it myself.
Vijay V.
Yash Softech
|
|
|
|
|
Are you seriously looking for someone to show you how to write if (value > 0) then...?
|
|
|
|
|
I was trying something like this.
It was giving error.
0 ? "Still Available" : "Not Available"%>]]>
Vijay V.
Yash Softech
|
|
|
|
|
Hi all,
I have many pages in my website. as follows
I want to rewrite the url as follows
http://www.test.com/site/jewelrycategory.aspx?iCategoryId=1&minPrice=500&maxPrice=1000&strOption=G
As
http://www.test.com/jewelry/
-----------------------
http://www.test.com/site/certified-wholesale-diamonds-diamondsearch.aspx?iCategoryId=3
As
http://www.test.com/diamonds/signature-diamonds.aspx
Pls help.
Thanks
Sri
|
|
|
|
|
|
Hi,
I need to have a column value from multiple rows as one value. My datagrid is binded to a record set and this record set column should have this value
e.g. select name from employee
returns> name
-----
david
malcom
rave
I need to have this value as
name
----
david, malcom,rave (in one row)
Please note that I am on sql server 2000
Can anyone help in generating such sql script.
My datagrid will show the result as
------------------
dept names
------------------
dept1 david, malcom,rave
-----------------------------
dept2 david1, malcom1,rave1
------------------------------
regards
Vijay
|
|
|
|
|
HI,
This forum is basically for .net
then also
1> Use Cursor for this ---
2>
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL ON
DECLARE @list VARCHAR(8000)
DECLARE @delm VARCHAR(2)
SET @delm = ','
CREATE TABLE #TableToList (value varchar(20))
INSERT #TableToList VALUES ('swati')
INSERT #TableToList VALUES ('ABC')
INSERT #TableToList VALUES ('NIDHI')
INSERT #TableToList VALUES ('XYZ')
SELECT @list = ISNULL(
@list + @delm + CAST(value AS VARCHAR(8000)),
CAST(value AS VARCHAR(8000))
)
FROM #TableToList
ORDER BY value
DROP TABLE #TableToList
SELECT list = @list
Reasons are not Important but Results are Important.
Swati Tripathi
|
|
|
|
|
Hi Swati,
Thanks.. but I still have some doubts
My data grid is dg_SearchResults
and I add a following column in it
Dim Details As New BoundColumn
Details.HeaderText = "Details"
Details.DataField = "DETAILS"
dg_SearchResults.Columns.AddAt(0, Details) (details should have those values in one row)
Now can I bind the out put of stored procedure as you have mentioned to my datagrid. i guess its not
dataset just a flat string . will it consider it as the dataset to get binded with my datagrid.
what changes do I have to make to my stored procedure?
regards
vijay
|
|
|
|
|
yes, you can bind these value with your data grid
this output can be used in stored proc just merge/add this variable(@list) with your select statement.
i am really not getting where are you not getting????
you can use cursor also for this output ...
Reasons are not Important but Results are Important.
Swati Tripathi
|
|
|
|
|
Hi Swati,
My query is in my asp.net code is as (which is not a stored procedure i am implementing it in my vb code.
select assets.asset_pk as UNIQUEID,
assets.asset_ID ,
assets.[name] collate database_default ,
asset_types.ASSET_TYPE_NAME ,
(CASE when IsNull(townland.townland, '') = '' THEN '' eLSE townland.townland END) ,
(CASE when IsNull(thoroughfares_fme1.thorfare_name, '') = '' THEN '' eLSE thoroughfares_fme1.thorfare_name END) ,
(CASE assets.LEASED WHEN 1 THEN 'YES' eLSE 'NO' END) ,
(CASE assets.DISPOSED WHEN 1 THEN 'YES' eLSE 'NO' END) ,
(CASE assets.ASSET_REGISTERED WHEN 1 THEN 'YES' eLSE 'NO' END) ,
assets.ASSET_FOLIO_NUMBER ,
assets.FLAGGED_NOTE collate database_default +'<br>' AS DETAILS
from assets
INNER JOIN asset_types on assets.type_id = asset_types.asset_type_id
left join asset_streets on assets.asset_pk =asset_streets.asset_ref_key
left join thoroughfares_fme1 on asset_streets.THORFARE_REF_KEY = thoroughfares_fme1.primaryindex
left join asset_townlands on assets.asset_pk=asset_townlands.asset_ref_key
left join TOWNLAND on asset_townlands.TOWNLAND_KEY = TOWNLAND.primaryindex
where
assets.asset_ID like '%L%' or
assets.[name] collate database_default like '%L%' or
asset_types.ASSET_TYPE_NAME like '%L%' or
townland.townland like '%L%' or
thoroughfares_fme1.thorfare_name like '%L%' or
assets.leased_to like '%L%' or
assets.LEASED_CUSTOMER_ID like '%L%' or
assets.LEASED_OCCUPIER like '%L%' or
assets.DISPOSED_TO_NAME like '%L%' or
assets.ASSET_FOLIO_NUMBER like '%L%' or
assets.FLAGGED_NOTE collate database_default like '%L%'
order by assets.asset_ID
here because of thoroughfares_fme1.thorfare_name field I am getting rows for the asset_id
e.g
62 BLD10001 ffa-234 LA BUILDING RATHQUARTER HOLBORN STREET
62 BLD10001 ffa-234 LA BUILDING RATHQUARTER CONNAUGHTON ROAD
I want this records as one record
e.g.
62 BLD10001 ffa-234 LA BUILDING RATHQUARTER HOLBORN STREET, CONNAUGHTON ROAD
Now my datagrid is binded to thi record set.
When I tried to have your list concept in my code I get the error as it can be implemented in other data retrieval fields.
Now please tell me how I can proceed from here?
regards
Vijay
|
|
|
|
|
sorry i thought you are doing stored procedure.
hey over here you have to do programming and use dynamic column for that.
where you need to check prev and current asset id and if it is same then add column or add string to ur current string.
Hope this will help you.
Reasons are not Important but Results are Important.
Swati Tripathi
|
|
|
|
|
Hi Swati,
even with stored procedure how i can proceed with as there are some other fields also, can it return
list as well as other fields also? and how can i then bind it with such a flat data as its not a dataset, My datagrid has columns which are linked with other fields from the existing querry? with the stored procedure how i can have this linkage?
regards
Vijay
|
|
|
|
|
please look at below
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL ON
DECLARE @list VARCHAR(8000)
DECLARE @delm VARCHAR(2)
SET @delm = ','
CREATE TABLE #TableToList (
Columns.....
)
Insert into #TableToList
select assets.asset_pk as UNIQUEID,
assets.asset_ID ,
assets.[name] collate database_default ,
asset_types.ASSET_TYPE_NAME ,
(CASE when IsNull(townland.townland, '') = '' THEN '' eLSE townland.townland END) ,
(CASE when IsNull(thoroughfares_fme1.thorfare_name, '') = '' THEN '' eLSE thoroughfares_fme1.thorfare_name END) ,
(CASE assets.LEASED WHEN 1 THEN 'YES' eLSE 'NO' END) ,
(CASE assets.DISPOSED WHEN 1 THEN 'YES' eLSE 'NO' END) ,
(CASE assets.ASSET_REGISTERED WHEN 1 THEN 'YES' eLSE 'NO' END) ,
assets.ASSET_FOLIO_NUMBER ,
assets.FLAGGED_NOTE collate database_default +'
' AS DETAILS
from assets
INNER JOIN asset_types on assets.type_id = asset_types.asset_type_id
left join asset_streets on assets.asset_pk =asset_streets.asset_ref_key
left join thoroughfares_fme1 on asset_streets.THORFARE_REF_KEY = thoroughfares_fme1.primaryindex
left join asset_townlands on assets.asset_pk=asset_townlands.asset_ref_key
left join TOWNLAND on asset_townlands.TOWNLAND_KEY = TOWNLAND.primaryindex
where
assets.asset_ID like '%L%' or
assets.[name] collate database_default like '%L%' or
asset_types.ASSET_TYPE_NAME like '%L%' or
townland.townland like '%L%' or
thoroughfares_fme1.thorfare_name like '%L%' or
assets.leased_to like '%L%' or
assets.LEASED_CUSTOMER_ID like '%L%' or
assets.LEASED_OCCUPIER like '%L%' or
assets.DISPOSED_TO_NAME like '%L%' or
assets.ASSET_FOLIO_NUMBER like '%L%' or
assets.FLAGGED_NOTE collate database_default like '%L%'
order by assets.asset_ID
SELECT UNIQUEID ,asset_ID,ASSET_TYPE_NAME, @list = ISNULL(
@list + @delm + CAST(value AS VARCHAR(8000)),
CAST(value AS VARCHAR(8000))
)
FROM #TableToList
ORDER BY value
Reasons are not Important but Results are Important.
Swati Tripathi
|
|
|
|
|
Thanks Swati for your time.
Yesterday i tried following which worked. after getting the dataset from my original sql script, I tried to check in the returned dataset and manupulated it to have the result I wanted for thorfare names and townlands
here it is..
Dim rowcoll As DataRow() = dsTemp.Tables(0).Select()
If rowcoll.Length > 0 Then
For Each rw As DataRow In rowcoll
If rw.RowState = DataRowState.Unchanged Then
Dim rowcoll1 As DataRow() = dsTemp.Tables(0).Select("UNIQUEID=" + rw(0).ToString() + " and DETAILS <> '" + rw(1) + "'")
If rowcoll1.Length > 0 Then
Dim str1 As String = rw(1)
Dim origStreet, origTown As String
origStreet = rw(1)
origStreet = origStreet.Remove(origStreet.IndexOf("<BR><b>Leased</b><BR>"))
origStreet = origStreet.Substring(origStreet.IndexOf("<BR><b>Street</b><BR>") + "<BR><b>Street</b><BR>".Length())
origTown = rw(1)
origTown = origTown.Remove(origTown.IndexOf("<BR><b>Street</b><BR>"))
origTown = origTown.Substring(origTown.IndexOf("<BR><b>Townland</b><BR>") + "<BR><b>Townland</b><BR>".Length())
For Each rw1 As DataRow In rowcoll1
Dim str As String = rw1(1)
Dim st As String = str
str = str.Remove(str.IndexOf("<BR><b>Leased</b><BR>"))
str = str.Substring(str.IndexOf("<BR><b>Street</b><BR>") + "<BR><b>Street</b><BR>".Length())
If String.IsNullOrEmpty(str) = False Then
If str.Length > 0 Then
If IsNothing(origStreet) = True Or (origStreet.Contains(str) = False) Then
str1 = str1.Insert(str1.IndexOf("<BR><b>Leased</b><BR>"), "<br>" + str)
origStreet = origStreet + "<br>" + str
End If
End If
End If
str = st
str = str.Remove(str.IndexOf("<BR><b>Street</b><BR>"))
str = str.Substring(str.IndexOf("<BR><b>Townland</b><BR>") + "<BR><b>Townland</b><BR>".Length())
If String.IsNullOrEmpty(str) = False Then
If str.Length > 0 Then
If IsNothing(origTown) = True Or (origTown.Contains(str) = False) Then
str1 = str1.Insert(str1.IndexOf("<BR><b>Street</b><BR>"), "<br>" + str)
origTown = origTown + "<br>" + str
End If
End If
End If
dsTemp.Tables(0).Rows.Remove(rw1)
Next
rw(1) = str1
rw.AcceptChanges()
End If
End If
Next
End If
dsTemp.AcceptChanges()
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
