oh im sorry i think i misunderstood the point. When you said this "the second highest bid that is not the same user " the same user means the person who is actually log in the system?

try this

SELECT TOP 1 idCustomerBid, idProduct, bidAmount, bidDate
FROM bidHistory
WHERE (idProduct = 272) AND (idCustomerBid <> 2) AND (idCustomerBid NOT IN
...

Take out the * and try it.

in your select statement are you retrieving that value? if yes verify you have autogeneratecolumns to false you have to create a bound column manually for the primary field and also you can set the...

Lets say that in the loadmain you set text for a label like this
Label1.Text = "Load Main"
But you want to do the same thing if you click a button, then create a function called for example...

Im not quite sure what is your problem, but did you try Response.Redirect(String URL);

Let's say you have a variable temp
Dim temp As String = "05/02/2005"
Dim ar() As String = temp.Split("/")
TextBox1.Text = ar(0)

The result of ar(0) is 05 i hope that help you.

The easiest way to do it is with a compare validator control
<asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="DropDownList2" ControlToValidate="DropDownList1"...

try use this dropdown.SelectedItem.Value to retrieve the values from the drop down box.

regards.

Hi, i once have that problem and i use this function and it work for me.

http://geekswithblogs.net/AngelEyes/archive/2007/04/12/111504.aspx

Ok once you have a connection set up, the easiest way to go is using a dataset you can basically do this. i did not test this.

Dim statement As String = "SELECT EmployeeId, FName FROM tblEmployee"...

Good. take care.

Well partner in c# i will do this, probably you can translate this to vb.

System.Text.StringBuilder sbScript = new System.Text.StringBuilder("");

sbScript.Append("<script...

ok so your statement should be like this.
regards.

Ok, I think I am a little lost lets put some data into that table
COUNTRIES
USA - UNITED STATES
DR - DOMINICAN REPUBLIC
MX - MEXICO
PR - PUERTO RICO

ALLOW
DR
MX

What about that.

try this.

SELECT DISTINCT countries.Country_Code, Country_Name FROM countries, allow WHERE countries.Country_Code != allow.Country_Code ORDER BY Country_Name

Regards.

Try that

SELECT Profiles.answer, users.gender, COUNT(Profiles.answer) AS count
FROM Profiles INNER JOIN
users ON users.userid = Profiles.userid
GROUP BY...

Let's go back to basic, you said before you had some virus and your pc, probably during the clean process you delete something that it is the culprit, is that is the case i will do a system repair if...

shutdown any firewall on, in order to test.
Try reinstall the program.
reboot in safe mode with network and try to update.

Try to rename the application and try to update.

regards.

Hi, you should open the connection cn.Open() and then cn.Close() also you have a problem and the insert statement you are calling label1.text as lable1.text.

besides that check your table and see...

when you got the black screen did you try to press ctrl+alt+del and see what happen. if did go to windows task manager then file -> New Task (Run...) and type C:\WINDOWS\explorer.exe and click ok if...

Just double check this, I am not sure. but when you say this
For i As Integer = 1 To CheckBoxList2.Items.Count
I think the checkboxlist index start in 0.

You right :).

Make sure your dropdownlist does not have duplicate values, for example if you result set when you bind the sub category dropdownlist have a duplicate value, when postback is going to go back to...

well if you cannot get into windows at all, try booting in safe mode, Press F8 at the beginning and select Safe Mode, If you can start your machine thru that, is there any recently software or driver...

Try this

Select a.SubCat_Name from SubCategory as a inner join category as b on a.SubCat_Cat_id = b.Cat_id
where b.Cat_name = '" & DirectCast(e.Item.FindControl("chkCategory"), CheckBox).Text &...

ok, i do not know if this is the best solution but it work.

I test this try to replace your statement in values, notice the event OnItemDataBound that makes the trick.
aspx

<table>
...

well i can tell you right now why.

you are retreiving category and sub category and the same resultset and your data is show as example.
Category Sub_Categor
Network ...

I would say this

<td><asp:Checkbox ID ="cat_title_chk" AutoPostBack="true" runat="server" OnCheckedChanged="CheckChange" Text='<%# Container.DataItem("M_CATPAGES_CAT") %>'></asp:Checkbox> </td> ...

Hi,
This code going into the dropdown event change, i think you are using 2003, im sorry i cant test this code in that version but in 2005 it work, hope that work for you.

string strJS = "";
...

I do not really understand your point. because if you want to edit something and that is why you have a edit button, the row you working with should become textbox in order to edit something.

hi,

you need to set the MaintainScrollPositionOnPostBack in the aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default"...

i do this to get the current computer maybe look for something like this.

Dim IPAddress as String = Request.ServerVariables.Get("REMOTE_ADDR")

that is vb, c# is almost the same.

Hi,
I do not know if this can help but try it
replace dr(0) for dr.GetString(0) and dr.GetString(1).
also try in the select retrieve exact the two fields that you want, i do not know what is the...

try this

select ( select f.cycle as col1
from final as f
for xml raw, elements, type).query('for $col1 in (row/col1) return concat($col1, " ")')

I did not test this.

Regards.