I have two DDBBs, one table (basic table) with basic data and another one (city table) with a list of cities and a code for each city. I want to add the city code into the basic table. The problem is that I am showing on the webpage the name of the city, no the code... but I am not able to get the code that I want to save into the basic table.
[Code]...
I want to create a table with an option of increasing rows on clicking a button which will be on the side of tableAfter user puts data into table, that should be updated in oracle database table.
View 1 RepliesI have some problem with working with tables which were created on previous form. Say we have a form Customers in which Customers are displayed in datagridview.Now to create or add ne customer to this customer table on sql server, another form is opened.In this form user enters all data like customer name, phone number etc. when changes are made to the sql server using a stored procedure this form is closed now I want to show this newly added customer in the datagridview of the previous form.Right now what I am doing is creating data set and command et. and again fetching data for all customers from sql server.
View 2 RepliesI found on msdn samples and modified (add Thread.GetDomaind.UnhandledException)
<SecurityPermission(SecurityAction.Demand, Flags:=SecurityPermissionFlag.ControlAppDomain)> _
Public Sub Main()
' Add the event handler for handling UI thread exceptions to the event.[code].....
I have made an application in VB.NET.The Button click codes are working fine. I have made a small modification in the code. I have commented the line 'Me.Close'But still my form gets closed. I think the application is executing from elsewhere.
View 8 RepliesI want to split this up into 3 side by side tables but have been unsuccessful in any of my attempts. Currently it prints one large table. The reader.Read is performing a really simple query that pulls a few names from a table.
Dim htmlString As String = "<table>"
While reader.Read()
htmlString = htmlString + "<tr><td>" + reader(1) + " " + reader(4) + "</td></tr>"
End While
[code].....
I made a simple VB application has a database created by SSMS and attached to it.Here is my form
Imports System.Data.SqlClient
Public Class Form1
Private cs As New SqlConnection("Data Source=STARMAX-PC;Initial
[code].....
I made a simple VB application has a database created by SSMS and attached to it.Here is my form code:
Imports System.Data.SqlClient
Public Class Form1
Private cs As New SqlConnection("Data Source=STARMAX-PC;Initial Catalog=PRACTICE;Integrated
[code].....
I have a big problem with a software I'm creating for my own use.I have code in my software that downloads the source code of a webpage into a .txt file and filters out information it's looking for. For normal HTML code this works fine.The problem is when I can't target specific parameters in the HTML code because they're too vague.I can download this kind of unique HTML code and pass the variable (Brown in this case) to Strings in my software because it's on the same line of code making it unique:
<div class="Performer_DataLabel">Hair Color:</div> Brown</div>
However I want to know how to search a specific table and its rows and cells (like this one below showing the code for 1 row and the 2 cells I'm interested in):
1. <tr>
2. <td class="paramname">
3. <b>Hair Color:</b>
4. </td>
[code]....
The question (Hair Color), regardles of how many hundreds of lines the full source code is, is always on the same line within the row of the table (line 3).The answer is also always on the same line (line 6) in the row of the table.However the question rows themselves are not always on the in the same place of the table.
Im new on SQL databases and im working with the "Northwind" sample from microsoft. there are 4 tables with this realtion Customer->Orders->OrderDetails->Products. i want for every customer to list the products ordered... how can i link those 2 tables?
View 4 RepliesHere is the:
Imports System.Data.OleDb
'Add reference to Access then
Imports Microsoft.Office.Interop
Imports Microsoft.VisualBasic
[CODE]...
I am using this to copy tables in an Access database(2003). the questions I have are:
1. How can I make this more 'obejct oriented'?
2. How can I copy just the structure of the tables and not the data?
(Currently both are occuring)
I do no know how to go about doing this. I have a view in the db. I have gatheredall the data in that view. Now when clicks a button, i want to transfer half column data in the view to header_table and the other half into the lines_table. Also once it is transgered, I want to display it in a grid view. This time all the fields from header_table and all from lines_lines. Can someone guide me how will I do that by an example of code that is not very complecated and does what I want to do?
View 1 RepliesOne of the buttons in my application maps a network drive.The code for it works fine when I run the application normally, but when I do a RunAs with other credentials, it does nothing. [code]
View 6 RepliesWhen i run this code to get results from yahoo or google it does not work and it says that that ids not there but it always is."Object reference not set to an instance of an object."
Public Class Form2
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles
[code].....
My MDIparent (MDIParent2) has a specific form(Webtab) as it's MDIchild, Webtab has a webbrowser control inside but I can't use the following:
Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
activemdichild.webbrowser1.goback
End Sub
I have written a short piece of code to validate a UK NI number. The format is 2 upper case letters, followed by 6 digits followed by A,B, C or D. This code does not work, it never matches even when the string NI_Num is OK: [code]
View 2 RepliesPrivate Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs)
If WebBrowser1.DocumentText.IndexOf("FAILED LOGIN") > -1 Then
[code]....
Now the number 40 shows up in the web broswer so why isnt the ELSE showing the message box saying Login OK and the others?
but i used this to check if its true
Dim returnValue As String = html
Label4.Text = html
If Label4.Text = "true" Then
[code].....
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
This is what I have, but its not working for the total at the end..the IF bit at the subtotal...
Description
Qty
Unit Price
Total
FORMTEXT
[CODE]...
I got the following code from net,its working sometimes but sometimes not working, why?Its not showing the video by every click of the button Preview.I want some better code which will work smoothly and will show the video by every click. [code]
View 4 Repliesi am trying to make it so that when you are typing a url into the url box on my web browser, you can click enter to search like on comercial browsers instead of having to click the actual search button, im trying to do the same with the web search(google, bing, yahoo!). it worked before, but i've added a tab system to the browser and now it's not letting me click enter to search.
my code:
Private Sub urlgo_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles urlgo.KeyDown
If e.KeyData = Keys.Return Then
CType(TabControl1.SelectedTab.Controls.Item(0), WebBrowser).Navigate(urlsearch.Text)
[code].....
How to use this code working if i use web user control of asp.net ?
[Code]...
[code]OK here is the problem, it does not send the email on any of my 2 computers. No firewall, No Anti Virus. I don't know if there is an error in this or what? All the other code works fine, except for this emailing part.
View 4 RepliesI want to convert the code at Webcam using DirectShow.NET to C#. It works perfectly in vb.net. I tried converting using an online converter, however I got about 30 errors
View 8 RepliesI have a database in sql server 2005 named as Addressbook and table Persons with PersonID as PK.I have created 4 textbox on form for FirstName, LastName, Address, CityID and an ADD button. When I input data to text boxes and press F5 then it show some error message. I hv tried eerything but failed.My code is as following and error messae is (The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.)[code]
View 1 RepliesI have this code to get images width and height from header file without full loading the image..I convert it automatically from C# to VB.NET by [url]....The source C# code here:http:[url]....
Now I need this code to work with .net framework 2.The code doesn't work after converting even with .NET 3.5
Imports System.Collections.Generic
Imports System.Drawing
Imports System.IO[code]..........
I wrote a custom installer that installs my software as well as sql server express 2005 on a pc. Now the client needs it to install on 64 bit pc's as well. It worked well on 32-bit but I had hard coded the install path of sql server as:
[code]...
this works on a 32 bit pc. But on a 64 bit I want it to detect the Program Files(x86) folder.How can I do this reliably?
I am using VB 06 code for MS winsock and no im not supprised its not working properly but I cant find any tutorials anyware for VB 08 and its starting to anoy me. I have managed to reorginise some of the code so it works but im at a loss to know what to do to correct these errors. .
Send Button
sckmain.SendData("[" & txtname.Text & "]" & txtsend.Text)
txtlog = txtlog.Text & "[" & txtname & "]" & txtsend.Text & vbCrLf
txtsend.Text = ""
Host Button this works:
sckmain.LocalPort = txtport.Text
sckmain.Listen()
Connect button this works:
sckmain.RemoteHost = txtip.Text
sckmain.RemotePort = txtport.Text
sckmain.Connect()sckmain.RemoteHost = txtip.Text
[CODE]...
Connection request
If sckmain.State <> sckClose Then
sckmain.Close()
End If
[CODE]...