I'm working in a database on vb.net with sqlite wich hosts a gallery and I want expand the search proprieties.[code]...
I want to filter the results also for image ext (table = images.ext) or one or more parameter...for example:
If the user search "cars ext:jpg width>500" the the database returns all images wich has the tag "cars", has the extension jpg and are bigger than 500 px width
Cookies to be stored in folder and on close delete the cookies The ability to watch youtube vids, view images, and play js/flash games good security, no ads?
View 6 RepliesI am using VS/VB 08 together with access 07 for my project. I am trying to fill my datagridview using a custom SQL query where the "where" criteria is altered to accept the column name from the selection of the user. When a user clicks on a column in the datagrid I want that column to be represented in the query. This is what I have but is not working. Is this possible by the way?
[Code]...
[code] i use this line to fill the datagrid Me.tableTableAdapter.Fill(Me.DDataSet.table)how can i fill the datagrid with a custom query?
View 4 RepliesIf you have custom type, and you wish to assign a List(of T) to that custom type[code]...
View 1 RepliesIm using the folowing function to return a SelectList. I need a custom format on Descr, but replacing Key.ToString() to Key.ToString("DD/MM/YY") render me the error "Method 'System.String ToString(System.String)' has no supported translation to SQL.". How could i use a custom date format on Descr?
Public Function ReturnDates(ByVal Param_Pesq_Cod As Integer) As SelectList
Dim Qry = From E In DB.Execs _
Where E.Pesq_Cod = Param_Pesq_Cod _
[code]....
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 have a List<string> that contains paths, such as:
[Code]...
Given a given root, such as Root, I would like to "query" this list to return only the first level values, such as:
[Code]...
VB.Net 2005 SQL server 2005
I have a project I have a dataset that contains tables In the dataset designer, each table has a defaiult FILL command set. I have draged and droped my table as a grid onto my form VB automatically sets up the table adapter, and binding source to make it all work.
in my code, is placed in the form load routine, a tableadapter.fill(dataset.datatable)
Here is my dilemma. The data in my table may have 100's of thousands or rows.
I have presented the user with a front end that allows for filterring and selecting based on several columns. reguardless of how many rows the result set contains, there will always be the same columns in the dataset.
Because there are so many combinations of select query, i do not want to make 20 or 30 custom fillby's in the dataset. I want to make an addhoc select query and have the binding source and table adapters work as expected. I have created a query called "FillByCustom" in the dataset designer attached to the DataTable Adapter section.
My question is this.
If i build a select query that returns the desired rows, how do i place it into the adapter in place of the FILLBYCUSTOM select command, such that it all works as expected?
GOAL: Bind nested ListViews to LINQ generated iQueryable of anonymous type. I want to use LINQ because you can use GroupBy and bind the nested ListView to the 'it' keyword.
SETUP: I have groups of sets of conditions. Each set of conditions is stored in the BillingCodes table. Each group of BillingCodes is stored in the BillingGroups table.
I have a custom object that stores the ID, Name, and NumCodes for each BillingGroup that the user has chosen.I have a collection of these objects called GroupsList that has a list of the groups that the user has chosen.
Problem 1: I can iterate through GroupsList and grab all the IDs. How do I translate the SQL 'WHERE ID IN(a string of comma delineated IDs)' for LINQ to SQL? Is that the best way to do that?
Problem 2: Once I have the list of BillingGroups I need to iterate through each group. For each group, I need to iterate through the BillingCodes. For each BillingCode I need to generate a WHERE clause that has all of the conditions in the BillingCode. I propose something like so:
for each BillingGroup in BillingGroups
for each BillingCode in BillingGroup.BillingCodes
where1 = "..."
next
next
Problem 3: Here's the part where I don't have a clue. I need to dynamically create a query in LINQ to SQL. Keep in mind that I don't know how many groups there'll be or how many codes are in each group.
There are 2 tables:
**transactions**
transaction_id
patient_id
[code]....
Is it possible to make a "Custom.Custom"? Example:
Custom.Custom1 = "1"
Custom.Custom2 = "2"
and
MessageBox.Show(Custom.Custom2)
Would show "2"
Do you know of any tutorial that could help me make a custom button in vb.net. Because visual studio 2008 doesn't allow you to create buttons in circle or triangular shapes. I've tried searching and found this one but, I cannot make use of it because there are lots of errors.url...
View 1 RepliesHow can I make my own menubar
View 1 RepliesI tried to make a 'custom' tabcontrol such that when I click Button1, panel1 is shown, and when I click Button2, panel2 is shown.But if I have a lot of panels then it'll be very messy when creating the gui at design time.(There'll be many panels overlapping each other.
View 1 Replieshow can i make a custom form like this? [URL]
View 4 Replies I have a background image and i'm trying to make a custom gui for the app, which goes around the image, and of course its an irregular shape, so i thought that i could use the region and so i used several ellipses and the i tried to add a rectangle but the parts that overlap invert the path therefor the part that overlaps is now transparent and not part of the window.
What I would like to do is get some examples of using all the curves, lines... and be able to make one region that is connected with all those paths that are made.
I Want To Make A Custom TabControl Like The One In VS2005 OR VS2008[code]...
View 3 RepliesI am working on a custom control and i have it working for the most part, but what i want to do now is, on the form that i put my custom control, i want to fire an event when my custom control gets focus. so what i did was just added an eventPrivate Sub CustCont1_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles CustCont1.GotFocusthe problem is, is that when i put a breakpoint on this line i never hit the breakpoint. is there something special i need to code in my customcontrol to fire the gotfocus and lostfocus events?
View 13 RepliesIs there a way to make custom message boxes and input boxes that are the same way as regular messageboxes? So if I named my custom msgbox CustMsg I could put the code like this.
CustMsg("This is a custom message box",I don't know what to put here,,"Message")
this is the code for my property
Dim _playernumber As Integer
Property Player() As Integer
Get
[code].....
which tool i use for Displaying Visualization and how to make
its must be move Following Music Effect
if I have Picturebox its contain a GIF image:[code]....
it is possible?
When i do the query
Dim SQL As String = "SELECT FirstName, Surname FROM List
it loads what i want in a combobox
However whenever i go
[code].....
I made a custom button to input keypresses:
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class KeyInputButton
Inherits System.Windows.Forms.Button
[code].....
i had an installer application around 2 years ago and it was great. it allowed me to make custom windows with my own images very easily. i can for the life of me remember the name of the program..Does anyone have any application they use to make custom installers?
View 5 RepliesWhat I want is to make a custom file with my program. This file we will pretend is called InfiniteMapFile.INMP and the file has no contents therefore we need to add contents. There are 3 pixture boxes and 3 text files. The data for each of these files needs to go into InfiniteMapFile.INMP with the associated names, then later on be taken out if needed. Here is a diagram:
you can see what I mean by putting the files within it, I would have made my file look more like a box, but we're not 5 years old and I'm sure all of you will understand.Just knowing how to combine multiple files in general will help.
here a way in VB2005/2008 to list all the apps in the systray and nothing but them. I can list all the windows by theyre hwnd, but it also shows the taskbar windows and windows not even shown anywhere in windows.So I need to somehow list all the systemtray icons in a listbox.If something's not clear,
View 8 RepliesI want to make my own custom installer without those other stuff. I want the installer to how I made it.I got the layout, directory picker and everything but how can I get the files I want them to install into the program and they click a button so they install to the location.
View 2 RepliesIs it possible to make custom buttons for the forms? I know i can add imaging to the button controls, but if is it possible to really customize the buttons so they look different, like designs instead of blocks?
View 3 RepliesI have some custom controls in a specific project. I want to make these controls available to ALL my projects. How do I do this?
View 5 RepliesI just started my WP7 programming journey. I need to add 2 text lines as an item to the listbox.
View 1 Replies
