"Build Your Own ASP.NET Website Using C# & VB.NET" released by SitePoint

[rbutler]

I have not setup an outlook account. Do i need to do this first?

No, IIS takes care of processing the emails on the local side. IIS takes care of processing emails remotely (as well when dealing with domains), but that is solved system admins. Why is it still not working locally?

[ScottArmand]

Thanks for asking RButler, but the problem still persists. My first posting was the error stack. The second posting was the code from the book customized for SQL/MSDE.

So, I have not got the SQL portion of chapter 8 working.

Thanks again

[Dave01]

No, IIS takes care of processing the emails on the local side. IIS takes care of processing emails remotely (as well when dealing with domains), but that is solved system admins. Why is it still not working locally?

Hey

I have no idea why it don't work . I have looked in my reports provided by Norton AV and i can see the activity such as

Connection: localhost: 2568 to localhost: smtp(25), 502 bytes sent, 1522 bytes received, 1.265 elapsed time and Details: Connection: localhost: 2568.
to localhost: smtp(25).
502 bytes sent.
1522 bytes received.
1.265 elapsed time.

So an email is going through but why does the other side not recieve it? I have tried sending to different addresses...
Any ideas? cheers.

[rbutler]

Scott, can you log into MSDE via WebDataAdmin? If so, can you query for result sets from any given table(s)? If you can't, then the database engine isn't working right. If not, post back.

[rbutler]

Dave, try disabling Norton AV and then try sending the mail.

[ScottArmand]

RButler,

Yes. I can log on to MSDE via Web data admin on localhost/sqlwebadmin using sa, password, and SARMANDXPLTCLON as the login entries. I can query the Dorknozzle DB and create stored procedures.

Thanks,

Scott Aramand

[rbutler]

Then you've got me stumped on why you're receiving this error, unless I'm missing something in code.

[ScottArmand]

Yeah, I'm stumped too. Well I am moving on with Microsoft Access portion. I am trying to getthe select statement working to display a single address from figure 9.7. However, the if statement does not work. That is, all the rows are returned. This is true even of the code in the book, so it does not work either.

My code is as follows

void BindData()
{
objConn.Open();
if (Request.QueryString["id"] != null)
{
objCmd = new OleDbCommand("SELECT * FROM Employees Where EmployeeID=" + Request.QueryString["id"],

objConn);
objRdr = objCmd.ExecuteReader();
dgAddressBook.DataSource = objRdr;
dgAddressBook.DataBind();
}
else
{
objCmd = new OleDbCommand("SELECT * FROM Employees", objConn);
objRdr = objCmd.ExecuteReader();
dgAddressBook.DataSource = objRdr;
dgAddressBook.DataBind();
}
objRdr.Close();
objConn.Close();
}

When I mouseover Shane and left mouse click I am redirected to the proper URL: http://localhost/DataGridsWithStyle.aspx?id=8. However, all the rows are displayed. Thus, the else logic is executed. If I rework so there is no if else as follows:

void BindData()
{
objConn.Open();
objCmd = new OleDbCommand("SELECT * FROM Employees Where EmployeeID=" + Request.QueryString["id"], objConn);
objRdr = objCmd.ExecuteReader();
dgAddressBook.DataSource = objRdr;
dgAddressBook.DataBind();
objRdr.Close();
objConn.Close();
}

I get

Server Error in '/' Application.
--------------------------------------------------------------------------------

Syntax error (missing operator) in query expression 'EmployeeID='.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'EmployeeID='.

Source Error:


Line 22: objConn.Open();
Line 23: objCmd = new OleDbCommand("SELECT * FROM Employees Where EmployeeID=" + Request.QueryString["id"], objConn);
Line 24: objRdr = objCmd.ExecuteReader();
Line 25: dgAddressBook.DataSource = objRdr;
Line 26: dgAddressBook.DataBind();


Source File: c:\Inetpub\wwwroot\MasterDetailNotRedirecting.aspx Line: 24

Stack Trace:


[OleDbException (0x80040e14): Syntax error (missing operator) in query expression 'EmployeeID='.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +111
System.Data.OleDb.OleDbCommand.ExecuteReader() +6
ASP.MasterDetailNotRedirecting_aspx.BindData() in c:\Inetpub\wwwroot\MasterDetailNotRedirecting.aspx:24
ASP.MasterDetailNotRedirecting_aspx.Page_Load() in c:\Inetpub\wwwroot\MasterDetailNotRedirecting.aspx:16
System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp, Object o) +5
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +784841
System.Web.UI.Control.OnLoad(EventArgs e) +102
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1064


It's as Request.QueryString does not pass in the variable.

Has anybody else had this problem, and know how to fix it.

Thanks,

Scott

[YourPhobia]

Hey all.
I just worked through the calander app and when I run it I get the following error:-
Access to the path "C:\schedule.bin" is denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path "C:\schedule.bin" is denied.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Source Error:


Line 28: dtmDate = myCalendar.SelectedDate;
Line 29: arrCalendar[dtmDate.Month - 1, dtmDate.Day - 1] = myNotes.Text;
Line 30: strmFileStream = new FileStream("C:\\schedule.bin", FileMode.Create);
Line 31: fmtrBinaryFormatter.Serialize(strmFileStream, arrCalendar);
Line 32: strmFileStream.Close();

Im kinda stick on this one. any one able to offer any assistance? Thanks
***EDIT***
Hey hey hey I solved it I just had a security problem just added everyone to the C:\ and it works gr8. thanks anyway

[YourPhobia]

Hi guys Hope some one can help me out.
In chapter 8 you discuss updating records. I have a problem here . I first worked of the book and though ok I might have made an error some where, So i downloaded the code fomr the archive. I have created a new project (the one in the download files ie chapter 8->CS->Project and I have compiled it. Now when I try to run Admin tools it works but I cant update anything. It left me select a name, and delete a name (employee) BUT I can't update it, whn i click update, it does something (no errors) but it does not update any of the fields i type into. Any ideas? I am using all the code you provide I have not modified it in any way as i downloaded it from your site. thx.
Thanks.
Heres the code for the update function:

void UpdateEmployee(Object s, EventArgs e) {
objCmd = new OleDbCommand("UPDATE Employees SET Name=@Name, Username=@Username, Address=@Address, City=@City, State=@State, Zip=@Zip, HomePhone=@HomePhone, Extension=@Extension, MobilePhone=@MobilePhone WHERE EmployeeID=@EmployeeID", objConn);
objCmd.Parameters.Add("@EmployeeID", ddlEmployees.SelectedItem.Value);
objCmd.Parameters.Add("@Name", txtName.Text);
objCmd.Parameters.Add("@Username", txtUsername.Text);
objCmd.Parameters.Add("@Address", txtAddress.Text);
objCmd.Parameters.Add("@City", txtCity.Text);
objCmd.Parameters.Add("@State", txtState.Text);
objCmd.Parameters.Add("@Zip", txtZip.Text);
objCmd.Parameters.Add("@HomePhone", txtHomePhone.Text);
objCmd.Parameters.Add("@Extension", txtExtension.Text);
objCmd.Parameters.Add("@MobilePhone", txtMobilePhone.Text);
objConn.Open();
objCmd.ExecuteNonQuery();
objConn.Close();

BindData();
}

Hey hey hey guys sorry to post and post and post - I figured it out . For some reason I had to put EmployeeID as the last value/paramater strange. :s

[ScottArmand]

FYI - The reason the code from the book does not work is the id is pointing to addressbook. Instead of MasterDetail.

<asp:HyperLinkColumn DataTextField="Name" DataNavigateUrlField="EmployeeID" DataNavigateUrlFormatString="addressbook.aspx?id={0}" HeaderText="Name" />
<asp:BoundColumn DataField="Extension" HeaderText="Extension" />

[iluna]

Hello Zak, does this book focus on ASP.NET 2.0?

[YourPhobia]

HI ppl. I have just started the chapter on web servcices and i'm very confused - was wondering if any one can help me. Im using .net framework V1.0, ASP.NET and C#. Im using aspx files with CS (code behind files). I just don't seem to get the grasp of the web service. I understand how you can create your own web services on local host and consume them, but I have no idea how consume a third party web service using say www.xmethods.com. Can any one reccomend a good tutorial that shows you how to consume a thirdy part web service using the Add web reference tool in MS Visual studio .net 2003?

Thanks..

[benq]

hello all

i was wandering if anyone could help me with this,

i,m using this from the boook and in visual studio 05 pro

<script runat="server" language="c#">


void page_load()
{}
void addtocart(object s, DataListCommandEventArgs e) {
}
dataset finditem(int item_number) {
}
decimal getitemtotal() {
}
void cart_edit(object s, DataListCommandEventArgs e) {
}
void cart_cancel(object s, DataListCommandEventArgs e) {
}
void cart_update(object s, DataListCommandEventArgs e) {
}
void cart_delete(object s, DataListCommandEventArgs e) {
}
void continueshopping(object s, EventArgs e){
}
void checkout(object s, EventArgs e){
}

</script>

<script runat="server" language="c#">
oledbconnection objconn = new oledbconnection(
Configurationsettings.appsettings["dsn"]);
oledataadapter objda;
dataset objds = new dataset();
datarow objdr;
datatable objcartdt;

void page_load()
{
if (!IsPostBack)
{
objda = newoledataadpter("select * from music", objconn);
objda.fill(objds, "store");
items.DataSource = objds;
items.DataBind();
showcart.Visible = false;

objcartdt = (datatable)Session["cart"];
if (objcartdt == null)
{
objcartdt = new datatable("cart");
objcartdt.columns.add("cartid", typeof(Int32));
objcartdt.columns["cartid"].autoincrement = true;
objcartdt.columns["cartid"].autoincrementseed = 1;
objcartdt.columns.add("item_number", typeof(Int32));
objcartdt.columns.add("stock_level", typeof(Int32));
objcartdt.columns.add("item_name", GetType(String));
objcartdt.columns.add("item_price", GetType(Decimal));
Session["cart"] = objcartdt;
}
}
}

void addtocart(object s, DataListCommandEventArgs e)
{
showitems.Visible = false;
showcart.Visible = true;

int item_number = Convert.ToInt32(
Items.datakeys[e.Item.ItemIndex]);
dataset objiteminfo = finditem(item_name);
objdr = objcartdt.newrow();
objdr["item_name"] = item_name;
objdr["item_description"] = objiteminfo.tables["item_description"].rows[0]["item_price"];
objcartdt.rows.add(objdr);
obcart.datasource = objcartdt;
dgcart.databind();
}


</script>

i have 8 errors

Error 4 The type or namespace name 'dataset' could not be found (are you missing a using directive or an assembly reference?) D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 126 7 D:\...\amierabbasv3\
Error 5 The type or namespace name 'oledbconnection' could not be found (are you missing a using directive or an assembly reference?) D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 146 7 D:\...\amierabbasv3\
Error 6 The type or namespace name 'oledataadapter' could not be found (are you missing a using directive or an assembly reference?) D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 148 7 D:\...\amierabbasv3\
Error 7 The type or namespace name 'dataset' could not be found (are you missing a using directive or an assembly reference?) D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 149 7 D:\...\amierabbasv3\
Error 8 The type or namespace name 'datarow' could not be found (are you missing a using directive or an assembly reference?) D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 150 7 D:\...\amierabbasv3\
Error 9 The type or namespace name 'datatable' could not be found (are you missing a using directive or an assembly reference?) D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 151 7 D:\...\amierabbasv3\
Error 10 Type 'ASP.copy_of_music_aspx' already defines a member called 'page_load' with the same parameter types D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 153 12 D:\...\amierabbasv3\
Error 11 Type 'ASP.copy_of_music_aspx' already defines a member called 'addtocart' with the same parameter types D:\Documents and Settings\AMIER\My Documents\Computer Studies yr 2.2\E.W 2\Ica 2\amierabbasv3\Copy of music.aspx 179 12 D:\...\amierabbasv3\


can some please care to look

[benq]

hi all

i,m using this book to build a small shop but i,m using the code dfferently is it possible for the interface to be in:

default.aspx - thats the interface for the shop
default.aspx.cs - thats the functionality and the problematic one.


thanks

[rbutler]

can anyone take a look

You haven't specified the appropriate namespaces for the OleDb database driver and DataSets in your page. Place the below as the very first two lines in your document, unless you're using a complete doctype, then place them right after the doctype.

 <%@Import Namespace="System.Data.OleDb"%>
 <%@Import Namespace="System.Data"%>

[rbutler]

Hello Zak, does this book focus on ASP.NET 2.0?

No.

[realwebbuilder]

hi Zak. i just bought your book. it is really great. but could you please tell me how to use a checkboxlist in your shopping cart, so the customer can select many products at the same time and add them into his shopping cart? thanks a lot.

[realwebbuilder]

Have you looked at Microsoft Press books? How about Thompson Learning, Prentice Hall, or even Deitel. Those books get up into the $75-$80 range. I'll tell you one thing, I've authored for Que, Sams, and SitePoint and I can say that the time the SitePoint team puts into these books is well worth the extra $10 you pay per book.

hi Zak, i just bought your book, it is great. but i have a question:
how to validate controls when you use datalist or datagrid binding dataset. for example at the page 453 figure 12.3, it seems you can not use a asp .net client side validation for the textbox. you have to hard code at server side with error handling and some if statement. thanks a lot

[tawanda]

Hie Zak
I ve gone thru your book and i must say i found it very easy to undestand and follow,good work.
But i have a question for you.Lets say after adding items to a shopping cart and intergrating the cart with Paypal, i want to insert the items purchased into an Order table.How do i insert the item into the table and all the other items for that same order,were do i implement that functionality and could you please give me an indication or guideline on how to do it.

I would greatly appreciate.

Thanks

Tawanda

[jeffc7272]

Hi,

I've been reading and re-reading Zak's book for the last six months and am finally starting to get a handle on some of basics of the vastness of asp.net (i've coded in asp for years). It is an excellent book by the way. I've thoroughly enjoyed it and would recommend it to anyone who wants to get their feet wet with asp.net.

I've been working with the shopping cart for some of my own sites, modifying it to add some more functionality and it's been great. I have come across one small issue that I have not been able to figure out. Sometimes when I add a product to the cart and then add a second item, only one item will be displayed. As I add more items it will seem like there are two datatables being created, each one showing some items, then sometimes the table will show all the items. It's strange and doesn't happen all the time. It's also something that happens with the code straight from the book, not just my modified code. I've noticed on several different computers and several different browsers (IE and Firefox).

Was wondering if anyone else has come across this and, if so, have been able to remedy it? The original logic in the code looks pretty solid and I still don't know enough aspx at this point to figure this out where I'm not just getting a blatant error.

Thanks for any assistance!
Jeff

[Raskolnikov]

so i am just getting started with this asp.net mumbo jumbo. I am trying to set my XP machine up with the proper elements to successfully create and deliver asp.net pages.

my problem is that I can not seem to find the software packages that the author mentions in the begining of the book.

All i could find was the .net framework 2.0. I installed that then installed the SDK. I did not find anything classified as the "redistributable".

I think it is all properly installed up to this point. However i was not able to find the MSDE. When i open Quickstart Tutorials, i don't see MSDE anywhere. I only see references to MSDN.

so instead i downloaded SQL Server 2005. but now i am lost. The book and what i am useing do not match up. Is there anyone that could help me get this things set up. maybe guide me to the MSDE program download, or guide me to a resource that would explain how to set this all up with the newer versions of the software.

Plus i haven't found the Web Data Administrator......

thanks
Ras

[dhtmlgod]

The book was written for ASP.NET 1.1. To start learning ASP.NET, head over here: http://asp.net/getstarted/default.aspx?tabid=61

[jyounger]

Can you please link to the current versions (including service packs if necessary) of what you have to install to get IIS, .NET FRAMEWORK, SDK, and finally the correct Web Data Administrator running on Windows 2000 Professional? (Also, which service packs Windows must use. I believe this is causing a lot of people Installation problems. This would be a great help to EVERYONE WHO BOUGHT THIS BOOK. Sorry but I'm running circles over whether to install 2000 Pro, .NET FRAMEWORK, SDK, etc. with service packs or whether to use Sql Web Data Administrator or Web Data Administrator. We need to know the PRECISE information for Installation here. Installing 15 different combinations of things is NO FUN Zak!

[jyounger]

Not a bad book when installation is fully figured out. I will commend Zak on that. As usual, I figured all this out on my own and finally have 1.1 and sql server installed beautifully, but it was a painful experience I'm not looking to repeat in my IT career often.