I've got a string like this 128000,0000 ,But this should be : 238.000,00 , and i should have it as: 128,000.00
The string can also be 20000000,0000 but also 23000,0000,So the all should be changed, but what is the best way to do this, i'm busy with substrings.. but it would be a load of code for something so easy?
I'm a web developer and I work primarily in Django -- I've never used ASP.Net or anything like that before, but I'm troubleshooting a problem for a friend's parents / client so I need some advice!
It's pretty simple: I need to change the parameters of their SQL Server database connection because of some server upgrades that happened at their hosting company -- is it ok for me to go in and just edit a .cs file, or does it need to be compiled or some other business?
Literally just need to change the parameters of
mySqlConn = new SqlConnection("server=hostname;database=dbname;uid=username;pwd=password;");
I have a web application that tracks financial data. I would like to have the option where a user can edit their currency via dropdown. The different currency types will be held in a database and a user can then select which currency they wish to use. The easiest way I can see doing this would be to check what the currency value is and dynamically change the culture to match the currency, thus I could continue to use the string str = String.Format("{0:C}", revenue);format. I am open to other suggestions but this just seemed the most logical to me.
View 2 Repliesi have two clock times in my DB as varchar datatype.. i loaded it from db as varchar itself. in C# i have assigned this value to a datetime variable.. how can i get the time from the datetime variable without changing it into a string.
View 4 Repliesi have created a website and i have published into a server whose connection string is specified in the connection string
Now i am sending the published files to some company.
If they just change the connection string of web.config to their server, will it work?
now the output is
<picture>11000covcl_2.jpg</picture>
<picture>11000covcl_3.jpg</picture>
<picture>11000covcl_4.jpg</picture>
[Code].....
My requirement is to save the connection string of database that will be provided to be me by user on form, which can be modified lator.
i need to know how and where i should store the connection string permanently which will be used lator to connect to database.
I'm loading data from my database into a DataTable, and one of the columns is a date field.
[Code]....
I'd like to format that column so that instead of containing a full date, it will be formatted like "MM/DD/YYYY".
I've tried looping through each row in the table and changing the cell for that column, but I get an error saying that the string isn't a valid DateTime object.
I tried changing the column DateType to a string, but I get an error saying I can't change the DateType after the table is filled.
How can I do this? This seems like such a simple thing, but I'm having so much trouble with it.
I have a problem that the OnLoad event is not fireing when I navigate to a page and just change the query string. If I do a postback it is called, then changing the query string ones more OnLoad gets called.
Here is how i try. I navigate to the page OnLoad fires -> then change the query string page updates (all bound elements get updated) OnLoad does not fire -> I do a postback using a button OnLoad fires -> then change the query string OnLoad fires. I will try to explain in more detail.
The system has log in window when I log in I navigate to an other aspx page sending two query string messages the last query string is a number (page.aspx?key=text82&key2=2010). When I get to the page the first time PageLoad event gets called and all is fine, if I in the browser change the key2 to 2011 and press enter the PageLoad does not get called but all my bound elements get updated (GrivView etc..). If I then do a postback using a button the PageLoad gets called. If I now change the 2011 back to 2010 and press Enter PageLoad is called. I try this is firefox the PageLoad get called every time. I tired to write a test website but I do not get the same problem, but what i found out is that in IE 8 changing the query string to the same number and pressing enter the PageLoad is not called. But doing so in firefox makes the postback fire. Here is the test code
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Welcome to ASP.NET!
</h2>
<p>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Default2.aspx?t=tt& tttttt=2010">HyperLink</asp:HyperLink>
</p>
<p>
You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409"
title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
</p>
</asp:Content>
Navigates to
<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/Site.master" CodeFile="Default2.aspx.cs"
Inherits="Default2" %>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><asp:Button ID="Button1"
runat="server" Text="Button" />
</asp:Content>
OnLoad event Default2.aspx
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text += "Called " + DateTime.Now.ToString();
}
How can I change the parameter value from Interger to String.
Here below is the part of the code that creates problem; the constant "sqlStatement" is as string, but when the parameters "@ProdColor" read the value it returns an integer instead of the proper type which is a string. I have tried every ting like: CType(sqlStatement(splitItems(1)), string)
Or convert or parse, but it keeps returning the wrong type.
Const sqlStatement As String = "INSERT INTO ProductDetails (ProdID,ProdColor,ProdSize) VALUES"
If item.Contains(",") Then
splitItems = item.Split(",".ToCharArray)
cmd.Parameters.AddWithValue("@ProdID", SqlDBType.Int).Value = sqlStatement(splitItems(0))
cmd.Parameters.AddWithValue("@ProdColor", SqlDBType.NVarchar).Value = sqlStatement(splitItems(1))
cmd.Parameters.AddWithValue("@ProdSize", SqlDBType.NVarchar).Value = sqlStatement(splitItems(2))
I have some problem to understand how this example works with the updatepanel. I have put a ListBox4 and a label inside an updatepanel and put the property for the ListBox to AutoPostBack = true; So what I now am trying to do is when I click on the four items in the ListBox, I want the label to update the new String that is clicked in the ListBox. However what first happens when I click the 2:nd item is that I get the error:
Index was out of range. Must be non-negative and less than the size of the collection. I wonder what the correct way is to do this. I am not sure to know what is right here ? I think many example I do will be solved if I learn this one.
[Code]....
I want to know if I develop and application using entity framework 4.0 and sql server and then changing the connection string to my sql one, will it work without any problem?
What are the other considerations to keep in mind?
i have a dropdownlist contaning years..now i want to connect my database by dropdown selection.if i select 2013 it will connect 2013 database ,if i select 2014 it connect 2014 so on..
View 1 RepliesThe problem is when am assigning my session table value to newly created table and if now am changing any coloumn name then the session table value also changing.
But my question is am assigning Session value to newly created table so how should session value should be affected?
for refference in my application
sessionState
mode="InProc"
I m facing some problem. i m not passing Dynamic string through query string..
I m using this code
string abc = "CPCB_" + TextBox1.Text + "_" + TextBox2.Text;
Response.Write("<script>window.open('xml.aspx?Flag=3&date='+abc,target='new');</script>");
i facing a problem to change the date format at gridview display.
below is my coding:
[code]....
on VWD 2005 this code works fine, but on 2008 it says I haven't created an instance of the object. I want to convert the object connString (a connection string) into a string.
'This acceses the virtual directory web.config file for connection strings
'We have to convert the object to a connection string
Dim rootWebConfig As System.Configuration.Configuration
rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/VirtualDirec")
Dim connString
As System.Configuration.ConnectionStringSettings
connString = rootWebConfig.ConnectionStrings.ConnectionStrings("ConnectString1")
Dim strConnString
As
String = connString.ToString().......
I'm concatenating a string in codebehind to use in a sql select statement.
in aspx
<asp:Label ID="LabelHidden" runat="server" Visible="False"></asp:Label>
SelectCommand="SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)"
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_Employees" Name="ID"
PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter ControlID="LabelHidden" Name="ActivityName"
Type="String" />
</SelectParameters>
in codebehind
foreach (ListItem li in ListBox_Activities.Items)
{
if (li.Selected)
{
queryBuilder += li + "', ";
}
queryBuilder = queryBuilder.Substring(0, queryBuilder.Length - 1);
LabelHidden.Text = queryBuilder;
When i run the code it comes up blank. I did a query trace and it seems to be running as
exec sp_executesql N'SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)',N'@EmployeeID int,@ActivityName nvarchar(50)',@EmployeeID=4,@ActivityName=N'Production Technical Support'', Tools Development'','
with exta "'s
How can i format the queryBuilder string correctly in my code?
//Read string contents using stream reader and convert html to parsed conent var parsedHtmlElements = HTMLWorker.ParseToList(new StringReader(contents), null);
//Get each array values from parsed elements and add to the PDF document foreach (var htmlElement in parsedHtmlElements) pdfDoc.Add(htmlElement as IElement);
//Close your PDF pdfDoc.Close(); Response.ContentType = "application/pdf";
//Set default file Name as current datetime Response.AddHeader("content-disposition",
[Code] ....
Error: Input string was not in a correct format. Contents in html file giving error ...
Suppose i am having 25 character length string and I want to bind only first 15 character of that string into the label control.
<a href="[URL]" >"<span class="name" style="text-align: left; font-family: Arial; color: #0094DA; font-size: 14pt">
<%#Eval("Name").ToString().Length >= 30 ? Eval("Name").ToString().Substring(0, 30) : Eval("Name").ToString()%></span></a>
At debug time I would like to see what are the keys in my InitParams collection - I can't seem to be able to list them.
EDIT:As Jon suggests below, this might be a bug within the Silverlight debugger. To reproduce, just create a new Silverlight Application within Visual Studio 2010 and just edit code
{
public partial class MainPage : UserControl
{ [code]...
I have project in development where string operations like "Hi " + variable + ", welcome to Project" are used at many places (given example is very minor one).
One of the requirement is to convert it to string.format style.
It is very long and tedious job, where I would not like to break earlier working code due to any human error might happen while converting it.
I would like to if any Macro or VS command which I can create to handle it. Just like we mark block of code and do Extract function in Re-factor options.
I want to split a string that taking both string and integer values like (Cmp_12). I want to use them in Separately.
View 4 RepliesI am fetching some data from Db and displaying it in a textarea using jquery in the following way.$('#textareatest').val('<% =teststring %>').It is possible that the string 'teststring' can contain XHTML line breaks(<br/>).whenever the string contains <br/> I am getting the 'unterminated string literal' error.I saw a number of posts considering '' as line breaks and suggesting to escape it.I tried to escape the <br/> similarly,but it didn't work.
View 4 RepliesI've build a random string generator but I'm having a problem whereby if I call the function multiple times say in a Page_Load method, the function returns the same string twice.here's the code
Public Class CustomStrings
''' <summary>'
''' Generates a Random String'
''' </summary>'
''' <param name="n">number of characters the method should generate</param>'
''' <param name="UseSpecial">should the method include special characters? IE: # ,$, !, etc.</param>'
''' <param name="SpecialOnly">should the method include only the special characters and excludes alpha numeric</param>'
''' <returns>a random string n characters long</returns>'
Public Function GenerateRandom(ByVal n As Integer, Optional ByVal UseSpecial As Boolean = True, Optional ByVal SpecialOnly As Boolean = False) As String.............