Hello Sir....
how we can plot line graph in windows application of .net with c# using text file as input....

the format of text file is:

Wavelength    Reflectance
325          0.09989
326          0.090777
--------------------------------
-------------------------------
1075           0.06866

i have to select text file using OpenfileDialog then it will plot graph on form..

plz help me to solve this problem i need it urgently...

thanks in advance..... 

    
    Thanks jaishree.....
now i can import my textfile to Access database.....
thanku soo much.... 

    
    Thanku soo much Mr. rakesh, I had done it...
thanku soo much... 

    
    Thanks jaishree, actually i m new to this technology, can u plz provide the code for this problem....
i ll be very thankful to u..... 

    
    Your easy solution is to do all from within access.
Modify your Wavelength table to add the new Field P3_Ref in the table designer or if you must do it from C# the SQL is 
ALTER TABLE Wavelength
ADD COLUMN P3_Ref Double;

Import the new data as a new table. File>Get External Data> Import 
In the Import File dialog: select files of Type: Text Files and choose your text file. 
Step thought the Import Text Wizard (choose delimited file with space as the delimiter). Click on each field and set the data type. When this is done you will have imported all the data as a new table (WavelengthP3).

Then it is simply a matter of updating your Wavelength table with the following query (copy and paste into the query designer).

UPDATE Wavelength INNER JOIN WavelengthP3 ON Wavelength.wavelength=WaveLengthP3.wavelength SET Wavelength.P3_Ref = WavelengthP3.P3_Ref;


If you must do from C# then use Kamran’s streamreader with the following SQL

UPDATE Wavelength SET Wavelength.P3_Ref = Variable1
WHERE (((Wavelength.wavelength)= Variable2)); 

    
    Hello Mr. Rakesh, Thanks for ur Help…..

but still my problem is there...

When I add new plant details in database then I hv to also add new column in table Wavelength with that plant name.(This i had done.) and import new text file in that column. 

The suggestion that u recommend in that we can only import into the columns that I had declared in the class…

public decimal P3_Ref {get; set;}

it is just for 1 column only….




Here i write some code in that I am little bit succcessfull but problem is that it Import record after the last record in the database table, I want to add it in series from Wavelength 325 to 1075………


private void button2_Click(object sender, EventArgs e)

{
         
string strProvier = "Provider=Microsoft.Jet.OLEDB.4.0;
DataSource=|DataDirectory|sac.mdb; Jet OLEDB:Database Password=*1234#";
            
OleDbConnection con = new OleDbConnection(strProvier);
           
 OleDbCommand cmd = new OleDbCommand();
           
 int effectedRow = 0;

 int lineCounter = 0;

 con.Open();

 if ((con.State.ToString() == "Open"))
       
{

           StreamReader stReader = new StreamReader(ofd.FileName);  


           //Ofd = Open file Dilaog


           string[] strRowData = null;

           while (stReader.Peek() >= 0)
           {
             lineCounter = lineCounter + 1;

             strRowData = stReader.ReadLine().Split( \t );

             try
            
 {
                        
cmd.CommandText = "INSERT INTO Wavelengtha(AcaciaMollissima) VALUES ( " + strRowData[1] + " )";

                               
 cmd.Connection = con;
                       
 if ((effectedRow == -1))
                      
  {
                           
//Messagebox.Show("Line: " + lineCounter + " Error");  
                       
 }
                       
 else
                        
{
                           
 // Messagebox.Show("Line: " + lineCounter + " Executed Successfully");

}
 }
                   
 catch (OleDbException er)
 {

 MessageBox.Show("Line: " + lineCounter + " Error: " + er.Message);

     }
 }
              
  stReader.Close();

  con.Close();
 }
 else
 {
                
MessageBox.Show("Not Connected To Database");
           
 }
}


Output of above Code:
ID    Wavelength       P1          p2               p3
1     325	       0.0001	   0.0002
2     326	       0.1200	   0.0021	
-     ---	       ------      ------	
751   1075	       0.0023	   0.0056
752              		                    0.0001
753           					    0.0765
754   						    0.0023 
---											                    ------
---						    ------
1502                                                0.0021			

I want Ouput Like:

ID	Wavelength	  P1	      p2               p3
1	325		0.0001	     0.0002         0.0001
2	326		0.1200	     0.0021         0.0765
-	---		------	     ------	    -------
751     1075		0.0023	    0.0056          0.0021

Plz try to solve my Problem. 

    
    Hi,

Best thing I will recommend is first make a Class like
public class WaveLenthInfo
{
public int Id {get; set;}
public int WaveLength {get; set;}
public decimal P1_Ref {get; set;}
public decimal P2_Ref {get; set;}
public decimal P3_Ref {get; set;}
}

Then load your table data into a List<WaveLenthInfo> list
then loop through each line of your text file and extract the P3_ref data and fill in releated object

public Class1()
{
List<WaveLenthInfo> objList = yourListFromTable; 
using (StreamReader reader = new StreamReader((buffer), Encoding.ASCII))
{ 
string line = string.Empty;
while ((line = reader.ReadLine()) != null)
{
if (line.Trim().Length > 0)
{
int irecordId = Convert.ToInt32(line.Substring(0, 2));
objList.Find(h => h.Id == iRecordID).P3_Ref =Decimal.Parse(line.Substring(3, 8)); 
line = null;
obj = null;
}
}
reader.Close();
reader.Dispose();
} 
}

public class WaveLenthInfo
{
public int Id { get; set; }
public int WaveLength { get; set; }
public decimal P1_Ref { get; set; }
public decimal P2_Ref { get; set; }
public decimal P3_Ref { get; set; }
}