I am interested in making a simple budget program that retrieves current transactions from my bank account and categorizes them appropriately. Is the proper way to do this:
1)Automatically log into the website
2)Read and parse the data
3)Place in correct category?
Is there anything special I would need to do when handling the login/password or should I just do this manually?I'm assuming that is how popular prgrams like Quicken do it.
I have a design question about parsing data in Silverlight. I need to allow my users to validate their csv data (they paste ten rows into a textblock), but I am not sure if I should attempt to do it on the client side where I don't have access to the textfileparser class or send the data to a webservice for validation. If I send it to a webservice how do I ensure the data is secure?
View 1 RepliesI'm developing a VB.Net and SQL Server 2005 Express application.Q: How to encrypt string values in the database to secure them from the one using my software and from DBAs (people who have access to the DB Server)? Here is what I tried:First, I used a Symmetric Encryption provided by the .Net Framework. But I noticed that I could not make partial searches (LIKE keyword). So, this is not working.
Then, I used a logic similar to the ROT13 to hide text. Although this logic works fine from VB.Net, once data has been stored in the database, the logic fails to decrypt data correctly. After some tries, I thought that the reason the logic failed was the Collation of the database (I do not know much about Collation topic).So, the first way doesn't allow partial searches, and the second way is not secure and also does not work because of the Collation or maybe another reason.I want to encrypt data. I've successfully hidden the schema by giving meaningless names to tables and columns.
What would be the best way of storing data securely away from users. What I have is a stack of files that get downloaded by the program, at the moment they COME encrypted, and stored in a temp location. Now where would be the be place to store them, and how would I store them? The program reads normal unencrypted files but in order for me to open them at the moment I nee to decrypt them in the temp folder and open them from there.This is bad because anyone could find the temp folder and simply copy out all the unencrypted files.Opening the files and then decrypting the bytearray is out of the question because the program only takes a filename as a option.
View 2 RepliesI'm just starting to really get into JSON as a tool for my sites. I was showing my friend how I am calling a WS and returning the data, and he asked me about security of passing JSON data to and from a web service as he saw the data from the "POST" (via Firebug). Many of our public facing sites deal with member information and contain PHI.
Can I encrypt the JSON data and then unencrypt it? Is that a good way to go about it to ensure a layer of protection? Or is there another "better/right" way of doing it? Or are his concerns unfounded? how to encrypt or secure the JSON data when needed? Just trying to gather as much knowledge as possible before I go down a path that won't work for the company.
I'm using a mysql as my backend database and i'm using the mysqldata adapter for binding the data, i have my data in the database, but the problem is i don't know how to retrieve it, for example when i want to add a record, before i add that record, i want to retrieve the data in my database to trap that the record i'm adding is an existing record
View 11 RepliesI got a weird problem here like I got a site that users can post comments on a friend profile page.Everytime a user post a comment my application sends e-mail to that page owner, you know to inform for a new posted comment on his/her profile page.The problem is I want to stop the application from sending email if that user has just recently posted a comment say like 5 hours ago/earlier.Here is the function I use that would try to check it:
[Code]...
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
[Code].....
how do we connect database in access after con.Close() since we do all operation after the con.Close() and works properly.
I have MSaccess database.I have 2 tables 1) CUSTOMER TABLE=----CUSTOMER ID-Primary --AUTO NUMBER2) ORDER TABLE =----(CUSTOMER ID--Foreign KEY) Now From the front end using VB.net I have an page in which if i enter Customer details and press button add .I have to INSERT into values into CUSTOMER TABLE and I Also at the same time INSERT into ORDER TABLE with this CUSTOMER ID which i generated now.How is it possibl
View 13 RepliesI have a code here which is to insert values in both the tables which has Relationship.[code]...
View 4 RepliesI have this XML:
<root>
<data name="lnkViewResultResource1.Text" xml:space="preserve">
<value>bekijk de resultaten</value>
</data>
[code]...
But, unfortunately, it is not working, it is not getting anything.
I'm using two textbox's to enter text and retrieve the data and then show that data in a datagridview.Here is my
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
[code].....
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Dim intaccount As Integer
Try
[Code]...
I am using two textboxes, one for roll number and the other for the corresponding roll number.
And I am using 4 command Buttons
Move First
Move Previous
Move Next
[Code].....
I am trying to retrieve the data in a DataGridView and display it in a RichTextBox.
[Code]...
This pulls the data from the first row only though, i want to be able to pull the information form each row and display it on a new line? So if there are 8 rows there will be 8 lines of text with the same values as set in the DataGridView?
I have created a .xsd dataset using the visual studio installed template ->DataSet. nothing programmitcally rather it was using the toolbox and creating various DataTable. how do I retrieve the data once it is assigned programmitcally.
View 2 RepliesI'm making a timer program, that I want to be able to store "unlimited" timer profiles, that someone can load and use. Now I've created a form that you fill with data, which then gets saved to a .xml file in a pre-defined directory. I'm now working on some sort of code that will:
1. Search the directory for .xml files
2. Find any .xml files and convert names to strings
3. Store the strings in a dropdown menu, so that when one is chosen, it loads that profile.
I think I have 1 down:
System.IO.Directory.GetFiles("C:Simple Timer")
Dim di As DirectoryInfo
di = New DirectoryInfo("C:Simple Timer")
di.GetFiles("*.xml")
Below is my code for login page I would like to show login user detail on home. For login my code works properly but does not show currently login user show following error "NO data exists for column/row".
[/CODE]
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login.Click
RetrieveUserPass()
End Sub
[code]...
I Want to Display Content of Database Into TextBox,i.e. i have column named "Ename" in "EMP" table of database1 ,now i want to display "Ename" in TextBox of my form , so, how can i do this ?
View 11 Repliesi am working with the XML.i created a new winapp,added a label to my form.then i added xml file by : Add - > New Item-> XMLFile1.xml.[code]all i want to do is to display the message present in the body part in the label present in the form1.
View 1 RepliesIm not good in querying. I would like to ask if this query works.I want to retrieve starttime, endtime and sessioncost from the table SESSION of my database. my program will be an autorun.
Dim sql As String = "select STARTTIME, ENDTIME, SESSIONCOST from SESSIONS where CLIENTID = (?)"
I am using ASP.NET.
There is a system that needs to POST data to my site and all they asked for is for me to provide them with a URL. So I gave them my URL [URL]
Now I do not know exactly how they POST it but now on my Test.aspx page I need to write code that will save that data to a database.
But how would this work and what must I do on my Test.aspx page?
I wrote some code in my Page Load Event that sends me an email on Page Load to see if they actually hit the page and it does not seem like they are even?
I have created a database in VB2008.NET using SQL 2008.
My problem is that while I am in the form where I see the the data, I want to retrieve backwards the related data from Owner and Car eg. the owners name and the car model.
Is there any way to do this in a single row?
I basically need to hold a lot of data - the structure is that of a five dimensional array holding integers.What would be the most efficient way of storing this in a file (I was thinking of XML - your opinion?) that would also be quick to extract.
View 3 Replieshow to work multiple bookings into my program. At the minute i have two calendars, one visible (Start date) and one invisible, wich the user can make visible if a repeat booking is required (End date).
How would i work a repeat booking into my SQL Statement, as i only have one BookDate field and one BookDate parameter.
e.g.
Dim BookRoom As New SqlCommand("INSERT INTO bookings ( UserID, RoomID, BookDate, StartTime, EndTime, Reason) " + _
"Values (@UserID, @RoomID, @BookDate, @StartTime, @EndTime, @Reason)")
[Code].....
Im viewing a form with x amount of data on it, i need to take the data from the webform and place it into a textbox.txtbefore.Text = wb.document.GetElementById("xxxx").InnerTextThats as far as i got, its on a web-page. The id is correct but i cant seem to gather itand seeing how vb.net has a lot of uses for forms it kinda makes it hard to search.
View 1 RepliesI am having trouble retrieving data from a stored procedure that I have set up as a Data Adapter using VB.NET 2005. The Database is SQL Server 2000, and what I am trying to access is a simple Stored Procedure that will validate a users login access. [code] I have a dataset set up as AdjustmentsDataSetspValidateLogin. I am trying to figure out in code how I can address this using a table adapter or how I can capture from a login form I have created the UserID and pass this value to the stored proc to return the current record, if any of the user.I initially setup a Dataset and dragged the dataset onto a form. Then I deleted the data navigator and the toolbar that was created by default so that I could just pass values to the Stored Proc. I also have the table adapter setup to return a table "LoginData" with the two fields Approver & Admin when I pass a userID.But I am having difficulty addressing the table adapter in code and pulling back the data values for the UserID I'm passing to the DataSet.Does anyone have any ideas on how I can call this stored proc and get the data values returned? I'm new to .net programming. [code]
View 1 Repliesi am working on a module in vb 10..i have to retrive data from the database between two dates...i have used the following code but not able to get ny output,,nt even an error
Imports System.Data.OleDb
Public Class Form4
Dim con As OleDbConnection
[Code].....
I'm working on this project and i need to retrieve data from my access database and display it on my vb.net windows application
i tried the code below..but there are still some errors on it..
[Code]....
I am trying to retrieve the telephone number from Active Directory for my script, I found alot of examples online, and I tried to implement what I think should make sense (but since I really don't know vb.net that well, this is problematic). Below is the piece of
... ''''Get Phone Number from Active Directory using employee ID retrieved from the logged in user Dim dirEntry, de As DirectoryEntry Dim dirSearcher As DirectorySearcher Dim sr As SearchResult dirEntry = New
[code]....