I'm wondering if any one knows a way to take two values from within VB and send them to a database. then return a list of values cpu (temp) list of all temp's ( and what is the best type of data base to use for this - it will need to be on the internet )
View 2 Replies
I am building VB.NET application that takes data from text files that are exported from a legacy DOS program. These are written to a datatable and displayed in a datagridview. Right now my code simply loops through the datagridview and inserts the data into the database (SQL Server). There is a requirement now that the client number must be checked before the insert to see if it exists in the database. If it does, then the value of one field (tax rate) is checked against the value of the field in the datagridview. If there is a difference, then the rate is to be updated in the database and the data that was in the database is to be written to a history table for audit purposes. If the client number is not there, then we are to do the insert (which is already written). I want to know what is the most elegant and efficient solution for this problem.
I need to compare what is in the database table with what is in the datagridview, update the history table for records that exist, and then insert new records.
I am creating an xml file with LINQ as follows...
Public Sub CreateXml()
Dim db As New MDataContext
Dim Customers = <gallery columns="3" rows="3">
[code]....
Could i mix local values with the ones returned from the LINQ query...Something like the following?
Public Sub CreateXml(ByVal **Col** As String, ByVal **Row** As String)
Dim db As New MDataContext
Dim Customers = <gallery columns="& **Col** &" rows="& **Row** &">
[code]...
Using ASP.Net, VB.Net
In my web page, i have the textbox values
when i press the send button the textbox value automatically send to email address.
I'm using some HTML with vb.NET and would like to know if it's possible to pass data back and forth. I need the value of an option in a drop down box passed down:
[Code]...
I'm trying to build a sales program in which by adding multiple items in a RichTextBox, with the click of a button, the program can sum the price of these items and put it in a TextBox as the total sum of these values.I've been going nuts about on how to write the code for this..It's the last part of the program that i need to conclude ir.
View 1 Repliesi'm trying to send values from a form to an access db. the db has an auto gen primary key field. the problem im having is i get an error when sending.
if i have a db and autoId is primary key:
memberTable(autoId,Name,Addy) from vb i have in the sql: insert into memberTable values (xxx, 'joe', 'dave');
also tried insert into memberTable(autoID,Name,Addy) values (xxx, 'joe', 'dave'); & tried it with and without autoID?
where 'xxx' is what value, if any, should go there to send it to the db?
I'm trying to build a sales program in which by adding multiple items in a RichTextBox,with the click of a button, the program can sum the price of these items and put it in a TextBox as the total sum of these values​​.I've been going nuts about on how to write the code for this..It's the last part of the program that i need to conclude ir.
View 2 RepliesI'm trying to loop through a bunch of checkboxes I have created on my aspx page. I would like to get all the values, and parse them to a string to send to another page as post variables. This is what i have so far:
aspx page:
<div class="ReportsCustomBox"><asp:CheckBox ID="CheckBox0" runat="server" /> Name</div>
<div class="ReportsCustomBox"><asp:CheckBox ID="CheckBox1" runat="server" /> Training Year</div>
<div class="ReportsCustomBox"><asp:CheckBox ID="CheckBox2" runat="server" /> Continuity Clinic</div>
etc...
aspx.vb file:
Protected Sub Submit_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Submit.Click
Dim targetURL As String
targetURL = "report.aspx?"
' This is the part i can't figure out.
' For Each checkbox on page
'if checkbox is checked
'targetURL &= checkboxid & "=true&"
End Sub
My goal is to build another page that will then check these values using Querystring variable, and build a listview out of them. (a report page, that basically lets the user select checkboxes of the columns they want to see on the report).
I want to send hex values across the serial port. I know, I know, your thinking not this again. But what I need to do does not seem to be addressed, or I am some how missing it when I search around.
[Code]...
I have three client PCs and one local server (actually a pc- Using windows 7 Ultimate on it).
In the server pc I have XAMPP installed and I am running an application developed using PHP on it. There I have the following PHP variables[code]...
When I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
I created a dataset and i am using OleDbDataAdapter to insert new values to access database. But when i close the program and after open it, values are not in the database. How can i solve this problem? Also, i have another problem. When i write codes that
[Code]...
I'm working on a tool that allows the user to connect to his SQL database and edit some of the database values.First here's a screenshot of the GUI (you can see my problem as well):
[Code]...
I'm currently patching an asp.net program where I need to be able to send an image to an SQL Server 2005 DB. It works fine when I use the asp:fileupload control, but the trick is that when the user deletes the image, I'm supposed to replace it with an image from the server saying "empty", in code-behind. I know how to open, use and save text files in vb, but I can't find any information anywhere on how to open an image / binary file in a similar manner so that I can use it as an sql-parameter on the update query. Below is an example of how easy it is to use a file from the fileupload control.
[Code]...
I have an application in which I have one textbox (in this one I write a date like 23.07.2010 ) and a combobox in which I insert a time from the list of combobox (like 12:30, 14:45, etc). I want that when I press a button to send this datetime value in a column of an sql database. I want to send something like (in VB.NET)
sql=" INSERT INTO table_name (column1, column2, date_time_column) values ( val1, val2, '23.07.2010 12:30') "
execute(sql)
So, I have problems when I want to send date/time into sql tables because of the different Regional Settings.
Dim con As New OleDb.OleDbConnection
Try
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = D:\project\login.mdb"
con.Open()
str = "insert into table1 values(" & Text1.text & ",'" & Text2.text & "')"
cmd = New OleDbCommand(str, con)
cmd.ExecuteNonQuery()
[Code] .....
If I insert integer value it will be updated in database every thing is ok but when I want to write some string in my textboxes and want to send them I get connection error.
I am currently making a college project for which i need to send scheduled emails.I googled for it and found out the we can do it through outlook. Is there any way to automate that process through vb, so that it will check for the dates in the database and send an email whenever necessary?Outlook is not important for me... I just need to send scheduled emails.And i even need to send sms (single and bulk) according to the needs... is there any free API for that too???I have already tried the google sms feature but it didnt work for me
View 8 Repliesmy app has mssql database ,i want to create service by which date will be checked in database whether the product is expired or not , if the date in database is date today then automticaly user will get notification email there whould not be any need to interaction of any human to server to check and send it manually i want to make this process totaly automatic and i dont have any idea about it, can sql send mails?
View 10 RepliesSo in my program I have a database where I send info such as passwords, is there any way to (in an easy way) encrypt the password before sending it so instead of sending "mypassword" to the database I send a random collection of letters and numbers like "shH3n2ja"? I only need two functions, encryptPassword, decryptPassword.
View 7 RepliesI need to create a window service that will check a Date field in the database and on the basis of that date it will send an auto generated mail.I am new in the field of Window service.
View 1 RepliesCurrently I have been using mysql connectors to send and retreive information from my database. Someone suggested that a web service (wdsl? etc) would be a more efficient way of sending information both ways.
View 9 RepliesMy Problem is we have two database. One for current year and one for last year.I have to get the sales values of this year and sales value of last year. The form i need is
WORLD LastYear_Sales CurrentYear_Sales
world 1 143124 65544
world 2 5635634 6666543
world 3 0 876876
now i will explain, world 3 is not in last year database, it is introduced in current year, so its value must be 0. I tried to union 2 queries, but its not showing correct.
Here is part of my [code]...
Here is my problem. My controls on the form were created from dragging and dropping one of my tables from the data explorer window onto the form in details form, not gridview. Amongst these controls are four comboboxes whose text properties are databound, but their items lists are not bound. When I click my submit button, all the data is sent to the database except the text from these four comboboxes. I have looked everywhere I can think of and can't figure out why the text from those comboboxes isn't being updated in the db.
I'm currently pulling HTML data from a database and displaying it in a WebBrowser control in my VB.Net application so that it's correctly rendered. The next step is to print it, but I need to be able to send it to a specific printer rather than the default printer. How can I accomplish this?
View 1 RepliesMay i know what is the code to automatically send the current time or date to database once i click the button? Since i'm using:
Label11.Text = System.DateTime.Today
Label12.Text = TimeString
That mean the time will keep on running.. What i want is when i click the button, the current date and time will be recorded.
I'm currently pulling HTML data from a database and displaying it in a WebBrowser control in my VB.Net application so that it's correctly rendered. The next step is to print it, but I need to be able to send it to a specific printer rather than the default printer.
View 1 RepliesThe following is the code that i used to store all the values in the listbox ito the access database.but it is not working.I didn't get any error.but the values in the listbox is not being stored in the database.The field in sample table that stores the value from listbox is a multivalue field.[code]...
View 2 RepliesI'm trying to add values to a MySQL database. The values that I need to save come from several textboxes. The SQL-query is read from a XML-file.
Query: INSERT INTO myTableName(ID, Groep, Naam, Achternaam, Intern, etc...) VALUES(NULL, NULL, tel_txt_group.Text, tel_txt_name.Text, tel_txt_surname.Text, tel_txt_intern.Text, etc...)
Unknown column 'tel_txt_group.Text.ToString' in 'field list'
