Create A Website With C# And Microsoft Acess As A Database?
Feb 9, 2010[Code]....
I still a beginner and i want to create a website asp.net with c# and microsoft acess as a database ,the problem that i can't insert new lines in my database
[Code]....
I still a beginner and i want to create a website asp.net with c# and microsoft acess as a database ,the problem that i can't insert new lines in my database
I am writing an application on my PC to insert record on a Microsoft Access database on another pc that has static ip address remotely.I can ping the remote address of the PC that I want to access without problems. The access database is in the folder c:inetpubwwwrootdb.mdb.
I have the code below but when I run it I am getting the following error:
error on ther server the object model couldnšt be found
OleDbException 0x800a2011
<%@ LANGUAGE = VB Debug="true" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Net.Mail" %>
<%@ Import Namespace= "System.Web.UI.WebControls.Menu" %>
<%@ Import Namespace="System.Data" %>
<script Runat="Server" language="VB">
public sub button_click(s as object,e as EventArgs)
dim ssql as string
dim strconn,objconn,rs,dbcomm
Dim ds As New DataSet
Dim da As OleDbDataAdapter = New OleDbDataAdapter
objconn=new oledbconnection("Provider=MS Remote; Remote Server=http://196.45.161.123; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\db.mdb;Persist Security Info=False")
objconn.open ()
dbcomm=New Oledbcommand("employee",objconn)
dbcomm.commandtext="insert into employee values ('mostafa',7,'tanzania')"
dbcomm.Connection = objconn
dbcomm.ExecuteNonQuery()
objconn.close ()
end sub
</script>
<html>
<Head>
</HEAD>
<BODY BGCOLOR="White" TOPMARGIN="10" LEFTMARGIN="10">
<form Runat="Server">
<asp:textbox id="t1" Runat="Server" text="type" />
<asp:button id="b1" Runat="Server" onclick="button_click" text="clickme" />
</form>
</BODY>
</HTML>
actually I have deployed the website .and some user is able to acess the same site from one location but some user is not able to acess the same site from other location .there is time out problem users get access and after some time there is time out ,but it is working fine in other locationsall the system configuration setting is the same .
View 2 Replieswrite code that can send bulk emails from an access database using asp.net/vb? I only need to send about 200 emails per day. also the email must be addressed to that person, eg. if the email address is kylesmith@gmail.com then the email should read Dear Kyle as well as the TO field should state kylesmith@gmail.com
View 22 RepliesI am having a problem with webforms in my website which i am developing it into VS2005. the changes like inserting new table on existing web form of website not getting displayed on webform when i debug it.
View 3 RepliesHow to create Multi language website in aspx where database store translations? I search many articles but there is not uniq solution.
View 3 RepliesI'm trying to create a website that allows the user to type something up and it gets stored into a database. I'm looking to give the user some control as to different formatting such as for decorations, weight, style, etc... Also I want to keep the spaceing the user inputs into the text area as well (if the user presses enter to create a blank line). Is there a control out there that would let me do something.
Pretty much what I'm thinking of is something like what you would use to create a thread on a forum (Like what I'm using as I type this), where I get to choose the font style and such.
I am coding in ASP.NET C#. I have Microsoft Dynamics GP hosted at a server and my database hosted at another server. I would like the GP database take value from some table there and synchronise it with my database. Which is the best alternative? Data transmission Service(DTS)?
View 1 RepliesI'm using a ListView to populate products data from LinQDataSource and using a DataPager for paging.
When I choose a product from page 2 and put it into cart then I go to cart, if I click on "Continue shopping" I want to back the page 2 contain product I've just selected before.
How can I do that?
Here is my code snipet:
ASPX File
[Code]....
CS File
[Code]....
there is a tutorial about ASP.Net Application but i am using ASP.Net Web Site so i don't have unload edit name feature like stated here [URL]
View 1 Repliesam absolutely clueless on this. I've been told that the web application I'm building (.net 4 / mvc3 / c# / sql server) will be "sitting behind UAG so we can silently authenticate". I've no idea now how to approach the authentication part of the build in my dev environment. Should I just use "windows authentication"? Will that be the required setting when the application goes live? How do I test the authentication?The people asking me to do this are currently just getting started with UAG too do so any help, pointers, .To put the situation in context, this application will be accessible via the company network internally, and also via the web externally (via UAG portal, of course). The company is on Active Directory, and all I actually need to "pull through" to the application to get further people entity data is the AD username.
View 1 RepliesWe have a server, in that we have lots of word files, all these files are belonging to several authors.Now we want to share these word files from the server to the author to do revision. And update back the revision file to the server. providing me sample pages to do this using ASP.net. This is similar like Microsoft Office Live.
View 3 RepliesI need to create a template for a Report to show the appointment letter. When teachers are approved student choices, It will auto generate a report gathering all the necessary information.
I know how to create a basic report using the ms report wizard but what if I want to redesign it, because I want each page per students.
is there any way to create a site map automaticly by using microsoft visual studio 2008
if it just create an index for static pages it is enough
dont need dynamic pages
I wanto to create matrix report dynamically using Microsoft.Office.Interop.Excel.dll so that i can create pivot table and Report from this, how i can create these kind of repots where in user will drag and drop the details and it will create reports.
View 2 RepliesMy name is Christian, I developed a web application in VB.NET 2005 that calls a Microsoft Word Application, it works fine in my develop's machine but when I put all of the code in production's server I received the following error:System Error: Cannot create activex component. following I put the code. If somebody knows how to solve this,
Dim oWord As Microsoft.Office.Interop.Word.ApplicationDim oDoc
As Microsoft.Office.Interop.Word.DocumentDim oTable
As Microsoft.Office.Interop.Word.TableDim oPara0
As Microsoft.Office.Interop.Word.ParagraphDim oPara1
As Microsoft.Office.Interop.Word.ParagraphDim oPara2
As Microsoft.Office.Interop.Word.ParagraphDim oPara3
As Microsoft.Office.Interop.Word.Paragraph, oPara4
As Microsoft.Office.Interop.Word.Paragraph
oWord = CreateObject("Word.Application")
oWord.Visible = True
oDoc = oWord.Documents.Add
oPara0 = oDoc.Content.Paragraphs.Add
oPara0.Range.Text = "Hola"
oPara0.Range.InsertParagraphAfter()
i need to rename microsoft access database in APP_Data folder using ASP.Net - VB.Net
View 1 RepliesI'm currently creating a web application.
I had Administrator, Teachers, Students roles.
I wanting to create a function where Administrator able to change username of the users that login to my web application or delete that user.
The users are created from asp.net web site administrator tools (security tab)..
I have a asp.net website in the IIS which is available on internet as www.xyz.com now I have been asked to prepare another website which will be accessed via www.xyz.com/abc.
For this, do I need to create a virtual directory under the website folder XYZ in IIS? or is there any other way to achieve this.
I am creating a web site through command line. I am able to create a web site with single host address. But i want multiple host address for a website. this is the command I am using iisweb /create D:Test Test.com /d [URL]
View 6 RepliesFor some reason neither SQL managment studio nor import and export wizard works on my friends network due to some security policy
i asked a question about OSQL two days ago and StackOverflow guys told me it is going to be obselete and that i should use SQLCMD instead.
to cut long things short my question is very precise:
using SQLCMD..1-need to import and export command from AND to MDB/MDF
2-need attach / detach commands
I have an error when visiting my page
The Microsoft Jet database engine cannot open the file 'E:""""""""datab.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
We have developed apllication in Microsoft VS 2008 and when we opening this same application with Microsoft VS 2010. Then it's asking to convert.
So can anybody tell me what it is converting exactly. Means it's open application in Microsoft VS 2010 and running properly also. But i am understanding whats happning while converting.
I'am developing a commercial website using visual studio.net 2005 and sql server 2005, where i have to import contacts from microsoft outlook 2003 into my web application, so i have searched a code, but it is a console application where it displays the contacts in the command prompt, but i have to retrieve it to my database application in an asp.net application becoz im working in asp.net2.0
the code which i have used to retrive the contacts from the outlook as a console application is follows,
Imports System.Reflection
Imports Outlook
Module Module1
Sub Main()
Dim oApp As New Outlook.ApplicationClass
oApp.AnswerWizard.ClearFileList()
oApp.ActiveWindow()
Dim oContacts As Outlook.MAPIFolder = DirectCast(oApp.Application.ActiveExplorer().Session.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderContacts), Outlook.MAPIFolder)
For Each oContact As Outlook.ContactItem In oContacts.Items
Dim FN As String = oContact.FirstName
Dim MN As String = oContact.MobileTelephoneNumber
Console.WriteLine(FN)
Console.WriteLine(MN)
Next
Console.ReadLine()
I'm looking for a way to parse excel into Asp.Net, the problem I'm experiencing same as in[ URL]
I've searched all web, but no1 seems to have an answer
here's the error
The Microsoft Jet database engine could not find the object 'Cities'. Make sure the object exists and that you spell its name and the path name correctly.
the code is the exact same as in [URL]