My Table Structure
Table Name Table1
ItemName Rate
A 10
B 15
C 20
D 25
E 30
I have return a Sql Query in my code behind as
Select Rate from Table1 where ItemName(A,C,D);
The following Rate should be displayed in my textbox in this format 10,20,25
using .NET 2.0 want to format datagrid , i am using DataGrid. i am saving data from textbox to database as formated text. now while retriving data from database i can see html format data i need to format : Example
<B> test my text </B> new test. want to show in dagagrid like test my text new test: and when i click on datagrid i want to see test my text new test this format not styling below code for data grid
<asp:GridView ID = "gvNotes" AllowPaging ="false" PageSize = "5" PagerSettings-Visible = "false" Width = "99%"
CssClass = "Grid" EmptyDataText = "No records found." runat = "server" DataKeyNames = "NOTES_ID"
AutoGenerateColumns = "false" OnRowCommand="gvNotes_RowCommand" OnRowDataBound="gvNotes_RowDataBound">
<EmptyDataRowStyle HorizontalAlign = "Center" Height = "30px" />
<Columns>
<asp:BoundField DataField = "NOTES" HeaderText = "Notes">
<ItemStyle CssClass = "GridRow" HorizontalAlign = "left" Width = "60%" />
<HeaderStyle CssClass = "GridHeader" HorizontalAlign = "left" />
</asp:BoundField>
<asp:BoundField DataField = "DATE" HeaderText = "Note Added Date">
<ItemStyle CssClass = "GridRowPadRight" HorizontalAlign = "Right" Width = "20%" />
<HeaderStyle CssClass = "GridHeader" HorizontalAlign = "Right" />
</asp:BoundField>
<asp:TemplateField HeaderText="Edit">
<ItemStyle HorizontalAlign="Center" Width="5%" CssClass="GridRow" />
<HeaderStyle CssClass="GridHeader" HorizontalAlign="Center" />
<ItemTemplate>
<asp:ImageButton ID="btnEdit" ImageUrl="~/Images/Edit.jpg" ImageAlign="Middle" runat="server"
CommandName="Edt" CommandArgument='<%#((GridViewRow) Container).RowIndex %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemStyle HorizontalAlign="Center" Width="5%" CssClass="GridRow" />
<HeaderStyle CssClass="GridHeader" HorizontalAlign="Center" />
<ItemTemplate>
<asp:ImageButton ID="btnDelete" ImageUrl="~/Images/Delete.jpg" runat="server" CommandName="Del"
CommandArgument='<%#((GridViewRow) Container).RowIndex %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
i want read from text box if there ; make sql qury then work thorw all string's
View 2 RepliesWhen I select a row from a grid view to update the fields of this row appearin many textboxes and I have an email field which I want it to split into 3 textboxes to updateex:if I have this email: xx@yy.com I want the xx appears in first textbox and yy appears in second textbox and com appears in third textbox I actually did it correctly but it raises an error when trying split the last part(com) here is my code:
txt1_email1_update.Text="";
txt1_email1_update.Text=txt_email_update.Text.Split('@')[0];
txt2_email1_update.Text = "";
txt2_email1_update.Text = txt_email_update.Text.Split('@')[1];
txt3_email1_update.Text = "";
txt3_email1_update.Text = txt_email_update.Text.Split('.')[2];
i have data like this 10.03 i split it 10 in textbox1 and 3 in text box2 .
but my need is textbox1 10 and in
textbox2 as 03
There is a "singleline" Textbox in my page in which both date and time are fetch from database table column "DateTime".
I want Time to be come below Date in that "singleline" Textbox.
I can't take that Textbox as "multiline". How to split date and time in singleline Textbox?
How to achieve this?
I displayed some words in text box.. The words are,
performcontextEmpRecordhostcontextEmpRefertlcontextEmpdatadatascontextEmpofficemain
contextEmppersonalhardwarecontextEmpsalaryhighcontextEmptype
Now, I want to store these words into database table using asp.net with c#..
each word should be stored into new row..(i.e words spilit into space)..
i would like to display phone number fields on a website as (123) 456-7890 but have the system see it as 1234657890 when calling myTextBox.Text i am thinking this would require overriding the text property and cleaning it up in the overridden property but wanted to run this past the community.
View 2 Repliesthis is my asp code
<ItemTemplate>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="19%">TRANS. NO. </td>
<td width="1%">:</td> [code]...
if the ID is NULL in the database the table or the ITEM will be hide...
I have a label , which has 1000 as default value .
And i have a textbox where user will input the value ...
I want to sum the total value of label and textbox and show in the same textbox .
Here am using one textbox ...
I have below digits. I want to show one digit after to decimal. How to format it?
2.85
2
1.99
I was using ("{0:0.0}". But data showing like
2.9 //It should be 2.8
2.0 //It should be 2
2.0 //It should be 1.9
I would like to ask is it possible to show crystal report in pdf format in web? I know how to export crystal report in pdf format, however, it is exported to client's computer.
View 1 Replieshow to show data in bar graph format in asp.net.
View 3 Replieshow to show the number seperated by comma
1000 to 1,000
I mean here is money format.
I have a modalpopup inside it I have checkboxes,when I check the checkboxes and save the changes there is a dynamically created table with dynamically generated labels.I have a checkbox Birthdate inside the modal popup which shows the mm/dd only.And another checkbox below it that will show the year only, and will be visible if Birthdate checkbox is checked. I want to show that if Birthdate checkbox is checked and the save button is clicked then insisde the dynamic table it will show the mm/dd only.And if year checkbox is checked ,and the save button is clicked, then it will show the Birthdate inside the dynamically created table as mm/dd/year.
View 2 RepliesI would like to display date format in the GridView as follows:
First column - Date: null / yyyy-MM-dd
Second column - Decimal:
if 0/null = 0.00
if 10 = 10.00
if 10.1 = 10.10
if 10.11 = 10.11
if 10.111 = 10.111 (no need to rounding)
How can I do that?
I am working on a web application in which i was showing images with .jpg format initially. Now requirement changed and i have to show images with .tif format. I tried this but it is not showing images on my data list view.
View 1 RepliesI have a number 2879068. I want to display it in currency format as like 28,79,068 in C#
View 4 RepliesI am using Microsoft Visual Studio Professional 2010. (Also SQL Management Studio for my database but this information may not be needed, just trying to give enough to make sure what i am doing is understood)I am making a website in ASP.NET with Visual Basic.net code behind. The site is basically a contact list site. 3 Text Box Fields. First Name, Last Name, Main Phone #. Add Record Button (Takes the information from the text boxes and inserts into a database) GridView that shows the database that is being populated with the informationI want to be able to type in for example a 10 digit number and as you type in the number... in the text field you see the formatting... (999) 999-9999. I do not want the user to have to put the hypens or parenthesis... just the number.
The number is then taken and added to a database but i only want the number 9999999999 to be sent to the database.I hope it is understood that when I say 9999999999 I actually mean whatever telephone number the user inputs.I also have a GridView that Visual Studio has and I inserted that. After this my next step will be taking that raw number and putting formatting for visual purposes in the GridView. But my question for now is how to do the formatting only in the text field and to only pass to SQL the 10 digit number without formatting. I hope I was clear. I am new to all of this actually. I saw something called AJAX.. don't know if I need it.
I have a field called WATER METER READING(Right now its a textbox to take 6 numbers) on my HTml page, but I need to change its format to display as [][][][][][] (6 separate small (single digit forms)).... all 6 fields required and all need to be a number. finally it should look like this.Water Meter Reading:* [][][][][][]
View 4 RepliesIs there a way to get the selected date on the calendar extender to show in UK format of dd/mm/yyyy
View 3 Replieson my web form i have a standard textbox.after the user enters a number i want to set it's format so 12500 - will be set to 12,500 and so on.how can i do it?
View 2 Repliesi want to set format for text like bold ,Italic or underline same as here on toolbar given i wan to do for text box and wanan save same one in database and get data from Db how i can do i dont want to use rich text box becoz i have alerady text box and dont want freetextbox.dll and i found by using this when i use italic i can not save in Database got error like db truncate error
View 4 Replieshow to format currency in a textbox? i don't want to user ajax maskextender..
View 5 RepliesI have ListView that has the following EditItemTemplate:
<EditItemTemplate>
<tr style="">
<td>
<asp:LinkButton ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
<asp:LinkButton ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
</td>
<td>
<asp:TextBox ID="FundingSource1TextBox" runat="server" Text='<%# Bind("FundingSource1") %>' />
</td>
<td>
<asp:TextBox ID="CashTextBox" runat="server" Text='<%# Bind("Cash") %>' />
</td>
<td>
<asp:TextBox ID="InKindTextBox" runat="server" Text='<%# Bind("InKind") %>' />
</td>
<td>
<asp:TextBox ID="StatusTextBox" runat="server" Text='<%# Bind("Status") %>' />
</td>
<td>
<asp:TextBox ID="ExpectedAwardDateTextBox" runat="server" Text='<%# Bind("ExpectedAwardDate","{0:MM/dd/yyyy}) %>' onclientclick="datepicker()" />
</td>
</tr>
</EditItemTemplate>
I would like to format the "ExpectedAwardDateTextBox" so it shows a short date time but haven't found a way to do this without going into the code behind. In the Item template I have the following line to format the date that appears in the lable:
<asp:Label ID="ExpectedAwardDateLabel" runat="server" Text='<%# String.Format("{0:M/d yyyy}",Eval("ExpectedAwardDate")) %>' />
And I would like to find a similar method to do with the insertItemTemplate.