I am trying to convert some strings fetched from database into 'Title case' however it is not working for records like 'JAMES Smith'. The output is all the same.
TextInfo companyName = new CultureInfo("en-US", false).TextInfo;
if(!myRecord.IsDBNull(myRecord.GetOrdinal("GENCLIENTNAME")))
{
myCompany.GenClientName =companyName.ToTitleCase(myRecord.GetString(myRecord.GetOrdinal("GENCLIENTNAME")));
}
I'm using code to convert items in a Datagrid row from UPPERCASE to Title Case. It works good, but the problem is if it comes across a hyperlink field, it will put in a blank value. Not sure why its doing this, but here is the code below. Wondered if any one has came across this problem and managed to solve it?
The code:
aspx page:
<asp:GridView ID="SectionsGridLevel1" AutoGenerateColumns="False" onrowdatabound="SectionsGridLevel1_RowDataBound" emptydatatext="No data available." runat="server">
<Columns>
<asp:hyperlinkfield headertext="Section - click to view sub-sections" datatextfield="SectName" datanavigateurlformatstring="BrowseSections2.aspx?type=sect&list=1&level=2§ion={0}" datanavigateurlfields="SectID" />
<asp:hyperlinkfield headertext="View" Text="View All" datanavigateurlformatstring="BrowseSections2.aspx?list=1§ion={0}" datanavigateurlfields="SectID" />
[Code]....
I am able retrieve the image for imagebutton from db on to gridview and perform some events but I am unable to view the complete image i.e, i am able to see only part of the image
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns = "False" Font-Names = "Arial" Caption = "UsingImageField">
<Columns>
<asp:BoundField DataField = "cProduct_id" HeaderText = "ID" />
<asp:TemplateField >
[Code] .....
i want the following in 1 div. say <div="topdiv">: i want to display on aspx page one image and its description fetched from database. i want to provide a next button at the side of it, onclick of this the next image and descriptn must be displayed without page being refreshed. i have another div (<div="divbottom"> which displays other information..
View 1 Replieshow to convert the dataset columnnames to UPPER case letters. I have a code like :
[Code]....
But returned dataset result is not showing the uppercase column names.
I have my project set up with the virtual path "/MyVirtualPath", create the virtual directory in IIS 6 (W2003) and everything works fine. Then to work better with Google Analytics I change the virtual path "/myvirtualpath" and change all redicecciones and links to lowercase. also applies the class "lowercase route urls in aspnet mvc" and works perfectly.
The problem I had to modify the virtual directory in IIS, delete virtual path "/MyVirtualPath" and I created the new "/myvirtualpath", but in all cases I use tilde "~" or where I make a "RedirecToAction" (which should take "LowercaseRoute"), continues to maintain the virtual path "/MyVirtualPath". For example, if I see the HTML source code in the browser, see "/MyVirtualPath/Content/Site.css" instead of "/myvirtualpath/Content/Site.css. "
we have a AutoGenerateColumns-enabled WmxDataGrid in which we are able to update table rows in a DataBase connected with a SqlDataSource.
Each time we clear a field an empty string is written to the database where we want to write DBNull values.
At the moment we generate the update string via UPDATE... SET.. and the SQL Server function NULLIF(value, '').
Works proper but when I want to add the values to e.NewValues in BeginUpdate event I'm not able to read the values from the auto generated text boxes. How do I do that? Is there an easier way to automatically convert empty strings to NULL values?
convert.toboolean(request.form["mycheckbox"]
but since the value is 'false', it doesn't seem to cast to boolean. What should I do? I don't like checking for == "false" and then converting to boolean. is there a cleaner way? Update All I am doing is:
if (Convert.ToBoolean(request.Form["somecheckbox"]))
{
}
Strings pulled from a database formatting issues:
These are pulled from fields in a Database and the results are listed below.
This:recognized as a "Woman in Science" at
Turns into this:recognized as a “Woman in Science†at
This:recently received 2 NIH Director's Awards
Turns into this:recently received 2 NIH Director’s Awards
This:- Director of Communications at acme Communications, Inc
Turns into this:†Director of Communications at acme Communications, Inc.
note:This seems to be not happen when using <ul>
<li> but when it is just enclosed in a <div></div> it
shows the †instead of bullet.How can I fix the display of these strings? This is using C# as the language.
Using MVC 2 and VS 2010 RC.I have a varchar database column set to NOT NULL and I use the Entity Framework to bind the column to a textbox. I want a user to be able to leave the textbox blank and have an empty string inserted into the database column. However, MVC is trying to set the property to null during the Create postback, which causes ModelState.IsValid to be false and subsequently the validation UI is triggered with the message "The value '' is invalid".Here is the model:
[Code]....
The controller:
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Create(Candidate c )
{
if (ModelState.IsValid) // This is false when the textbox is left blank.
[code]...
I am using a form to add and edit record of database.
In Add case my email box has no value. I have used customservervalidation to check the given email address with previous database records.
In Edit case my email box is populated with data from database.
When i click save button in both cases my customservervalidation method invokes and checks the given value. it works fine for new/add case but in edit case it checks with itself also and says duplicate email... pointing own record...
I have a database table that contains list of all UserTypes(constant strings) used in the application.
What is the best way to store(what datastructure do I need) these so that code can access them ?
The need is similar to enum, but I want to associate these values to those in DB so that there will not be 2 places to edit in case of adding/removing an entry.
one other option I considered is using public static readonly string, but how to associate with those values in DB ?
I have application that fetches email configuration settings such as host (SMTP Server name), username (SMTP Username) and Password from App.Config File as shown below
<system.net>
<mailSettings>
<smtp from="name@example.com"><network host="smtp.gmail.com" userName="test123@gmail.com" port="25" password="PassworD"/>
</smtp>
</mailSettings>
</system.net>
Now i wish to configure the settings that i have set in database and NOT from App.Config File. From database the credentials are not available in SMTPClient's properties .FYI, they are saved in database as well as the values are also correct.
[Code]....
this is the code for login.aspx.vb it checks the username and password in the database and redirecrs to respective page on the basis of rows returned. i'm having problem in finding a right function in the sqldatareader namespace so that it counts the number of rows affected.
so you will have to bare with me, but I've been trying to figure this out for a month now and I'm getting to my wits end.Basically, all I want to do is take a field of an MS-Access database and display it as the page's title. Currently I have a sub page_load to display the content from the database on an id autonumber basis. The info for this is displayed using formview.Ive tried numourous different ways and scoured the net, but unfortunately cannot find a simple way that dosen't get highly confusing.So now for the title, I'm trying to run this below, but am getting a whole bunch of errors.
My database is "dblatesteditorials.mdb"
table is "editorialpage"
field is "header"
[code]...
I have a page which lists stores,malls of individual cities. I have used the list of cities in DropDownList. I have added dynamic title to page as like
Page.Title="Stores in"+DropDownList1.SelectedValue;
It works fine. But when I see that page in Google Search then its showing only one title like "Stores in Delhi". Here 'Delhi' is in the default selected value in DropDownList1. But as I have many cities in that DropDownList1, I want to show each value of DropDownList1 to be appear in search result as title according to search query. For example if user types search query "Stores in Jaipur" then search result should show result with this title "Stores in Jaipur" Remember that Dynamic title is working fine but question is that "How to show is in search result"
How to display the data in title tag from database in asp.net
eg
<html xmlns="[URL]">
<title>Here i want to display the data using server control </title>
</head>
<body>
<form id="form1" runat="server">
.....
</form>
</body>
</html>
How to Display Icon IN title bar of Browser with title?
View 7 RepliesIn my application I have the following message:Object reference not set to an instance of an object.
@Html.DropDownList("Title",ViewData["PersonTitle"] as SelectList, Model.Person.Title)
The dropdownlist contains simple strings (person titles). When you select a title, that title should be returned to my model. Controller code:
ViewData["PersonTitle"] = new SelectList(new[] { "Dhr.", "Mevr." });
Why is this not working ? Edit: The purpose is to change
@Html.EditorFor(model => model.Person.Title)
into something like this
@Html.DropDownList("Title",ViewData["PersonTitle"] as SelectList, Model.Person.Title)
On UI Ajax calendar control is used to allow the user Expiry Date as shown below. As this is one of the controls in search, when the Search button is pressed using SQL statement (copied below) data is retrieved from ExpiryDate column of the table. The table creator declared the column type as string and the dates are saved as single digits(Example: 2/2/10 sometimes and sometime as double digits (Example: 02/02/10) I like to know the best practice in retrieving both type of strings from database table. Calendar control
[Code]....
SQL(part of stored proc)
[Code]....
with in button click event stored procedure is called to return search results.
Does the script service means creating a webservice in asp.net?
View 1 RepliesI am binding a datalist to some table 0 of a dataset from the database. When I check the number of rows in the dataset table 0 it's coming as 129 but when I check the count of the datalist items(using Datalist_Name.Items.Count) inside the datalist item created event I am getting a maximum count of 128.Due, to this I am unable to assign values to the last label control(last as in the last row) present inside the datalist dynamically. I am not sure where I am going wrong. I even tried to replicate the same code inside the ItemDataBound event but even then I am getting the same error.
View 5 RepliesI have a custom object that I'm throwing into the viewstate on an async postback. If I step through the code, I can put the object into the viewstate, then call the object from the viewstate and cast it with no problems. The code, when stepped through, has no issues whatsoever. However, when I go to FF and run it, I get "60|error|500|Error serializing value 'Case' of type 'Case.'" First thing that hits me as weird is that the value is being named as the type. It's not like value oCase (an instance of Case) of type Case. I've checked that all containing objects are set for serialization, compiled and rerun the web app.
View 4 RepliesI'm creating some url rewriting for asp.net. Now I am tobbing if I should include the id in url or just the title. Do you guys know if it's a significant performance hit to lookup an item by title instead of id?
View 4 RepliesHow to convert ASPNETDB.MDF mssql database to MySql which works with ASp.NET
View 1 Replies