Creating VB Application With VS 2010 That Access Data Via The Internet?
Jun 7, 2010
I have been creating a web site over the past year that has been used as an appplication for the company I work for to allow remote and local users to update data. It has been working ok but I want to see if there is a better way to do what I need to.
issue is that the remote sites are all on satellite internet access and the latency and bandwith are hurting us. I have looked at some thrid party options such as Gizmox WebGui but I would like to explore other options.
Is it possible to create a VB application with VS 2010 that would allow users to update data from the remote sites? The only people using the application would be company employees and I can update the program during the evenings if I make any changes during the day. My thoughts are that the amount of internet traffic would be data engages and that would solve the bandwidth issue and therefore mitigate the latency issue somewhat since there would be less traffic.
I have one question here.I created a registration form using asp.net and c#.
when I entered all the fields in that form and hit the register button the data will be inserted in to the database table called xyz table
in that table I have an id field which is a text field in access database consists of guid starting with letter P
when I inserting the data from aspx form...the guid is not inserting into the table.
one of my datarecord in that table with the id field is like this.(.P11111111-1BBB-4444-A9D1-111111111111)
need to insert anoother record in that table that field must be generate with the ID starting with P..its an guid.. the creating guid in the aspx.cs page..??
my application is in Intranet, but in my application mail is trigger to the user, and in that mail (outlook) user getting one link of that application so that he can update "YES"
My problem is that when the user is not in office and he is using Blackberry, at that time intranet link will not work.........
so, any solution that anybody can update through internet.
I am biginner regarding Database in vb.net I have a ms access as db
Field names as follows.. Uname and UPassword, the table is named as accdb and saved as useracc.mdb in 2k3 format... While in my vb.net my main page form has the followings
2 label boxes for Name and Password 2 text boxes namely loginid.text and loginpass.text A button named Login Here are the codes that i am working on
I had a page to update user picture and redirect user to login page, the problem is when a user re-login, the old picture is still available until user refresh the page.
notes: I have already use <%@ output> but not working with master page and also have used Response.Cache.SetCacheability(HttpCacheability.NoCache) and also not working
here is my code:
Protected Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnUpdate.Click 'Updating User Pic fuUserPic.PostedFile.SaveAs(Server.MapPath("~ImagesUserPic" & UserID & ".jpg")) Response.Cache.SetCacheability(HttpCacheability.NoCache) FormsAuthentication.SignOut() FormsAuthentication.RedirectToLoginPage("msg=Please login again") End Sub
what can I do to delete temp internet files to display picture after updating?
I am creating my application in asp.net 3.5. I have to make my Data Access layer, in which I am doing the traditional method of fetching/updating the data. Which is SqlConnection than SQLCommand, than SQLadapter. Will there be any other way I can create my DAL layer easily.
Specification.
My website is small. Approx 7-10 pages. Database has around 80 tables.
What I know:
Linq to SQL - I don't want to use it because I am not fully aware about the LINQ statement and I need to develop the application really fast. [3 days :-( ]. Also, there are 100% chances that the table structure will be altered in future. Enterprise Library: It will take too much time for me to integrate to my application.
I have installed teampulse http://www.telerik.com/team-productivity-tools.aspx community. I add in bindings my domain name with port 9898 like it is with localhost. I can connect through localhost but not throuh the domain
I need to get access to the page index of the gridview so I can correctly get some data from a coresponding array to set the cell's contol properties correctly. Below is what I've got so far. The ExcelObject is a class that houses both the data read in from an sutomer submitted excel file and a matching 2 dimensional array of characteristics that I use in this case to set the CssClass property. My problem is that when I enable paging for the gridview I don't get the proper datasource row index when the data is read by the databinder.eval; what I'm getting is the current row of the gridview being generated.
I have installed google chrome in my computer and mozilla, and when i do start debugging open with the google chrome ..how to change to the open with Internet explorer 8
I have experience with creating web-based database applications for the intranet but not the internet. I want to create a web-based database application to be deployed to the internet.Do I need an ASP.NET (3.5) and SQL Server (2005) host provider?How should I handle user authentication?How should I handle site
I'm still using vs.net 2003, Windows XP and hence IIS vers 6 to serve ASP.net pages on my computer. My problem is that the Application Directory seems to change to the "root folder" when I run my program from an actual internet server. This is borne out by functions like .ApplicationPath, .Physical Application Path, to which I had found a work-around solution. But I still have a problem in that under IIS the assembly.dll file is found in the ApplicationPath/Bin folder, whereas on the uploaded to the internet server is is in the Root/Bin folder. I can live with this problem, and I cant understand why it is so...
I have an intranet site that i set up to windows authentication. It works fine most of the time but some departments wont be able to access the site and will be asked to enter user name and password.I checked their Active Directory account and the only difference i could see was that the organizational unit parameter was different than the rest of the users.
This should be easy enough but I can't seem to get it to work. I have a master list table someone forwarded me a separate email table. So, I wrote a quick and very inefficient block to add the emails to the master list. Everything works fine on the form as datagridview1 shows my changes and states the numbers of rows affected. When I check the actual mdb file though, no changes are ever made.
Currently, on our production IIS web farm, we host about 15 applications in a single App Pool (Default App Pool). There are two websites and about 13 virtual directories.A colleague has recommended that we change our IIS configuration so each application is a separate App Pool (with identical settings).
Is there any drawback or potential issues to doing this?Is it possible that ASP.NET applications could have been built with the requirements that they are all within the same App Pool?
Using data posted by a mobile app to my database (via a web api) I will need to create PDF forms with the data filled in as if a user did that. I never did PDF generation, so some "points" that might decide what to use:
-Forms are pretty much a tabular structure. -Some pages are in portrait, while others in landscape. -Some columns have the data printed vertically. -I will need to put images (saved in database, byte arrays) in some fields.
From what I read so far ITextSharp seems to be a popular choice?
I am new to the whole ajax/jquery/web service scene. I am trying to create a web service to pass back data for a jquery post and currently have two errors. It appears there are examples the web but must in c and looking for something in vb. Below is my web service. See in bold the error descriptions and in red the items visual studio is highlighting.
WordsService.asmx HTML Code: <%@ WebService Language="VB" CodeBehind="~/App_Code/WordsService.vb" Class="WordsService" %> WordsService.vb Code: Imports System.Web Imports System.Web.Services Imports System.Web.Services.Protocols Imports System.Runtime.Remoting.Services Imports System.Collections.Generic Imports System.Data.SqlClient Imports System.Data Imports System.Web.Script.Serialization ' To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. <System.Web.Script.Services.ScriptService()> _ <WebService(Namespace:="[URL] <WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _ <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Public Class WordsService Inherits System.Web.Services.WebService Private _sConn As String = ConfigurationManager.ConnectionStrings("DB").ConnectionString
'1) Type 'ScriptMethod' is not defined.
'2) Value of type '1-dimensional array of String' cannot be converted to '1-dimensional array of 1-dimensional array of String' because 'String' is not derived from '1-dimensional array of String'.
<WebMethod(Description:="Gets the books matching part of a title."), ScriptMethod(ResponseFormat:=ResponseFormat.Json)> _ Public Function GetBooksByTitle(ByVal strTitle As String) As String Dim myConnection As SqlConnection = New SqlConnection(_sConn) Dim objCommand As SqlCommand = New SqlCommand("SELECT * FROM table WHERE field like '%" _ + (strTitle + "&' ORDER BY field;")) Dim dsSearch As DataSet = New DataSet Dim sdaSearch As SqlDataAdapter = New SqlDataAdapter(objCommand) sdaSearch.Fill(dsSearch, "english") myConnection.Close() ' Create a multidimensional jagged array Dim JaggedArray()() As String = New String((dsSearch.Tables(0).Rows.Count) - 1) {} Dim i As Integer = 0 For Each rs As DataRow In dsSearch.Tables(0).Rows JaggedArray(i) = New String() {rs("BookNum").ToString, rs("Title").ToString, rs("Author").ToString} i = (i + 1) Next ' Return JSON data Dim js As JavaScriptSerializer = New JavaScriptSerializer Dim strJSON As String = js.Serialize(JaggedArray) Return strJSON End Function End Class
Here is the article I am currently following for example: How To Create A JSON Web Service In ASP.NET.
