How to read this data from Notepad file and save it to sql server table .

Hi Hamid,

Try this..



 //declaring streamreader to read text file
        StreamReader objReader = new StreamReader(filepath);
        string sLine = "";
        int i = 1;
        //checking if the text file is empty or not
        while (sLine != null)
        {
            //reading the line from text file and stored into a string variable
            sLine = objReader.ReadLine();
            //checking the line stored string varible is empty or not if it it not empty storing the value into dropdownlist
            if (sLine != null)
            {
                //data will be available in the string array named as "s"
                string[] s = sLine.Split('^');

//insert statement of data base

            }
        }
        objReader.Close();