I have two text box's and compare from two columns in database the result auto show another text box and then following below code using my program:
Public Sub cal() Dim sum As Double Dim res As Double With Common_Class.GetSrvRec("i_Unit_Con", "", "QTY_UNIT='" & txtitemunit1.Text.Trim & "'") If .Fields("QTY_UNIT").Value = txtitemunit1.Text Then [Code] .....
i am making a progrom to calculate delivery charges this depending on weight of the item.i enter the weight of the item in a text box i need it to calculate the shipping cost, currently i have something like this but it is wrong. [code]
So im trying to fill a combo box with data from a database but depending on how much a pregressbar is filled THis is what im trying:
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Form1.ProgressBar9.Value <= 10 Then Me.Level1TableAdapter.Fill(Me.CTDBDataSet1.Level1)
I need to write a method in C# to save all rows in a given datatable back to the database, but I cannot depend on the rowstate of each row. I can't think of how best to do this without extensive looping through the database table data or constant database querying.
I want to essentially perform the following insert / update for each row in the datatable, but more efficiently:
I've got a tab control and want to dynamically add tabs depending on the output from a database. I can easily add a new tab, however I want to inherit the controls and layout from the initial tab.
When .Clear() is invoked, is the memory freed up that was allocated when all of the items were added? I need to load several lists of codes from a database depending on the import selected by the user. Each list of codes will be a List(Of String). My idea is that I will load only small strings into a List(Of String) along with a List(Of <class>) for the data I will be validating and manipulating. When I am done, I want all of the data from the Lists to be purged from memory. Will .Clear() take care of that or does the memory still remain allocated and have to be dumped by the OS once memory gets full? (And, incidentally, what causes the OS to decide which memory blocks to dump? FIFO concept?)
There are so many lists, I'm not sure if I just want them sitting in memory or not. Granted, the lists will just consist of a single string value for each code pulled from the database. So there won't be a ton of data, so maybe I could just load all the validation lists at the beginning of runtime and only worry about purging the data List since it will contain between 35-50 "fields" per record and there will be a couple thousand records each import that is run. I don't want my program to actually cause a hit in performance in the long run. I ultimately don't see a problem because I won't be running millions or even hundreds of thousands of records at once, but I just want to be sure.
how to calculate the association with a database, containing two tables the first table price, and the second table of the goods, and the program in the language of Visual Studio 2010 Professional, using the Access database or sql no matter, the question is: How do I make the program take values from the table price, and calculates the cost of living depending on the equation Stored in the database??
I'm having some trouble firstly trying to calculate the total of a column in the database connected to my vb.net project. Then I want to divide that total by the number of items in a listbox. This is my code so far:
Private Sub btnavresult_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnavresult.Click Dim sqlx As OleDbCommand = New OleDbCommand
[Code]......
I get an error saying "No value given for one or more required parameters." when I try to run my program on this line "Dim rdr As OleDbDataReader = sqlx.ExecuteReader()"
how to calculate numeric values in a sql table in vb.net. For example I am developing a system which returns the required fields in GridView, I then copied the "NetValue" field in a list box. Is ther a way of calculating (adding them together) all the Net values listed in the list box? or is there a better way around it?
I'm developing Asset Management System, it will compute for straight line depreciation, my problem is how to calculate running total on each group that I've extracted from my database.Here's a snippet for my extraction of data
Private Sub cboAType_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboAType.SelectedIndexChanged ListView1.Items.Clear() If Not cboAType.Text = "-" Then
I am trying to calculate the number of years for my calculate age event handler, however i am apparently missing a method or whatnot because im trying to calculate the age , can anyone suggest help on this. I need to subtract years to get my age but when i try the birthdate.Subtract (currentDate) method i get an error about not able to convert from LONG?
So below is what I have.
Private Sub btnCalculateAge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateAge.Click Dim currentDate As Date Dim BirthDate As Date Dim Age As Long
I have achieve to populate my combobox from sql and from this combobox to populate a textbox but now I have to do something more complicated.I would like to populate a combobox from an other combobox choice. And what i mean is that I have a table with Streenames and Postcodes. What I want to do is fistly to choose the Streetname from the one combobox and the interface to appear the Postcodes to the second combobox. Secondly, the postcode combobox should appear more than one postcodes because it is probable that the same streetname maybe belongs to more than one region(postcode).
I want it to show the first MsgBox if the NewEntryName.text = "" and I want it to show the second MsgBox if openfiledialog1 = nothing... how do I do it
Is there a way to write an if statement in here to detect what url I am on so I can allow a certain role for that certain URL.
Example code in my head of what I kind of want to see:
If (UCase(Url) = UCase("URL")) Then <allow roles="ROLES"/> ElseIF(UCase(Url) = UCase("URL")) Then
[code]....
Is this even allowed in the web.config? I have 3 websites. One for Dev, UAT and PROD. Now for each sites I have different user groups for each set up. I just want to find a way that I can just find what URL i'm at and point it at the certain user group. I'm guessing I have to make a web.config for each because you can't do conditional statements but I'm just making sure. If I have to make a web.config for each how can I go about setting that up?
I work with VisualStudio 2008 and write my codes in VBasci.Also,I use Microsoft SQL server 2008 for my database and here is the question;I ve curently been doing a simple hotel software, the step that I ve got stucked in is that, I take the reservations by clicking on buttons those represents rooms in the hotel,buttons have green colour on them because they are available until I take a reservation for that room,and they must be staying green until a customer checks-in..On a check-in day,that room must go to colour of red or somethıng and must'nt be able to take another rezervation into it until the customer checks-out, I ve got 2 people comıng for that room for tomorrow who will stay for 1 night,so today it should stay green whıch means it s available,but by the mid night it must go red and must be not available to take rezervations for tomorrow,once they check-out on the day after tomorrow ıt should go green,so,available again.
What is the appropriate declaration such as "ValueChanged" or "Click" for a NumericUpDown that will execute the code when I press enter. I already know that setting the "AcceptButton" property of the main form to a default button will not work, especially if I want a different button to be selected depending on which control I give focus. How do I accomplish this?
PS: Is the syntax any different from Visual Basic 2010 Express than it is on Visual Studio 2012 RC (running in Visual Basic Mode)?
I'm trying to do a calculation where-in the output is different depending on what the input is. [code] I have these repeated using >=50 >=60 etc. but when I go to run the program I get this: [code] basically I need to know how to create a cut off point for the grading system. <= doesnt seem to work.
I have 2 comboboxes. When I choose a country in cboLand I want only the states to show in cboStaat that are associated with the country from cboLand. I tried the code below but I get all different error messages. Perhaps you can see something in my code that I missed.
Example: That's 8 different combinations: 1, X, 1 1, X, X 1, 2, 1 1, 2, X X, X, 1 X, X, X X, X, 1 X, 2, X
Any way to get the different combinations depending on the Checked checkboxes into an ArrayList. One entry per possible combination (like the example above). Note this example is just for 3 games, I will have 13 games in my program so if you click all checkboxes thats 1,6M combinations. Is it really wise to have 1,6M entries in an Array? I also want to be able to set demands, like: delete all lines in the Array containing two X. Maybe an ArrayList isn't the way to go?
Ok the other day I saw a neat little DLL that grabbed an image of the internet depending on what the user enters it was used like dllname.Whatever(String, PictureBox1) now the thing is Picturebox was was just that you just Put it on your form and called the dll with that does any one know how to do this
Hey, Just trying to loop through my gridview and change the color of the row if the first cell equals a given value. This is the code I am trying but does not work.
vb With gvItemList For i = 1 To .Rows.Count - 1 If .Rows(i).Cells.Item(0).ToString = stValue Then .Rows(i).BackColor = Drawing.Color.CadetBlue End If