|
Hi,
I am not an SQL or database expert but I would be very surprised if SQL could do record selection based on BLOB content.
I do have one suggestion: you could add an 'imageHash' field to your table, then with an app, calculate and store the image hash value one. Any algorithm would be fine. Later on, when you want to search for an image, calculate its hash value, then search for the hash value.
NB: there is a slim chance a hash search may result in more than one match, so you would still need code to compare the bytes if you want to be absolutely sure you got the right image.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Mates,
hello, i need help. how to run or call rdlc report in vb.net.
why is it that i dont have Me.ReportViewer in code. I added already the reference Microsoft.ReportViewer.WinForms but still. I google already. but their examples has Reportviewer. Is there any something i missed.
Thanks for in advance.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
You won't find a ReportViewer object in your project unless you drag an instance of it from the ToolBox onto your form. Once you do this, it's default name will be ReportViewer1, not ReportViewer.
|
|
|
|
|
why i have the following msg ??
Namespace or type specified in the Imports 'System.Managment' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases. C:\Documents and Settings\XeleX\Local Settings\Application Data\Temporary Projects\WindowsApplication1\Class1.vb
|
|
|
|
|
Don't cross post on multiple forums. It makes collaborating on an answer very difficult.
One of two things happened. You either didn't set a reference to the System.Management.dll file, or you tried to use a namespace as a class or object.
For the reference, right-click "My Project" in the Solution Explorer, then click on the References tab. Click on the Add button, then in the dialog that pops up, click on the .NET tab. In the list, look for System.Management and double-click it.
If you tried to use System.Management as a class, you need to rewrite your code a bit and use the correct class in that namespace. You can't just specify "System.Management" as expect it to work.
|
|
|
|
|
thanks a lot dave
|
|
|
|
|
Hey,
I'd like to know if there is a way to make a screenshot including the cursor. Normally it comes pretty handy that the mouse cursor isn't displayed, but now I need the darn thing 
Any suggestions are welcome,
(Edit: It needs to be done in VB coding, so not some other method :P)
Zaegra
Motivation is the key to software development.
|
|
|
|
|
Well, I've never had to do this, buy you might want to track the mouse position, then try to get the image of the mouse cursor, or just use a standard mouse pointer image you create, and when you take a snapshot, paint the mouse cursor image at the required position.
|
|
|
|
|
What is the most efficient way to do string comparisons that occur very frequently?
The patterns I am checking against are relatively simple, but they must be done quite frequently on a varying types of hardware. Example patterns to match would be similar to:
*Store*
*StoreTest*
*Store###* (### could be any 3 digit pattern
*StoreNightly*
(Anything else that doesn't match the above 4 conditions)
There are several ways that could be used: like operator, compiled regexs, contains method, etc. Is one method generally faster than the others? Can someone guide me to the light as to which would be the most appropriate in this case?
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
How about writing a small application to test your methods?? All you would need is a file full of test data and the StopWatch class. How you write a compare method for each method is up to you.
But, IMHO, given your requirements, my bet would be on compiled Regex. This would give the greatest flexibility, though maybe not the absolute best performance. There are trade-off's you have to consider with other requirements you haven't given.
|
|
|
|
|
I thought the regex.compiled method would be the best way, but I found a couple links online stating that the results could largely vary depending on system hardware.
I debated doing the benchmarks on my box, but I don't want to get caught in the "works fine on my box" scenario w/ this method. If the app was running on one specific machine or server, I would have done the benchmarks already and determined the most appropriate one - just trying to figure out what is the best for wildly different hardware requirements.
I just create a test app with the benchmarks and run it on several diff. machines here and get a baseline avg for each method type.
Dave Kreskowiak wrote: There are trade-off's you have to consider with other requirements you haven't given.
Really, this is just a function that needs to check a given string several different ways and then output another string as output. That simple really, but it will be called a ba-zillion times a day.
Thanks anyways Dave.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Just posting the results from my benchmarks in-case anyone else is doing something similar. I had the benchmarks perform with 500,000 iterations with each compare type and then with 2 million each. Benchmarks were performed on numerous machines from a zeon server w/ 16 gig ram to a client box with 512 ram and several in-between.
Fastest to slowest:
1. Regex with RegexOptions.Compiled Or RegexOptions.CultureInvariant Or RegexOptions.IgnoreCase set
2. Contains method
3. LIKE operator
4. Regex with only RegexOptions.Compiled set
#2, 3, 4 would generally end in the order specified above, but not always. #1 always finished as the fastest compare method using regex.ismatch w/ the settings specified.
FYI: I wouldn't use this as the standard for all comparisons done in the future; but rather provided to give you an idea on what options can be used to test against.
#1 seems to be the best performer for this particular routine and the numerous checks being done. Your results may vary as defined by your needs.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
How to use spell checker in vb.net
|
|
|
|
|
|
Wouldn't that be covered in the documentation you have on the spell-check component you're using??
|
|
|
|
|
In Visual Studio 2005 .Net, How can you programmatically edit the string value for a Gridview SqlDataSource SelectCommand?
For example, I need to conditionally replace SelectCommand="Select * from [Table1]" with SelectCommand="Select * from [Table2]"
Code snippet Example:
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns&>
<asp:TemplateField HeaderText="Office Number" SortExpression="O Number">
.... etc..
<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status">
<HeaderStyle BackColor="#EBFFEB" />
</asp:BoundField>
.... etc..
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=(serverName);Initial Catalog=(databaseName);Integrated Security=True" SelectCommand="Select * from [Table1]"</asp:SqlDataSource>
-
I have tried various AsP <%#variable%> techniques without success.
-
I have also tried the following (in the Page_Load and a Button1_Click sub) :
Dim SqlDatasource1 As New SqlDataSource
Dim GridView1 As New GridView
Dim sSQLDataSource As String
sSQLDataSource = "Select * from [Table2]"
Dim SqlConnectionString As String
SqlConnectionString = "Data Source=(serverName);Initial Catalog=(databaseName);Integrated Security=True"
SqlDatasource1.ConnectionString = SqlConnectionString
SqlDatasource1.SelectCommandType = SqlDataSourceCommandType.Text
SqlDatasource1.SelectCommand = sSQLDataSource
SqlDatasource1.DataBind()
GridView1.DataSource = SqlDatasource1
GridView1.DataBind()
-
Any enlightenment with what I'm missing with the Bound GridView would be greatly appreciated.
|
|
|
|
|
Just in case this can help anybody else, the only solution I was able to find around the Bound GridView SelectCommand was to use a store procedure and pass parameter options via Session variables to return dynamic record sets.
|
|
|
|
|
Hi,
does anybody know if it is possible to export an image from sql 2005 to excel?
Thanks,
T.
|
|
|
|
|
Both Chuck Norris and JSOP know 
Treat them as two separate tasks;
1) fetch an image from SQL Server
2) export data to Excel[^]
I are troll 
|
|
|
|
|
I have set up a typed dataset with 2 tables and a relationship between the 2. For some reason I cannot get the child table to populate.
Here is my code:
Dim ds As New dsEmail
Dim emailHeaderTable As New dsEmail.EmailHeaderDataTable
Dim emailToAdressesTable As New dsEmail.EmailToAddressesDataTable
Dim emailHeaderAdapter As New dsEmailTableAdapters.EmailHeaderTableAdapter
Dim EmailToAddressesTableAdapter As New dsEmailTableAdapters.EmailToAddressesTableAdapter
emailHeaderTable = emailHeaderAdapter.GetData
emailToAdressesTable = EmailToAddressesTableAdapter.GetData
ds.Tables.Add(emailHeaderTable)
ds.Tables.Add(emailToAdressesTable)
For Each emailHeaderRow As dsEmail.EmailHeaderRow In emailHeaderTable.Rows
Dim emailToAddressRow() As dsEmail.EmailToAddressesRow = emailHeaderRow.GetEmailToAddressesRows
For Each toRow As dsEmail.EmailToAddressesRow In emailToAddressRow
MsgBox(toRow.ToAddress)
Next
Next
It appears that the relationship is not there despite it existing in design view of the dataset.
What am I doing wrong?
|
|
|
|
|
Hi,
Im having trouble populating my datagrid control from an ms access database. 1st method I used was through ADODC control and it worked fine. Then I just found a way to lessen the code by creating a class then passing variables through a module. Anyways using the class method my datagrid does not show any data at all. I've removed the datasource control and debugged the program...record count shows that it did get something. Im just in the dark why it won't populate in my datagrid. By the way I'm using vb6 and datagrid through common control 6.0.
populate datagrid
clsPubConnection.GetQuery rs1, "insert query here", 1, 1
Set dgd1.DataSource = rs1
dgd1.Refresh
code inside the class
If rs.State = 1 Then rs.Close
With rs
.CursorType = intCursorType
.LockType = intLockType
.ActiveConnection = cn
.Source = strSqlCommand
.Open
End With
Any help would be greatly appreciated. Thanks in advance 
Aim small, miss small
|
|
|
|
|
Hi friends,
I am just thinking how can i capture the full height of a window that has an scroll bar?
pls give me your sptep by step ideas.
tx
|
|
|
|
|
You would have to find the height of the window and then account for both the visible, and invisible parts of the scrollable area.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Hai expert cumming.
Thank you for the reply.
"You would have to find the height of the window"
Height of the window using GetWindowRect() is normally returned only the visible area if i am corect?
so how can i retrive the full height of the window?
|
|
|
|
|
Dear All,
Sorry this is a newbie type question though er, I have been programming for er 10 years.
I have found one or 2 C++ pieces of code to enable squiggly lines under a text box. Alas I am no good at C++ anymore and am a VB er person. I find references to an Extended Rich Text control, but I have seen in other applications without rich text control. Unless that is just appearance.
What would be the recommended path for me to try, I can use a rich text box, but ultimately I would like to have a textbox which has a spell check with some other thesauras type feature (it is for a recruitment project and I would like to have words that move people into categories - eg: if it finds FMCG underlines in blue and if the use right clicks it says it is part of Sales, Marketing and Advertising.)
Many thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
