Comments by mitchiee1226 (Top 33 by date)

If grdvwInterestBreakdown(j + 1, i + 1).Value.ToString() has no value will it return this error?? Object reference not set to an instance of an object.

Tried your suggestion. But returns with an error: Object reference not set to an instance of an object.

Updated the question for you. Forgot to put the declaration of Row and Col.

Run the exec sp_updatestats, it still did not work.

Updated the question for you. :)

Index1 is the code which i will use to get the random number. Then use that random number to get the label to be disabled. Sorry the codes are a little messy. Jsut thought of the logic just just but do not know how to execute it.

Index1 is the code which i will use to get the random number. Then use that random number to get the label to be disabled. Sorry the codes are a little messy. Jsut thought of the logic just just but do not know how to execute it.

How do you put the Title of the columns in this code?

@Wes Aday and @Dave Kreskowiak I have updated where error really occurs. Sorry to point out the wrong one.

@Dave Kreskowiak changed it to this but still has the error. If this helps here are the Imports I have added to the form:

Imports System.Data.SqlClient.SqlConnection
Imports System.Data.SqlClient
Imports System.IO.Directory
Imports System.Configuration
Imports Microsoft.Office.Interop.Excel
Imports Microsoft.Office.Interop

@Wes Aday added that one. :)

I have done the cast of b.term to float and also b.loanAmount. The error gets worst.

Answers:
1. Prices are in varchar because the program just copied it to the DB from a text-file. Varchar is the easiest way to copy the data though the database because it accepts both letters and numbers.
2. The column I should store in the database is the respective prices.
3. "I want to update the DifPrice with this formula supposing that DifPrice has DifPrice10 and onwards" - What I mean about this is the formula continues until DifPrice10. Supposing I have DifPrice until 10.
This is what I mean:
ID||Products||TotalPrice||Price1||DifPrice1||Price2||DifPrice2||Price3||DifPrice3||...||Price10||DifPprice10||
01||Pencil ||100.00 ||10.00 ||.00 ||25.00 ||.00 ||30.00 ||.00 ||...||2.00 ||.00

Finally got your answer. Thanks! :D

CASE WHEN a.column2 >= b.column3 THEN 1 ELSE 0 END AS billPaid

CASE a.column2 <= b.column3 [THEN]<--Change this TRUE [1 ELSE]<--How come there is an Error here? 0 END AS billPaid

The table above is a sample of the output I want. Updated the question and added TableA and TableB.

Updated the question.

The output. I want to output this type of table. Is it possible?

Updated the question.

i have already gone to that site.

To what it is shown in the comment, that is the sequence of how I added it.

I have added the scripts in correct order. Here are the css files in my .aspx file:

<link rel="stylesheet" href="css/stylesheet.css" />
<link rel="Stylesheet" href="css/bootstrap.css" type="text/css"/>
<link rel="Stylesheet" href="css/bootstrap-responsive.min.css" type="text/css" />
<link rel="Stylesheet" href="css/bootstrap-responsive.css" type="text/css" />
<link rel="stylesheet" href="css/jquery-ui.css" type="text/css"/> <---- This seems to be the JqueryUI file you are looking for.
<link rel="stylesheet" href="css/dataTable/demo_page.css" type="text/css"/>
<link rel="stylesheet" href="css/dataTable/demo_table.css" type="text/css"/>

Sorry if I haven't replied but I will improve the question for you.

Narrowed down the question. :)

It doesn't have a particular error. I just want the code to copy certain data is workbook1 and workbook2 then put it in the new work book.

Example:
Workbook1
Name, Address, Postal Code, Age
Workbook2
Name, Address, Age, Occupation
In the new workbook I wan the columns with
Name and Address only.

Only in a gridview? how about a table??

how come when I execute the procedure it outputs "zero" always even though the username and password exist?