InsideTech

If you have knoweldge of asp.net post please

I agree. What is the problem you want to solve? or is that you just want to know who has a knowledge?

ok if you google it you'll find yourself a tutorial, i kinda looked thru it alittle but of the top it looks to be related to things like commputer programing issues, you werent realy specific enough for me to tell you were to look for it so just try that.

Another question is do you all no how to setup a blog and a forum I would like to put both of them on my site

Yeah if you post up your code here, I'd be happy to take a look at it.  Also any error messages.

As has been said, there are a lot of ways to skin this particular cat.  Personally, I find PHP to be a lot friendlier as far as communicating with a database and generating html out of it.  Here's how easy it is to query a DB in PHP (from my personal site):

<?php

$dblink = mysql_connect('my.database.com', 'username', '********');

if (!$dblink) {

    die('Could not connect: ' . mysql_error());

}



$query = "SELECT title, author, genre, description FROM books_read ";

$query .= "ORDER BY book_id DESC LIMIT 11";



// Perform Query

mysql_query('USE dbestebbins');



$result = mysql_query($query);



// Check result

// This shows the actual query sent to MySQL, and the error. Useful for debugging.

if (!$result) {

    $message  = 'Invalid query: ' . mysql_error() . "\n";

    $message .= 'Whole query: ' . $query;

    die($message);

}

// Code to display results snipped



// Free the resources associated with the result set

// This is done automatically at the end of the script

mysql_free_result($result);



mysql_close($dblink);

?>

But if you have to use ASP.net, and you are writing your query code by hand, make sure and run them through your query browser (what this is called depends on what flavor of SQL you are running, but it basically allows you to run queries through your database manually).  Make sure that you are using the right data source , that it's all configured correctly, and the query is proper, if you are allowing Visual Studio (or some such, I assume this is what you're using since you're using ASP.net) to write your code.  If you are as you say finding some queries work and some do not, then you can rule out database connectivity issues and there is likely an issue with your query itself.  Returning null values shouldn't make your form barf, but there may be some problems with your table dependencies, table/column disambiguation, etc.  I would recommend that you research how to make your pages, at least while you're developing them, display any error information.  There's a decent thread on how to do this here:

http://forums.asp.net/t/1317998.aspx

Don't leave this functionality in your live pages though as it could be a security risk...

Hope this helps

Way to go Eric!

I also prefer PHP and MySQL over ASP.NET.

But definetelly, it's impossible to help if we don't really know where the problem is.

Yes, you should