Configuration :: Float Numbers Are Converted To Integer After Website Publishing
Nov 20, 2010
In one of webforms user must enter the percent of tax and then I convert it to the float number and finally save it into database. here is a sample:
Dim txtMyPercent
txtMyPercent=Convert.ToSingle(txtPercent.text)
label.text=txtMyPercent
insert into(txtmypercent)
This peice of code, works perefect while runs via Visual Studio 2010, however after publishing, numbers are converted to integer. Thus it can't be inserted into Sql server database .... Server OS: Windows 2003 x64 IIS: 6 .Net Framework: 4.0
View 2 Replies
Similar Messages:
May 26, 2010
I am running on Windows Server 2003. The former site was a .Net 2.0 website built using VWD 2005 as I recall. I downloaded VWD2010 and upgraded the project (from the fileset on the server). Initially I got an error stating: 'Unrecognized attribute 'targetFramework'.
I went into IIS, clicked properties for my application, and set the ASP.NET version to: 4.0.30319. When I restarted IIS, the project could not find any of the 'pages' (i.e., Page Not Found) for all pages. I ran: aspnet_regiis -i Essentially, the web server acts like the application doesn't even exist with the 'Page Not Found' error. I'm sure this has to be a simple issue - but I can't figure it out so far
View 3 Replies
Mar 4, 2010
I am using below code to validate interger and float in asp.net but if i not enter decimal than it give me error
<asp:TextBox ID="txtAjaxFloat" runat="server" />
<cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" TargetControlID="txtAjaxFloat" FilterType="Custom, numbers" ValidChars="." runat="server" />
i have this regex also but its giving validation error if i enters only one value after decimal. [URL]
View 4 Replies
Aug 5, 2010
i have registered a domain and in IIS 7.5 created a new Website for this domain. It works great the ASP.NET website (BlogEngine), now i wanted to add another ASP.NET webapplication to call it something like this:[URL]I tried to add to my existing website, a virtaul path to the ASP.NET webapplication und converted to an application. after calling the URL i get an exception, that i could not load an assembly of the website (mydomain) : Could not load file or assembly 'BlogEngine.Core' or one of its dependencies. The system cannot find the file specified.
View 1 Replies
Feb 26, 2010
We are using visual studio 2005 and SSMSE for this project. I had already created some pages which is capable of inserting and updating the values on the sql server. After inserting and updating it will redirect to another page to view the result. When I add a homepage, something just mess up. When I insert a new items for the table, it prompts a message, DBnulls cannot be converted to type integer. When I try to check at the sql tables, the data was inserted but I was not able to view the result on the other page.
View 5 Replies
Mar 11, 2010
I hv a query regarding publishing the website. I use aspnet2.0 and for uploading we use filezilla.
Whenever I make any changes to my website (either in aspx or aspx.cs page), I need to upload the entire website (along with my bin folder, after publishing)again otherwise my site just doesnt work.Its very time consuming.
View 6 Replies
Nov 9, 2010
I am a bigineer in the asp.net with c#. May any one help me to know "What happen to all .cs files that contain the code on publishing."
View 6 Replies
Nov 29, 2010
I am trying to move my web application from my computer to a server by publishing as a web site. But, after publishing, the user controls defined in the designer files are no longer recognized by the code behind.
View 5 Replies
May 9, 2013
i have textbox it should accept only integer or float values..........
View 1 Replies
Aug 16, 2010
Login not working after publishing asp.net website
I am used default login control, form based authentication and default sqlmembership provider.but in local my site working fine,when i publish it locally in iis means,the login is not working , i don't know what is the reason?
View 3 Replies
Dec 21, 2010
When I try to upload my website I have created to [URL] then test it I cannot see any home page or anything. Just a list of pages etc I have uploaded, Its like im looking into a FTP server. I publish using visual studio 2010, I have tried both Copy website over to my FTP server and Publish website under the build button.
View 8 Replies
Nov 16, 2010
How to publish the website/application on localhost and what should be entered in browser while accessing it from localhost
View 1 Replies
Mar 26, 2011
The file system I'm publishing to is a not hosted by me, but by my university. IT here offers students their own web directory to host a website. My intention is to use it to host projects for classes and demo them for my professors. You can enter in a specific link in any browser to go to this website and view it as long as there is a file named 'index.html' in the directory with some presentable html code.
So here's the problem. I want my website to be written using ASP.NET and when I use VS2010 to publish my ASP.NET website to the 'File System,' I cannot simply open up my browser, type in the normal link, and have it display. It just shows up as a list of files in the directory and I can see all my source code for the web site
View 2 Replies
Jul 8, 2010
Iam exporting dataset to excel , the numbers on the sheet shown as text when export it to excel. Here is the code:
public class Excel
{
const int rowLimit = 65000;
private static string getWorkbookTemplate()
{
StringBuilder sb = new StringBuilder(818);
sb.AppendFormat(@"<?xml version=""1.0""?>{0}", Environment.NewLine);
sb.AppendFormat(@"<?mso-application progid=""Excel.Sheet""?>{0}", Environment.NewLine);
sb.AppendFormat(@"<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:o=""urn:schemas-microsoft-com:office:office""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:x=""urn:schemas-microsoft-com:office:excel""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:html=""[URL]
sb.AppendFormat(@" <Styles>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""Default"" ss:Name=""Normal"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Alignment ss:Vertical=""Bottom""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Borders/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Verdana"" x:Family=""Swiss"" ss:Size=""12"" ss:Color=""#0000A0""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Interior/>{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Protection/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s62"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000""{0}", Environment.NewLine);
sb.AppendFormat(@" ss:Bold=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s63"">{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat ss:Format=""Short Date""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" </Styles>{0}", Environment.NewLine);
sb.Append(@"{0}
</Workbook>");
return sb.ToString();
}
private static string replaceXmlChar(string input)
{
input = input.Replace("&", "&");
input = input.Replace("<", "<");
input = input.Replace(">", ">");
input = input.Replace(""", """);
input = input.Replace("'", "'");
return input;
}
private static string getCell(Type type, object cellData)
{
Object data = (cellData is DBNull) ? "" : cellData;
if (type.Name.Contains("Int") || type.Name.Contains("Double") || type.Name.Contains("Decimal")) return string.Format("<Cell><Data ss:Type="Number">{0}</Data></Cell>", data);
if (type.Name.Contains("Date") && data.ToString() != string.Empty)
{
return string.Format("<Cell ss:StyleID="s63"><Data ss:Type="DateTime">{0}</Data></Cell>", Convert.ToDateTime(data).ToString("yyyy-MM-dd"));
}
return string.Format("<Cell><Data ss:Type="String">{0}</Data></Cell>", replaceXmlChar(data.ToString()));
}
private static string getWorksheets(DataSet source)
{
StringWriter sw = new StringWriter();
if (source == null || source.Tables.Count == 0)
{
sw.Write("<Worksheet ss:Name="Sheet1">
<Table>
<Row><Cell><Data ss:Type="String"></Data></Cell></Row>
</Table>
</Worksheet>");
return sw.ToString();
}
foreach (DataTable dt in source.Tables)
{
if (dt.Rows.Count == 0)
sw.Write("<Worksheet ss:Name="" + replaceXmlChar(dt.TableName) + "">
<Table>
<Row><Cell ss:StyleID="s62"><Data ss:Type="String"></Data></Cell></Row>
</Table>
</Worksheet>");
else
{
//write each row data
int sheetCount = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((i % rowLimit) == 0)
{
//add close tags for previous sheet of the same data table
if ((i / rowLimit) > sheetCount)
{
sw.Write("
</Table>
</Worksheet>");
sheetCount = (i / rowLimit);
}
sw.Write("
<Worksheet ss:Name="" + replaceXmlChar(dt.TableName) +
(((i / rowLimit) == 0) ? "" : Convert.ToString(i / rowLimit)) + "">
<Table>");
//write column name row
sw.Write("
<Row>");
foreach (DataColumn dc in dt.Columns)
sw.Write(string.Format("<Cell ss:StyleID="s62"><Data ss:Type="String">{0}</Data></Cell>", replaceXmlChar(dc.ColumnName)));
sw.Write("</Row>");
}
sw.Write("
<Row>");
foreach (DataColumn dc in dt.Columns)
sw.Write(getCell(dc.DataType, dt.Rows[i][dc.ColumnName]));
sw.Write("</Row>");
}
sw.Write("
</Table>
</Worksheet>");
}
}
return sw.ToString();
}
public static string GetExcelXml(DataTable dtInput, string filename)
{
string excelTemplate = getWorkbookTemplate();
DataSet ds = new DataSet();
ds.Tables.Add(dtInput.Copy());
string worksheets = getWorksheets(ds);
string excelXml = string.Format(excelTemplate, worksheets);
return excelXml;
}
public static string GetExcelXml(DataSet dsInput, string filename)
{
string excelTemplate = getWorkbookTemplate();
string worksheets = getWorksheets(dsInput);
string excelXml = string.Format(excelTemplate, worksheets);
return excelXml;
}
public static void ToExcel(DataSet dsInput, string filename, HttpResponse response)
{
string excelXml = GetExcelXml(dsInput, filename);
response.Clear();
response.AppendHeader("Content-Type", "application/vnd.ms-excel");
response.AppendHeader("Content-disposition", "attachment; filename=" + filename);
response.Write(excelXml);
response.Flush();
response.End();
}
public static void ToExcel(DataTable dtInput, string filename, HttpResponse response)
{
DataSet ds = new DataSet();
ds.Tables.Add(dtInput.Copy());
ToExcel(ds, filename, response);
}
}
View 1 Replies
May 7, 2015
I want to add items DropDownList Csharp using For next loop
int i;
for (i = 1; i <= 4; i = i +1) {
DropDownList1.Items.Add(i.ToString());
}
Code not working.
View 1 Replies
Jun 29, 2010
I am getting int values from the stored procedure. But when i bind this datasource with the gridview i am seeing the values being converted into float. i am using Text='<% # Bind("Quantity") %' I wanna that to be displayed as int, with out zero'seg: let the value be 233, when i bind that its getting displayed as 233.00
View 1 Replies
Oct 12, 2010
I am receiving an error with a line of code I have learnt from a tutorials site (after converting it from C# to VB):
[Code]....
View 4 Replies
Mar 10, 2011
Is there any way that I can make it so that to use a "Production" publish profile, it would require that the build configuration was set to Release?
I believe you're supposed to be able to customize the profiles with add-ons or something...?
View 1 Replies
Mar 7, 2013
Select number,empname,empfathername from emp
where number column is float data type
I need first four dights of number where it consists 10 digits.
num is 1234567890
O/P like to be
1234
View 1 Replies
Dec 2, 2010
if i have a separate dll for each page on my server and that is working fine. if I make some changes in code behind file of a particular page say, xyz.aspx page. then I have to upload the dll of that particular page. and that refreshes the whole web application and all sessions and other values got disturbed in the application. Is there any way that uploading the xyz.dll (of page xyz.apsx) on refreshes the xyz.aspx and didn't disturb the whole web application.
View 1 Replies
Jul 25, 2010
publishing my website,i published my site before just to test how will it look like.but then when i intended to make some changes and publish them, it doesnt update the file that i've copied.even if i deleted the file from the hosting provider then re publish it, it still doesnt work.
View 2 Replies
Nov 30, 2010
When I publish my new web application onto the localhost, my error handling class did not get published with it. Therefore when I go to run the code, the site crashes out because it cannot find the class in the 'App_Data' directory.
Two of the pages (aspx) refer to the class using the following code.
[Code]....
I take it I am missing some referencing step.
View 5 Replies
Dec 5, 2010
This is what my website looks like:
When I build the website and upload everything as it is, I get this error:
Quote:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I guess I have to deploy Database, or?
View 10 Replies
Apr 1, 2011
I have created a website with asp.net and uses oracle connectivity with pl/sql developer.i have uses the crystal report which is a third party tool. how to purchase it.
i am using visual studio 2005 and yes i am using basic crystal crystal that comes with visual studio.
Now suppose i hav purchase a domain www.abc.com.
View 10 Replies
Nov 5, 2012
I've published my website and tried to host in my localsystem.Im getting the login page but cannot login to my application.When i click the submit button in the login page,the page simply refreshes and comesback.The page is not showing any error like 'invalid username or password' which i've set for not proper login
I am using visualstudio 2008 and iis 5.1.What could be cause of this error ??
View 1 Replies
