dr[2] = SqlDataReader dr1.item("lastmane");
from database
but I have error expected
I don't while
SqlDataReader dr1 = cmd.ExecuteReader();
dr1.Read();
dr[2] = SqlDataReader dr1.item("lastmane");Hello, what is dr ? and what is the error generated ?
regards|||dr [2] this is array
and I haw error
An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS1002: ; expected
And my code is
<%@. Import Namespace="System.Data.OleDb" %
<script language="vb" runat="server">
dim rek(100)
dim strImie as string = "adam"
public sub Page_Load(sender As Object, e As EventArgs)
dim dbconn,sql,dbcomm,dbread,dbconn1,dbcomm1
'dim a=New ArrayList
dim a=New SortedListdim mycountries=New ArrayList
dim x
dim b(10)dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("baza/Blok.mdb"))
dbconn.Open()'dim objCmd as new OleDbDataAdapter _
'("SELECT Login,IloscZlecen FROM Blokowanie where Blok=True", objConn)sql="SELECT Login,IloscZlecen FROM Blokowanie where Blok=True"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()if Not Page.IsPostBack then
x=0
Do While dbread.Read()'Authors.Items.Add(New ListItem(dbread.Item("Login") + " " + Cstr(dbread.Item("IloscZlecen"))))
'Authors.Items.Add(New ListItem(dbread.Item("Login") + " " + (Cstr(x))))
a.add((x),(dbread.Item("Login")))'a.TrimToSize()
'a.Sort()x=x+1
loop
rb.DataSource=a
rb.DataValueField="Key"
rb.DataTextField="Value"
rb.DataBind()
'rb.DataSource=a
'rb.DataBind()end if
If Page.IsPostBack Then
x=0
'Czytanie z bazy kolumn
Do While dbread.Read()
rek(x)=dbread.item("IloscZlecen")
x=x+1
loop
'SelectedAuthor.Text=(Authors.SelectedItem.Text)
'response.write(rb.SelectedItem.Value)response.write(rek(rb.SelectedItem.Value))
response.write(rek(rb.SelectedItem.Value)+1)End if
dbread.Close()
dbconn.Close()
end sub
Public Sub button1(Sender As Object, e As EventArgs)
text.InnerHtml="You clicked the button"
response.write("Adam")
response.write(rek(rb.SelectedItem.Value))
End Sub</script
<html>
<body>
<form runat="server">
<asp:label id="Status" runat="server"/
<asp:RadioButtonList id="rb" runat="server" AutoPostBack="True" />
Wybrany serwisanta: <asp:label id="SelectedAuthor" runat="server" /><p></p
</asp:RadioButtonList>
<button id="b1" OnServerClick="button1" runat="server"
</button>
<p id="text" runat="server" />
</form>
</body>
</html>
No comments:
Post a Comment