I am fetching data from MySql database.When i look at the object it looks like this:But when this object is converted to String then it appears like this:The Formatting of the object is gone..How can i get/show the original formatting that is fetched from the database..
View 5 RepliesI have problem in converting date to string I am using cstr(p.tripstart) , which is returning Date as 12 Aug 2010 12:AM I need to make formating This is my code :
[Code]....
I am getting object refernce error at line:if (Session["Tax"].ToString() == "9")
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Tax"].ToString() == "9")
{
lblTax.Text = Session["Tax"].ToString();
}
else
{
lblTax.Text = "0";
}
}
Is anything wrong I have done?
I have an web application solution in asp.net webforms with 3 projects named:
1) TestiModels where are custom classes.
2)TestiServices where are are asmx web services
3)TestiApp where are UI files like default.aspx. inside this project consume webservices
For two days I am getting this error at default.aspx file:
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 70: u.gender = RadioButtonList1.SelectedValue;
Line 71: u.photo_path = FullPath;
Line 72: int retVal = service.InsertUser(u);
Line 73: if (retVal == -1)
Line 74:
Source File: c:UsersJonTestiAppTestiAppDefault.aspx.cs Line: 72
Models are located in a separate project named TestiModels
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace TestiModels
[code].....
I want to show just a part of a string for example:
Instead: "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua."
Just a: "Lorem ipsum dolor sit amet, consetetur sadipscing..."
Which method can I use to do that?
In my repeater I am attempting to set the label format based on a value from my datasource. The following line from my repeater is straightforward enough but now how would I modify it if I wanted the "C2" statement in the ToString to pull from a field in my datasource named "MyFormat" which would contain either the C2 or N0 value? Basically switching the formatting for that label between currency and a double?
<asp:Label runat="server" ID="lblValue1" Text='<%# Convert.ToDouble(Eval("MyValue")).ToString("C2") %>'></asp:Label>
I've attempted to simply insert a statement such as Eval("MyFormat") in place of the "C2" statement but to no avail.
I am trying to create a control, but I need to load my formatting string from my web.config file, but every time I try to run the program I get an error one the formatting line. show me the correct syntax to load this data?
[Code]....
im getting an error converting this IP to string
[Code]....
{
i'm developing a website. i have a registration form where user can registered with this website. this have a birthdate field for store user's birthdate.that is a textbox. here is my code.
[Code]....
I have a textbox wherein user is allowed to enter the value of type (4,4) but that will be in string and while sending it to database I need to convert this value to double format. I have searched alot but alas no help .for example my string is 12.244 and i need to convert it into double value 12.2440.
View 3 RepliesI want to display a Gridview of Patients before I submit them to the database. Is there a way(better way), other then List<Patients>, to bind a list to a GridView.
I am using Linq to SQL and I have a DAL with the Patients table inside. I create a new list of Patients
[Code]....
Now the problem is I can't use a Linqdatasource or Objectdatasource to link to the GridView as no data is in the db yet. The only thing that works is GridView.DataSource = _patients; but I lose all automatic formatting and as far as I can tell it is going to be a pain to format manually. It would seem I should be able to somehow link my object _patients to an one of the datasourses so I would have formatting and all.
I have the following code, which generates insert queries
For Each f As String In Directory.GetFiles(d)
objSQLStringBuilder.Append("insert into table1 (full_path, file_name) values ('" & f.Replace("'", "''") & "', '" & f.Remove(0, Len(d) + 1).Replace("'", "''") & "');")
Next
However, the paths which it finds are formatted as follows c:program filesmicrosoft officewinword.exe I need to format the paths as follows file:///c:/program%20files/microosoft%20office/winword.exe. How can I modify the above code to do this?
I've been wrestling with this for a while, and I just can't seem the get the correct amount of quotes in the correct place, so as a last resort, I'm hoping someone could attempt to correct it.
[Code]....
i want to bind my table to the datagridview in VB.net windows form (not in asp.net). but when i try to bind and run the applicatiion i got the following error "syntax error converting datetime from character string". my table contains two date filed"pdate","date" which contains the date in the followingg format"2010-02-01 00:00:00.000 i want to bind this date fileds to datagrid view.
View 2 RepliesBased on below code, how to convert the data ? For the UnitCost input Data is float.
protected void CalNett_TextChanged(object sender, EventArgs e) {
int GrossWeight = Convert.ToInt32(WMGrossWeight.Text.ToString());
int UnitCost = Convert.ToInt32(WMUnitCost.Text.ToString());
decimal NettWeight = (GrossWeight - 85);
decimal TotalCost = (NettWeight * UnitCost);
if (WMItem.SelectedValue == "SW.307.004 ")
this.WMTotalCost.Text = TotalCost.ToString();
}
I have a calculation that takes place utilizing the TimeSpan.FromTicks method, the result is stored in a TimeSpan object. The calculation itself is working correctly, but I'd like to format the result a bit nicer than it is and I can't figure out how to format a TimeSpan.
The result from the TimeSpan is:
00:00:04.6153846
I'd like to remove any preceding zero's and round up to the second decimal place, such as:
4.62
Does anyone know how I might be able to accomplish this? I can't seem to find a .NET 'built in' solution.
DateTime.Now.ToString("h:mm tt")
What is the proper way to.. escape if that is the proper term, that html entity so that it will produce the output Code: 8:53 am and the non breaking space is rendered correctly be the browser?
I have a table in my SQL DB that is a DateTime table, what I want to do is take the numeric datetime it stores and convert it to a long date (i.e. 12/12/2012 conversts to December 12, 2012). Seaching the forums it looks like the string.format is the way to go and searching for info on that I found [URL] which lists all the different formats but they do not list a formating string to convert to the format I want to use. Does anyone know what format string I would use to convert a numeric date to a long date like I want? And can you show it in a code example because I am not 100% sure I understand the code examples shown on that site.
View 4 Repliesi want to search record with dropdown list and text box
i have fields in dropdown like
1.Orthopedics
2.Clinic
3.Pharmacy
4.ENT
when i select one field and type date in text box i want a list of record submitted on this date with the specific field
I Tried This
protected void Button1_Click(object sender, EventArgs e)
{
DateTime date1 = Convert.ToDateTime(TextBox1.Text);
con.Open();
[Code]....
conversion failed when converting date and/or time from character string
I'm trying to submit my form into the database but I'm getting this error on the cmd.ExecuteNonQuery() section:
Conversion failed when converting datetime from character string.
I have three date fields (in bold below) and in the database they are set up as datetime (8).
What am I missing:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection("Data Source=cmssolutions.db.9373013.hostedresource.com; Initial Catalog=cmssolutions; User ID=CMSSolutions; Password=CMSMedical1")
If BMItxt.Text = "" Then
BMItxt.Text = "01/01/1900"
[Code] ....
I have a label I want to display as a lovely number format i.e. {0:N0} Now, this label text equates to a query string value.How do I go about formatting a label's text from a query string value in one fell swoop?I have tried this
lblTotalPurchQS.Text = String.Format("{0:N0}",Request.QueryString["totalpurchasequantity"].ToString());
I am unable to convert JSON string to .net object in asp.net. I am sending JSON string from client to server using hidden field (by keeping the JSON object.Tostring() in hidden field and reading the hidden field value in code behind file)
Json string/ Object:
[[{"OfferId":"1","OrderValue":"11","HostingTypeID":"3"},
{"OfferId":"1","OrderValue":"11","HostingTypeID":"3"},
{"OfferId":"1","OrderValue":"11","HostingTypeID":"3"},
{"OfferId":"1","OrderValue":"2","HostingTypeID":"3"},
[Code]....
While converting i am getting following error:
Expecting element 'root' from namespace ''.. Encountered 'None' with name '', namespace ''.
I want to be able to store strings in the DB but some are long and i want to format them such that when i copy them out of SQL and past them into notepad they have line breaks to break up the otherwise single line that runs on forever and hard to read.
lets say i am storing a string of all the session variables like this, how do i include line breaks in here?
StringBuilder theBody = new StringBuilder();
theBody.Append("Session Values: " + "
");
foreach (string s in Session.Keys)
theBody.Append(s + ":" + Session[s] + "
");
We have a service that generates a report (using word templates and a 3rd party library), and then returns a string in HTML. While this HTML isn't great - its formatted correctly in this string. We want this HTML to show up on a page - format intact. What we currently have done is set an ASP.net Literal's text element to this string. While this works, I have noticed that it has reformatted the HTML string slightly. For the most part, it looks like it generated a bunch of new CSS classes, and a new style element in the HTML. This HTML does not exist in the string thats being returned. I could filter all of this back out, but wonder if there is a better way. I assume that the Page itself is altering something. What is the best way to display this raw HTML back to the user? I can't directly use a Response.Write(string), because this page does have a few other controls on it.
View 3 RepliesThis is the Firefox error console window when I clicked on any page.
Error: Sys.WebForms.PageRequestManagerServerErrorException: Conversion failed when converting from a character string to uniqueidentifier.
Source File:
[URL]
And here's the aspx code:
[Code]....
And here's the RowCommand method:
[Code]....
Her'es the SQLDataSource adapter control:
[Code]....