Tracking Forums, Newsgroups, Maling Lists
Home Submit Tracker Forums
  Advanced Search


Basic HTML Concatenation From SQL Select Using C#

i have the following code:

//Product category
SqlCommand comm_productcategory = new SqlCommand("SELECT TOP 1 productcategory_id, productcategory_name FROM tblProductCategory ORDER BY productcategory_name;", conn);
SqlDataReader reader_productcategory = comm_productcategory.ExecuteReader();
while (reader_productcategory.Read())
productCategory.Text += "<li><a href=productcategory.aspx?productcategoryid=" + reader_productcategory["productcategory_id"].ToString() + ">" + reader_productcategory["productcategory_name"].ToString() + "</a></li>;

It's supposed to write out some navigation list items to my page. However, I get the following compilation error when I try to run it: CS1010: Newline in constant On this line: productCategory.Text += "<li><a href=productcategory.aspx?productcategoryid=" + reader_productcategory["productcategory_id"].ToString() + ">" + reader_productcategory["productcategory_name"].ToString() + "</a></li>;

It must be something to do with the way the string is being concatenated, but I can't figure it out!?

View 2 Replies (Posted: Feb 6, 2009, 05:11)

Sponsored Links:

Related Forum Messages For ASP.NET category:
How To Use Basic Html Tags
how can i use basic html tags(h1,h2 and <p>) in code behind.

Posted: Jun 27, 2010 02:28 PM

View 4 Replies!   View Related
Security :: ValidateRequest, And Basic HTML Failure?
Here's the situation. I have an aspx page that is designed to receive a POST request with some XML values, parse the XML, grab the relevant items, and write them to the page. The problem arises when I try to launch the page using the POST request. When I launch using Fiddler, building the request manually and just pasting the XML in the body of the request everything works fine and dandy. When I launch the page from a basic HTML form, however, things don't go so great. The HTML form that I'm using looks like this:


When the page loads I get the error:

A potentially dangerous Request.Form value was detected from the client Everything I've read so far has told me that the solution is to add ValidateRequest="false" to the page directive in the top of the .aspx file, or in the pages element of the web.config file. But neither of these work. Afterwards, I still get the same error. Any idea what I need to do to make this work?

Posted: Jun 28, 2010 02:45 PM

View 5 Replies!   View Related
Possible To Use Basic HTML TextArea For RichText Editing
Is it possible to use Basic HTML TextArea for RichText Editing?If not, what benefit we have out of using TextArea instead of TextBox?I DO NOT want any third party editors. Looking for some option available by default in ASP.NET or HTML.

Posted: Jul 9 10 at 18:50

View 1 Replies!   View Related
Html - Inserting A .swf Or Flash Files In Visual Basic?
inserting a .swf or flash files in visual basic give me coding sample or procedure or a link to inserting a flash files in my web form in vb

Posted: Jan 31 10 at 7:35

View 2 Replies!   View Related
Use Basic HTML Or Can Use More Advanced Web Forms To Build The Page?
 I learned some and in college three years ago and now need to put it to use so I am trying to dust off those memory cells.

If I am trying to create a directory of people in a website will there be any problems in viewing that page if they are using a mac?

Is there anything I should avoid using in creating my page? Should I only use basic HTML or can I use more advanced web forms to build the page?

Posted: Sep 15, 2009 06:25 PM

View 1 Replies!   View Related
Web Forms :: Add Background Music To Each Page Of Website (in HTML And Visual Basic)
How can I add background music to each page of my web site (in HTML and Visual Basic). What code should I add? What is the best format for web page music (mp3, wav, midi ...)?

Posted: Dec 03, 2009 03:14 PM

View 1 Replies!   View Related
Web Forms :: Create An Online Html Editor Used In .net Application With The Basic button ?
i need to create an online html editor to be used in my application with the basic button of dataformating + adding/inserting images+creating templates

Posted: Jan 18, 2011 07:43 AM

View 4 Replies!   View Related
Installation :: Basic Assemblies Required To Run A Basic 4.0 Website?
I am trying to figure out what are the basic assemblies required to run a basic ASP.NET 4.0 website. Say.. a website with just a label in it. I looked online and didn't find a list there. I know installing the framework 4.0 will give me all the dlls but I just need the basic ones that will make a basic site work on ASP.NET 4.0.

Posted: Sep 08, 2010 05:28 AM

View 1 Replies!   View Related
How To Get Select Item Name From Html SELECT
Use Html element SELECT in aspx page like:Data is feed by setting its property DataSource:MySelection.DataSource = IEnumerable collection DataSuppose data is stored in table in DB like:

1 - Option A
2 - Option B
3 - Option C
4 - Option D

From MySelection.Value, I can get the ID value, like 1,2,3.From MySelection.Name, I will get "MySelection", not the selected item name like "Option A"How to get the selected item Name?

Posted: Feb 7 at 17:31

View 2 Replies!   View Related
SQL Statement Using String Concatenation?
I want to create a program that allows me to enter the name of a table, a field along with a value. The program should concatenate the values to form a valid SQL select statement. I can also modify the program to include multiple field names and values. Example: -Select “FieldName” from “TableName” where “FieldName”= “Value” I have created 3 textboxes called and 3 labels named Select, From and Where This is my code here, i would need an assistance on the right way to achieve this, maybe mine is wrong.

Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim SelectItem As String
Dim From As String
Dim Where As String
SelectItem = txtSelectItem.Text
From = txtFrom.Text
Where = txtWhere.Text
lblDisplay = "Select" & " " & SelectItem & " " & "From" & " " & From & " " & Where
End Sub
End Class

Posted: Mar 25th, 2011, 03:58 AM

View 3 Replies!   View Related
How String Concatenation Works
suppose x=3,y=4
Response.Write(x.ToString + " " + y.ToString)

This gave correct as i thought: 3  4 But this gave unexpected result, so what's the rule behind string concatenation and conversion?

Response.Write(x.ToString + " " + y).

This gave :7. Why could'nt 'y' here got converted to string ? why arithimatic sum happend here?

Posted: Apr 21, 2010 12:31 AM

View 18 Replies!   View Related
Use A Concatenation Of 2 Columns In A SQL DB Properly?
I'm using LinqToSql like this with a CheckBoxList in ASP.NET:

var teachers = from x in dc.teachers select x;
cbl.DataSource = teachers;
cbl.DataTextField = "name";
cbl.DataValueField = "teacherID";

I want to display both "firstname" and "name" in the DataTextField however. I found this solution but I'm using LINQ: [URL]

Posted: May 28 10 at 12:56

View 3 Replies!   View Related
Web Forms :: Basic Differences Between Html Server Controls And Web Server Control
I want to know: what are the basic differences between html server controls and web server control. As I have gone though lots of surfing but couldn't find the exact answer.

Posted: Feb 04, 2011 05:19 PM

View 5 Replies!   View Related
Double Quotes In String Concatenation
how this string concatenation taking place? i am really confuse what is happening why that slash i there and how the double quotes are used

SessionStateItemCollection items = new SessionStateItemCollection();
items["LastName"] = "Wilson";
items["FirstName"] = "Dan";
foreach (string s in items.Keys)
Response.Write("items["" + s + ""] = " + items[s].ToString() + "<br />");
Response.Write("items["" + s + ""] = " + items[s].ToString() + "<br />");

Posted: Nov 3 10 at 6:04

View 3 Replies!   View Related
WebMatrix :: Trimming A String For Concatenation
I have a string variable that is a concatenation of text and a variable;

var selectQueryString = "SELECT * FROM WholesaleItems WHERE ProductClass like '" + @pc + "%'" ;

This returns with a space between the variable and the percent sign breaking the LIKE selector. I cannot find any way to trim the variable result.

Posted: Feb 17, 2011 10:38 AM

View 14 Replies!   View Related
SQL Server :: Statement Using String Concatenation
I want to create a program that allows me to enter the name of a table, a field along with a value. The program should concatenate the values to form a valid SQL select statement. I can also modify the program to include multiple field names and values. Example: -Select "FieldName" from "TableName" where "FieldName"= "Value" I have created 3 textboxes called and 3 labels named Select, From and Where This is my code here, i would need an assistance on the right way to achieve this, maybe mine is wrong.


Posted: Mar 25, 2011 11:06 AM

View 1 Replies!   View Related
String Concatenation Inside Jquery Selectors
I am developing a application in C#, ASP.NET and I have a lot os divs in my page, each div is a container for a chat message and each div have a unique id: like this

"<div id='" + myMsgs[j].id_chat_message + "' style='padding: 10px;'>"

so, each div have the same id in page and in database. now a want to find some div, with jquery, but it doesnt work

for (var j = 0; j < myMsgs.length; j++) {
findDiv = $('#<%= ' + myMsgs[j].id_chat_message + '.ClientID%>');

i know that my problem is the concatenation of the strings, but i dont know how to solve it.

Posted: Feb 4 10 at 12:00

View 3 Replies!   View Related
Web Forms :: Literal Control And String Concatenation
I am having a small problem with the concatenation of a variable being passed into a String. My site is going to be database driven and display youtube videos based off their URL. My videos are not connecting to the URL and I think it is because of the single quotes. Here is the page source:


Posted: Sep 13, 2009 04:47 PM

View 3 Replies!   View Related
Forms Data Controls :: Concatenation Of Two Strings In Markup Portion?
How can I concatenate two string in Markup Portion. See the following:

<asp:Image ID="Image1" runat="server"
ImageUrl='<%#Bind("PictureURL") %>' Width="80px" />

I want to add an pre URL before the binding. How can I accomplish this?

Posted: Feb 19, 2010 02:03 PM

View 1 Replies!   View Related
How To Select All Elements With Specified Css Class In HTML Using C#
Lets assume that I have retrieved page html using HttpWebRequest & StreamReader. Now I would like to cut one div from the loaded html and put it in literal on my page. I know that that div has css class content. How can I do it?

Posted: Mar 10 at 9:28

View 2 Replies!   View Related
HTML Select Size Not Being Rendered?
Recently we copied an ASP.NET WebForms solution. In this solution we are using some ASP:ListBoxes where the Rows property is set to more than 1.

This renders following HTML..

<select size="8" name="ctl00$MainContainer$lbType" multiple="multiple"
onchange="javascript:setTimeout('__doPostBack('ctl00$MainContainer$lbType','')', 0)" id="ctl00_MainContainer_lbType">
<option value="--">-- - --</option>
<option value="BR00">BR00</option>
<option value="BR01">BR01</option>
<option value="...">...</option>

Looks fine to me. But the strange thing is that in the copied solution the browser doesn't render what it should be rendering. The size property seems to be ignored. It just gets rendered as if the size was set to one.

This applies to all listboxes in the solution. I compared the masterpages and web.configs and there are no differences. This issue also applies to all browsers. I used IE8 Developer tools to compare the documentmodes and they are the same for both solutions.

Posted: Jul 29 10 at 14:57

View 2 Replies!   View Related
Binding Datasource To An Html <select> Tag?
Is there any way to bind a datasource to an html select tag with runat=server attribute.

<select runat="server" onchange="showdistrict();" class="textbox" id="DpCity" name="DpCity">
<option value="0">unknow</option>

Posted: Mar 30 at 7:48

View 1 Replies!   View Related
MVC :: Select Data From HTML Form?
I'm new to MVC, so bear with me on this.  I have reviewed a number of tutorials, and sample applications, and have yet to see one that covers getting data selection filters from a HTML form.  I'd prefer not to pass these filters as URL parameters to the controller.  I just thought I would get some opinions, and review my options.  

Posted: Jun 30, 2009 12:13 AM

View 3 Replies!   View Related
.net - Disable And Select Mvc Html.RadioButton?
How can i set selected = true and disable this radio button

<%= Html.RadioButtonFor(m =>m.AddToLevel ,new {id = "rdSameas" }) %>

Posted: Jul 14 10 at 9:06

View 2 Replies!   View Related
Select All Text In Html Textbox?
I want to select all text in textbox while focusing the textbox.

In Html : <input type="text" id="txtbox" value="1234" />
In : HtmlElement txtbox = HtmlDocumentObject.GetElementId("txtbox");

// Here i want to select all text in the textbox while focusing.

Posted: Jan 23, 2009 04:25 AM

View 2 Replies!   View Related
Getting Value Of HTML Select Element On Form Post?
I have a View that has a select drop-down list and an edit button within a form. What I want to do is have the user select one of the options from the select element, click on the edit button, and get the value of the selected option in the Controller method.

I created my form with <% Html.BeginForm(): %>

and the Controller "Edit" method should be called.

I looked through several online examples, but each one focused on how to set values and the default selected value of the select element, rather than retrieving it from the code in the Controller method. I tried grabbing it from the Request.Form collection like:

string val = Request.Form["myDropDownList"].ToString();
and also:
string val = Request.Form["myDropDownList"];

Obviously I didn't do this correctly, because I get a null reference exception. Does anyone have the solution to this issue?

Posted: Mar 29, 2010 06:01 PM

View 10 Replies!   View Related
MVC :: Html.DropDownList Doesn't Select SelectedValue
I am using Html.DropDownList to render a List<object> as a ddl.  I am creating a SelectList object using this code


where countriesRepository.Countries is an IList<Country> and where the Country object has properties CountryCode and CountryName, countryCode is the current country value being passing in.  I want this to go into a DDL called "Parent.Country" and am putting countryList into ViewData["Parent.Country"] - why does this code not work


when this code (changing nothing else) does


The former renders the list, but doesn't select the SelectedValue (I have debugged the countryList and the correct item is listed as Selected=true).

Posted: Sep 10, 2009 02:14 PM

View 11 Replies!   View Related
MVC :: Trying To Use Html Select And I Have Few Values Hard Coded In It?
i am trying to use html select and i have few values hard coded in it. i am trying to use onload,oninit events of it but these events not seems to work in MVC project whereas, other events working fine. can any one confirm that.???

here is code

javascript function
function myfunction()
<select id="first" onload="myfunction()">

Posted: Sep 11, 2009 05:57 AM

View 2 Replies!   View Related
MVC :: Select Item In Html.DropDownlist By Checkbox
I need a control that selects Html.DropDownlist elemnti with the checkboxes you can have an example with the extension method?

Posted: Mar 07, 2011 05:00 PM

View 2 Replies!   View Related
C# - How To Get Html.DropdownFor() To Select Current Element
I must be missing something simple here. This code was working and i can't seem to figure out why it stopped.

First, I generate a selectlist in the controller like this:

// Select List
ViewData["FieldTypesList"] = new SelectList(
genesisRepository.FieldTypes, "ftID", "ftName"

The View that uses this select list looks like this:

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<Genesis.Domain.Entities.Stream2FieldTypes>" %>
<%@ Import Namespace="Genesis.Domain.Entities" %>
<%: Html.DropDownListFor(
model => model.FieldTypeID,
<%:Model.FieldTypeID.ToString() %>

However... the HTML that gets generated shows this:

<select id="Stream2FieldTypes_0_" name="Stream2FieldTypes[0]"><option value="1">Text Area</option>
<option value="2">Text Box</option>
<option value="3">Rich Text</option>
<option value="4">Image</option>
<option value="5">DateTime</option>
<option value="6">Decimal</option>
<option value="7">Integer</option>
3 <!--FYI: current value-->

I am completely missing why the view does not render html that selects 3 (Rich Text).

Posted: Nov 11 10 at 17:21

View 3 Replies!   View Related
Get Selected Text From Html Select In Code-behind?
I use html Select in apsx page and bind it to data in database as dropdown:

<SELECT id="dd" name="dd" runat="server" DataValueField="ID" DataTextField="Name">

Then in code behind, I can get the selected item value(which is mapped to ID) as:

myvalue = dd.value;

But I want to get the selected text(which is mapped to Name), not the value in code behind. How to do it?

Posted: Dec 7 10 at 15:17

View 1 Replies!   View Related
Mvc 3 Pre-select Html.DropDownListFor Not Working In Nerd Dinner?
Learning about dropdown lists, Im trying to add a RSVP create page for nerddinner as in Scott Gu's blog with a Html.DropDownListFor listing available dinners. I can get the dropdown list populated but I cannot get the dropdown to pre select the value ("Sample Dinner 2") I want. Im using an initilizer to seed a few dinner objects in the db. The database is sql ce 4 using a EF 'code first approach'. Sorry I know this is a v common problem and hate to ask, but honestly have spent quite some time on this but cant get it to work:


public class RSVPViewModel
public SelectList DinnersList { get; set; }
public RSVP Rsvp { get; set; }
public string SelectedItem { get; set; }

So is not preselecting the dropdownlist with the value "Sample Dinner 2" when the page loads. The list displays ok and sets the correct DinnerID when I make a selection and click Submit.Tries this also:

@Html.DropDownListFor(x => x.SelectedItem, Model.DinnersList)

but doesnt set or bind to Rsvp.DinnerID.This preselects from the list but doesnt bind (or set Rsvp.DinnerID)


I want to keep it mvc3 so want to implement with strong type using ViewModel approach (no ViewData) and preferably using Html.DropDownListFor (not Html.DropDownList).Viewbag seems unnecessary for this case.Thinking I should be using a selectList of selectListItems I tried this verbose approach :

RSVP rsvp = new RSVP();
string selected = "2";
List<SelectListItem> dinners = new List<SelectListItem>();

foreach (Dinner dinner in dbc.Dinners.ToList())
SelectListItem slDinner = new SelectListItem();
slDinner.Value = dinner.DinnerID.ToString();
slDinner.Text = dinner.Title;
slDinner.Selected = (slDinner.Value == selected);
var dinnersList = new SelectList(dinners, "Value", "Text", selected);
var viewModel = new RSVPViewModel { DinnersList = dinnersList, Rsvp = rsvp, SelectedItem = selected };

However still no work. Should I be making use of the ViewModel SelectedItem property in: @Html.DropDownListFor.. somehow? Something like :@Html.DropDownListFor(x => x.SelectedItem, Model.DinnersList)but how to I get a selected value to set Rsvp.DinnerID. I think thats called binding.

Posted: Jan 26 at 0:43

View 2 Replies!   View Related
Web Forms :: How To Get Html Select (DDL) Selected Value Text In Code Behind (C#)
Iam Dynamically creating a HTML Select(Drop down list) in runtime through Javascript. The DDL values are

<SELECT NAME="mylist" >

I can able to get the value of DDL in CodeBehind

string Name = Request.Form["mylist] .ToString();

For Name iam getting Selected value i.e., if AAA is selected Name=m1. But i want AAA.

My question is how to get selected value Text in codebehind (Instead of m1 i want AAA).I dont want to take the text value through javascript function.

Posted: Nov 28, 2009 11:11 AM

View 10 Replies!   View Related
DropDownList / HTML Select List Default Selection?
For my ASP.NET page, in the code behind I load various items/options into a DropDownList but I do not set a default by assigning SelectedIndex. I notice for the postback SelectedIndex is set to 0, even if I never set focus to or changed the value in the DropDownList.

If not otherwise specified in the code behind or markup, will a default value of 0 be used for the SelectedIndex in a postback with a DropDownList? If yes, is this part of the HTML standard for selection lists, or is this just the way it is implemented for ASP.NET?

Posted: Jul 18 10 at 18:53

View 1 Replies!   View Related
WebMatrix :: Html.ListBox Cannot Select Multiple Items?
I'm trying to use the ListBox html helper in a simple form.

verhuurPrijzenLst is a simple list that gets put into the ListBox, I think I need "MultiSelectList", but I cannot use it (MVC framework needed)?

I don't know exactly how to do that ( bin folder and @inherits ? )

So it's nice to have a helper at hand, but if you cannot use it properly without using the MVC framework, that is a pity.


Posted: Nov 10, 2010 10:16 AM

View 4 Replies!   View Related
Collect The Chosen Value From A Html Select Element And Insert?
I am trying to collect the chosen value from a html select element and insert it into an SQL Server 2005 database and I get the following exception caught:

Failed to convert parameter value from a HtmlSelect to a String.  (I've been converting everything to String before submission to the DB using ToString();

Posted: Apr 14, 2010 08:19 AM

View 5 Replies!   View Related
Web Forms :: Why Simple HTML Select Element Has A Misplaced Focus
This was generated from my page. (ListBox was rendered as select element)

I was able to isolate the focus problem from the ListBox to the following HTML.

Just copy-paste the HTML bellow and open it in a browser window.

The browser renders the Focus in a strange way. I have to solve it for one of our clients.

If the Height is set to 185px the focus  doesn't work properly. I tried to play around with different heights.

Btw, if the Height is set to 81px there's no problem with the Focus.

But I have to have the height at least 170px.


Posted: May 13, 2010 02:35 PM

View 1 Replies!   View Related
Select Form Elements In JQuery Based Upon An HTML Table?
I am working on some ASP.NET web forms which involves some dynamic generation, and I need to add some onClick helpers on the client side. I have a basic outline of something working, except for one huge problem.

There are multiple HTML tables, each generated by a different ASP.NET web control. Each table can contain overlapping field names, which is causing a problem with my JQuery click event handlers. The click event handler is linking to unintended form fields in addition to the intended form field.

I have provided a simplified sample version of the code below. This code is trying to set the value of textbox box1 when a particular radiobutton is selected in the table with id=thing1. Obviously, the jquery code will be triggered for the form fields in both tables.

The tables are dynamically added to the webpage based upon different conditions. It is possible that no tables will be loaded, only 1 table, or both tables might load. In the future, other tables could be added. Each table comes from a different .net web control.

Other than renaming the form fields to make sure they are unique across all user controls, is there a way to have JQuery act only on the intended form fields? In other words, could the table ID be incorporated into the JQuery code in a manner that does not become a nightmare to maintain later?


Posted: May 13 10 at 19:48

View 2 Replies!   View Related
C# - String With Javascript Call Which Is Bound To HTML Select Event?
have the string with javascript call which is bound to HTML Select event:

@Html.DropDownList(Model.DropDownName, Model.ItemsForView, new { onchange = "someMethod('someArgumentValue')" })

which is rendered to the following code:


Is there any way to make ' symbol render "as is"?

Posted: Nov 1 10 at 16:02

View 2 Replies!   View Related
Copyright © 2005-08, All rights reserved