SeanDevoy

Your code is close. Try these two minor fixes: mailMess.From.Add("abc@gmail.com"); mailMess.To.Add("xyz@gmail.com"); If you still have an issue, or if you just want to use some other email host server (i.e. post-office) add this code: SmtpMail.Credentials = New System.Net.NetworkCredential("Your post Office Username", "and Password"; SmtpMail.Host = "your mail server (ie. smtp.mailhost.net)"; …

This is a HUGE topic. I will atempt a short explanation. A constructor is a special function called to create an "object" of a specific class. Lets look at an example of a class called "Fruit": public Class Fruit { String FruitType; String Color; public Fruit() { FruitType='Unknown'; FruitColor='Unknown' } …

Your problem is in line 15 and 16: 15. $totalshifttime = ($time2 -$time1) / 3600; 16. $totallate= $totalshifttime - $date ; 15 subtracts $time1 from $time2 / 3600 (hrs): 09:00-01:00 = 08:00/3600 = 8. 16 subtracts current time (say 02:00) from 8, not even 8:00 ???? I think what you …

Let the database do the work for you. Change your first select to only return the rows that are not read: select * from announcements where annID not in (select annID from annComplete) That is standard SQL, I am a Sql Server guy with limited MySQL use, but I think …

You have not provided any information about what fields are in you datagrid or what you want displayed. If the datagrid uses the samew data as your query, you need this (assuming the datagrid name is DG): DG.DataSource=table DB.DataBind() HTH, Sean

There is a great article on this reasonably complex topic. A lot is involved because of the disconnect between server-side rendering and user/ajax side requests. The server renders a row at a time and does not keep the complete data-set around, while the user is looking at that data the …

It is hard to answer without knowing the table designs. But, assuming Messages has a column "user" which matches friend_one or friend_two in the friends table and there is a primary key on the friends table, it seems to me this would be a little cleaner approach: select F1.friend_two, F2.friend_one, …

As mentioned, you are very close. The part it seems you don't understand is that for "aggregate functions" (like SUM, MAX, MIN and others) the rules for "SELECT" columns and "GROUP BY" columns are necesarilly quite strict. Every column in the "SELECT" fields must either be an aggregated column or …

Hi Simonloa, I have years and years of sql server experience. I would like to help you but it is hard to follow what your tables are and what the goal is. Are you running these queries from an application? If so, what language? In general UNION is a very …