ASP.NET

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.

--Example Table 
create table MYT
(
Column1 varchar(30) null, 
Column2 varchar(30) null,
Column3 varchar(30) null
)

insert into MYT
values('mike','26 June','me@yahoo.com')

--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

name	date	     email
=================================
name	date	    email
mike	26 June	    me@yahoo.com

for (int i = 0; i < dt.Columns.Count ; i++)
{
    dt.Columns[i].ColumnName = dt.Rows[0][i].ToString();
}
dt.Rows.RemoveAt(0);

<%@ Page Trace="true" %>

<a href="http://localhost:8081/WebSite/trace.axd">http://localhost:8081/WebSite/trace.axd</a>[<a href="http://localhost:8081/YourWebSite/trace.axd" target="_blank" title="New Window">^</a>]