|
I am an idiot I forgot to initialize the observableCollcction Busta sorry I bothered to bullshit.
|
|
|
|
|
Hi all,
I have four selection list boxes.....authorList publisherList yearpublishedList and genreList..
I have managed to write code that enables me to click on 1 or more of the boxes and get a result.
For example if I click on Ken Davies in the Authors list then all his books will appear.I can then click on the second box the publishers list and this will narrow his books down to that publisher and so on.
My problem is this,once I have clicked on any of the lists I have to make a selection in that list.For example if I click on author Ken Davies in the authors list,I can't find a way of "unclicking" that list.I have to stay with it and select another author or otherwise close and open the program again.
The problem being that If I was checking an author,then I decided I just wanted to check genre ,I cant because an author is already selected.
My question is this.Is there a way I can just reset the program,or perhaps is there a way tha I could "uncheck" an item in a list.
Thankyou
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
Dim ds As New DataSet
Dim tables As DataTableCollection = ds.Tables
Dim source1 As New BindingSource()
Dim da As New OleDb.OleDbDataAdapter
Dim isFirstColumn As Boolean = True
Dim author As String = ""
Dim publisher As String = ""
Dim yearpublished As String = ""
Dim genre As String = ""
Dim aa As String = authorList.Text
Dim bb As String = publisherList.Text
Dim cc As String = yearpublishedList.Text
Dim dd As String = genreList.Text
Dim astring As String = "SELECT * FROM books "
If authorList.SelectedIndex > -1 Then
If isFirstColumn Then
author = "WHERE author = '" & aa & "' "
Else
author = "AND author = '" & aa & "' "
End If
isFirstColumn = False
End If
If publisherList.SelectedIndex > -1 Then
If isFirstColumn Then
publisher = "WHERE publisher = '" & bb & "' "
Else
publisher = "AND publisher = '" & bb & "' "
End If
isFirstColumn = False
End If
If yearpublishedList.SelectedIndex > -1 Then
If isFirstColumn Then
yearpublished = "WHERE yearpublished = '" & cc & "' "
Else
yearpublished = "AND yearpublished = '" & cc & "' "
End If
isFirstColumn = False
End If
If yearpublishedList.SelectedIndex > -1 Then
If isFirstColumn Then
genre = "WHERE genre = '" & dd & "' "
Else
genre = "AND genre = '" & dd & "' "
End If
isFirstColumn = False
End If
dbProvider = "PROVIDER=Microsoft.ACE.OLEDB.12.0;"
dbSource = "Data Source = C:\Documents and Settings\james\Desktop\authors2.accdb"
con.ConnectionString = dbProvider & dbSource
con.Open()
Dim sql As String = astring & author & publisher & yearpublished & genre
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "books")
Dim view1 As New DataView(tables(0))
source1.DataSource = view1
DataGridView1.DataSource = view1
DataGridView1.Refresh()
<pre lang="vb"><pre lang="vb"><pre lang="vb">
End Sub
End Class
|
|
|
|
|
Hi All,
I managed to resolve this.I placed a button on my form and place the following code into it.One line for each box.
authorList.SelectedIndex=-1
1
Regards
cw
|
|
|
|
|
Your code is vulnerable to SQL Injection[^].
NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I want to minimize my primary Bugs as testing team is saying.I think my Unit Testing is not much effective.I like to get a few tips on that part.Please help me!
[ASP.NET,C#,SQL SERVER 2008]
Thanks in Advance
|
|
|
|
|
Our very own Marc Clifton has written this free[^] book on unit testing. It's very good.
|
|
|
|
|
Thanks.I will give it a try.
|
|
|
|
|
A very important issue is that your code must be "clean" to be testable (see also Robert Martin "Clean Code"). Classes with several thousand lines of code, functions with hundreds of lines of code are not testable. You'll have to write many small classes with small functions. That could be the hardest issue when starting.
|
|
|
|
|
Thanks.Robert Cecil Martin'sBernhard Hiller wrote: "Clean Code"
|
|
|
|
|
Hi!
i have bought T5567 rfid read or write.link of myw reader is http://www.ebay.com/itm/321488854348?_trksid=p2060778.m570.l4467&_trkparms=gh1g%3DI321488854348.N19.S2.M-34323.R1.TR1
ho can help me to make connection with reader because the reader not going to make a realized a connection.
Thank you!
|
|
|
|
|
The manufacturer can help you with it.
Get the manual for it and/or any SDK for it and that should get you the information you need.
|
|
|
|
|
Can anyone give a simple description about what is framework?
|
|
|
|
|
I don't know whether to laugh or cry here. You could simply have opened up the question and answers just below this.
|
|
|
|
|
Definitely .
|
|
|
|
|
Well, at least they're not sharing their homework, I guess.
(Class of 2012).
|
|
|
|
|
I've been writing a blog about the difference Framework and Library, so Googling around and found an interesting example about framework on Stack Overflow: http://stackoverflow.com/questions/2964140/what-is-a-framework-what-does-it-do-why-do-we-need-a-framework[^]
Quote: Framework:
If I say you to cut a paper of dimension 5m by 5m then surely you would do that. But then I ask you to cut 1000 paper of the same dimension. Then you won't do the measuring for 1000 times, obviously you would make a frame of 5m by 5m and then with the help of it you would be able to cut 1000 papers in less time. So, what you did is you made a framewok which would do that type of task. So, instead of performing same type of task again and again for same type of applications, what you do is you create a framework having all those facilities together in one nice packet and hence providing the abstraction for your application and more importantly many applications.
Can anyone please provide a same way example about library.
“That which does not kill us makes us stronger.” ― Friedrich Nietzsche
|
|
|
|
|
There are some excellent answers here[^].
|
|
|
|
|
iSahilSharma wrote: I've been writing a blog about the difference Framework and Library,
You would of course first need a definition for those two terms that make them distinct from each other.
And it would help if it was authoritative.
|
|
|
|
|
|
Can we see your code? With the exact line of the error?
It is hard to tell what your problem is as we can't see what you see...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
תפסיק לספר לה' כמה הצרות שלך גדולות, תספר לצרות שלך כמה ה' גדול!
|
|
|
|
|
Dim FileName As String = System.IO.Path.GetFileName(FileUploadBenGrid.PostedFile.FileName)
Dim FilePath As String = System.IO.Path.GetFullPath((FileUploadBenGrid.PostedFile.FileName))
Dim fs As FileStream = New FileStream(FilePath, FileMode.Open, FileAccess.Read)
Dim br As BinaryReader = New BinaryReader(fs)
Dim bytes As Byte() = br.ReadBytes(Convert.ToInt32(fs.Length))
br.Close()
fs.Close()
<div id="divBenGrid" style="display: none;">
Select a file to upload
<input type="file" runat="server" id="FileUploadBenGrid" name="FileUploadBenGrid" size="50"/>
</div>
<asp:Button runat="server" ID="btnBenGrid" Text="Continue" CausesValidation="false" />
|
|
|
|
|
The FileName property returns the name or path of the file on the client.
Your code is running on the server. It does not have access to files on the user's computer.
It might appear to work when you're testing in Visual Studio, but that's only because the client and server are the same computer at that time.
You need to use the InputStream property to read the file:
Dim br As New BinaryReader(FileUploadBenGrid.PostedFile.InputStream)
Dim bytes As Byte() = br.ReadBytes(FileUploadBenGrid.PostedFile.ContentLength)
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
How do I get the file name ?
|
|
|
|
|
You already have the code to get the file name:
Dim FileName As String = System.IO.Path.GetFileName(FileUploadBenGrid.PostedFile.FileName)
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
As I understand you try to read the content of the newly uploaded file...
You made two three mistakes:
1. Didn't read the documentation: http://msdn.microsoft.com/en-us/library/system.web.httppostedfile(v=vs.110).aspx[^]
2. PostedFile.FileName is the name of the original file on the client machine and you try to pen it on the server
3. You try to open a file that already opened an presented for you
Dim br As BinaryReader = New BinaryReader(FileUploadBenGrid.PostedFile.InputStream)
Dim bytes As Byte() = br.ReadBytes(Convert.ToInt32(FileUploadBenGrid.PostedFile.InputStream.Length))
br.Close() Somethin like this...But read the documentation!!!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
תפסיק לספר לה' כמה הצרות שלך גדולות, תספר לצרות שלך כמה ה' גדול!
|
|
|
|