C# Discussion Boards - CodeProject

I am working on an application that uses camera(s) to detect while lane lines on different surfaces adn track them, and eventually give directions to the vehicle (two wheeled robot) so that the vehicle stays in between the lines. So far I managed to write the program so it takes color video feed and converts it to black and white, and filters the edges so it detects the edges of the lanes. I don't know where to go from here. Any suggestions?

Looks like a fun and interesting problem. Without knowing anything more regarding your app I would advice you to look a bit at AI and gaming AI for inspiration.

First of all I would try to create perception layer whose purpose is to present the world in a a simpler format in which your robot knows its options and operate at full speed. This may also give you as a developer ideas of how to interpret robots world and to enhance your world parsing algorithm.

Best of luck
/U

What if the world was your spoon.
What if was in your power to bend it to your liking.
What if it could provide for you whatever you asked of it.

I agree with Uffe Rask, this sounds like an interesting project. Now, I know very little about Robots, modern ones anyway, but I googled for line following robot algorithm and got lots of hits that sounded to me like they might be of help. Perhaps if you do the same (always assuming that you haven't already done so), you might find something that you can adapt.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

What i was thinking, was to use the edges detected and a drawn ellipse. The app will calc the distance between the two lane edges and draw an ellipse in the center of the distanc of the two white lanes. Im just not sure how to make a fast algorithm that scans the binary bitmap for white at the top of the image and then calcs the distance. Im using AForge.NET as my vido processing library. Whats a good way to scan for pixels that is fast, i am doing this at 15 frames a second.

As far as measuring distances, perhaps this article Range Finder[^], might have something useful. THe same guy has written a couple of other articles on Strereoscopy thet you might want to look at.

For fast image processing try this one Fast Pointerless Image Processing in .NET[^]. If you go to the CodeProject Home Page and type fast image processing in the Search Articles box, you will get lots of hits, some of them deal with Edge Detection Methods, which you might also find useful.

Good luck. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Thanks a million bro...as always your a life saver! Thanks again to all who helped throughout the months on my project. Ill followup with my results and i might even post an article about lane tracking with robots and/or vehicles! Big Grin | :-D

sebogawa wrote:
i might even post an article about lane tracking with robots and/or vehicles

That would be really Cool | :cool:

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Hello I am trying to add an event to a button that I created dynamically, but I can not get the event to trigger.

I also want to reference the button in an array of buttons, but I have been unsuccessfull.

Any Ideas? Thank you in advance.

private void btnDouglasBrowse_Click(object sender, EventArgs e)
{
if (fbdDouglasMain.ShowDialog() == DialogResult.OK)
{
tbDouglasFolder.Text = fbdDouglasMain.SelectedPath;
btnDouglasBrowse.Enabled = false;
jtnDouglasMain.FolderName = tbDouglasFolder.Text;
for (int i = 0; i < 20; i++)
{
Button buttonName = new Button();
//buttonName.Location.X = i * 20;
buttonName.Location = new Point(i * 20 + 20,530);
buttonName.Width = 20;
buttonName.Text = i.ToString();
buttonName.DoubleClick += new EventHandler(buttonName_DoubleClick); // This line
this.Controls.Add(buttonName);
}

}

}

private void buttonName_DoubleClick(object sender, EventArgs e)
{
MessageBox.Show("The calculations are complete", "My Application",MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk);

}

Hi,

now that is what documentation[^] is for. A Button's DoubleClick event is disabled by default.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

What I'm trying to do is insert a new record into a SQL Server 2008 database file.

So far the samples I have fount don't work. Does any one know how to do this. Below is one of that samples I did fine.

string UserConnection = Properties.Settings.Default.UsersConnectionString;
SqlConnection MyConnection = new SqlConnection(UserConnection);

MyConnection.Open();

String MyString = @"INSERT INTO UserData (Name, telnetaddr) VALUES('addr.name', 'addr.telnetaddr')";
SqlCommand MyCmd = new SqlCommand(MyString, MyConnection);

MyCmd.ExecuteScalar();
MyConnection.Close();
RMDoor.WriteLn("New Entry Added");

}
catch(SqlException e)
{
RMDoor.WriteLn(e.Message.ToString());
}

bigjoe11a wrote:
MyCmd.ExecuteScalar();

Replace with MyCmd.ExecuteNonQuery();

hope it helps

dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support

Thanks how ever I did try that too. and for some reason. It just not inserting. Its not giving me any errors.

The problem is caused by String MyString = @"INSERT INTO UserData (Name, telnetaddr) VALUES('addr.name', 'addr.telnetaddr')";, in particular the VALUES clause. By enclosing addr.name etc in the quotes they are treated as just another part of the string. Their values are not fetched and used, as you intended.

What you need is a parameterized SQLcommand take a look at the example here[^] and try to adapt it for your data.

Please post back if you get stuck.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Well I'm stuck. Is there a sample related to what I'm doing. This isn't going to work.

I didn't see the extra commands at the top. This is an update. I need an insert

OK.

For now, try breaking the string up like this:

String MyString = @"INSERT INTO UserData (Name, telnetaddr) VALUES('" + addr.name.ToString().Trim() + "', '" + addr.telnetaddr.ToString().Trim() + "')";

Leave out the .ToString() if addr.name etc. is sure to return a string. I would leave the .Trim() there if it were me.
For the future, it might bring benefits to learn about Parameterized Queries, they make things a lot easier in many cases.

Good luck. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

well I'm getting some errors on some of the lines. So I can't compile yet.
I do know that some of of it is missing. My code is below

string UserConnection = Properties.Settings.Default.UsersConnectionString;
SqlConnection MyConnection = new SqlConnection(UserConnection);

String MyString = @"INSERT INTO UserData (Name, telnetaddr) VALUES('" + addr.name.ToString().TRIM() + "', '" + addr.telnetaddr.ToString().Trim() + "')";

SqlCommand command = new SqlCommand(MyString, MyConnection);
//command.Parameters.Add("@ID", SqlDbType.Int);
//command.Parameters["@ID"].Value = ID;
command.Parameters.Add("@Name", SqlDbType.Text);
command.Parameters["@Name"].Value = addr.name;
command.Parameters.Add("@telnetaddr", SqlDbType.Text);
command.Parameters["@telnetaddr"].Value = addr.telnetaddr;

// Use AddWithValue to assign Demographics.
// SQL Server will implicitly convert strings into XML.
command.Parameters.AddWithValue(commandText, );

try
{
MyConnection.Open();
Int32 rowsAffected = command.ExecuteNonQuery();
Console.WriteLine("RowsAffected: {0}", rowsAffected);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}

Error 1 Argument missing C:\Users\Joe\Documents\Visual Studio 2008\Projects\MyDoor\Program.cs 245 66 MyDoor

Error 2 'string' does not contain a definition for 'TRIM' and no extension method 'TRIM' accepting a first argument of type 'string' could be found (are you missing a using directive or an assembly reference?) C:\Users\Joe\Documents\Visual Studio 2008\Projects\MyDoor\Program.cs 233 114 MyDoor

Error 3 The name 'commandText' does not exist in the current context C:\Users\Joe\Documents\Visual Studio 2008\Projects\MyDoor\Program.cs 245 53 MyDoor

What I should have ask if some one could type out the full code So I know I get every thing right.

Error 2 is my fault I put it in uppercase, it should be Trim(). Blush | :O

Have a try with that change while I look at the others.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

None of this is needed now that you are no longer trying Parameterized stuff.

//command.Parameters.Add("@ID", SqlDbType.Int);
//command.Parameters["@ID"].Value = ID;
command.Parameters.Add("@Name", SqlDbType.Text);
command.Parameters["@Name"].Value = addr.name;
command.Parameters.Add("@telnetaddr", SqlDbType.Text);
command.Parameters["@telnetaddr"].Value = addr.telnetaddr;

// Use AddWithValue to assign Demographics.
// SQL Server will implicitly convert strings into XML.
command.Parameters.AddWithValue(commandText, );

either delete those lines or preferably just comment them out until you have the thing working.

Error 3 is caused by Error 2, so should be alright now.

The stuff about MyDoor, I cannot help with, although I remember seeing it in one of your previous posts.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Well this is what why code likes like now. I'm just going to add the rest of the code. I didn't think it would help. Here it is. Don't worry about the RMDoor. Its just an add on library that I added.
////////////////////////////////////

public static void add()
{
RMDoor.ClrScr();

Person addr = new Person();

RMDoor.Write("Enter Name : ");
addr.name = RMDoor.ReadLn();

RMDoor.Write("Address : ");
addr.telnetaddr = RMDoor.ReadLn();

RMDoor.ClrScr();

RMDoor.WriteLn("BBS Name : " + addr.name);
RMDoor.WriteLn("Telnet Address : " + addr.telnetaddr);
RMDoor.WriteLn();

RMDoor.Write("Is this what you want Y/N");
string Q = RMDoor.ReadLn();
Q = Q.ToUpper();
savelog("User has just added an entry");
if (Q == "Y")
{

string UserConnection = Properties.Settings.Default.UsersConnectionString;
SqlConnection MyConnection = new SqlConnection(UserConnection);

String MyString = @"INSERT INTO UserData (Name, telnetaddr) VALUES('" + addr.name + "', '" + addr.telnetaddr + "')";
SqlCommand MyCmd = new SqlCommand(MyString, MyConnection);

MyConnection.Open();
try
{
MyCmd.ExecuteNonQuery();
Int32 rowsAffected = MyCmd.ExecuteNonQuery();
RMDoor.WriteLn("RowsAffected: " + rowsAffected);
MyConnection.Close();
}
catch (SqlException ex)
{
RMDoor.WriteLn(ex.Message);
}

}
else
{
RMDoor.WriteLn("Save Aborted");

}

RMDoor.WriteLn("Press Enter to Continue");
RMDoor.WriteLn();

}

I hope this helps. It just doesn't work.

Apart from the fact that you execute the command twice:

MyCmd.ExecuteNonQuery();
Int32 rowsAffected = MyCmd.ExecuteNonQuery();

I could not see anything wrong with the code, as it is. So I copied and pasted it into a project. To get it to compile on my machine I changed all your calls to RMDoor.whatever to Console.whatever and commented out the savelog line. I created a new database, added a table called UserData with two columns Name and telnetaddr both nvarchar(50).

In the project I created a new DataSource ConsoleUsersTestDataSource from the database above, and ran the project.

Because the command executes twice, it added two new records, with identical data.

Just so that you can see that my code is essentially identical to yours, here it is:

class Program
{
    static void Main(string[] args)
    {
        add();
    }

    public static void add()
    {
        Console.Clear();

        Person addr = new Person();

        Console.Write("Enter Name : ");
        addr.name = Console.ReadLine();


        Console.Write("Address : ");
        addr.telnetaddr = Console.ReadLine();

        Console.Clear();

        Console.WriteLine("BBS Name : " + addr.name);
        Console.WriteLine("Telnet Address : " + addr.telnetaddr);
        Console.WriteLine();

        Console.Write("Is this what you want Y/N");
        string Q = Console.ReadLine();
        Q = Q.ToUpper();
        //savelog("User has just added an entry");
        if (Q == "Y")
        {
            string UserConnection = Properties.Settings.Default.ConsoleUsersTestConnectionString;
            SqlConnection MyConnection = new SqlConnection(UserConnection);

            String MyString = @"INSERT INTO UserData (Name, telnetaddr) VALUES('" + addr.name + "', '" + addr.telnetaddr + "')";
            SqlCommand MyCmd = new SqlCommand(MyString, MyConnection);

            MyConnection.Open();
            try
            {
                MyCmd.ExecuteNonQuery();
                Int32 rowsAffected = MyCmd.ExecuteNonQuery();
                Console.WriteLine("RowsAffected: " + rowsAffected);
                MyConnection.Close();
            }
            catch (SqlException ex)
            {
                Console.WriteLine(ex.Message);
            }


        }
        else
        {
            Console.WriteLine("Save Aborted");

        }

        Console.WriteLine("Press Enter to Continue");
        Console.WriteLine();

    }
}

I can only suggest that you try cleaning your solution (Build | Clean Solution, just in case you don't know) and then rebuild it.

If it doesn't work then, I can only assume that there is something wrong with your database; or you have duplicate databases and that you are updating one of them and checking the other for changes, which obviously won't be there; or something really weird like that.

Apart from deleting the extra ExecuteNonQuery() line I am at a loss.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Thanks. That's works now. It turned out to be the table name was wrong. That's why.
It Shows as UserData and it should be UaersData.

What I did was I went back and check my lines again making sure they were all spelled right and so. I changed so many times. I forgot to change it back.
I can't under stand why it didn't throw an error.

Ok, now. Now how about a search. How can I setup a search. Using the same code or is that not the same.

string sname = "Tom Cat";

So how would I search for this name and if it finds it, it displays the record. If not it throws an error.

For that you will need to use a SELECT Command, which would look something like:

SELECT * FROM dbo.UaersData WHERE Name = @userName

******************************** Note **************************
This is only approximate. and it uses a parameter (the @userName)

However instead of that you can do as you have done for the INSERT and break the string into bits, a bit like:

string commandString = "SELECT * FROM dbo.UaersData WHERE Name = '" + theVariableHoldingTheNameFromTheConsole + "'";

In order to use it efficiently however you really should use the Prameterized methodology.

In the mean time take a look at this[^], scroll down till you reach the Executing SQL Statements that Return Rows Using a Command Object section. This is very similar to the method you have been using. You will then need to research the SqlDataReader object to find out how to get the data from the reader

As this is really basic stuff, I think you will be better off if you do some reading in the MSDN Documentation, and by googling.
If you have any further questions, I would suggest that you start a new thread, as I will be away from my PC for a few hours.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Well I wanted to tell you too. That when I added the new record. It added it. But is didn't save it to the database. When I added the record. And I when to view all the records. The 3rd and new record was there. How ever when I closed the application and
look in the database explorer. to view the records. The 3rd record was missing. Looks like it never got added to the database file.

And all so I have been doing searches for all this at google and I go throw 100's of pages and still can't find what I'm looking for.

Thats why I desided to post.

Dear All

I want to updated the changes made in DataGridView back to SQL Table in an easiest way while i am working with 3-Tire approach (GUI, BusinessLogic, DataAccess)

I have search a lot on Google but i am not able to find a good,simple and easy solution.

Thanks for helping.