I'm working in ASP.NET ( beginner ) and I tried to make update query using the code below. I try the same code to get date from database and it work fine, but only don't work with update query.
Note: I use LINQ
Dim updateCust = (From cust In db.Customers
Where cust.CustomerID = "JILLF").ToList()(0)
updateCust.ContactName = "Jill Shrader"
[code]....
I have a client app written in VB (Visual Studio 2008) + VS 2008 SP1. I can see the option "Create desktop shortcut" under --- Publish > Option > Manifest but it is disabled.What do I need to do to enable it so I can have it checked before publishing it?
View 3 RepliesI have an application I have developed which works great on individual PC's. However I've had some interest from a few customers that asked if I have a network version for site licencing.If my app did not save any data or write any reg entries, this might have been ok. But it does to the local computer. I also built in my own copy protection and trial function that stores data in the registry on the local computer.What would I need to do to enable my application to run on a server/network share, so that the only a serial number needed is for the server?
View 3 Repliesam i just stupid or do they have a ____ up system?the "publishing folder" is set to my ftp server.. and the upload works.. so thats Done.the installation folder is set to "Whata ____ is this?!" and i dont know if it works or not..it is supposed to update when the application starts.. it does not. and that does problobly have something to do whit the installation url to do..so how do i make it update automatically?
View 3 RepliesI'm trying to update a data user using vb.net2008 and sql server management studio express for my backend. the error says "must declare the scalar variable "@username" here's the code .[code]...
View 14 RepliesHere is the code snippet
objCommand.CommandText = "UPDATE tblCustomers SET weight= @weight, height= @height WHERE id=@id "
What i want to do is the following:
I have a form and i want,by clicking the appropriate button, to update the height and weight values which have the specified primary key 'id'.
The primary key 'id' is of type IDENTITY.The problem is that the above code does not work. It says Must declare the scalar variable "@id".
Well after lots of research i have managed to get a working Shoutcast Server that will allow you to run and stream music to winamp locally or over the net. [URL]is the free source offered by some people over at spesoft using the BASS.dll and BASSenc.dll I'm having problems with Re-sending the original header to winamp when the song changes to update the title of current song playing.this is very straight forward source. however i can't seem to figure this out.
Private Function SendHeader(ByVal sHttpVersion As String, ByVal sMIMEHeader As String, ByVal iTotBytes As Integer, ByVal sStatusCode As String) As Boolean
Dim sBuffer As String = ""
sBuffer = sBuffer & sHttpVersion & " 200" & vbNewLine
[code]....
I am trying to update a SQL Server database Date field.When the user enters the date they enter 02 Oct 2010.When I pick up the DateTimePicker.Value it is 10/02/2010 00:00:00. I need to get the value to read 02/10/2010 00:00:00 How do I get the value to be in this format?
View 7 RepliesHow to use this query to update record [code]....
View 1 RepliesI want to allow the user to enable or disable a textbox by clicking either a button (enable) or the reverse. (disable) if the user clicks the enable button the textbox should receive the focus.
View 4 RepliesI am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
I really like the coding speed that vb.net provides, but I don't like the possibility to forget to declare variable types, return types of functions, etc. and that is why in each class I use[code]..
Is there a way to define those two options on the project/solution level?
the combo box style 1 has both the drop down option but also a manual entry option. I need to know how to code it so that when you manually enter data, it takes that data and places it in a text message "The shipping charges for "data" is $15" displaying in a text box. Shouldn't be hard but have developed a mind block.
View 4 RepliesBasically what i want to do is enable DCOM with visual basic how can i do this..not manually..bu with a code or script?
View 1 Replieswhat does these two code means in vb.net: Option Explicit on Option strict on i think option explicit means the compiler is not going to do any kind of conversion and i need to do all of them by the code;also it becomes case sensitive i.e;
[Code]...
I would like to make the list view that the post closed in the database and it is loaded into the list view.
from the time the record function is closed '(False, True)
that this item cannot be clicked.
but the other records have to be click able.
I have a list box with three items in it. This has been disabled and I want to enable a button if all three are checked, i was looking for a CheckedChange type event in the MSDN but could not find anything. How can I do something like this?
View 2 RepliesI was messing about with my code when I recieved some errors, I deleted some stuff but I don't know what but it fixed the errors I was getting but now the Enable Application Framework section has gone..
View 1 RepliesI have a RichText control on my form. In the control when running, the tab key does not do anything. I would like to enable it and set the size of the tab. How can I do this?
View 1 RepliesOk, ive got a control that is added on at first run..
So I cant see the property pane at the right to enable the keypreview = true
How can I do this manually in my code?
how to enable /disable the timer with a button and how enable /disable the timer with a checkbox? and the opposite how to enable /disable a button with a timer and how to enable /disable a checkbox with a timer
View 5 RepliesIs there a way to set the enabled property of a combo box using the tab index?
In my program I have two combo boxes next to eachother. When a certain option is selected in the first combo box, I want the second to enable itself. Obviously this is easy to do by using combobox2.enabled = true but I have 10 rows of boxes that need to do this and I want to put all the functionality into one sub. It's possible to read the tabindex into a variable by using VAR = sender.tabindex and then add 10 to that variable (The box that needs to be enabled will always have a tab index of sender + 10) but I can't figure out how I'd use the tab index to enable it. If only I could just type sender.tabindex(+10).enabled = true
how to update sql server from temporary table using visual basic net but don't create that temporary table on sql database (just in coding), the value of temporary table from ms-access table.
View 3 RepliesI am using the below mention code to update and delete data from datagridview. but i am unable to solve this issue. Delete is working but not update.
[code]...
my application reads from an .xls file I put on google sites. The problem comes when the application modifies a cell and tryes to save the file on the site, actually it does nothing since to read something from the site is easy, while trying to save something requires a connection with username and password.
So, how can I pass the username and the password to the application? and even most important,can I encrypt it so that the person who uses my application could not see the real trafic details with a http sniffer?Right now I am using this code:
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
[code].....
im currently developing an application as my semester project and i strucked becuse of an small error. i have tried to update a record set in the sql server 2005 databse table by giving the following code. but its not showing any errors its working and displaying a message succeeded. but in database table i cant find any changes
sql
Public Shared ReadOnly SQLConnectionString AS String = "Server=RUSHANSQLEXPRESS;Database=nolimit;Trusted_Connection=True;"
Dim cnn AS SqlClient.SqlConnection[code]......
I make changes on my program very often so after I change something in application I have to go from PC to PC and copy paste new .exe file or .dll. I have more than 100 pc. I was thinking on this way but I do not know how I can make it; I want run application in the server, if got any update files server should update to rest of the pc which are online. In this case I do not need to walk around and copy-paste files every time I make any change in application.
View 1 RepliesI have a datagrid which is binding in my MS SQL database. I've created a two button: Import Data (this button is used to import my table from access database then display it to my datagrid) and Update button (this button is used to save/update my sql server through datagridview). When i clicked the Import Data button, it successfully import my table from access in my datagrid but the problem is, when i clicked the Update Data button an error message occur. I found the error in this code (da.UpdateCommand = cmb.GetUpdateCommand) saying "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information"
Here is the part of the sourcecode:
Imports System.Windows.Forms
Imports System.Data.SqlClient
Imports System.IO
[code]....
I'm trying to register two hotkeys to enable two different button clicks. I have the first button successful. (F9 = Button 1) How would I add the second button without errors? (F10 = Button 2)
[Code]...
I have a usercontrol that contains a datagridview and a toolstrip. When creating a windows form that contains 2 of the mentioned usercontrol i gate for example c1 and c2 where both contains for sure the datagridview and the toolstrip hving the same control name for example G and t. in my case i want to apply the security on each form, i do this by reading the access of each control inside the windows form and if the control on the form was a user control then i dont consider it as one entity instead but as a grid alone and a toolstrip alone in order to be able to apply its security accordingly. but in ma case, if i want to disable the first grid and enable the 2nd i wont be able to do so since both grids have the same name. is there any solution for the above.
View 2 Replies