C#

public class TextToDataSet
//created by ashish gupta on 12/5/2005 for log register
	{
		public TextToDataSet()
		{
			//
			// TODO: Add constructor logic here
			//
		}

		public static DataSet Convert(string File, 
			string TableName, string delimiter)
		{   
			//The DataSet to Return
			DataSet result = new DataSet();
    
			//Open the file in a stream reader.
			StreamReader s = new StreamReader(File);
        
			//Split the first line into the columns       
			string[] columns = s.ReadLine().Split(delimiter.ToCharArray());
  
			//Add the new DataTable to the RecordSet
			result.Tables.Add(TableName);
    
			//Cycle the colums, adding those that don't exist yet 
			//and sequencing the one that do.
			foreach(string col in columns)
			{
				bool added = false;
				string next = "";
				int i = 0;
				while(!added)        
				{
					//Build the column name and remove any unwanted characters.
					string columnname = col + next;
					columnname = columnname.Replace("#","");
					columnname = columnname.Replace("'","");
					columnname = columnname.Replace("&","");
        
					//See if the column already exists
					if(!result.Tables[TableName].Columns.Contains(columnname))
					{
						//if it doesn't then we add it here and mark it as added
						result.Tables[TableName].Columns.Add(columnname);
						added = true;
					}
					else
					{
						//if it did exist then we increment the sequencer and try again.
						i++;  
						next = "_" + i.ToString();
					}         
				}
			}
    
			//Read the rest of the data in the file.        
			string AllData = s.ReadToEnd();
    
			//Split off each row at the Carriage Return/Line Feed
			//Default line ending in most windows exports.  
			//You may have to edit this to match your particular file.
			//This will work for Excel, Access, etc. default exports.
			string[] rows = AllData.Split("\r\n".ToCharArray());
 
			//Now add each row to the DataSet        
			foreach(string r in rows)
			{
				//Split the row at the delimiter.
				string[] items = r.Split(delimiter.ToCharArray());
      
				//Add the item
				result.Tables[TableName].Rows.Add(items);  
			}
    
			//Return the imported data.        
			return result;
		}
	}

leelaraj wrote:

CDate isnot a recognised function name

leelaraj wrote:

how to cnvert Mod 60 in to sql server

skyeddie wrote:

my EXCEL DATABASE

private void ParseBoldText(RichTextBox tb)
{
    int boldCount = 0;
    int lastBoldStartPosition = 0;
    int currentPosition = 0;

    while (currentPosition < tb.Text.Length - 3)
    {
        if (tb.Text.Substring(currentPosition, 3) == "<b>")
        {
            if(boldCount == 0)
                lastBoldStartPosition = currentPosition;
            boldCount++;
        }
        if (tb.Text.Substring(currentPosition, 4) == "</b>")
        {
            boldCount--;
            if (boldCount == 0)
            {
                tb.Select(lastBoldStartPosition + 3, currentPosition - lastBoldStartPosition - 3);
                tb.SelectionFont = new Font(tb.SelectionFont.FontFamily, tb.SelectionFont.Size, tb.SelectionFont.Style | FontStyle.Bold);
            }
        }
        currentPosition += 1;
    }

    //clean the <B> tags, carefulf to use the RTF property instead of TEXT property !!!!
    tb.Rtf = tb.Rtf.Replace("<b>", "");
    tb.Rtf = tb.Rtf.Replace("</b>", "");
}

tb.Rtf = tb.Rtf.Replace("[b]", "");<br />
tb.Rtf = tb.Rtf.Replace("[/b]", "");