I need to populate a dropdownlist with results from a linq query done in my controller. I want users to be displayed but when the item is selected and submitted, the userid is passed back to the controller.my controller:
[Code]....
I have a basic Linq query and what I need to do is query the DB then display the data in HTML.Typically I would bind this to a control but in this instance I need to actually generate the HTML in the code behind page.The Linq query is very basic something like this with Northwind:[Code]....
Instead of binding that to a gridview how can I write out the html... I'm sure I can use stringbuilder or smilar to create the html but I'm not sure how to get he data in the tables... foreach datarow in?
I'm looking to translate an SQL query into linq
INNER JOIN Usrs ON
SAQ.UserId =
Usrs.UserId AND Scan.UserId =
Users.UserId
I'm not sure how to include the "AND" in the LINQ statement.
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
how to programmatically create an ASP.NET Menu Control populated using LINQ to SQL (with an unknown number of levels) and couldn't find one anywhere. It took me a while to figure out the logistics of it so I thought I would post my final solution so that you don't have to spend time figuring this out for yourself. Note that I am a self taught developer so I am potentially breaking any number standards coding protocols.
In this example I am working with an ASP.NET project named Virtual. Non-Standard NameSpaces are Virtual.(tools, components) etc...
1. Create your database table that will eventually be used to populate your menu control.
[Code]....
i'm using jQuery to populate an cascading dropdownlist. But i want to set a selected item after jQuery filled the DDL with items.
View 20 Repliesi have one simple question; do I have to... or is there any need to validate value from DropDownLists that are populated from SQL Datatables. I know how to validate them, but I am just concerned about potential SQL Injection, because those DropDownLists are going to be "Input fields" for a new Datatable, and insted of using TextBoxes, user will choose values from those DDL's and Submit them (INSERT INTO) to SQL Datatable. Is there a way for a "hacker" to insert his item value into DropDownList. I hop You understand what I mean!?
View 6 RepliesI have 2 dropdown lists on a WebForm. One of them is populated in the page's Page_Load event. This oneworks fine with the following code.
[Code]....
Then, after a value is selected from this list and a date is selected from a DateTime picker, then I click a button which is supposed to populate the 2nd dropdownlist. In the debugger in the button's click event I can see that the dataset is being populated with data, but then the list is never populated after the DataBind() method is run. Here is code from the button's click event.
[Code]....
I have a DropDownList populated with a SQL Stored Procedure. On the page, there is also a button that when pressed, processes the contents of the dropdownlist. I would then like the dropdownlist to automatically remove the selection, and if there is nothing left in the dropdownlist, I would also like the button to be disabled.
View 5 RepliesDropDownList Not Being Populated
[Code]....
I have two drop down lists on my page. One (DropDownList A) has the values preset by me. The other (DropDownList B) has its values filled by a database query if a button is pressed. Each of them have AutoPostBack set to true. Each of them have corresponding onselectedindexchanged functions. DropDownList A works fine. When I change it, I want it to turn itself invisible. It does. DropwDownList B is not working. When I select something, it does the postback but the selected item is reset and the onselectedindexchanged function is never called. I feel like this is a problem I've solved in the past, but it's been 3 years since I programmed ASP.NET. All this is done in C# by the way.
View 12 Repliesi am currently working on a webform that has several dynamically populated dropdown lists. this works just fine, however, i have other web controls that require to have a postback..and at the time the page postsback, it reloads my dropdownlists, reseting whatever option i had chosen...
what can i do to resolve this?
I want to sort the dropdownlist by date, but i cant figure out how.
ddate.DataSource = myTable
ddate.DataTextField = "ddate7"
ddate.DataValueField = "ddate7"
ddate.DataBind()
Sample Code.
<asp:DropDownList ID="MediaTypeDDL" Width="306px" ToolTip="Select Media Type" runat="server"></asp:DropDownList>
<asp:DropDownList ID="MediaFormatDDL" Width="306px" ToolTip="Select Media Format" runat="server"> </asp:DropDownList
<asp:Button
ID="btnUpload"
runat="server"
OnClick="btnUpload_Click"
Text="Upload"
/><br
/>
protected void btnUpload_Click(object sender, EventArgs e)
{
String strMediaFormat = MediaFormatDDL.SelectedItem.ToString(); // Not seeing value here!
}
Item Selected in MediaTypeDDL determines values in MediaFormatDDL. I'm using Javascript to populate MediaFormatDDL. This is working. I now select the item I want from MediaFormatDDL. That works The problem I'm seeing occurs when I press the button to save the values from
the screen. I don't see the Item I selected from MediaTypeDDL. All the other fields are okay. This must be someThing simple, but I'm not seeing it.
I have a dynamic dropdown that is populated from sql. The user is supposed to select an option from the dropdown, then click a search button on the form to return some results based on that selection. It works fine if the dropdown gets populated with more than one record. However, if only one record is returned, that one record can't be selected. Whether you select it or just leave it alone since it's the only one, when you click the form button (search button), no results are returned b/c the dropdown selection must not be actually selected.
I've included the relevant code below. First the DDL, then the datasource, and finally the C# code in the if (!Page.IsPostBack)
[Code]....
I'm populating a DropDownList using JS on the client and validating with a RequiredFieldValidator.This works fine on the client but the Page.IsValid consistently comes back false on the server.Is this because the selected value wasn't in the DropDownList when it was first served to the page?What's the easiest way around this? (I need to leave server validation turned on)
View 1 RepliesWhen I use the code below an error accur when click add button to insert into sql because the selected value in DropDownList is back to --select-- Idon't know why it should be the the value I selectedbut when not use this code and bind the DropDownList using wizard it works but I need to use the code to make the first selection is --select--.
private void PopulateDropDownList() {
string constr = ConfigurationManager.ConnectionStrings[1].ConnectionString;
using (SqlConnection con = new SqlConnection(constr)) {
using (SqlCommand cmd = new SqlCommand("SELECT Country_ID,Country_Name FROM Country", con)) {
using (SqlDataAdapter da = new SqlDataAdapter(cmd)) {
[Code] ....
I want to use "if statement" in Linq query. How can I do this situation?
For example:
if txtAge.Text=="", I will not use that in Linq Query.
else txtAge.Text!="", I will use that in Linq Query.
I'm using Ajax to dynamically populate a DIV. I have each page content stored in XML files as CDATA. When a user clicks on a link from the navigation bar, the Ajax loads the XML for that particular page, parses it, and populates the DIV with it's content.
Everything is working GREAT, except for one thing. I have a jQuery modal popup whose markup is loaded from that page's XML file. The .js and .css files from the jQuery plugin are all loaded, and when this is HARD CODED (i.e., not loaded from XML), it works fine. But when it's loaded from the XML, the modal doesn't work.
When the page is loaded from the XML file- What the page is supposed to do is load the HTML from the XML file, which it does, and there's a hyperlink that when clicked, it's supposed to create the modal popup window. Instead, clicking on the link does NOT fire up the modal popup window.
When the page is hard coded- it does everything it's supposed to do.
A live example is at:
http://mikemarks.net/clientSites/tabras/
Click on "The Band", and at the bottom you'll see the hyperlink called "Demo". Clicking on that should bring up a modal popup window, but instead as you can see it just takes you to the top of the page.
Below is my markup (notice the div id="copy", which is the placeholder for my HTML content that's loaded from the XML file), my Ajax JavaScript code, and my XML file (which is shown as the markup that's loaded into the div id="copy").
<div id="leftTwoThirdsColumn">
<div id="menu">
<ul class="menu">
<li style="width:65px;"><a id="default" href="#" onclick="makeRequest('xml/default.xml');"><span>Home</span></a></li>
<li style="width:65px;"><a id="lyrics" href="#" onclick="makeRequest('xml/lyrics.xml');"><span>Lyrics</span></a></li>
<li style="width:110px;"><a id="merch" href="#" onclick="makeRequest('xml/merch.xml');"><span>Merchandise</span></a></li>
<li style="width:93px;"><a id="bio" href="#" onclick="makeRequest('xml/bio.xml');"><span>The Band</span></a></li>
<li style="width:80px;"><a id="contact" href="#" onclick="makeRequest('xml/contact.xml');"><span>Contact</span></a></li>
<li style="width:150px;" class="last"><a id="friends" href="#" onclick="makeRequest('xml/friends.xml');"><span>Friends of Tabräs</span></a></li>
</ul>
</div>
<br /><br />
<div id="copy">
</div>
</div>
function makeRequest(url)
{
if(window.XMLHttpRequest)
{
request = new XMLHttpRequest();
}
else if(window.ActiveXObject)
{
request = new ActiveXObject("MSXML2.XMLHTTP");
}
sendRequest(url);
}
function sendRequest(url)
{
request.onreadystatechange = onResponse;
request.open("GET", url, true);
request.send(null);
}
function checkReadyState(obj)
{
if(obj.readyState == 0) { document.getElementById('copy').innerHTML = "Sending Request..."; }
if(obj.readyState == 1) { document.getElementById('copy').innerHTML = "Loading Response..."; }
if(obj.readyState == 2) { document.getElementById('copy').innerHTML = "Response Loaded..."; }
if(obj.readyState == 3) { document.getElementById('copy').innerHTML = "Response Ready..."; }
if(obj.readyState == 4)
{
if(obj.status == 200)
{
return true;
}
else if(obj.status == 404)
{
// Add a custom message or redirect the user to another page
document.getElementById('copy').innerHTML = "File not found";
}
else
{
document.getElementById('copy').innerHTML = "There was a problem retrieving the XML.";
}
}
}
function onResponse()
{
if(checkReadyState(request)) {
var response = request.responseXML.documentElement;
var root = new Array();
root = response.getElementsByTagName('');
//alert("Total Number of HTML Elements Found: " + response.getElementsByTagName("").length);
var html = '';
for (var i = 0; i < root.length; i++) {
var tagName = response.getElementsByTagName("").item(i).nodeName;
var tagObj = response.getElementsByTagName("").item(i);
html += tagObj.firstChild.nodeValue;
}
document.getElementById('copy').innerHTML = html;
}
}
<div style="padding-top:5px; margin-left:auto; margin-right:auto; text-align:center;">
<img src="images/ShawnBioActive.png" />
<img src="images/JasonBioActive.png" />
<img src="images/WillBioActive.png" />
<img src="images/RasoulBioActive.png" />
<img src="images/bioStrip.png" />
<div id='basic-modal'><h3>Basic Modal Dialog</h3><p>A basic modal dialog with minimal styling and no additional options. There are a few CSS attributes set internally by SimpleModal, however, SimpleModal relies mostly on style options and/or external CSS for the look and feel.</p><input type='button' name='basic' value='Demo' class='basic'/> or <a href='#' class='basic'>Demo</a></div><script type="text/javascript" src="../js/modal/jquery.simplemodal.js"></script><script type="text/javascript" src="../js/modal/basic.js"></script><link type="text/css" href="../css/modal/demo.css" rel="stylesheet" media="screen" /><link type="text/css" href="../css/modal/basic.css" rel="stylesheet" media="screen" /><script type='text/javascript'>jQuery().ready(function () {$('#basic-modal-content').modal();});</script>
<div id="basic-modal-content"><h3>Basic Modal Dialog</h3></div><div style='display:none'><img src='images/modal/basic/x.png' alt='' /></div></test2>
</div>
My issue is similar to [URL] how-to-use-the-value-of-a-selected-value-from-a-dropdownlist-populated-with-ajax but I am using ASP.NET, not PHP. I have a dropdownlist that is populated by another dropdownlist's current value through ajax. So if DDL A is 'NY', DDL B is populated with different data relating to 'NY'. I need that data to be posted back to the server because this affects an SQLDataSource parameter. However, as far as I can tell, the value is always null after postback resulting in the gridview to be empty.
View 1 RepliesI've build a linq query.But i want a random selection so its not always ID : 1,2,3,4,5,6 How can i randomize this var? I like to bind it to a repeater.//TagCloud:
Random rand = new Random();
var tc1 = from i in JumpTide.cms.menu.GetMenuItems(32)
select new
[code]...
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 RepliesI have a gridview which contains a templatefield. Inside this is an ImageButton and a dropdownlist. This is all created in the aspx page, although the ddl list items are populated in the RowDataBound event in the vb page. When i change the selected item in the drop down list and hit the imagebutton, the selected item is not maintained after postback. Instead the first record is displayed in the dropdownlist. I have wrapped an If Not Page.IsPostback around the datasource and databind's but this doesn't help. I have tried enabling viewstate in all areas on the page too, but still nothing. The list items for the ddl must be created on RowDataBound also. As far as I am aware, my ddl is not really dynamic, its just the list items which I add in the code behind which are classed as dynamic.
View 11 RepliesMultiple DropDownList in GridView populated with unique values in ASP.Net
View 1 RepliesWe bind dropdown using json and web service but when we click on save button we can not get selected value of that dropdown...
View 1 Replies
