ASP.NET Server Data Persistence?

May 28, 2010

I'm not really sure exactly how the question should be phrased, so please be patient if I ask the wrong thing.I'm writing an ASP.NET application using VB as the code behind language. I have a data access class that connects to the DB to run the query (parameterized, of course), and another class to perform the validation tasks - I access this class from my aspx page.What I would like is to be able to store the data server side and wait for the user to choose from a few options based on the validity of the data. But unless my understanding is completely off, having persistent data objects on the server will give problems when multiple users connect?

My ultimate goal is that once the data has been validated the end user can't modify it. Currently I'm validating the data, but I still have to retrieve it from the web form AFTER the user says OK, which obviously leaves open the possibility of injecting bad data either accidentally (unlikely) or on purpose (also unlikely for the use, but I'd prefer not to take the chance).So am I completely off in my understanding? If so, can someone point me to a resource that provides some instructions on keeping persistent data on the server, or provide instruction?

Concrete Example: We recently hired Inspector Gadget to insert data for the Sign Inspectors who go 'round inspecting the highway signs to make sure none of them have been mangled or stolen by bubble-gum chewing, normally upstanding members of the youth city council.If Gadget can prove his mettle then he might get promoted to do the actual sign inspections. For now, his only job consists of going to this intranet site an inputing information about the most recent inspections. The district, county, route #, section of road, and dates the sign was installed and inspected.

Of course any of us who were alive in the late 80's are familiar with Gadgets ineptitude. So the site is about as Gadget proof as we can make it. The district/county/route is all filled out through a dropdown list, he only has to manually enter the section start and end and the dates. On occasion he fumbles the mouse and ends out swapping the begin and end of the section, doh! So the text turns red to alert him of the mistake. Unfortunately he chose to wear his anti-red sunglasses today that turn all red colors to black. Well, after attempting to submit the data it shows him an error message telling him where and what he needs to fix. Unfortunately he fat fingered the keyboard and instead of inputting 1.337 he put in 13.37 (miles)- and the road is only 10 miles long! Well, now a message (a modal div) pops up and tells him that the real mileage for the road is 0-10, and that his entry will combine three sections of the road. Then he is given three buttons to choose from. Cancel, which allows him to go and modify his data, Constrain, which will convert 13.37 to 10, and Override which will allow him to input that data anyway.

"Yowza!" Gadget exclaimed, and clicked cancel to go back and fix his mistake. Well the next set of data he input correctly, so a confirmation message popped up showing him the changes he was about to make and asking if it was OK to continue. Well, unfortunately Inspector Gadget knocked over his coffee cup, scattering detritus across his desk. In his haste to clean it up, he clicked "OK", but not before his Go-Go-Gadget electro-magnet accidentally flipped a few bits on his computer, changing the county in the form from ARKANSAS to AKRSANAS, doh!

Had the data been stored on the server across campus, and the only information passed was "OK" or "Cancel", this would have been avoided.Of course I can always validate again after the "OK", but it just seems like a hacky workaround.

View 2 Replies


ADVERTISEMENT

Gradually Transition To NHibernate Persistence Logic From Existing ADO.NET Persistence Logic?

Sep 3, 2010

The application uses ADO.NET to invoke sprocs for nearly every database operation. Some of these sprocs also contain a fair amount of domain logic. The data access logic for each domain entity resides in the domain class itself. ie, there is no decoupling between domain logic and data access logic. I'm looking to accomplish the following:

[Code]...

View 2 Replies

MessageBox Persistence In .net?

May 30, 2011

I'm using MessageBox to give some information to the user, but when such a box pops up, I want it to block access to the main window. So, until the user has clicked "OK", they should not be able to click (or even focus on) the window that's below it.

Does anybody know how to do this? I've noticed that MessageBox has very few functions, so maybe I'll even have to use a different object for this.

View 3 Replies

.net - Persistence Of User Scoped Settings?

Jan 22, 2012

I have a Boolean, user scoped setting. I access it through a referenced class library, called Settings. This class library has a Module with properties:

[Code]...

While the code is running this works. But after a restart of the application the new value is not persisted.

View 2 Replies

.net - Use Singleton Pattern For LINQ To SQL Persistence?

Apr 16, 2011

I have a table, Users, with a related child table, UserSecurityGroups. In my GUI, the operator would select a user from a list. The program would retrieve the user record and allow the operator to edit the user data in one form. The operator could also edit the UserSecurityGroups of this user on another form.

I am considering using a singleton class for user instance retrieval and persistance back to the database. If this is a good practice, I want to use this with many other tables in my DB. My question is: Is this a good practice? What pitfalls am I missing? What would you recommend as an alternative? Would your recommendation change since I also have tables with three or four levels of relations (as opposed to two in the example above)?

Here is my proposed code:

Imports System.Data.Linq
Public Class UserConduit
Implements IDisposable

[code]....

View 1 Replies

Custom Control Property Persistence During Runtime

Aug 30, 2011

How to get a property to persist after its been changed dynamically during run-time? When Visual Basic reverts back to the IDE, the property goes right back to its original value.

View 3 Replies

Add Persistence To Multiple DataGridView In Terms Of Hide/Show Column And Column Width

Feb 24, 2010

Add persistence to multible DataGridView in terms of Hide/Show column and column width

View 1 Replies

Insert Data To A SQL Server Compact Database Sql Server Mdf?

Feb 28, 2010

i have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.

View 1 Replies

Data Transfer From Ms Access Or Sql Server To Sql Server

Jul 6, 2010

I want to know how you can export data from a disconnected database that could be access or ms sql to an sql server database.

Here is the scenario:

I have several software in a remote sites on either sql or ms access databases as back-ends...and I have another sql server database that i want to consolidate data from the remote sites.

One solution I have been thinking about is to use email to send incremental backups of the databases to the main database using a separate piece of software and have another one on the main server to pull that data into the database.

Basically am looking at setting up the remote databases as linked servers at the main database and then having incremental backups sent by email to the main database.

I have thought of replication but the internet link at the sites is terrible.

Is that a good implementation? If yes

How do i get to send the incremental backups and get them imported?(the code)

Tools:

Visual basic 2008 standard edition..Net 3.5
SQL Server 2005.
32 bit architecture.

View 2 Replies

Import Excel Data Into SQL Server - ERROR: "ODBC --Connection To {SQL Server} Servernamesqlservername Failed"

Aug 13, 2010

I am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:

strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()

[Code]...

Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.

On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?

View 1 Replies

Code That Reads An Input File And Store Data In SQL Server Data?

Sep 11, 2009

I am new to VB.net. I want to read and input file and store that data to an SQL Server database. Do you have an sample code that do such?

View 1 Replies

VS 2010 : Send Data From Client To Server (encrypted) And The String Sent From The Client Is Not The Same As Received From The Server?

Jun 27, 2011

Hey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.

Client:

Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)

[code]....

View 4 Replies

.net - Tcp Client Not Receiving The Entire Data Response Data From Server?

Apr 19, 2011

I have a small program which is a tcp client. I send a string from this client to a device over ethernet (it acts as the tcp server). As soon as the device recieves the input string it will respond back with response data. My problem is i am not getting the entire response data back from the server. (device).

Dim serverStream As NetworkStream = clientSocket2.GetStream()
Dim outStream As Byte() = System.Text.Encoding.ASCII.GetBytes("my-cmd")
serverStream.Write(outStream, 0, outStream.Length)

[code]....

View 4 Replies

While Inserting Data Into SQL Server Data Table?

Dec 15, 2011

I am using VB.Net 2010 and SQL Server 2005 Enterprise Edition I have created a table named customer having columns (id int, fullname varchar(50)) and id is my primary key I have created a Class Library for inserting data into the customer table. to insert data I am using following code...

Public Function insertData(ByVal TableName As String, ByVal LinkToDb As SqlConnection, ByRef Adapter As SqlDataAdapter, ByRef DS As DataSet, ByVal MyArray As ArrayList) As Integer
' ----- inserts data into table
Dim sqlCmd As SqlCommand

[Code]...

View 1 Replies

Data Types - Decimal - Move That Value Into A SQL Server Data Table Column Defined As A "Float"?

Aug 7, 2010

SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?

View 4 Replies

Add Data In Database Sql Server?

Jan 14, 2011

[code]...

This codes are working but how can I validate the username if it is already in the database?[code]...

View 2 Replies

Compressing Sql Server Data Across Vpn?

Aug 16, 2009

compressing sql server data (on the fly) from a select statement when accessed across the internet. i.e data is stored in Sql Server Express on a remote computer (1) connected via an Internet VPN. An application on a remote computer (2) on the same VPN sends a select statement to the SQL server machine.The data would then be compressed at computer (1) sent across the VPN and decompressed at computer (2)

The Reason is, broadband speeds are not the greatest in Australia, and it would reduce the size of the data transmitted, resulting in faster response, as the compression/decompression is done at each machine

View 1 Replies

Copy Data From A DB To Other DB In Different Server?

Nov 3, 2009

I have to query one table and insert the result in a table on another database in another server The query is "select ID, name from Table" The other table exists and have the same fields. How can I do this?

View 5 Replies

Getting Data From My MySQL Server?

Mar 18, 2011

I use to do programs in VB5 and haven't touch VB for years, and now i just started to pick it up again, VB2010. my problem is getting data from my MySQL Server (local)

i was able to create my Data Source successfully.. however, when i click and drag my CUSTOMERS table to my form the datagridview shows nothing. I read a few online tutorials and they all said that's all i have to do not working for me..i have 9 records in the table already but nothing is showing..

View 2 Replies

How To Decrypt Data From SQL Server

Dec 15, 2011

Im having a problem in my coding. I am doing a username and password application (sumtthing like a password keeper).

So I have created the interface and i integrated vb 2008 with sql server 2008. So the adding of account and password all went fine.

I have applied aes 128 bits for the password. that means when the user enters a new record for example an email and he click save, the password will automatically be encrypted before it is saved in the database.

now im having a problem where when i want to display the password in the gridview of vb.net (i decided to use grid view to show all the username and password), i am having trouble in decrypting the password column to show the real password to the user.

of course user cant decrypt the password using their brains. so I want to know how to choose dat particular column (password column) and decrypt it before it appears in the gridview.

bcoz now it is appearing gibberish i.e. aes 128 bits. Below i show u some snippet of my codes in encrypting and storing it in the database. [code....]

View 3 Replies

Inserting MDB Data Into SQL Server DB?

May 4, 2009

OK i am using the following code to copy data in an MS Access database to an SQL Server DB

Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand
Dim sql As String = "SELECT * FROM [" & CurrentTable & "]"
Dim u As SqlClient.SqlBulkCopy = New SqlClient.SqlBulkCopy(CurrentRSConnection) 'SQl Server Connection String Try CommandType = CommandType.Text

[Code]...

View 3 Replies

Rretrieving Data From SQL Server?

Dec 15, 2011

I am using VB.Net 2010 and SQL Server 2005 Enterprise Edition I have created a table named customer having columns (id int, fullname varchar(50)) and id is my primary key

I have created a Class Library for retrieving data. to retrieve data I am using following code...

Public Sub getData(ByVal TableName As String, ByVal LinkToDb As SqlConnection, ByRef Adapter As SqlDataAdapter, ByRef DS As DataSet)
' ----- sends data from database
Dim sqlCmd As SqlCommand
Dim Query As String

[Code]...

View 7 Replies

Send Raw Data To A Server?

Sep 9, 2009

How do i send raw data to a server that the server will read and print out the data that was sent.

View 1 Replies

Sql Server - List Ms Sql Data In .net?

Mar 11, 2010

I got no errors in the code now, but it doesn't seem to work. The only thing that works is when I try to list all the data.But when I try to narrow the data that is to be listed. I get no good results. Here is my code:

If ComboBox1.SelectedItem = "School" Then
Dim connectionString As String = "Data Source=SENBONZAKURASQLEXPRESS;Initial Catalog=testing;User ID=SenbonZakuraRew; Trusted_Connection=True;"
Dim selectCommand As String

[code]....

The code above is not the whole thing. I've omitted those that are not relevant. What do I do to make this work?

View 1 Replies

Way To Send Data To Sql Server?

Sep 18, 2010

What is the best way to send data from vb.net project to Sql server. I am using now first I am Createing like belowFirst: Createing a Insert store ProcudureSecond : Creating a Ent Class where I am Declering the Fild Proper Catagory of all the Field and Second I am Creating another Class wher I am connection with The Sql server and Calling the Parameter and joing the Ent with teh store Procudure

View 1 Replies

Write Sql Server Data To CSV?

Jul 9, 2009

I need to write a couple of columns to a csv or possibly xls file. I cannot find any good tutorials on this.

View 2 Replies

Add Data In SQL Server 2005 Database?

Mar 10, 2010

'm just a beginner who want to learn on manipulating SQL Server data using vb.net. I have already experienced manipulating data in ms access. So I just recycled the code that I used in here. But unfortunately I got this error:Object reference not set to an instance of an object.And another problem is that, I'm not really sure if what I have inputted in the SqlConnection matches what is in SQL Server. Here is a screen shot of sql server management studio express:

Imorts system.data.sqlclient
'declarations
Dim idnum As String

[code].....

View 2 Replies

Adding New Data Connection To SQL Server DB?

Apr 24, 2009

I'm trying to add a new data connection to a SQL Server database that lives out on my network. When I add the new connection I get the "Choose Data Source" dialog but it only contains the following:
Microsoft Access Database File
Microsoft SQL Server Database File
I don't see an option for a remote SQL database. How can I add that option to my list?

View 2 Replies

Asp.net - Can't Send Post Data To Another Server

May 17, 2011

this is my code right now:

[Code]...

View 2 Replies

Best Way To Insert Data Into SQL Server 2005?

Oct 19, 2007

I have a VB.net app (which I will turn into a webform soon), my app generates a datatable of values (3 columns and on average about 1000-3000 rows).What is the best way to get this data table into an SQL Server? I can create a table on SQL Server no problem but I've found simply looping through the datatable and doing 1000-3000 insert statements is slow (a few seconds). I'd like to make this as streamlined as possible so was wondering is there is a native way to insert all records in a batch via ADO.net or something.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved