|
have a look here[^], this might be useful to you
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
The user will enter the value in textarea like this
1 100224 KBD PS-2 104KEYS TVSE GOLD WHITE
1 will be first word
100224 will be second word
KBD PS-2 104KEYS TVSE GOLD WHITE will be thrid word
How i will seperate these words in .net
|
|
|
|
|
only two letters away from being an asset
|
|
|
|
|
Try to use String.Split(' '). Then extract the first two items in the resulting array and combine all leftover items (don't forget to put a whitespace between each item while combining).
Btw, your user enters all these value by hand? I hope I am not forced to do this...
|
|
|
|
|
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
why posting the same thing twice... Try split('') to do the job. split using spaces.
|
|
|
|
|
String.Split method allows you to control how many parts you will get back, so for example, you can specify that you only want 3 parts and once it has split the string into 3 parts, it won't look for any further splits.
For example, see the following code:
string s = "1 100224 KBD PS-2 104KEYS TVSE GOLD WHITE";
string[] parts = s.Split(new char[] { ' ' }, 3);
// NOTE : s will be broken up into maximum of 3 parts, instead of potentially 8 parts;
foreach(string part in parts)
{
// TODO : Do something with part;
}
I hope that helps. You can also give the method a StringSplitOptions value to control if you will get empty entries, etc.
|
|
|
|
|
没有明显的分隔符啊
living none stoping.
|
|
|
|
|
The following is the line i need to split.
100224 KBD PS-2 104KEYS TVSE GOLD WHITE 6600 9213551
KBD PS-2 104KEYS TVSE GOLD WHITE is one word.
|
|
|
|
|
What do you mean? Separate the elements? What have you tried so far?
only two letters away from being an asset
|
|
|
|
|
The user will enter the value in textarea like this
1 100224 KBD PS-2 104KEYS TVSE GOLD WHITE
1 will be first word
100224 will be second word
KBD PS-2 104KEYS TVSE GOLD WHITE will be thrid word
How i will seperate these words in .net
|
|
|
|
|
What have you tried so far? We're here to help, not give it to you without trying.
only two letters away from being an asset
|
|
|
|
|
Try this:
string[] separatedStrings = myString.Split(' ');
|
|
|
|
|
shijivijayan wrote: The following is the line i need to split.
100224 KBD PS-2 104KEYS TVSE GOLD WHITE 6600 9213551
KBD PS-2 104KEYS TVSE GOLD WHITE is one word.
shijivijayan,
What does it mean ? Do you want to split all the word in this line? or this are two different line and you want to split them?
|
|
|
|
|
Hi,
I have a populated DataTable of vaying columns and rows. I need to somehow take the data of the 1st row and make this the column name of the column in which it is found eg;
Column1 | Column2 | Column3
name | date | email
mike | 26 June | me@you.com
dave | 05 Apr | him@wibble.co.uk
should read as:
name | date | email
mike | 26 June | me@you.com
dave | 05 Apr | him@wibble.co.uk
Any suggestions?
Many Thanks.
|
|
|
|
|
In GridView1_RowDataBound event you can do like that,
if (e.Row.RowIndex == 0)
{
e.Row.Cells[0].Text = "Name";
e.Row.Cells[1].Text = "date";
e.Row.Cells[2].Text = "Email";
}
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
That doesnt solve the problem unfortunately.
As explained i need to take the content of the cell in row1 and make that the column name. This is because i dont know the content of row1 nor do i know how many columns there are, since the info is from an uploaded source. Likewise i dont have a gridview, i have a datatable as the work is being done in the codebehind.
Thanks anyway.
|
|
|
|
|
In GridView1_RowDataBound,
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Visible = false;
}
if (e.Row.RowIndex == 0)
{
e.Row.RowType = DataControlRowType.Header;
}
hope this will help you.
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
Hi still someway off what im asking help with but thanks anyway.
|
|
|
|
|
Good Afternoon
Step 1
--Example Table
create table MYT
(
Column1 varchar(30) null,
Column2 varchar(30) null,
Column3 varchar(30) null
)
i made some inserts in the tables like this
insert into MYT
values('mike','26 June','me@yahoo.com')
and i had this
--Assign Variables
DECLARE @Col1 varchar(15)
set @Col1 = (select top 1Column1 from MYT)
--rename the Column
exec sp_rename 'myT.Column1',@Col1
go
--Assign Variables
DECLARE @COL2 varchar(15)
set @Col2 = (select top 1 Column2 from MYT)
--rename the Column
exec sp_rename 'myT.Column2',@Col2
go
--Assign Variables
DECLARE @Col3 varchar(15)
set @Col3 = (select top 1 Column3 from MYT)
--rename the Column
exec sp_rename 'myT.Column3',@Col3
and the Tale looked like this
name date email
=================================
name date email
mike 26 June me@yahoo.com
as you can see the Columns are still in the table , Delete the first row.
hope it Helps
Vuyiswa Maseko
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Vuyiswa,
Thanks but unfortunately i need to do this in the codebehind before uploading the DataTable to a SQL2005 server since i need to do some columnmapping via SQLBulkCopy.
So i really need a solution which is able to work in the c# codebehind and programmatically perform the changes to the DataTable.
Thanks.
|
|
|
|
|
Hi
Try this
for (int i = 0; i < dt.Columns.Count ; i++)
{
dt.Columns[i].ColumnName = dt.Rows[0][i].ToString();
}
dt.Rows.RemoveAt(0);
himanshu
|
|
|
|
|
Himanshu!!!!!
Yet again you are a genius and an amazingly helpful guy.
(i just hope this works now )
Thanks!
|
|
|
|
|
|
Hi,
I am assigned to do some performance test in asp.net site. The customer feels that the page loads very slow. I want to investigate the performance of all action happened in the page. Is there any way to get individual method performance?
Thanks in advance.
|
|
|
|