I have the following code for SQL insertion, but how can I prevent data dublication in vb.net so that the same data is not entered twice? I mean can I add a exception in my code to check if one of the field in the sql server table contains the same data? [code]
View 14 RepliesHere's an interesting problem, and I'm looking for a pattern that will keep it all workable. I am building a smart-client app for a school system. It will contain information about students including their report cards, sick days, and so forth. it will generate student-level reports, including their report cards, each rich with very personal commentary by their teachers. The app will retrieve data from the remote server via web services.
[Code]...
I receive three errors using the following function:
Private Sub readWebpage(ByVal url As String)
Try
Dim req As System.Net.WebRequest = System.Net.WebRequest.Create(url)
Dim resp As System.Net.WebResponse = req.GetResponse
[code]....
The remote server returned an error:
(500) Internal Server Error.
The server committed a protocol
violation. Section=ResponseStatusLine
[code]....
How would I be able to prevent these errors?
I created a server-client application using the asynchronous socket. I found the problem when closing a socket on the server, applications so closed. The procedure that I do to close the socket server is:
Terminate the listening thread. Close the client socket is still connected to the server. Close the server socket.
How to prevent the application is closed, when I close the server socket?
Protected Friend Sub CloseServerSocket(ByVal IPAddress As IPAddress, ByVal socketPort As Integer)
' Terminate the listening thread.
[Code].....
Assume a .NET class library code that, for example, writes to the Windows registry. Then this code has problem to run over internet, because default Internet policy does not give access to write to the registry.By adding a RequestMinimum statement in the assembly we can specify that the code requires permission to write to write to the registry. This will not alter the fact that the code does not have the permission, but will stop the assembly from loading; the runtime will throw a System.Security.Policy.PolicyException and identify the permission that is required.Do you now any other examples of using evidence, security policy and permissions (the key elements of code-access security) to prevent an assembly from loading on a web server?
View 1 RepliesI have a Windows 2003 server that we regularly RDP in to monitor some programs that we set up to run on the machine automatically.However, the server will automatically log me out after a few minutes of inactivity. Unfortunately the server admin (who has the admin rights to the server, which I don't) is reluctant to remove such restrictions "for security reasons".
Therefore, instead of me trying to fill up 10000 piece of paper getting a security exemption, I am just wondering if there is any tiny program that I can run on the server (either a script or some VB.NET code) that will trick the server into thinking I am constantly typing something even though I am not (For example, as if I am moving my mouse cursor once every 30 seconds or type any letter then erase it in notepad)?Note that since I do not have admin rights, any installation is certainly out of question, and the script, if any, can not require admin rights to run properly.
i am trying to save data from vb.net form in sql server 2008 below is the code which i am using but the only problem is . i am not getting any error instead the data which is being saved in sql server in my First Name , Last Name and Address fields is not the one i insert into textboxes, when i check the backend it shows me my field values as first name , last name and address.
Dim FirstName As String
Dim LastName As String
Dim Address As String
[Code].....
I have the following code which I mashed up from several sources:[code]This works great until I add another POST parameters to query, like "client=mgdf&version=100".No errors are thrown, the program doesn't crash, nothing. It simply stops working. How can I POST multiple values to my server?
View 1 Replieshow to update the data of an SQL server 2008 express using vb.net 2008? My raw data actually from excel file only and i want to transfer all the data and merge it in my newly installed SQL server 2008.Normally im updating it daily that is why i want to create code.
View 6 Repliesi want to take back up of our data base data i request to you for give best solution for it .. code .. and it will also run whenever some one accessing our vb.net project?
View 1 RepliesI've been trying to write code to import Excel files into a SQL Table using the following code (url...) with little success.
This is a VB.Net app using Visual Studios 2008 with SQL Server 2008 on a Vista Ultimate 64 machine.
The runtime error encountered is: "COMException was unhandled...Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."[code]...
I am using visual basic 2008 and sql server 2008. I am trying to retrieve data from a table in sql server 2008. I am using the following code
Dim cn As ADODB.Connection
cn = New ADODB.Connection()
Dim rs As ADODB.Recordset
rs = New ADODB.Recordset
Dim cnstr As String
[Code]...
I'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 RepliesI want to transfer Excel sheets data to SQL Server database.
View 4 Repliesi wanted to develop an apps that sends sends data from client to server and vice versa. i want to biuld it with
View 5 RepliesI need to solve the following problem:- Create a server application which generates a random number every second- Have any number of client applications access the current random number through a dll (associated to the server) at anytime How would I do this? Anyone has a prototype VB.Net code for the server which does this kind of thing? I'm pretty sure I know how to write the client code.
View 5 RepliesMy problem is that I would like to know that if some data from client has arrived to the server, I would know its length.Now I m getting an error at: mClient.GetStream.EndRead(ar). It is saying that ar cannot be empty. [code]
View 3 Repliesi want to prevent user from adding same data on my database... (using access as database)
let say i have 5 fields on my database... ID, Name, address, contact, email... binded to textboxes... idTextbox, nameTextbox, addressTextbox, contactTextbox, emailTextbox.
if the user add a data.... and clicks the save button (saveButton) a messagebox will show a message saying that the data he/she entered already exist..
the messagebox will only show if the user entered a data with the same Name.
I have linked VB to my sql server and all my tables and data load correctly in VB.I drag and dropped my table in "detail" view and then debugged the program, little did I know, when I tried to add a new instance of data into my table I literally have to enter the primary key. I am trying to figure out how to set the "STU_ID" (PrimaryKey) to auto-increment off of the last row of data on my table.
View 3 RepliesI have a project to import data from one worksheet into database SQL Server 2008 on Windows Server 2008 using Interop. The project in debug mode works fine, but accessing the site from a client computer, I am getting permission denied message to the file I'm trying to import and it is located on the server. I wonder what it takes to make additional settings, as well as file folder. IIS? DCOM?
View 1 RepliesI am using the following code for inserting data to the database
[Code]....
this inserted data to database when programs is running but if i close the program and start again previous data i have inserted are lost ....why ?
Here 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".
I THINK this should be a fairly simple fix, but my VB newbness is holding me back.I want to add data from various CSV files into a SQL Server staging table. Each CSV file has its own quirks as far as field names, more fields than the others, etc. go, so I'll need to map each CSV structure to the staging table in code.
[code]...
But it's no good, I get this error, "Input array is longer than the number of columns in this table." at "row.ItemArray = data".
I'm not sure what I have done wrong, I am trying to get my program to send data (UsernamesPasswords) from client to server, then the server says if it's right or wrong.
The error is on this line:
Dim networkStream As NetworkStream = TcpClient.GetStream()
Heres the Client:
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
If TextBox1.Text = "" Then
MsgBox("You must enter UN/PW!")
[Code] .....
I'm trying to update some data fields in an existing data table, and want to access the data directly. I know it's possible, and I used to do it years ago in VBA, where you could do things like
[Code]...
I have created a VB form where I select the "API Type" and click "Generate API" buttoThe dropdown "Environment" should show all users in database. in this casefoo, dead, cafef i select cafe, I want the "changepass" table to be queried and display the password for the user cafe.
View 1 Repliesi'm working on a voting system but im having problems in adding records... i have two a primary key, the idnumber and the address. the address is where I base if that certain address already voted. but the problem is everytime i try to add a record with the same address (ex. Block 1 lot 4), the data is duplicated which is not output i want. the program should detect that there is already an existing address.
[Code]...
I have this sql server query that I am running in my .net app.[code]...
Any date that has e in the middle such as 20120731*e*0000001 turns into scientific data.
I coded this program. It has three forms, when I try to open the [Design] on one of the forms it give me this error: To prevent possible data loss before loading the designer, the following errors must be resolved:
[Code]...
I am updating my last post so hopefully someone will help. I have following code that will move a cell to the next column when hitting the enter key while doing an edit. It will even check the row at the last cell to validate data is present.
However, if there is no data in a cell and I press enter, the focus moves to the next line like it normally does. I need to prevent the user from moving or clicking on any cell until the cell they are on has data in it. Here is the coe I have used[code]...