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?
SELECT TOP 1 idCustomerBid, idProduct, bidAmount, bidDate
FROM bidHistory
WHERE (idProduct = 272) AND (idCustomerBid <> 2) AND (idCustomerBid NOT IN
(SELECT TOP 1 idCustomerBid
FROM bidHistory AS bidHistory_1
WHERE (idProduct = 272) AND (idCustomerBid <> 2)
ORDER BY bidAmount DESC))
ORDER BY bidAmount DESC
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 visible property to false if you do not want people look at it, in the background you still can reference that column.
also is your datagrid allow to generate the columns automatically, if not i would like to see the datagrid structure and the exact field you are retrieving from the calendar table
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
The easiest way to do it is with a compare validator control <asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="DropDownList2" ControlToValidate="DropDownList1" Type="Integer" Operator="LessThan" ErrorMessage="DropDownList2 must be greater than DropDownList1" Display="dynamic"></asp:CompareValidator> DropDownList2 is the ToYr and DropDownList1 is FromYr
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"
Dim adapt As New SqlDataAdapter(statement,connection)
Dim ds As New DataSet()
connection.Open()
adapt.Fill(ds)
connection.Close()
CmbEmployee.DataSource = ds
CmbEmployee.DisplayMember = "FName"
CmbEmployee.ValueMember = "EmployeeID"
CmbEmployee.DataBind()
SELECT DISTINCT countries.Country_Code, Country_Name FROM countries INNER JOIN allow ON countries.Country_Code != allow.Country_Code ORDER BY Country_Name
try this. SELECT DISTINCT countries.Country_Code, Country_Name FROM countries, allow WHERE countries.Country_Code != allow.Country_Code ORDER BY Country_Name Regards.
SELECT Profiles.answer, users.gender, COUNT(Profiles.answer) AS count
FROM Profiles INNER JOIN
users ON users.userid = Profiles.userid
GROUP BY users.gender, Profiles.answer
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 you have the cd.
Just to share some personal experience, once i had a similar problem with a mini dell, and i last 3 days working with a dell support guy and at the end, he just recommend me to make a fresh install, my lucky that computer is quite simple to backup, if it is not a really headache for you I will do the same thing.
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 what is the minimum parameters that you need to insert.
also i will create another connection call it conn
sqlcmd = New Sqlcommand ( "Select * from Staff_Main where Staff_id like '"&textbox1.text&"'",cn)
cn.Open()
dr = sqlcmd.executereader
while(dr.read())
{
sqlcmd = new sqlcommand ("insert into smart.dbo.event(e_staff_name) values '"+dr.GetString(1)+"'",conn)
conn.Open()
sqlcmd.executenonquesry
conn.Close()
}
dr.Close()
cn.Close()
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.
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 first position because your value must be unique, verify that first and then tell us, what happened. to be more straightforward check this field M_PAGES_ID_PK when you bind the sub category dropdown.
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 update that you have installed, uninstall it, also run antivirus scan, do it step by step and try boot as normal.
Hope that help, if non report back how far can you get thru safe mode.
well If you know how to make a connection with the database which i think you do, because you are getting data from the db. to insert a new record is much easier.
lets say that we have a table like this Person Name LastName Address
Dim insertStatement As String
insertStatement = "INSERT INTO Person (Name, LastName, Address) VALUES ('"+TextBox1.Text+"','"+TextBox2.Text+"','"+TextBox3.Text+"')"
Dim cmd As New System.Data.SqlClient.SqlCommand(insertStatement, Conne)
Conne.Open()
cmd.ExecuteNonQuery()
Conne.Close()
Which TextBox1.Text Contain the name or could be a string variable. TextBox2.Text Contain the Last Name and TextBox3.Text the Address
And Conne is the connection already created. hope that helps regards.
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 & "'
I do not know if your really need DirectCast cause you are just asking for the checkbox label text which is string.
you are retreiving category and sub category and the same resultset and your data is show as example. Category Sub_Categor Network CCNA Network CCNP Programming C# Programming VB
and when you pass that to the datalist is going to embed the data as show above. and what you need is Network CCNA CCNP Programming C# VB now are you doing that because somebody can select multiple sub_category at the same time?
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.
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.
you need to set the MaintainScrollPositionOnPostBack in the aspx page <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" [B]MaintainScrollPositionOnPostback="true"[/B] %> That is in vs 2005. in vs2003 i think is SmartNavigation="true"
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 structure of your table. if that does not work try this
Dim cmd As New OleDbCommand("select * from login where id= '"+txtUser.Text+"' and pass='"+txtPwd.Text+"'", conn)
dr = cmd.ExecuteReader
if(dr.HasRows)
Form2.Show()
Else
txtUser.Clear()
txtPwd.Clear()
txtUser.Focus()
End If
