|
Hi Friend,
You want to do following steps.
************************************************
1.Add a new SqlDataSource.
2.In the page load function give
SqlDataSource1.ConnectionString = "server=yourserver;Integrated Security=yes;Database=yourdatabase"
SqlDataSource1.SelectCommand = "SELECT [field1], [field2] FROM [yourdatabase]"
After these in the designe phase you should give connection to drop down list
<asp:DropDownList ID="DropDownList1" runat="server" Width="156px"
DataSourceID="SqlDataSource1" DataTextField="field1">
************************************************************
thats all....
try....
Sherin Iranimose
|
|
|
|
|
You can do all these things at designe time.
it is difficult to explain.But it is easy.
try it yourself.
Sherin Iranimose
|
|
|
|
|
Hi,
You can bind Dropdownlist inside ItemTemplate of Datagrid.The following my code:
<br />
<asp:GridView ID="GridView1" runat="server"><br />
<Columns><br />
<asp:TemplateField><br />
<ItemTemplate><br />
<asp:DropDownList ID="DropDownList1" runat="server"><br />
</asp:DropDownList><br />
</ItemTemplate><br />
</asp:TemplateField><br />
</Columns><br />
</asp:GridView><br />
|
|
|
|
|
Thanks for your Replay, But Where is the Serverside code to bind the DropDownList
Mkanchha
|
|
|
|
|
Hi,
I have a usercontrol.It is having a dropdownlist dp1. I want to know how to bind/associate events to that usercontrol. For e.g. if i place that usercontrol on a web page then on the selected index change of the dropdownlist(dp1) of the usercontrol, i want an event to get fired.
Does anyone have a clue on how to do it.
Note: The dropdownlist(dp1) is generated using html and is not used directly from the toolbox.
Thanks,
Riz
|
|
|
|
|
Rajiya wrote: The dropdownlist(dp1) is generated using html and is not used directly from the toolbox.
Are you talking about custom control ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
ya...it is a custom control.
Below is the code used for creating the control:
<LINK href="toolTip.css" type="text/css" rel="stylesheet">
<script language="javascript" src="toolTip.js"></script>
<OBJECT id="combo" style="WIDTH: 156px; HEIGHT: 24px" height="24" width="156" classid="clsid:8BD21D30-EC42-11CE-9E0D-00AA006002F3"
name="combo" VIEWASTEXT>
<PARAM NAME="VariousPropertyBits" VALUE="746604571">
<PARAM NAME="BackColor" VALUE="16777215">
<PARAM NAME="ForeColor" VALUE="2147483656">
<PARAM NAME="MaxLength" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="ScrollBars" VALUE="0">
<PARAM NAME="DisplayStyle" VALUE="7">
<PARAM NAME="MousePointer" VALUE="1">
<PARAM NAME="Size" VALUE="4128;635">
<PARAM NAME="PasswordChar" VALUE="0">
<PARAM NAME="ListWidth" VALUE="4000">
<PARAM NAME="BoundColumn" VALUE="1">
<PARAM NAME="TextColumn" VALUE="65535">
<PARAM NAME="ColumnCount" VALUE="1">
<PARAM NAME="ListRows" VALUE="8">
<PARAM NAME="cColumnInfo" VALUE="0">
<PARAM NAME="MatchEntry" VALUE="1">
<PARAM NAME="ListStyle" VALUE="1">
<PARAM NAME="ShowDropButtonWhen" VALUE="2">
<PARAM NAME="ShowListWhen" VALUE="1">
<PARAM NAME="DropButtonStyle" VALUE="1">
<PARAM NAME="MultiSelect" VALUE="0">
<PARAM NAME="Value" VALUE="">
<PARAM NAME="Caption" VALUE="">
<PARAM NAME="PicturePosition" VALUE="458753">
<PARAM NAME="BorderColor" VALUE="0">
<PARAM NAME="SpecialEffect" VALUE="3">
<PARAM NAME="Accelerator" VALUE="2">
<PARAM NAME="GroupName" VALUE="">
<PARAM NAME="FontName" VALUE="Arial">
<PARAM NAME="FontEffects" VALUE="1073741824">
<PARAM NAME="FontHeight" VALUE="170">
<PARAM NAME="FontOffset" VALUE="0">
<PARAM NAME="FontCharSet" VALUE="0">
<PARAM NAME="FontPitchAndFamily" VALUE="2">
<PARAM NAME="ParagraphAlign" VALUE="1">
<PARAM NAME="FontWeight" VALUE="200">
</OBJECT> <!-- code for the combo box-->
<P></P>
</A>
I want to know how to add events or event handlers to it.
regards,
Riz
|
|
|
|
|
Rajiya wrote: <object id="combo" style="WIDTH: 156px; HEIGHT: 24px" height="24" width="156" classid="clsid:8BD21D30-EC42-11CE-9E0D-00AA006002F3"
="" name="combo" viewastext="">
I think it is not ASP control
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Assuming that you have have developed a proper custom control
now you can add events to it take a look at this example
http://msdn2.microsoft.com/en-us/library/aa720416(VS.71).aspx[^]
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Hi,
I went through the link that u had suggested but did not get the information that i needed. Do u have any other link which cud give me the necessary details.I wanted to know how cud i get the selected index change event of that particular custom dropdownlist. Is is not an asp.net control.
Regards,
Riz
|
|
|
|
|
Hi friends,
I got problem when i redirects from one http page to other https page then , my page from which i am redirecting is reloads first time.
can any one tell me why this is happening ?
i have simple anchor tag like <a href="https://....>Registration</a>
when i click on that my page which contains that anchor tag is reloaded.
is it necessary to set "requireSSL="True"" in web.config for this type of redirection in same application.
Thanks.
-- modified at 5:09 Wednesday 9th May, 2007
Chirag Patel
|
|
|
|
|
Your anchor tag is not visible. Modify your message and use ignore HTML tags option.
|
|
|
|
|
I need to limit the number of characters entered by the user in a Textbox to 1000.setting MaxLength property doesnt work.
ravi
|
|
|
|
|
Hi friend,
Its working properly here.
is it not working only greater values like 1000.
Sherin Iranimose
|
|
|
|
|
Hi Everyone,
I would like to know how am I able to access the templateField I created in my GridView, which I set it to invisible initially, to make it visible when user click on the EDIT button and subsequently update into the database for the selected value.
|
|
|
|
|
Try with Javascript for making the combo box as visible when the user clicks edit button in the Grid view.
Regards,
Satips.
|
|
|
|
|
Hi,
When You create template field for edit, make it as "edit item template".
No need to make invisible.
An "edit item template" will automatically display when you press edit link.
Sherin Iranimose
|
|
|
|
|
Thank you so much for your help. I am quite new to asp.net so i may be asking some silly questions. Can I ask you another question? When I enter editing mode, how do i set the value of the combobox to the record in my database. If the user changes it, how do get the value of the combobox and update it back to the database ?
|
|
|
|
|
hi,
For make editing using gridview you should do following things.
1. Enable AutogenerateEditButton property of 'gridview' to true
2. Add Dropdownlist in to 'Item template' of 'gridview'
///
<asp:DropDownList ID="DropDownList1" runat="server" Width="126px"
DataSourceID="SqlDataSource1" DataTextField="Field2"
DataValueField="Field1" SelectedValue='<%# Bind("Field1") %>'>
</asp:DropDownList>
///
3. Add Dropdownlist in to 'Edit item template' of 'gridview'
/////
<asp:DropDownList ID="DropDownList2" runat="server" Width="126px"
DataSourceID="SqlDataSource1" DataTextField="Field2"
DataValueField="Field1" SelectedValue='<%# Bind("Field1") %>'>
</asp:DropDownList>
/////
4. Add an sqldatasource to your form
////
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="server=yourserver;Integrated Security=yes;Database=YourDatabase"
SelectCommand="SELECT [field1], [field2] FROM [YourTable]"></asp:SqlDataSource >
////
Now it will show the data in your table.
4. To update the data...
You should specify an "UpdateCommand" to the sqldatasource of your "gridview".
ex: UpdateCommand="UPDATE [YourTable] SET [field1]=@field1 WHERE [field2]=@field2"
Try...............
-- modified at 6:03 Wednesday 9th May, 2007
Sherin Iranimose
|
|
|
|
|
HI,
Thank you so much for your wonderful reply. I still can't get it to work..The user changes the category from the category Combobox and I need it to update the selected category to the database. The rest of the fields in the editing mode are textboxes, so there are no problem with updating them. The bind command doesn't work as it says categoryName can't be found? Without the bind and inputing @categoryname doesn't reflect the selected comboxItem...I tried controlParameter under the updateParameter but it doesn't work as well...I am so lost....
|
|
|
|
|
Hi,
In your select command of "sqldatasource" you should give that field name.
Sherin Iranimose
|
|
|
|
|
Thanks alot...i misses out the column name thats why i encounter the error..You are of a wonderful help, Sherin. May I ask you, how do i resize the textbox column in editing mode? I heard from my friends that it was fixed? How do I make it shorter in width? I got alot to learn from you...wonder if u have any email address or msn if you dun mind? :P anyway, Thank you so much for your help. I really appreciate it..
Regards,
Aaron Neo
|
|
|
|
|
hi AaronNeo,
Do you know one thing.. The controls inside "Edit item template field"
are same as other controls.So we can do whatever we like, on it.
So just resize it in design mode itself(from inside the "Edit item template field").
try...
vsherin@gmail.com
Sherin Iranimose
|
|
|
|
|
i am new to asp.net and have a code that works fine inline but doesnot work in vs 2005 code behind. someone please help
when the page loads all dropdownlist are empty however when you click search
button all results are displayed.on clicking paging number for next record it
again shows empty dropdown list.
here is the code:
code behind
Imports System
Imports System.Configuration
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
Imports System.Data
Imports System.Data.Odbc
Partial Class _Default
Inherits System.Web.UI.Page
Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)
dgrdProducts.CurrentPageIndex = 0
Page_Load()
End Sub
Sub PageChange(ByVal sender As Object, ByVal e As DataGridPageChangedEventArgs)
dgrdProducts.CurrentPageIndex = e.NewPageIndex
Page_Load()
End Sub
Dim strBackGroundColor As String
Sub dropColors_SelectedIndexChanged(ByVal s As Object, ByVal e As EventArgs)
strBackGroundColor = dropColors.SelectedValue.ToString
End Sub
Dim strBackGroundColor2 As String
Sub dropColors_SelectedIndexChanged2(ByVal s As Object, ByVal e As EventArgs)
strBackGroundColor2 = dropColors2.SelectedValue.ToString
End Sub
Dim strBackGroundColor3 As String
Sub dropColors_SelectedIndexChanged3(ByVal s As Object, ByVal e As EventArgs)
strBackGroundColor3 = dropColors3.SelectedValue.ToString
End Sub
Sub Page_Load()
'1. Create a connection
Dim myConnection As New OdbcConnection("DSN=store")
Dim myConnection2 As New OdbcConnection("DSN=store")
Dim myConnection3 As New OdbcConnection("DSN=store")
'2. Create the command object, passing in the SQL string
Const strSQL As String = "select distinct category from products"
Const strSQL2 As String = "select distinct product from products"
Const strSQL3 As String = "select distinct price from products"
'Const strSQL as String = "SELECT distinct category, product, price FROM products"
'Const strSQL as String = "SELECT FAQID, LEFT(Description, 40) + '...' AS Description " & _
'"FROM tblFAQ ORDER BY Description"
Dim myCommand As New OdbcCommand(strSQL, myConnection)
Dim myCommand2 As New OdbcCommand(strSQL2, myConnection2)
Dim myCommand3 As New OdbcCommand(strSQL3, myConnection3)
'3. Create the DataReader
myConnection.Open()
myConnection2.Open()
myConnection3.Open()
Dim objDR As OdbcDataReader
Dim objDR2 As OdbcDataReader
Dim objDR3 As OdbcDataReader
objDR = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
objDR2 = myCommand2.ExecuteReader(CommandBehavior.CloseConnection)
objDR3 = myCommand3.ExecuteReader(CommandBehavior.CloseConnection)
'Databind the DataReader to the listbox Web control
If Not IsPostBack Then
dropColors.DataSource = objDR
dropColors.DataBind()
dropColors2.DataSource = objDR2
dropColors2.DataBind()
dropColors3.DataSource = objDR3
dropColors3.DataBind()
'Add a new listitem to the beginning of the listitemcollection
dropColors.Items.Insert(0, New ListItem("-- Choose a category --"))
dropColors2.Items.Insert(0, New ListItem("-- Choose a product --"))
dropColors3.Items.Insert(0, New ListItem("-- Choose price range --"))
End If
Dim dstProducts As DataSet
Dim dadProducts As OdbcDataAdapter
Dim strSQLQuery As String
Dim objConnection As OdbcConnection
Dim objCommand As OdbcCommand
Dim strBackGroundColor As String
Dim strBackGroundColor2 As String
Dim strBackGroundColor3 As String
strBackGroundColor = dropColors.SelectedValue.ToString
'strBackGroundColor = lstFAQs.SelectedValue.ToString
'Response.Write(strBackGroundColor)
'Response.End()
strBackGroundColor2 = dropColors2.SelectedValue.ToString
'strBackGroundColor2 = lstFAQs2.SelectedValue.ToString
'Response.Write("strBackGroundColor2")
strBackGroundColor3 = dropColors3.SelectedValue.ToString
'strBackGroundColor3 = lstFAQs3.SelectedValue.ToString
'Response.Write("strBackGroundColor3")
'Response.End()
If Len(Trim(strBackGroundColor)) >= 0 Then
' Set up our connection.
' Grab Products Table
dstProducts = New DataSet()
objConnection = New OdbcConnection("DSN=store")
' Set up our SQL query text.
strSQLQuery = "SELECT StoreID, category, product, status, description, price, stock, moreinformation, photo, priceactual, buy " _
& "FROM products " _
& "WHERE category LIKE '%" & Replace(strBackGroundColor, "'", "''") & "%' " _
& "AND product LIKE '%" & Replace(strBackGroundColor2, "'", "''") & "%' " _
& "AND price LIKE '%" & Replace(strBackGroundColor3, "'", "''") & "%' " _
& "ORDER BY status;"
'Response.Write(strSQLQuery)
'Response.End()
objCommand = New OdbcCommand(strSQLQuery, objConnection)
dadProducts = New OdbcDataAdapter(objCommand)
dadProducts.Fill(dstProducts, "products")
' Bind to DataGrid
dgrdProducts.DataSource = dstProducts
dgrdProducts.DataBind()
Else
End If
End Sub
End Class
here is aspx front end
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<table border=0 width=300 height=100 align=center>
<tr>
<td align=center>
<td >
<asp:DropDownList id="dropColors" runat="server" Rows="1"
OnSelectedIndexChanged="dropColors_SelectedIndexChanged"
AutoPostBack="false"
DataTextField="category" DataValueField="category" />
</td>
<td align=center>
<font color=black><b>Product :</b></font></td>
<td >
<asp:DropDownList id="dropColors2" runat="server" Rows="1"
OnSelectedIndexChanged="dropColors_SelectedIndexChanged2"
AutoPostBack="false"
DataTextField="Product" DataValueField="Product" />
</td>
<td align=center>
<font color=black><b>Price :</b></font></td>
<td >
<asp:DropDownList id="dropColors3" runat="server" Rows="1"
OnSelectedIndexChanged="dropColors_SelectedIndexChanged3"
AutoPostBack="false"
DataTextField="Price" DataValueField="Price" />
</td>
<td colspan=2 align=center>
<asp:Button id="btnSearch" runat="server"
Text = "Search"
OnClick = "btnSearch_OnClick"
/>
</td>
</tr>
</table>
<asp:DataGrid id="dgrdProducts" runat="server"
AutoGenerateColumns="False"
EnableViewState="False"
ShowHeader="true"
HeaderStyle-Font-Name="arial"
HeaderStyle-Font-Bold="true"
HeaderStyle-BackColor="lightblue"
ItemStyle-Font-Name="arial"
ItemStyle-Font-Size="10pt"
AlternatingItemStyle-BackColor="pink"
CellPadding="8"
cellspacing=0
AllowPaging = "True"
PageSize = "5"
OnPageIndexChanged = "PageChange">
<PagerStyle Mode="numericpages" />
<PagerStyle backcolor="lightblue" />
<PagerStyle font-bold="true" />
<Columns>
<asp:BoundColumn
HeaderText="Product"
DataField="product" />
<asp:BoundColumn
HeaderText="Description"
DataField="description" />
<asp:BoundColumn
HeaderText="Type"
DataField="status" />
<asp:BoundColumn
HeaderText="Price"
DataField="priceactual" />
<asp:TemplateColumn>
<itemTemplate>
<table>
<tr>
<td><a href='<%# String.Format( "details.aspx?id={0}", Container.DataItem( "StoreID" ) ) %>'>More Info</a></td><td><a href='<%# String.Format( "form_to_accessdb.aspx?id={0}", Container.DataItem( "StoreID" ) ) %>'>order now</a></td>
</tr>
<tr>
<img src= "<%# Container.DataItem( "photo" )%>" width=150 height=120></td>
</tr>
</table>
</itemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>
i will really appreciate any help
-- modified at 12:27 Wednesday 9th May, 2007
|
|
|
|
|
to easily tracking the convertion...you just do a part of it...then post the problem here if you cannot overcome that...
<< >>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
