For insertion, I have dropdown inside a form.
The dropdown is linked with sqldatasource which is retreiving distinct records from table.
In table there is no NULL value.
What I want to do that when user will access Insert page to insert record then like all textboxes, dropdown should also load with NULL value.
I have been struggling for a while 72 hours with this .When I update the form view a NULL value is inserted in my product ID field instead of the productID from the drop down list.
here is the code for the form view.
<asp:FormView ID="FormView8" runat="server" DataKeyNames="LoadID,ProductID"
DataSourceID="Pro1SQL">
<EditItemTemplate>
LoadID:
<asp:Label ID="LoadIDLabel1" runat="server" Text='<%# Eval("LoadID") %>' />
[Code]....
I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.
[code]....
I have two Dropdownlist on my webform(DDWO,DDLI) on Page_load I am retreiving WONumber values into DDWO when i select WONumber and click on Button corresponding values of selected WONumber will be loaded into DDLI but i dont want button here, instead when i select value in DDWO(WONumber) corresponding values of selected WOnumber should be loaded into DDLI.On which event i have to write insted of button to load values on select of DDWO value. Following code to retreive values to DDWO,DDLI
[Code]....
i would like to know how to load the dropdown list in the Gridview edit with the dropdown list values from the database
View 3 RepliesI required to load dropdown with the section name on the basis of UserProfile when the page load anytime.
The dropdown is bounded by sqldatasource configured to TblSections.
TblSections with datafields sectionId(numeric) and Description.
There is another table Users with field sectionId and UProfile.
There is a gridview grvResult bounded by objecdatasource configured to TblFltReg.
TblFltReg has field Owner(numeric).
Actually Owner and SectionId are same.
I don't know how to do this task.
I am designing my own Customize Calendar for my webproject.Using Calendar Control of asp.net2.0 I want to add three dropdowns at the top to collect Hour, Minutes and Seconds.What I required to load dropdown menus on runtime with values:
View 1 RepliesI am experimenting with 3 dropdowns bound to 3 different datasources. I want the contents in each dropdown depending on what is selected from the above dropdown and the datasource queries reflect this.
<asp:DropDownList ID="DropDownList_CostCentres" runat="server" Height="16px"
Width="138px" DataSourceID="CostCentreDataSource" DataTextField="CostCentre"
DataValueField="CostCentreID">
</asp:DropDownList>
<asp:SqlDataSource ID="CostCentreDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [CostCentreID], [CostCentre] FROM [CostCentres]">
</asp:SqlDataSource>
<br />
<br />
<asp:Label ID="Label2" runat="server" Text="Manager:" Font-Bold="True"></asp:Label>
<br />
<asp:DropDownList ID="DropDownList_Managers" runat="server" Height="16px"
Width="138px" DataSourceID="ManagerDataSource" DataTextField="EmployeeName"
DataValueField="EmployeeID">
</asp:DropDownList>
<asp:SqlDataSource ID="ManagerDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [EmployeeID], [EmployeeName] FROM [Employees] WHERE ([CostCentre] = @CostCentre)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_CostCentres" Name="CostCentre"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
However, the second dropdown does not load with the relevant data when I select a value from the first dropdown (stays blank). Must I still provide an event handler and how do I combine this with the sqldatasource?
i want my dropdown list or my list box, load data from my database .i use visual studio 2008 and sql server 2005.
View 3 RepliesI have Dropdown for Quotenumber(auto increment ).i have created a function to retreive the data from database.data loading into dropdown. when i click on Addquotenumer button the new quotenumber generated and same loading into dropdown but 2 set of Quotenumbers are displaying rather than singleset, i debudded the code the reason was i have called this function twice one is form load and another one in AddQuotenumber button event,both should manadetory as per my requirement. how can un load this dropdown before AddQuotenumber button
Function to retreive data to dropdown
Public Sub retriveDataToDropDown()
Try
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim query As String = "SELECT QuoteNumber FROM quotes"
Dim connection As New MySqlConnection(connectionString)
Dim da As New MySqlDataAdapter(query, connection)
Dim ds As New DataSet()
If da.Fill(ds) Then
DDQuote.DataSource = ds.Tables(0)
DDQuote.DataTextField = "QuoteNumber"
DDQuote.DataBind()
'DDQuote.Items.Insert(0, New ListItem("Select", "Default value"))
End If
connection.Close()
Catch ex As Exception
'Console.WriteLine(ex.Message)
End Try
End Sub
AddquoteNumber button code
Protected Sub btnAQ_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAQ.Click
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim rowsEffected As Integer = 0
Dim Query As String = ""
Dim connection As New MySqlConnection(connectionString)
'Dim cmd As New MySqlCommand(Query, connection)
connection.Open()
Query = "insert into Quotes(query follows...................)
retriveDataToDropDown()
retriveDataToDataGrid()
connection.Close()
End Sub
I have a dropdown control that has a list of names in it called PlayerNameDropDownList_Insert and a textBox called PlayerName.
When I select a name from the dropdown it populates the textbox correctly.However, when the page opens the first name is selected in the dropdown but nothing in the textbox. How can I get the textbox to populate with the value of the dropdown at pageload?
[Code]....
I have setup my business object to have a create_date and edit_date members both datetime datatypes. My company want to display the create_date and edit_date fields in a gridview for each transaction. The problem i have is that after insterting a record it will have a valid create_date but no edit_date and when displayed in the gridview it defaults to datetime.minvalue (My default). How on earth do i show an empty field in my gridview for a null datetime field in the database?
I am using similar architecture to the Imar Spaanjaars example of a tiered solution. With a few small tweeks it has worked well for me for ages. I am passing a List<Database> to my object datasource which connects to my gridview.
i have a dropdown with month names if the user has data for the month tht is selected then gridview displays the rows with day nos as per the month but if the gridview has no data for the same the dropdown or gridview via some event should call a insert procedure to insert data into the table for tht month with daynos ad rebind the gridview witht the rows just created
View 6 RepliesI have a gridview where i have two fields. one is product and second is sub category.
I need to do 2 things.
1. I need to populate the two combos from the database. But depending what is selected in dropdown 1 this will determine what needs to be populated in drop down 2?
how can i achieve this?
I have two dropdown linked with sqldatasources.When I select item in ddl1 then on the basis of selection ddl2 is being loaded.Is there any possiblity that if I select ddl2 then ddl1 will also load on the basis of selection?
View 3 RepliesI am new to MVC, I have a form in which selection of one dropdown should reload another dropdown. On selection of the dropdown, I use a jquery post to get the data and my viewstate is reloaded with new data, but I am not sure how to set the newly loaded viewdata to load the dropdown again.
View 5 Repliesgot a wired problem (well I find it a wired problem :P)
I have an order page done in asp.net c#, and which a user adds ingredients to a set of list boxes, once the user and finished adding items, they get combined to make a sandwich then added to another list box that shows the sandwiches and their ingredients. I also have a button to allow the user to remove the ighlighted sandwich from the order, this all works fine until the page loads up with a query string that skips the adding of ingredients and just shows the sandwiches on a order, the listbox of sandwiches populates fine but I then get an error when the remove button is clicked which is
[Code]
I've currently got a form with two dropdown boxes on, and an XML file sitting on the site.
My two drop down boxes are Location and Date and what i'm trying to do it get the Location box to filter the XML and put the dates in the Date dropdown box.
I'm using C#.
Unfortunatly, its not working.
My code is:
[Code]....
and my XML is like this:
[Code]....
why my dropdown boxes are not being populated?
I have drop dowm menu as follow.
<asp:ListItem Value="">none</asp:ListItem>
<asp:ListItem Value="STO">Stock</asp:ListItem>
<asp:ListItem Value="ORD">Order</asp:ListItem>
If I chose none, it stores data as "Null" If I Query the data as below, I don't get the data has value of "Null" SELECT tabale From type Where type <> STO or type <> ORD I get data that has empty string but not Null.
1, How do I write dropdown menu value in oder to get empty string instead of Null?
I did <asp:ListItem Value="">none</asp:ListItem> but this stores Null.
2, Why this Query won't pick up Null?
SELECT mytabale FROM type WHERE type <> STO or type <> ORD
Does any one knows how i can load all the control names in my web application into a drop down box?
{
i++;
ControlName = while(ControlNum >=i)string ControlName =
this.form1.Controls[i].ID.ToString().ToString();
this.cboControls.Items.Add(ControlName.ToString());"";
}
I have a user control with GridView. GridView template has label that suppose to get custom object value Name.
aspx:
<asp:Label ID="lblImage" runat="server" Text='<%# MyData.Name%>' />
cs:
public MyObject MyData;
During page loading MyData object is null, so I'm getting exception: "Object reference not set to an instance of an object.".
How to avoid the error?
I am stuck at this point "Displaying a dropdown list of Categories with a --None -- Option. I want the gridview control to display 2 dropdown list one in read-only mode and the other in edit mode. When a record is in read-only mode, the dropdownlist's enabled property will be set to false."When it's on a read-only mode, it doesn't display the selected Category. it shows but the "No Category". When i click on edit to edit or change category, it doesn't display the selected category.
The example is given below( I am reading the book Sams Teach yourself ASP.NET 2.0 by Scott Mitchell. page 628)
<asp:Label ID="UserIdValue" runat="server" Visible="False"></asp:Label>
<asp:SqlDataSource ID="picturesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Pictures] WHERE ([UserId] = @UserId) ORDER BY [UploadedOn] DESC"
DeleteCommand="DELETE FROM [Pictures] WHERE [PictureID] = @PictureID"
InsertCommand="INSERT INTO [Pictures] ([UserId], [CategoryID], [Title], [Description], [UploadedOn]) VALUES (@UserId, @CategoryID, @Title, @Description, @UploadedOn)"
UpdateCommand="UPDATE [Pictures] SET [UserId] = @UserId, [CategoryID] = @CategoryID, [Title] = @Title, [Description] = @Description, [UploadedOn] = @UploadedOn WHERE [PictureID] = @PictureID">
<DeleteParameters>
<asp:Parameter Name="PictureID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="UserId" />
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text"/>
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="UserId"/>
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
<asp:Parameter Name="PictureID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="categoriesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId)">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="maxPictureIDDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT MAX(PictureID)
FROM Pictures
WHERE UserId = @UserId">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId"
PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:Label ID="cannotUploadImageMessage" runat="server"
Text="The photo could not be added to your album either because you did not specify a file to upload or the file specified was not a JPEG image with the file extension .JPG"></asp:Label>
<br />
<asp:DetailsView ID="dvPictureInsert" runat="server"
DataSourceID="PicturesDataSource" Height="50px" Width="125px"
AutoGenerateRows="False" CellPadding="4" DataKeyNames="PictureID"
DefaultMode="Insert" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />
<EditRowStyle BackColor="#2461BF" />
<FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />
<Fields>
<asp:TemplateField HeaderText="Picture">
<InsertItemTemplate>
<asp:FileUpload ID="imageUpload" runat="server" />
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="imageUpload" Display="Dynamic"
ErrorMessage="There was no file selected" ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="pictureCategory" DataSourceID="categoriesDataSource"
runat="server" DataTextField="Name" DataValueField="CategoryID"
SelectedValue='<%# Bind("CategoryID") %>'
Visible='<%# Bind("CategoryID") %>' AppendDataBoundItems="True">
<asp:ListItem Selected="True" Value="">-- Select Category --</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Title" SortExpression="Title">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1" Display="Dynamic"
ErrorMessage="you must provide a name for the title"
ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Title") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Description" SortExpression="Description">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Description") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Description") %>'
Im dynamically creating several dropdowns onclick of a button... but the dropdown returns null when im trying to get the values on submitting the form... i read tat during postback all dynamically created controls will be lost... s there a way to register the controls... i want to access the item selected in the dropdown .... expecting a positive reply...
View 1 RepliesHow can i load the QuoteNumber database column values into dropdown list which is autogenerated column.I am able to generate the QuoteNumber value and same inserting into database simultaniously all the Quotenumber values should load into dropdown, these two should happen in one click button event.My QuoteNumber dropdown name is "DDQuote" Code for generating Quotenumer and same inserting into database.
Protected Sub btnAQ_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAQ.Click
Console.WriteLine(updateRecord("insert into quotes (PartNumber) values ('" + txtPart.Text + "')"))
retriveDataToDataGrid()
End Sub
Function updateRecord(ByVal query As String) As Integer
Try
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim rowsEffected As Integer = 0
Dim connection As New MySqlConnection(connectionString)
Dim cmd As New MySqlCommand(query, connection)
connection.Open()
rowsEffected = cmd.ExecuteNonQuery()
connection.Close()
Return rowsEffected
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Function
I have a function on page load which will work based on dropdown selected value. and I am using this dropdown in a user control. So getting problem because the dropdown value is not loaded yet before Page Load. How Can I do that using those control still.
Here is my code below.
public partial class GradeEntry : System.Web.UI.Page
{
StudentManager studentManager = null;
CourseManager courseManagerObj = null;
GradeManager gradeManager = null;
[Code]....