below is the "Filter Builder" for the OS Event logs.
My Question is, is it possible to use this dialog in VB.Net? i would like to be able to call it in order to generate the XML which i would then use in conjunction with the EventLogQuery.
I have quite a complicated database with a lot of relations and I need to make form that gets data from all kinds of tables and calculate prices etc... Another important thing is, when I open/load a report in my application, I want to be able to filter it using the Primary key. I don't want all records in my database to be shown. I know for sure this can be done but I don't know how.
View 2 RepliesI create a dataset and configure the query builder and in the filter i key in this "?" and when I search the name by enter the full name it will show but what I want is just type "A" and it will show the whole name starting with A. I stuck in this problem what the code to do in order to type just 1 letter and show the whole name starting with first letter that I want.
View 9 RepliesI'm develloping a small application over na Access 2007 database. how can i pass the value of a combobox to a query being built with the query builder tool?If I use ? in the Filter column I�m prompted to enter the value but what I need is to pass the value of a combobox in a form. I tried to use:
HTML
=MyForm.MycomboBox.Value
but it is ignored, interpreted as the value to be filtered.
I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
I am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String
...
If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
I'm trying to filter my access database and when I "search" by name, it works, but when I search by policy number it doesn't seem to work.
Here's my code:
If RadioButton3.Checked = True Then
Form3.Show()
Me.Close()
[CODE]...
i want to filter date and also time (shortime) for example if Datum.hour="8:15" andalso Datum.day of week "Saturday"or "Monday" now i can only filter date ... this is my filterline objbindingsource.Filter = "Datum > = '" & Dtp1.Value.Date & "'"
View 5 RepliesI want to filter a text in all columns in a datagridview. So I use Like % in the filter text. However, I found that the text(strFilter in my code) may contain % sometimes. So it have a syntax error. How can I use filter with like clause when the filter text contains %?
Private Sub PassFilter(ByRef dataTable As DataTable, ByVal strFilter As String)
Try
Dim dataview As DataView = dataTable.DefaultView
[Code].....
i want to filter row and put it in a textbox and filter another row in another text box vb.
ex.
ID--------- Date -------- msg_num ------------ Message <<
10001 -- 01/01/2012 ------ msg1 ------------- Blah! Blah![code].....
Im trying to make an EXE with a GUI have made so they can input there info and make the program.
Im trying to make a mail sender
Trying to do another replace method ' Strip URL text to generate correct download link
[Code]...
I'm trying to modify a dataset with designer and when using the query builder to get the month or year of a date field query builder transforns month(date)into [month](date)
Where do I get all the functions that can be used in Query Builder?
i was wondering if there was something i can use in VB which will let me have some fields in the DGV query to automatically have the format of 0.0000? There are some fields in that query which require this format. The Crystal Reports that accesses it gives incorrect info without this format type.
View 6 RepliesI'm looking for a form builder / questionnaire system that will let me build a questionnaire and collect data for insurance applications. I don't want to have to build this whole thing by hand. I've looked at a few options out there and the closest is Formulator.Net [URL]. What Formulator is lacking, though, is a way for me to pass parameters to be stored in the results in the database so I can identify who filled out the form.
View 1 Repliesbefore getting into this I'd like to say that I'm very inexperienced. I know how to work vba in excel and a basic idea of how to program in VB. With that said, I need help with something I wanted to make for quite a while. So I'm in an orginization called Civil Air Patrol (or CAP). We have a certain order our ribbons on our uniform have to be. The ribbon on the bottom right is the least important ribbon and the one at the top left is the most important one.[URL]I tried making this program before, but I completely failed and threw it out. My main concern is displaying the images of the ribbons in order.
View 17 RepliesI will have to perform updates/inserts/... on several relational tables of an Access database but I know that the Command builder usage is limited only to one table at a time.
View 1 Repliesi'm using this code to try and write a value to a table in an access database. when i try to write oledb.oledbcommandbuilder, intellisense doesn't recognize this but it doesn't throw an error up for that line either. when i try to execute this code i get the error "syntax error in UPDATE statement"
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUPdate.Click
Dim myConnection As OleDb.OleDbConnection
Dim ds As New DataSet
[code]....
I want to ask how to i , passed the value i get from my previous form using this"Login.user.Text" to a Query Builder to filter the result based on the value of Login.user.Text" .
SELECT LecturerID, Lecturer_P
FROM Lecturer
WHERE (LecturerID = ??? )
[code].....
I'm experimenting with the sql command builder and it seems to do nothing when trying to update existing rows. If I create a new row and then add it then it works fine but I cant seem to update an existing record.
Heres what I have at the moment
Code:
Dim strConnection As String = "Server=myServerSQLExpress;AttachDbFilename=C:databasepath estdb.mdf;" & _
"Database=testdb; Trusted_Connection=False;User Id=sa;Password=test;"
[CODE]...
But I'd really like to find out why its not working when using the command builder. I'm working with VB.net 2010 express and SQL server express.
I've been using sandcastle builder to make my help file documentation for our code base. It works real good just out of the box, but I need to customize it a little.How do you you format remarks? In the xml comments in code, you can have tabs and carriage returns and such to make things look readable, but all that get's taken out by Sandcastle and it gets converted to one long paragraph.For instance:
''' <remarks>An example of how to use this function would be:
'''
''' Using Selector As ObjectSelectors.FacilitySelector = [code]......
Would end up looking like:An example of how to use this function would be: Using Selector As ObjectSelectors.FacilitySelector = ObjectSelectors.FacilitySelectorUtils.GetStandardFacilitySelector(Me.m_Project, Me.m_Map) Selector.Text = MessageCaption If Selector.ShowDialog = Windows.Forms.DialogResult.OK Then 'add these facilities to the list For Each FacilityRow As Data.DataRow In Selector.SelectedItems If Not Me.BarricadingFacilityTable.Rows.Contains(FacilityRow(0)) Then Me.BarricadingFacilityTable.ImportRow(FacilityRow) End If Next End If End Using
I know there must be some kind of tag I can use - or would it be a bunch of tags? Or is there a setting in Sandcastle Builder?
I'm making a builder for a simple ftp client, but i have a problem.I have readed a tut about a builder with a stub, thats done but i only can fill in 1 form, but how can i make that my builder fills 2 forms in the client?
My code in the stub is:
Dim options(), text1 As String
Const FileSplit = "@vorfin@"
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
FileOpen(1, Application.ExecutablePath, OpenMode.Binary, OpenAccess.Read, OpenShare.Shared)
[code].....
i have this win form app that performs a database search of customer information. I have a datagridview, a binding navigator and a fill/addquery toolstrip with a toolstrip button and a textbox.Here is my query, i want to find all customer names like what i enter in the textbox
SELECT ACCOUNT_NUMBER, COMPANY_NAME, COMPANY_ADDRESS, BILLING_ADDRESS, CITY, STATE, ZIP, COUNTRY, PHONE FROM tblCustomerInfo
WHERE (COMPANY_NAME LIKE @COMPANY_NAME + N'%')
i am using sql client with a datagrid and i already bind the data to the grid as a dataset automatically so i did not manually code the connection, cmd, dataset ect here is the find button code that recieves the customer info according to the sql query
Private Sub FillByToolStripButton_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillByToolStripButton.Click
Try
Me.TblCustomerInformationTableAdapter.FillBy(Me.CoCustomerAccountInformationDataSet.tblCustomerInformation, COMPANY_NAMEToolStripTextBox.Text)
[code]....
COMPANY_NAMEToolStripTextBox.Text is where the the Customer Name will be entered... I originally called it txtName.Text but still even when i changed and did everything through the query builder I get nothing when i run the query.
I've search this forum and haven't found the answer to this problem and bing new to VB 2010 [cod]e...
View 8 RepliesI want to distribute my downloader base, but not the actual source code. I've got some parameters in the downloader which the user needs to change, such as the download link and file description.How do I create a program that changes these? The user will insert the desired values into the builder, and the builder will create the downloader.exe that can be distributed to other people.
View 22 RepliesIt seems like the query builder in vb only allow 1 table to use the INSERT statement, so are there any way add more than 1?
View 2 RepliesI have a string which is like this - MVAL("A","01-01-1900")+MVAL(B,"01-01-1900")+MVAL("C")+MVAL(D). Now I want to extract B AND D out of this using regex because it is the first parameter and it has no quotes around it in both the overloaded version of the functions. Secondly because MVAL function is an overloaded function with two versions like MVAL("A") and MVAL(B,"01-01-1900") how will I find which version of the function is being used.
I'm using System.Text.RegularExpressions.Regex method.
I'm using a datagridview to display data and make updates to my access database. I was able to display data from my database to the datagridview but it is not filtered. The datagridview displays all the records on my database. I tried using query builder to execute sql select statements that will filter the data and this is where I'm stuck. Im using a variable as a parameter to the sql statement and I dont know what syntax to use in Query Builder. I tried to use @varname, '" & varname & "', and
View 1 RepliesI want to develop select query builder in my vb.net application. If user write the "select query" in a richtext box that query will be executed and the result will be displayed in a grid view. Any one send the Sample Application for this
View 1 RepliesHow do I insert enter key in the built-in report builder? I have the following code but it's not working for me.
=IIF(Fields!YearLevel.Value="LC10","English" & ChrW(13) & "0.3","")
and
=IIF(Fields!YearLevel.Value="LC10","English" & Chr(13) & "0.3","")
[Code].....