i have a column in table and need to combine words seperated by single space, i am using sql server 2005.
DECLARE @text varchar(256)
SELECT @text = 'Micro Tech'
--required output MicroTech
I have two textboxes
1.To get the Hour
2.To get the Minutes
From user.
And in the back end... i would to Combine the data from these text boxes and store it in single column..
For eg.
If textboxHours.Text="11";
textboxMinuetes.Text="56";
In the backend it should store like..
MeetingTime (column name)
11.56
I am redirecting string like this a1|b1, a2|b2,a3|b3.... to another page.
On next page I have repeater control
And I want to show data in repeater control like this
a1 b1
a2 b2
a3 b3.
How can I show value like it in repeater control?
How to replace a character in a String to space or white-space?
View 3 RepliesI have a form with many form fields and controls, with some offering an "other" if a value does not meet the needs for the user. How can I bind the sql insert so that it will take the ddl selection along with the txt field selection for the "other" value? Even if the txt field is empty it should not be a big deal since the ddl would provide something other than null. Since the column in the db does not allow nulls. I'm using asp.net (vb) 3.5 sp1
View 3 RepliesIn my website, users have the ability to upload images to my website. When the image is uploaded it will automatically have a smaller thumbnail created by my website. The thumbnails are not displaying correctly in my repeater though (and by correctly I mean Im not sure how to display them).
Each image sits inside a square div element which is 145 x 145 pixels. Some of the images are 145 wide with a relative height and some are 145 high with a relative width. When my page is displayed the wider images sit at the bottom of my 145 x 145 div,whereas the higher image sit at the bottom and to the left. I would prefer them to all be centered.
I cant find a way to do this is in CSS becuase the images are retrieved dynamically so I cant assign a height beforehand. Is there a way to add white space to my image during the thumbnail creation process so that all images are 145 x 145 but still maintain the aspect ratio? Or can someone think of a good way to do this with CSS and HTML, OR even with javascript (keeping in mind that my images come inside a repeater bound to data in the db.
If you want to see any of my code or the thumbnail creating class just ask.
I'm trying to remove all white or transparent pixels from an image, leaving the actual image (cropped). I've tried a few solutions, but none seem to work. Any suggestions or am I going to spend the night writing image cropping code?
View 4 RepliesI want to be able to show as below in asp.net using vb
Warehouse
Purchasing
System
I am using labels for the above three words. Is there a way to do it.
when i create a chart, it renders with lots of white space around the actual chart itself, especially below the legend. how can i adjust this?
View 3 RepliesIn my ASP.NET application, I was trying to add few white spaces between two text boxes by typing space bar. The equivalent HTML source was instead of . So I just wanted to check: is this the new replacement for white space? If yes, why they changed?
View 3 RepliesFor some reason, the 20px button wraps around to the next line even though the div is 500 pixels wide.What am I doing wrong?
[Code]....
i m using vs2005 for development
i haev desing a one web page with size ( 15 k) now i want to remove the white space and make it in one single line .
how can i separate words in db column separated by enter key. I am entering data in a multi line textbox directly to db, and i want to search a word in that column. Since the words are seperated by enter key, how can i separate the words to search. If i use like i can't search the exact word is there..
View 2 RepliesI have a page with several asp labels with no text. I use a click event to add text the fields that have related values from a datareader. In my code I state that if column value of the datareader is null, then make the label visibility false.
[code]....
That all works fine, but then when I render the page, white space where the hidden labels are located is shown.is it possible to remove the blank white space when labels have null values and are visually hidden?
I found an useful link which show tutorial for setup Gridview export to Excel.http://archive.aspsnippets.com/post/Export-GridView-To-WordExcelPDFCSV-in-ASPNet.aspxIt works well but if I want to preserve white space for certain boundfield, after the excel export, I got merged cell for every row. how do I avoid the merged cells?
[Code]....
I am currently working on an invoice report which may or may not span across multiple pages. I have a header which I have setup to only be displayed on the first page, and a footer which I have setup to only be displayed on the last page. The problem is, the hidden header/footer reserves unwanted whitespace and messes up the report layout (see the screenshot). The black areas represent space that is reserved by the header/footer. There must be a simple way to remove this unwanted space.
View 2 Replies--AND (CONTAINS(O.OrgName, N'"3 step*"')) ORDER BY O.OrgName ( Contain function fails for a string with single character followed by space)
AND O.OrgName
like
'3 step%'
ORDER
BY O.OrgName(Works
perfectly fine)
Contain function fails for a string like 3 step, @ fire etc which has single characters followed by space.
I am having problems with rendering differences between a gridview control and a local report .rdlc rendering. The dataset shows different spacing between characters in the dataset visualizer than it does in the gridview. The sql reporting services report is more closely rendering what is shown in the visualizer. The dataset is filled From a DAL and then bound to the gridview and reporting service at runtime. I'm currently using VS2008 and programming in VB.
View 6 RepliesIm trying to test my extension method that converts a list of strings in a string comma separated:
public static class Extensions
{
public static string ToCommaString<T>(this IList<T> input)
{
StringBuilder sb = new StringBuilder();
foreach (T value in input)
{
sb.Append(value);
sb.Append(",");
}
return sb.ToString();
}
public void TestExtension()
{
IList test=new List<string>();
//test.ToCommaString doesnt appear
}
}
The issue is that in the method TestExtension i cant use ToCommaString method. Do you know what's happening?
Could i make available for all my web application this extension method registering in web.config or something similar?
I am working on a query to pull the revenue for the last 7 days, as individual days, to be used in a bar graph. My query does what I want it to:
[Code]....
My question is: How do I change the Date1, Date2, Date3, etc to display the actual date it is pulling from? So instead of Date1, it will say "Jan. 3 2011" and so on...
can any one helpout my problem that how to insert more than one space between two strings while binding dropdownlist.
View 3 RepliesThe table cells on the List.aspx all have an inline CSS style that prevents the text from wrapping. Sometimes I want the cells to wrap. How do I prevent the inline CSS from appearing?
[Code]....
I have 4 different select statements which i sequently assign to an sqlDataSource like this:
sqlNoutatiProduse.SelectCommand = select;
and i keep the results in different DataViews like
MySession.Current.dataViewNoutatiProduse1 = (System.Data.DataView)sqlNoutatiProduse.Select(DataSourceSelectArguments.Empty);
Is it possible to combine into a single DataView the results of these queries?
I am trying to combine two datatables into single datatable... First table contains 3 columns[e.g: 'col1','col2','col3'] Second table contains 2 columns[e.g: 'col4','col5'] Both tables have the same no.of records[rows], but different columns. How to combine them into single table? I need DataTable with columns ['col1','col2','col3','col4','col5']. I am inserting through looping the both the tables and adding values into third table. I tried the Merge (DataTable.Merge()), but it is adding the records to bottom of first one, but i need it should be added to the side[as columns] to first table'
View 6 Repliesi'm writing a stored proc and if a field i return is longer then 200 characters, i want to truncate, find the last space, remove any characters after that space, then add some full stopseg:
INSERT INTO @rec(articleid, abstract)
SELECT a.id,
CASE
[code]...
