i am getting this error message : Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
[Code]...
I need to create a picturebox that allows different pics to show when The user clicks an item in a combo box. in vb.net..
View 4 RepliesI have used a single picture box and I want it to display many pictures when I run it, whereby I cant navigate through it by clicking next or back. I used some codes, they had no error but they weren't able to display my pictures during run time.
View 14 Replieshow do i recieve webcam pics and transform each to a string ?
View 18 RepliesI�m trying to create an app to copy pics from my camera to my hard drive. Problem is when I connect the camera it shows in �My computer� but not as a logical drive. Is there any way I could access my pics using vb.net without the need for the camera SDK which is not available for my camera model.
View 2 Repliesi am trying to develop a project for my academics...i.e, windows application s/w... how to get the thumbnail view(in win7 taskbar shows in that manner?) of all applications that are appearing on taskbar with code in vb ..
View 1 RepliesI have the following html code for some pictures:
<table cellpadding='0' bgcolor='#ffffff' cellspacing='0' style='border: solid 3px #470506;padding-right:1px;'><tr><td><img src='./images/counter/b.gif'></td>
<td><img src="./images/counter/3.gif" border="0"/></td>
[code].....
What Im making is like a face book and tagged login from my app
1. I have Combobox with 3 urls in there ( Facebook.com Tagged.com and Bebo.com )
2. I have a Form2 with webbrowser
3. I have a Button when clicked it should open up my form 2 and preview of the website which I selected in my combobox in form1
All I'm trying to do is when I select lets say facebook in my form 1 and click load it should open up my form 2 with facebook website in it.[code]Now when I click my button in form 1 it will load Form2 ( named Explorer1) but my form2 is not showing me facebook or tagged page for some reason
i'm creating a website that allows people to upload images to the website in a folder called images on the Site. But I don't know how to upload a file and I'v searched everywhere Please Note: In this Website were not Using the asp:fileupload, were developing our own interface
View 1 RepliesWhat I want is: To scan a website every 15 mins or so, (craigslist in this case), and email myself any new posts that come up. I know I need to use WebClient, but I never used that before. Another question would be how to only email when a new post is up and not receive the same email every 15 mins.
View 2 RepliesI have a ASP.NET 2.0 website created in C# that acts as a completely independent site and I am looking to integrate this into an existing ASP.NET 2.0 website created in VB.NET. Unfortunately I just don't know much about the server management side of ASP.NET yet so too much I'm unaware of when it comes to IIS configuration etc. Does anyone have any advice as to how I can go about integrating this? Basically I want to host it in a subdirectory from root so when you hit example.com/myindependantsite/ it will pull up my C# site.
One possible solution I came across mentioned just dropping the project folder into the root directory and setting up that directory as an application virtual directory in IIS? A few other random questions were small things like would my application relative links (~/for-example.aspx) stay relative to my root subdirectory if it's made into an application virtual directory? Just trying to get this running on their site but like I said it's completely independent so want to preserve my websites environment.
I want to create a program to fetch information from a website (that's fine). However, you need to be logged in to get this information. I just want two simple textbox controls that I would type my username and password into and hit submit and the information would be returned to me so I can use it. (I don't want to use a webbrowser control)
View 2 Replies'Code for inserting Data into the Database
Try
Dim com As New OleDbCommand
com.Connection = con
[Code].....
I'm trying to do an Insert into a couple tables on one form with data controls. The problem is I don't know the approach. You see, the client has books to sell. He has catagories and he wants to add many catagories for each book. One or more catagories. It would seem to me that this is a many to many normalization. Being that one or more catagories can belong to one or more books? If this is incorrect, please tell me, as I thought it was a one to many earlier with one book having one or more catagories? Anyway, I need to be able to allow the client to enter one book, and then assign one or more catagories? He wants the potential buyers to be able to query books by catagories obviously. Wondering what approach to use? What data controls, and is it possible with just the controls, or do I need to write a stored procedure to grab the ID from the book using the @@Identity SQL statment?
View 4 RepliesI have an asp page where I am trying to insert a checkbox value into my SQL db. I converted the value to the byte datatype so that it will be recognized as either a 1 or 0. The column in SQL is a bit datatype.
I currently have this:
[Code]...
My problem is when I try adding a new appointment I get an error that says ""Column 'AppID' does not allow nulls."" Editing existing appointments is fine and it updates the DB no problem. I don't have an INSERT statement right now (which might be the issue) so I was thinking of doing this: INSERT INTO [tablename] ( [column1], [column2], ... ) VALUES ( [value1], [value2], ...) Only problem with that is I would need to use the textbox names for the VALUES, and that form that pops up to gather appointment info is from a third party, and I can't find the names of any text boxes
View 2 RepliesI have the following code:
Code:
Imports System.Data.SqlClient
Public Class Form1
Dim ReturnValue As Object = Nothing
[Code].....
which should return back the next available sunday to me from the database. What I'm getting back is 01/01/0001 - 01/08/0001.
I've tried a couple of versions of this but they all produce the same date.
Basically I am trying to insert some data about a user into a database for a test that they complete. If it's their first time completing the test then I want their results to be automatically stored. If not then I want their results to only be overwritten if they agree to it.
Here's my code so far:
Dim sqlx As OleDbCommand = New OleDbCommand
Dim con As New OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source =
[code]......
Doing a project in Visual Web Developer 2010 using Visual Basic. MS SQL Server 2010.I can connect to my SQL server. But when I try to INSERT INTO sql server, I get an error that the columns could not be found. But the column's SQL is listing is from my VALUES field! Here is code and SQL error. [code]
View 3 Repliesi am trying to input 72003 3131/1 from text from a text field into sql as a string.I have the following code but getting an Error while inserting record on table, incorrect syntax near '3131'.the end user will be able to change this text to anything they like and still
the exe will run.
Private Sub line2add_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles line2add.Click
Dim NewLongDesc As String
Dim RConv As String
Dim StkCodeV As String
[code]....
Here's the code:
CODE:
I'm getting the error: Syntax error in INSERT INTO statement.
I've written the following code to add a new record to a database:
Public Shared Sub AddTopicUser(ByVal UserID As Integer, ByVal TopicCode As String)
Dim RowsAffected As Integer
Dim ATUDCONN As New OleDbConnection
ATUDCONN.ConnectionString = DBCONNSTR
Dim ATUDCMD As New OleDbCommand("INSERT INTO tblSubscriptions (UserID, TopicCode, Completed) Values (@UserID, @TopicCode, @Completed)", ATUDCONN)
[Code]...
I recieve no errors from the code, but when i open the database after - the record has not been added.
I have checked that the values being passed as parameters to the function are valid. I was curious as to whether I was formatting the OleDbCmd correctly, which is why i added a message box function to show be the value of the connection string which at runtime is: when they're not being added to the db?
I am having problems with inserting into my sql database my program is as follows:[code]So when I enter my data, into my program, it goes perfectly until it gets to "dim num as integer = cmd.ExecuteNonQuery" and then it comes up with an error saying "Syntax error in INSERT INTO statement.".i am also doing an update function which is pretty much exactly like this, except for the sql command of course, and that works perfectly with this code.[code]I have noted that instead of"replace" it should be "insert" but am now getting another error where it says "Conversion from string "#PlayerNo#" to type 'Integer' is not valid."
View 5 RepliesI have a SQL Compact Database that I've added in my Data Sources. I then have a DataGridView which is filled with all the records in a particular Data Set.There's a button on the same form as the DataGridView that opens another form, which allows the user to add a new row (record) to the DataSet. Currently however, the fields on this form are not related to the columns in the Data Source in any way.
View 6 RepliesI have recently created a disk catalog program for myself, it is working fine. The problem is, when i try to index my 2 TB HDD, the time taken to write 66K rows into sql table is taking a lot of time nearing 30min.
I am using sql client (sdf is the file extension).
Also, i am using two threads to insert data simultaneous saving 50% of time.
I am using vb generated table adapters only.
This is the code I have
NewCustomerTable.Clear()
NewCustomerconnection.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=G:Shop.mdb"
NewCustomerconnection.Open()
[Code] .....
I have a button called btnUpdate and when I click on update I want the program to check to see if the ID number already exists within the database but I cant seem to figure out how to do that.
Im prting a values to my Database which will later be pulled to make HTML Reports. So Im needing to insert "<br>" Every 50 characters so the values isnt displayed as one big long string.I do have it to do it at the first 50 chars. But since Im writing it to a Database My code looks like so:
cmd.Parameters.Add(New OleDbParameter("@Notes", txtcustnotes.Text.Insert(50, "<br>")))
And it works for the first 50, but not for the next 50. Any tips to make it do every 50 chars and still write properly to the DB?
So I have the following that seems to work fine in MS SQL Server management Studio and seems (but isn't) to be working as its doing a re-direct to another page after the insertion of data...Basically, I pull in all the data from the text boxes and hidden fields, convert that info to strings and do my insert statement. Now in MS SQL SMS The following insert statement works:
insert into [Contacts].[dbo].[contactInformation] values ('Adam', 'john', '16', '' , '' , 'm', '', '');
You can tell from the above which are allowed and which are not allowed to be null. any ways. Why is this not inserting data into my database? is it because of
cmd.CommandText = SqlDataSourceCommandType.Text
im working on a project that is calculating the total population for given countries and its in the hundreds of thousands. And i need to output the population with the ,'s in the appropriate places.Ex. population 123456789 i need to output it in a listbox as 123,456,789 so im looking for a converter function or something built in that takes my value
[Code]...
Now i got it to work but the bulk copy is inserting the rows twice, instead of once and i know the table has the correct rows because i can see it in the gridview correctly I FIXED THIS PART my program works fine when i run it in debug mode but not when i place it on the server, it doesnt run the stored procedure when i put it on my server.
Label1.Visible = True
Dim tourid As New List(Of String)
tourid.Add(TextBox1.Text)
Dim tasktype As New List(Of String)
[code].....