I always have a problem with dynamically generating WHERE conditions to a SQL statement which are base on the nformation given by user (combobox, listbox, checkbox etc.) Here`s an example of how I normally deal with the problem:
[Code]...
I'm working on a piece of code at the moment that allows the user to enter values into fields. Once the user clicks on the 'save' button I am checking those fields against certain conditions (essentially calling a bunch of stored procedures to assess the values). If any of these 'rules' are met, I need to generate a popup that informs the user that certain values need to be fixed before they can continue for some of the conditions, and for others just to inform them of what conditions may need their attention. how do I generate a popup box in my codebehind if the conditions are met?
View 1 RepliesThis is something probably very simple for you all by the looks of these other thread but I can't figure it outThis is a hotel reservation order form.IsFormComplete function checks to make sure the form is complete, if true it calls GetOrderList which... well you get it.The problem is this:I have checked functionality at random and everythn there is an error, message box displays what is wrong... except one thing. When you complete everything but choose cash as the payment method and click place order, the message box pops up with the GetErrorList caption "Please Complete the following:" BUT there is no error reported after. I'm losts, I know, it's probably terribly written to begin with but I'm all of a week in to the class so I will get there.
Option Explicit On
Option Strict On
Option Infer Off
[code]....
How can I have multiple If Not conditions on one line?
Here are the combinations that I've tried, but they either don't work, or won't build.
If Not (txtDisplay.Text = "0") And If Not (txtDisplay.Text = "")
statement1
Else
[Code]....
I want to write conditions for the button to be able to submit. The combobox must have a store name and the textbox must be a decimal or integer. Whenever I don't have the inputs are not valid I want an error msg to be display on the labels
This is my code so far:
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
If IsNumeric(TextBox1.Text) = True And ComboBox1.Text = "store" Then
MsgBox("good")
[CODE]...
I am trying to write a Function which will return a data table, filled with a data from a database.
The Function will accept 6 diffrenet parameters as Optional. Each one of them will be an additional condition to be added to a where clause, if it`s provided when the function is beeing called.
Is there any method in .NET to simply add a new condition to the where clause?
I have a ListView that I populate with running processes and would like to highlight specific rows based on the amount of memory consumption. After I add the processes to the list and and call the WorkingSet64 property of the process, I tried this:
vb.net For Each lvi In ListViewProcess.Items If proc.WorkingSet64 >= 2000 Then lvi.BackColor = Color.Yellow End If Next
Processes is the variable I used to grab the collection of processes. proc is defined as a variable and then used to loop through the processes.
lvi is of course the ListViewItems in the ListView.So, by the code I have above, I loop through the ListViewItems, and if any of the processes are above or equal to 2000, then I set the background color to Yellow.
However, it sets every line to yellow, and I can't seem to figure out to set only those processes that have a WorkingSet64 above 2000.
Would I need to loop through the processes and then set the background color of the ListViewItem based on that? That kind of makes sense to me, but if I do that, I'm not sure how to set it just for those processes. Maybe by setting a separate variable?
I have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesFirst I dont know how to "link" forms easily. For example: Form1 is like a calculator and I get value X (label.text). How can I "sent" that X to form2? I mean like: Form2.label1.text = form1.label1.text but it doesnt work like that. And I know why it doesnt work.. I dont know how to save that X. Every time I close and open again Form1 I had to start over. So how to save and link forms? Then another: what's wrong with this? Or how I could make it another way? Textbox2 should be numeral (should I code something for it?) and user can set it's value. Now it doesnt show anything in label5. [code]
View 6 RepliesI have 3 table which are Timetable, Schedule and Consultation slot and I wish to combine them so that all the data are able to retrieve easily.
Timetable are having
1. TimetableID
2. Lecture ID
3. ClassVenue
4. ClassStartTime
5. ClassEndTime
Schedule
1. ScheduleID
2. LectureID
3. ScheduleVenue
4. ScheduleStartTime
5. ScheduleEndTime
Consultation Slot
1. ConsultationID
2. LectureID
3. StudentID
4. ScheduleID
5. remark
Here is my code in metadata
Partial Public Class CombinationOfTSC
<Key()> _
Public Property LectureID() As String
Get
Return m_LectureID
[Code] .....
I'm having error at c.LectureID = s.LectureID = t.LectureID
I wish to get the combination of 3 tables through the lectureID since there are lecture ID on 3 tables.
I have a program that is accessing many similar tables using a linq to sql datacontext. Do linq to sql tables implement a common interface? I would like to write methods that could work with any of the similar tables, so it would be great to do something like
Dim myTable as ILinqDataTable
If switch = "TableA" then myTable=myDataContext.TableA Else myTable=myDataContext.TableB
[Code]...
i doing asp.net and using vb.net.I have a datalist control which inside it show a product img, description, price the problem is that i was to show the product another img, so i want to have a small picture below the img, so when click on the picture the img change to another.
i want something similar to this link : [URL]..this link they use flash to come out with the effect that i want, but they are not in datalist, so think that i may need to use ajax but which one?anyone have any sample or example ? if i was to use the jquery easy slider numeric navigation how am i going to implement onto the datalist?
Basically, we have three databases to grab data from. One is a SQL Server database, one is an Access database (which is particularly annoying to connect to because we have to map a network drive and such), and the final one will be an Oracle database when IT finally gives us rights.I'm thinking about creating a helper function that makes querying any one of these databases as easy as possible. I want to create a two-dimensional array
Dim myEasyResultArray(10,10) as String
myEasyResultArray = DatabaseHelper("Access", "SELECT * FROM Employee")
Is this a good design decision? Also, how can I have the array be the right size? Can I just do this?
Dim myEasyResultArray = DatabaseHelper("Access", "SELECT * FROM Employee")
Should this be a module or a class? I don't really need to share variables?
I want to create a VB program for my final year project,the contents of which can be editable by the user, for example when new information becomes availabe it can be easily added. Now,I thought that this could be done using the text box, although it doesn't seem to be possible.
I plan to use a database to hold the initial information.Could I achieve program 'updatability' in a fairly easy manner?
I have an access database with 5 tables.I want to fill a dataset with the entire contents of the database.Why can't it roughly look like this?[code]Instead I'm having to create an adapter for EVERY table, tab the table name (why?), fill the schema, and then fill the table.
View 1 RepliesI need to make basically a bunch of 2d arrays, that I can access the independant values easily. Like multiple properties As an example:
[code]...
Because later I have to access Value1 in a manner that spells out each independantly. I have used some basic Structures to define 1 property and does something with it. But not 2 properties, and I am out of my norm on creating a Class to do something like this.
How to implement an observer pattern in VB.NET?
Currently I have a lot of working code in VB6 which the company wants me to migrate to VB.NET. Well, that would normally be straightforward ... yes? Unfortunately, not so in our case.... recently, our company decided that I need to modify it to implement the MVC (Model View Controller) paradigm to make it truly OOP and adaptable to TDD (Test Driven Development).
Currently, my move was to start with a simple one, opening a form and then grabbing a piece of text from a textfile and putting it as the caption of the form... now, that is easy.
The problem lies in trying to implement observer patterns ... in the observer pattern I cannot simply call the usual me.caption = mytextstream.ReadLine from the form_load event instead, I need to use objects that would use an interface to register themselves as observers as the form loads but not necessary having to be residing in the form_load event... in fact ... if there is somehow a way for me to make such a thing happen before the code goes through the form_load event then that would more completely separate the View layer from the controller layer which gets implemented through the use of observers and observer related patterns.
So im making a text replacer for PSP Programmers to easily convert the codes to NitePR format. None of you know what that is but w/e Heres my problem I load the text file that has the code into a text box.
Then i press the button to convert. It has this code
[Code]...
basicaly i'm on a project which involves generating programs on the fly from a website, these programs will have the ids of the logged in users.To do this, I found a little trick, which is having a vb.net program running on my windows server communication with my website's database and generating another executable then send it back to the client.Anyway this is just some boring introduction, basically my question is how can I generate an executable from my vb.net executable?
View 6 RepliesI want to generate different graphs in vb.net 2008. Please guide me i dont know how can i do that, where from i should start. I have different values which i want to show by graph. Like Service distruption time conventional scheme vs proposed schme. How can do this.Please guide me with sample code example. Can we make it in excel and how can we add it in vb.net or can we open excel in it?
View 7 RepliesI created a project using Visual Studio 2008 Express and I use the Menu tool called Build. There are two selection for the express (Build and Publish).I used the Build and found an .exe in the "bin" folder and the "Debug" subfolder. I am able to double click this .exe file and the program executes.
If I move this .exe file to 2 levels up on the directory, the .exe starts with my (modal form) and then it hangs. how I can make an .exe file that would execute in a different level?
I want to generate all possible string (a-z, A-Z, 0-9)
[code]...
how to generate student number in visual basic 2008 in this format. the year+date+in what number that the student is enrolled. example: 111201. where the year will change depend on the year that the student enrolled for the first time.
View 5 RepliesYou see three buttons which all contains a one digit number (1, 2 and 3) at the start of running a program. There is one other button stating "Randomize" and when you hit this randomize button all the three buttons that were first containing 1, 2 and 3 are now shuffled in a random order like 2, 3 and 1. In fact, when clicking the randomise button the figures will stay between 1 and 3.I was hoping to sort this out with the following code but it didn't actually work at all:
Dim a, b, c, d, x As Integer
a = Button1.Text
b = Button2.Text
[code]....
Create a GeneratedNumber application that stores in an array with indexes 1 through 100 numbers generated by the index values when Generate is clicked. Generate the number to be stored at each index by summing the index and it's individual digits. For example, 25 should be stored at index 17 because 17+ 1+ 7 = 17 and 4 should be stored at index 2 because 2+ 0 + 2.
Your program should use a FillArray() procedure to generate the nuymbers and DisplayArray() procedure that displays each index and its element in the list box.
[Code]...
How do I generate random text? (Numbers+Letters, or just letters)
View 1 Repliesi'm programming sudoku game for my vb 8 class.but i don't know how to generate random numbers, i think that i've to use random or randomize, but i don't know how to use them, i've been looking around but i can't find an answer.and i only have this week to program it
View 10 RepliesI have a file called CalcProg.DLL written in Delphi which is used in Plaxis. I am planning to write a VB.net wrapper for this DLL. The problem is that I don't know what function names there are in the DLL. I was wondering if there was a wrapper generator so I could input a DLL and the generator generates a dummy CalcProg.vb with the function names so I could have a VB class that does something like this:
[Code]...
I want to automatically generate VB.NET forms using tables from a SQL Server database (one form / database table). It is perhaps possible with writing custom custom code for it, but if there is already some feature that does the job that would be great (database has 40+ tables, manually doing this is a tedious task).
View 1 RepliesI'm trying to generate a pivot table in Excel using VB.NET 2008. I need to bring the data into one tab, and then generate a Pivot on another (i can't do this externally because the data is pulled from a bunch of different places). Currently I'm doing this pivot in the actual code, and then writing to Excel, but it takes up a lot of resource and time and this will make things much easier! I created a sample list below, and I am trying to generate a sample pivot table based on it, but I'm getting errors:
Dim wb As Excel.Workbook
Public Sub ExcelGen()
Dim ex As New Excel.Application
[code]....
The error I'm getting right now is the no object reference set error on the "pCat =" line...