Hello,

I know there is an example in the ASP.NET 1.1 ... Wrox book about checking whether the user has alread registered for updates. I implimented the example in the book, but it didnt seem to work so well. There must be another way of doing it without using cookies.

I just want the code to check if the user is alread in the database. I am using c#. I should think i need to use an IF statment, but how?

Brett:D

Use a simple select query to check for a user against your table:

Select count(*)
From <table>
Where <col> = @userid

then use an if statement to do what you want to do based on the result

I tried using the select command below,

strCommand = "SELECT [Addressbook].[Email] FROM [Addressbook] WHERE [Addressbook].[Email] = @txtFrom.Text";

however it didnt seem to collecting data from the txtFrom textbox, it gave me an error that:

No value given for one or more required parameters.

To view the code:
http://www.sks.co.za/workingEMAIL4.aspx

Brett

Sorry, I forgot that the code will be rendered in html.

here is the code:

           OleDbConnection objConnection;
           OleDbDataAdapter objCommand;
           String strConnect;
           String strCommand;
           DataSet DataSet1 = new DataSet();

                      //Connect to access database
           strConnect = @"Provider=Microsoft.Jet.OLEDB.4.0;";
           strConnect += @"Data Source="+Server.MapPath("//db//sks1.mdb")+";";
           strConnect += @"Persist Security Info=False";
           objConnection = new OleDbConnection(strConnect);


           strCommand = "SELECT [Addressbook].[Email] FROM [Addressbook] WHERE [Addressbook].[Email] = @txtFrom.Text";
           objCommand = new OleDbDataAdapter(strCommand, objConnection);
           objCommand.Fill(DataSet1, "Addressbook");

Thanks

Brett

You can't put a control property in a literal string like that. .NET doesn't implicitly figure out that you are referring to an object. You need to concatenate the value like this:

strCommand = "SELECT [Addressbook].[Email] FROM [Addressbook] WHERE [Addressbook].[Email] = '" & txtFrom.Text & "'";

-Peter