|
Hi there,
I am using a DropDownList within a Gridview , and am selecting data from Three tables, where table "b" relates both tables "a" and "c". Table "a" is called "Tours" and each tour has a all the price ranges in Table "c" (table PriceRange).
I am able to populate the DropdownList with the "Price Ranges" but the query returns dublicate values for the Tours. I tried using the Full, the Left and Right outer join but didnt work. One more thing is that each one of the Tours has all the price Ranges that exist.
Please help. Your help is highly appreciated
SELECT DISTINCT a.TourId, a.TourDesc, b.TourRangeId, c.PriceRangeId, c.[Desc]
FROM dbo.Tour AS a INNER JOIN
dbo.TourRange AS b ON a.TourId = b.FKTourId INNER JOIN
dbo.PriceRange AS c ON b.FKPriceRangeId = c.PriceRangeId
allphpro
|
|
|
|
|
Here is the VB code that i am using. Please help.
Private Function getdataset() As Data.DataSet
Dim myconnection As New SqlConnection(connectionstring)
Dim ad As New SqlDataAdapter("GetTours1", myconnection)
Dim ds As New Data.DataSet()
ad.Fill(ds)
Return ds
End Function
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
gridview1.DataSource = getdataset().Tables(0)
gridview1.DataBind()
End Sub
Protected Sub gridview1_rowdatabound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
Dim mytable As New Data.DataTable()
Dim TourRangeIdcolumn As New Data.DataColumn("TourRangeId")
Dim Desccolumn As New Data.DataColumn("Desc")
mytable.Columns.Add(TourRangeIdcolumn)
mytable.Columns.Add(Desccolumn)
Dim ds As New Data.DataSet()
ds = getdataset()
Dim TourId As String = 0
Dim expression As String = String.Empty
If e.Row.RowType = DataControlRowType.DataRow Then
'TourId = int32.Parse (DataKey.Equals ("TourId")
TourId = Int32.Parse(e.Row.Cells(0).Text)
expression = "TourId = " & TourId
Dim ddl As DropDownList = CType(e.Row.FindControl("dropdownlist1"), DropDownList)
Dim rows As Data.DataRow() = ds.Tables(0).Select(expression)
Dim row As Data.DataRow
For Each row In rows
Dim newrow As Data.DataRow = mytable.NewRow()
newrow("TourRangeId") = row("TourRangeId")
newrow("Desc") = row("Desc")
mytable.Rows.Add(newrow)
Next row
ddl.DataSource = mytable
ddl.DataTextField = "Desc"
ddl.DataValueField = "TourRangeId"
ddl.DataBind()
End If
End Sub
<fieldset><br />
<legend>GridviewNestingDropdowlist</legend><br />
<asp:gridview id="gridview1" runat="server" autogeneratecolumns="False" <br />
onrowdatabound="gridview1_rowdatabound" Width="793px"><br />
<columns><br />
<asp:boundfield datafield="TourId" headertext="TourId" /><br />
<asp:boundfield datafield="Tour" headertext="Tour" /><br />
<asp:BoundField DataField="TourDate" HeaderText="Tour Date" /><br />
<asp:BoundField DataField="Nights" HeaderText="Nights" /><br />
<asp:BoundField DataField="TourDesc" HeaderText="Tour Description" /><br />
<asp:templatefield headertext="Price Range"><br />
<itemtemplate><br />
<asp:dropdownlist id="dropdownlist1" runat="server" AppendDataBoundItems="True" ><br />
<asp:ListItem>---select---</asp:ListItem><br />
</asp:dropdownlist><br />
</itemtemplate><br />
</asp:templatefield><br />
</columns><br />
</asp:gridview></fieldset>
allphpro
|
|
|
|
|
|
Hi have all html data in an hidden field and I want to print it on paper without rendering on the browser can any one tell me the solution.
Problem: When tried to print the data it prints like this:
<b%>Printing</b>
But I want output as
Printing
modified on Wednesday, August 19, 2009 10:41 AM
|
|
|
|
|
What are you doing, let me know.
Are you printing using Window.print. I dont think it prints hidden field.
Are you using @media print CSS??
|
|
|
|
|
In my case data is very heavy so browser creates a problem while rending so, I withdraw to use Window.Print, now I have all in hidden fields.
Also, I tried all in Stringbuilder.
Now, problem is how to get all printed with proper formatting.
|
|
|
|
|
Gaurav.Kumar.Arora wrote: Also, I tried all in Stringbuilder.
Without window.print how do you print. This is the only possible way to print. the thing that you can do is use @media print css to those hidden fields and apply correct formatting.
|
|
|
|
|
Hi,
We are using MasedEditExtender and ,masekedEditvalidator for Validating date.
even If a validation error occurs also , it is saving . and form is getting posted.
Plese tell us how to stop posting the data if there is an validation error message on form .
Thanks in advance.
Cheers,
Sriharsha
|
|
|
|
|
Hi,
I am working in asp.net2.0 and C#. Actually i have created classes. I can create instance of that class. But i am not able to access the methods in that. Please help me
|
|
|
|
|
hi,
did you mark your methods as public? Maybe you could post a bit of your code...
Regards
Sebastian
|
|
|
|
|
Yes i have done it as a public only. This is my code.
public class BFS
{
public BFS()
{
//
// TODO: Add constructor logic here
//
}
public void ret(string DUv)
{
//My code
}
}
|
|
|
|
|
And the code where you want to use your class looks like? Did you pay attention to namespaces?
|
|
|
|
|
How should i give namespaces. Please help me. if my class in XYZ then what will be the Namespaces?
|
|
|
|
|
If you have this:
namespace MyNamespace {
public class X {
}
}
then you can access the class by MyNamespace.X. Maybe you could post your code...
Regards
Sebastian
|
|
|
|
|
you can use anything as namespace... but for easy use give some relevant name like when you are adding two numbers then you can give "namespace Addition"....
|
|
|
|
|
Have you made them public/internal
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hey all,
I want to call a javascript function and also the click event that is present in the code behind for an
ASP ImageButton.
I am using AjaxUpdate Panel and the Click event of the image button is registered for the auto update of the Ajax panel.
How do we do that?
Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"
|
|
|
|
|
Just add javascript to the onlclientclick event of the imagebutton and make sure to return true from javascript.
|
|
|
|
|
have done that but it gives compilation error...
Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"
|
|
|
|
|
AB7771 wrote: ut it gives compilation error...
So, you are expecting we will guess what error you are getting ?
Please Provide the proper/details information to get the correct answer.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
maybe you can do it like this
In Page_Load event
ImageButton1.Attributes.Add("onclick", "javascript:alert('yes')");
|
|
|
|
|
Hi
I want to display an alert while deleting a record in gridview if the user clicks ok then only the record has to be deleted
can u help me out regarding this issue
|
|
|
|
|
You can simply do it in RowDataBound Event of GridView. where you need to find control add the JavaScript onlick for that button/link.
Let me know if you need any further clarrification.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
function ConfirmDelete()
{
return confirm('Do you want to delete?';
}
at this to onclick attribute of the delete button.
|
|
|
|
|
When visitor of webpage closes page without logout(clicking cross in titlebar) means which event will be generated?
|
|
|
|