Basically it comes down to the difference between .Net 2.0 (2005) and .Net 3.5 (2008) Framework. Basically what you code in .Net 2.0 won't work the same if at all with .Net 3.5 framework. But ...

This is for ASP.NET 1.0 and 1.1 only, not 2.0 just as an FYI

Table

CREATE TABLE NorthWindUsers
(UserID INT IDENTITY(1,1) NOT NULL,
UserName VARCHAR(50)...

Your code with the brackets located above have me a little puzzled. Be sure you can go through each logic path and have a return value!

We are more than willing to help, but we don't do the work for you. The idea is that you take the effort to learn for yourself, and when you get stuck or don't understand why something is not...

This is the reason, you are using this code which is for ASP.NET 1.1 and NOT ASP.NET 2.0. There are some significant differences between 1.1 and 2.0 framework that makes this code non-functional.
...

You have
(int)objReader.GetValue(0) which returns a value, an integer value to begin with so you shouldn't be converting it to int.

The GetValue Method "gets the value of specified column, by...

Let see if this helps...

Try visiting http://www.w3schools.com/sql/default.asp (http://www.w3schools.com/sql/default.asp)

A very free site with good intro tutorial on SQL.

Saying that here...

No problem at all.

Glad I could help and you got it working!

The reason it is Null is this :


dsExcel.Clear();

You are clearing the Dataset, i.e. making it empty, and then updating it. That is why it would read NULL

Example of SQLCommandBuilder

SQL Connections string

Network Library=DBMSSOCN;Data Source=192.168.90.10,1433;database=Northwind;User id=;Password=;

I am sorry awaw, but I dont understand what you mean?

What is the problem you are having with using the Session Object? Stored Procedure?

FYI

Table code:

CREATE TABLE NorthWindUsers
...

No problem.

I do indicate how to do this in the related tutorials described at the beginning of this tutorial in detail:

This can be done with a session object or a cookie

See here for...

I am sorry I can't attach the file. SQL doesn't use any file (except a script to generate the table / stored procedures) that I can attach and send to you. It is not like an access mdb file.
...

Also one thing to note. I would avoid using LIKE as you will can have the chance of a guess working for the login, or even more likely to have multiple records.

A login should grab one, and...

The start of the tutorial states where to find the basis on which this tutorial is built.

But here is the original Stored Procedure:

CREATE PROCEDURE sp_ValidateUser /* How it would appear...

Are you using Visual Studio or Web Matrix?

If you are using Visual Studio, have you stepped though the code?

Comment out the Invalid Login portion of the code and see what error message you are...

I have a few times. It can depend on many things, but often it depends on the how you setup your SQL scripts.

Hmm, I would check the security settings on your Access DB.

I can't see anything wrong with the code... hmm

I will look into it again tomorrow!

OK a don't see anything wrong with your code, what version of SQL server are you using? Microsoft Recommends that if you have version 7.0 or later (includes MSDE) the SqlClient should be used. ...

Hey sounds good.

My prayers are with you.

provide code with respect to the issue, and we may be able to help!

If you are importing a CSV into SQL server it will remove the quotation marks for you. Use Enterprise manager in SQL Server to import the CSV file as data and you should be fine.

If you...

Look into the tutorials here at Daniweb. What you are trying to do I have shown in many tutorials.

Well when you installed it, was there not a prompt saying how many connections? My memory on it is limited, been awhile since I played around with this application.

Here are some links to read up...

Ok, what you need to do is step back and relax. You are trying to do too much at once, and not getting any real understanding and logic before proceeding.

Logical Process to Developing an...

Well ok, SQL 2005 Server Express is a good starting point. You could use Access, MySQL, or Oracle as other possible databases. Depends on your knowledge and experience. Knowing the differences...

So you set the BackColor to Transparent and how is it that it doesn't work? Transparent label will appear as the same color as you form control it is placed on. The color of the form comes through...

The start of what I have.... working on it when I have time...

Code so far

public class Vehicle : FuelTank
{
private int m_VehID;
private string m_Desc;
private int m_Odometer;...

Cool. I am off in an hour and have a long weekend for doing home reno's. I will work on this with you over the weekend... sound good? I have no development apps here at work, so I will help you...

Hmm, this sounds like fun. :) Lucky you.

I would love to see the code for the console & / or pseudo-code you have for the windows side. From there we can use that as a basis to create a windows...

If you are using a SELECT statement, which I would assume you are, just add an ORDER BY clause to that statement and voila.

Ok, my bad. Sorry about that. See... even I goof on copy paste. Hehe. But that doesn't excuse you... :) :) :) See, you should understand what you are copying and pasting. :lol: :lol:
...

Are those lines in web.confg? Using system; should not be in the Web.Config file.

Remove that using system line

Provide some of the code giving you the issue.

Thanks

Daniweb has loads of resources. You should check out the search ability on here, or look in the Code Snippets Section or Tutorial Sections for help before posting.

Here is your answer : LINK...

Answer found here! (http://www.daniweb.com/techtalkforums/thread28325.html)

Are you building this in Visual Studio then? You would use the Menu Creator/Editor in Visual Studio.

Also here is how to create menu's at runtime as opposed to design time!

LINK...

You asked in another posting why people don't answer your questions. I replied to that, but i will also add this. Not providing us with information as to what you have tried, makes us wonder if...

Ok, well posting messages like this:




Make it kind of hard. Why? you have not provided any details of what you are trying to do are a little vauge. This question is only a little vague...

Well unfortunately it is not a simple better or worse. It depends on what you are doing / requiring.

From a distribution standpoint, and relatively small scale, the Access DB is far easier. ...

All correct, but closing the connection does just that...close the connection. It does nothing with DML (Data Manipluation Language) i.e. Update, Insert, etc.

In the process you mentioned it...