C#

string filePath = @"Path_to_your_file_here";
string line;

// Field lengths (I use the lengths from your original post):
int idLength = 5, snLength = 13, amountLength = 15, blankLength = 15;
 
if (File.Exists(filePath))
{
	StreamReader file = null;
	try
	{
		file = new StreamReader(filePath);
		while ((line = file.ReadLine()) != null)
		{
			// Extract fields from the line
                        string id = line.Substring(0, idLength);
			string sn = line.Substring(idLength, snLength);
			string amount = line.Substring(idLength + snLength, amountLength);
			string blank = line.Substring(idLength + snLength + amountLength, blankLength);
		}
	}
	finally
	{
		if (file != null)
		file.Close();
	}
} 

int id;
int sn;
double amount;
int blank;
StreamReader sr = new StreamReader("C:\FileFolder\myfile.txt");//
String strInput="";
strInput=sr.ReadLine();//Read first line in file
while ((strInput = sr.ReadLine()) != null ) //Read file rest of the file
{
     //Use Substring to extract specific portions of the string and assign value to the right variable
     try
     {
        id = int.Parse(strInput.Substring(0,5));
        sn=double.Parse(strInput.Substring(5,13));
       //etc
     }
     catch(Exception e)
     {


     }
}

mehrdad333 wrote:

i want to connect two or more webcams to program

mehrdad333 wrote:

its vital

object oRowCount = Command.ExecuteScalar();
int iRowCount = (oRowCount == null) ? 0 : int.Parse(oRowCount.ToString());

con = new SQLiteConnection(@"Data Source= MyData.db;Version=3;New=False;Compress=True;");<br />
                con.Open();<br />
                cmd = new SQLiteCommand();<br />
                cmd = con.CreateCommand();<br />
                cmd.Connection = con;<br />
                cmd.CommandText = "SELECT COUNT(Call)FROM Hall_Call_Up WHERE Car = 3";

object oRowCount = cmd.ExecuteScalar();
int iRowCount = (oRowCount == null) ? 0 : int.Parse(oRowCount.ToString());

jashimu wrote:

COUNT(Call)

Eduard Keilholz wrote:

int.Parse(oRowCount.ToString()

int iRowCount = (int) Command.ExecuteScalar() ;