I 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 RepliesI want to query an access database with variable data defined by the user. The "Search" criteria would be in a textbox. I made a query like
SELECT askID, Question
FROM chita
WHERE (askID LIKE 'Textbox10.text%')
and referring to this query as
Form1.ChitaTableAdapter.searchrec(Form1.ChitaDataSet1.chita)But id does not take the value of the textbox, instead it takes the Textbox10.text as a value. Is it possible to refer to it like this, or should I Linq?
[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 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 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 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.
It 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'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 have been trying to create a filter search as instructed by many Youtube tutorials but I am unable to get my code to work:This is what I have. I created a query in the Query Builder like so:[code]So I went back to basics and re-created the Query in Query Builder, this time I executed the query in the QB, but all of my columns are displayed as NULL when I know I have data in the tables.
View 4 RepliesI am trying to use a DataViewGrid to show certain transactions.I also have a TextBox for the user to enter the transaction ID to fill the DataViewGrid.In the Query Builder it works if I give the NABTransID in the Query but I want it to read the TextBox1.text to find the transactions.
[code]...
I 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 have a datatimepicker1 on the form and want to display the result dataset in the datagrid view.So I use query builder in the dataset designer to put "@PickDate" in the filter of PickupDate.And i use the following code to get the result and show in datagrid.But it is not working.Actually I don't know what syntax to use for the date parameter.
Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged
Me.HisPickupTableAdapter.FillByDate(Me.HisPickUpDataSet.HisPickup, Me.DateTimePicker1.Value.Date)
End Sub
I have developed an ASP page in Visual web developer that retrieves the data usingan AccessDataSource object. I have the following UPDATE Command:
[Code]...
OpenFileDialog.ShowDialog()
Connection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " & OpenFileDialog.FileName
[code].....
In Access, when you build a new query, you can add tables to the view, which is then represented by individual windows that are somehow embedded/constrained to the upper portion of the query designer. I know then typically, windows are free floating anywhere on the screen, but somehow they manage to keep it confined to a certain container area. It also appears that the windows never get a real "focus" as the title bar is always a faded shade of blue, yet, you can still click on them and move them around.
View 3 RepliesI have created a query method for my tableAdapter in the dataset designer. I typed the command text manually, but tested it in the query builder after I got a Constraint Exception when debugging. When running in the query builder via 'Execute Query' I get exactly the results I expect. When running the application I get this exception: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." I tried temporarily setting my dataset's EnforceConstraints property to FALSE but still get the same exception. I can't understand why the Query Builder would return the correct datatable but running the app would not. Is this a bug?
View 3 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.
Whenever I try to modify "any" Dataset using the designer in a specfic projet, I get the error mentioned in the title. The designer works OK in other projects.Steps:
1. Open the the dataset.xsd from the solution explorer.
2. Right click in thedesigner and add Tableadapter.
3. Click the Next button twice to get to the "Enter SQL Statement" and click "Query Builder" button.
First Error Message: "The Query Builder Faied..." "The Parameter is Incorrect" Click OK and click the "Query Builder" button again...2nd Error Message: "The Query Builder Failed..." "Attempted To Read Or Write Protected Memory.This is often an indication that other memory is corrupt."
This one particular dataset has been editied a number of times. Furthermore, in this project, I now get this error in all three (3) datasets I have in the project. Is there a way to start a new prject, import the form andf class objects and create an entirely new set of datasets? I've tried this with no success.
i'm getting an error with the code below
The Error.... SQL Syntax Errors Encountered
Error in Select clause: expression near 'DESC'.
Missing from clause
[code].....
I've created a log in system using a database and query builder to return the correct values, however, once the users signed in I need to bring up the rest of their data from the same table in the database. How'd be the best way of going about this? I'm not sure whether the log in should be changed to use the primary key as well.
View 2 RepliesI use visual basic 2010 professional edition. I am working on a project on it with access on the backhand. i want to view the data in datagrid control for the stock management. I also want to setup a query in the query builder which will search the database according to the ID but i cant get it right i dont know why. i type in the form filter this: LIKE @ID + '%'. But when i click somewhere else, an error appears which says: Data type error in expression.
View 1 RepliesHow can I develop a custom data source control for WinForms ? This example is just for ASP.NET. VS version: VS 2008
View 7 Repliesi'm currently making an app that needs to run a query between two dates. this app will run automatically, so i need to put the dates as today and yesterday, essentially.
[Code]...
Can i add resources at runtime? i have created a builder and stub [URL]...so i want to upload like a picture to the created/buildet application with the builder.If you don´t Believe in it, Then it Does´nt Exist!
View 14 RepliesI am new to this forum and I would like some help from my respected seniors.I am trying to develop a ASP.Net Web Application using C# or VB. First of all prefer me whether C# would be easy or VB for the following scenario:Below are the requirements:
1. For All Users:
Text-chat feature will allow users to chat with the available online users.
2. For Registered User:Allow users to create new folders and sub-folders, to store (upload) files.Allow users to perform move/copy/delete operations on folders and files. The percentage of storage capacity remaining and used should be displayed on the top. Automatic versioning system will record the version/revision information when a file is replaced/overwritten Team management feature will allow users to work in teams (by inviting other existing registered users). The activities of the team include access to the password protected area for the team, uploading files, commenting on the uploaded files (discussion), polls, automatic and manual reminders to the team members.
3. For Administrator:
Approve/Reject new team requests; update/delete existing teams.View all the files and folders uploaded on the server.Allow to perform delete operation on any existing file/folder existing on the server.Delete account for any registered user.Define and Edit storage capacity and other limits such as Maximum file size allowed for uploading.
Queries:
1) As, every user will have his/her own PERSONAL profile page then how will the system redirect the user to his/her PERSONAL profile page after hitting Login?
2) How this chatting feature can be developed?
3) How this storage capacity would be assigned overall?
4) How Administrator will manage all this?
I am totally confused.I have developed SRS as well. but in coding I am totally stuck as I am not so good in coding. I thought Visual Studio 2010 would help me effectively in this case, and I am trying but couldn't find any way for this to be done.
I have a requirement to move the html text available in a string builder to a word document and open the word document after the data is appended in a VB.NET console application. I am new to console applications and am not sure how this could be done, but I am aware that if I am using a Web Application then I can use the following code:[code]
View 1 RepliesI want to develop an accounting software for a mini Super-Store, this program will be able to run on a network with a central database; in other words a network application. I have not used sql sever before neither have I written any application that will run on a network.
View 7 RepliesI am very keen to build a simple application to convert AVI to jpg in order to learm a little about video processing. I know free applications that do this already exist. But, I'd still like to develop an application to help me learn more about avi's and to hone my programming skills a bit with a real project.I'm familiar with VB, so that's not a problem. I just don't know how to process an avi file nor how I would programmatically extract the frames from that file.Where should I start? What is required to extract frames out of the avi to individual jpgs?
View 2 RepliesI am trying to develop a application that will invert my mouse but that will run in the background of my computer. I do not know how this can be done.
View 9 Replies