I've created an application in <acronym title="Visual Basic">VB</acronym> .net to allow me to modify my student database, the problem being that it only updates the copy of the database in the debug folder. How can I make the program update the real database instead? I'm using Visual Studio - <acronym title="Visual Basic">VB</acronym> .Net - 2010
View 5 RepliesI am using the select command to find a specific row and if its found update it but when I update back to live database I get a concurrency error. Here is my
[Code]...
I want to make a database of all the xbox live arcade arcade games on the xbox live marketplace, I need to parse an xml file and add the needed data from the xml node into a datagridview.Here is the xml file i need to use to grab links and other data about the game:
[URL]
Being the noob I am it took me about 6 hours to figure out how xml works and to write some code for what i need to do.
Here is what i came up with:
'for grabbing the name of the update
Public Sub updatename()
Dim xmldoc As New XmlDataDocument()
[code]....
That code works fine.Now when i add another column to the datagridview called "update size" i want to know how to add the grabbed data from another sub i made to the new column.What would the code be for adding the strings for the new sub into the seconds column? the first was, DataGridView1.Rows.Add(str)" . So what would the second be ?Also another question i have is how do i put an image in an imagecolumn by a web link, not a local picture.
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
how would i record a live .avi video on to a network stream?
View 1 RepliesI'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page:
<asp:SqlDataSource ID="msgUnread" runat="server"
ConnectionString="<%$ ConnectionStrings:edinsec %>"
[code]....
As you can see I was playing with WithEvents but that didn't seem to help. In the above code all I was trying to get was some kind of reaction to the clicking of a checkbox - but nothing happens (no errors, either).
I have an application written in ASP.NET and using EF. I want to make a copy of the live database, have my application point to the copy, and be able to run the application against it as if it is live...but making updates to the copy.
I know I can manually copy the database and manually update the web.config files...but I'm wondering if there is a better, more automated method for achieving this with VS 2010?
Also, if there is anything I need to know about setting up a live/dev version of a database while using EF4.
How can I create a live connection to my textbox.Text form data base Means... when I click in the datagridview row the data field input will reflect in the textBox.Text..[code]
View 3 RepliesIs there a way to make the border edge round like Windows Live Messenger?
View 9 Repliesi try to make a program that can share a database to other people using a upload/update system but when i try to download/upload it keeps saying mdf file in use how can i make the code so that it Uploads and overwites the file without that error.as it must be so it must upload to my server (build in)and download (also build in)the error gives file in use constandly how can i fix this issue?of that file in use problem. even when these no querry or other code running?
View 9 RepliesI was trying to add a worksheet to my current active workbook. I had misreferrenced the command and got an exception thrown. OK, that happens. But what happened next kinda threw me for a loop. Now, and it still happening, everytime I use F10 step I get a new worksheet added. It is the strangest thing. OK, I gave up trying to figure out this problem. I solved it by selecting the entire form1.vb file and pasting it into a new application.
View 4 RepliesI want to make live search form like when user enter 1 char then it ll find all data start with or contain letter.i have use the sql like query with textbox textchanged event but it is too slow any other method to make it fast?
View 4 RepliesThe info i need extracted is formatted:
<TD><A HREF="http://xxxxx.com/xxxxxx/index.html"><IMG SRC="../xxxxx/thumbnails/xxxxx.jpg"> </A></TD>
<TD>=== <B><A HREF="http://xxxxxxxxx.com/xxxxxxxx/index.html">LINE 0</A></B> ===<BR>
<FONT SIZE="2" COLOR="#400080">
[code]....
how do i extract the info between TD=== and /a and Line 1,2, and 3 and store it into a database from a live website?
There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
I am fresher in vb.net but I have experience in vb 6.0. But I want to connect database in sql server through sql connection. In that case how to create connection with window or sqlserver authintication mode and how to add or update new record in data base in batch transaction. Please help me with sample code.
So that I can understand eassily.
I've set up a simple database connection using visual basic 2010 express. I have set up a table and dragged the fields onto the form, where a navigation bar appears. I am able to enter and save data when I debug the programme; however when I stop debugging and make some changes, then start debugging again, the records are reset to 0.
View 2 Repliesupdate statement, i am trying to update a row within a access 2007 database here is my code.
[Code]...
I have an update panel that has a table in it with 4 images. Every few seconds a new image is shown. All this works but when the image changes the whole page is refreshed. I am using Visual Studio 2008 and VB.Net 3.5.I only want the images in the updatepanel to refresh. How can I do that?
UpdatePanel Code:
<asp:UpdatePanel runat="server" ID="upImgSwitch" UpdateMode="Always">
<ContentTemplate>
<table height="200px" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
[Code]...
I am using vb.net with access database. I am using sql. How can i update database with the value 40'6"(Feet and inches values)
View 5 RepliesSimple question that does not seem to be covered: If I use a lot of Debug.WriteLine statements in my code, will they be completely absent in my production version?
I mean: Is the compiler smart enough to not emit any code for those calls? Or would I have to surround them by #if DEBUG..#end if directives?
What is wrong with this code. It does not update the access database and no error.
Dim conn As New OleDbConnection
Dim sqlQRY As String = "SELECT * FROM StdMaster WHERE StuNo = " & txtStudentNo.Text & " ORDER BY StuNo"
[CODE]...
Dim hex = "41"
Dim text As New System.Text.StringBuilder
For i As Integer = 0 To hex.Length - 2 Step 2
text.Append(Chr(Convert.ToByte(hex.Substring(i, 2), 16)))
[code].....
but yet this fails.. (the output isn't itself in a new line) what's the explanation for that?From what I know, doesn't System.Diagnostics.Debug.Writeline does something which looks like this:
System.Diagnostics.Debug.Write(input)
System.Diagnostics.Debug.Write("
")
so regardless of my input it should always have a newline char even if there is a terminating 00 char in my input?
I'm using vb2008 and database ms access.
I want to know if exist in the Debug folder in my project Database access
what is the connection string when the database copy paste in debug folder?I have a code connection string it's work but when i try to other computer cannot connect in to the database.
Try
If sqlconn.State = ConnectionState.Open Then
sqlconn.Close()
End If
[code]....
is there a way to update a database row with the update command by first defining all parameters and then all values just like you can in the insert command? "insert into table1 (parameter1,parameter2,....) values (value1, value2,....)"something like "set table1 (parameter1, parameter2) values (value1,value 2,...) where ...."?because I only know the syntax to define each parameters value "set table parameter1=value, parameter2=value2... where"
View 8 RepliesI 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]...
Is there a way to make an update for your program that the 'user' can update the app without re installing the whole program?
View 1 RepliesI am using 2008 Express Edition. I am trying to make a Release build instead of a Debug build.Under Tools->Options, Projects and Solutions->General - I checked Show advanced build configurations. The option to switch configurations does not show up in the IDE.
After this, I went to the Project Properties->Compile and switched the Configuration from Active(Debug) to Release.After building, I looked in my project directory, however only in the Debug sub-directory was the .exe and nothing in the Release sub-directory.I have used Visual C++ Express Edition, where I noticed that if you do not change to Release in the IDE than after changing to Release in properties, resets the project to the last configuration setting which is usually Debug.how to make the Debug/Release box available in the IDE, since Tools/Options does not make it show up?
i want to update my inventory table in database from another database name. Example: In VB, i had a form named Orderform. User need to select e product that they want and key in the quantity. all these information are able to store inside my database named ORDERTAB. but now the problem is i wanted to update another field in my database named INVENTORY by minus the quantity tat the user had key previously. i totally had no idea how it going to works.
View 3 RepliesI am having a bit of a problem with a query and I have google around and I still haven't find out a solution.I have an update query, but when it is executed I get a Syntax error in UPDATE statement.
[Code]...