I am planning to start learning asp.net mvc. And also I want to learn Microsoft's Data Access application block. But I dont want to waste time in MDAC block if theres a better option to go for, or if MVC provides any good feature than MDAC. As I have heard MVC architecture automatically generates code.
View 2 RepliesWe 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 have a problem and I could not solve it. Hope you can write a sample code for me. I have a Microsoft Access database, and in asp.net website, i draw a grid view on the design page. I also configure the source data access. It works, but display all the data in the database. i want to display all the data which is related to John. sql = "select username, customer_name, phone from db where username = John" how do i configure the data grid view?
View 3 RepliesI have 4 file uploader in my form to upload 4 images in the DB for each article submitted. My issue when I want update/edit my article with some new pictures and I want delete or update the old pictures with the replacement with the new one.
How I can implement it? I am using ASP.NET based on VB.NOT .... NOT C#
It looks that the old SqlHelper class from the Microsoft Enterprise Library has been mostly replaced by the Database class which is included in the new Enterprise Library version 5.
I have a very simple and trivial example:
using Microsoft.ApplicationBlocks.Data;
private void PopulateCheckBoxGroup()
{
const string strConnTxt = "Server=(local);Database=DataBindTests;Integrated Security=True;";
const string strlSql = "select Technology from PreferredTechnology where ParentId = 1";
CheckBoxList1.DataSource = SqlHelper.ExecuteReader(strConnTxt, CommandType.Text, strlSql);
CheckBoxList1.DataTextField = "Technology";
CheckBoxList1.DataBind();
}
I want to create a search button and put the results in a data grid.
Select Company_Name,Contact_Name,Contact_Number From ClientSystem WHERE Company_Name=txtSearch.Text
I have a code to link to sql can anyone give me the same code for microsoft access....
try
{
int videoID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection conn = new SqlConnection("server=WEBDESIGN-PC;database=Credentials;uid=sa;pwd=Azeem;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM videopath WHERE videoID=" + videoID, conn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
FlashVideo1.VideoURL = Convert.ToString(dtr["Filepath"]);
Label1.Text = Convert.ToString(dtr["Filename"]);
conn.Close();
}
catch (Exception ex)
{
Label1.Text = Convert.ToString(ex);
}
finally
{
}
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>
how many users can open a connection to Microsoft Access database simultaneously ?I am using asp.net 4.0 to write my application.
<add name="E_ShopAccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|
eport.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
How can I move records from one table to another in Microsoft Access?. I would like to be using an sql.
View 4 RepliesCurrently i am developing ASP.NET AJAX server control in which i am using jquery code. Inside jquery event, i wish to access the microsoft ajax object. If it is not clear, find the below code example,
Type.registerNamespace("MyControls");
i need to rename microsoft access database in APP_Data folder using ASP.Net - VB.Net
View 1 RepliesI am developing a simple web app on Visual Studio 2010 on Vista, using Local IIS. When I ran I got this error message:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
For this app, I did the following.
-- Add Reference of Microsoft Excel 12.0 Object Library from WebSite option on Visual Studio 2010.
-- Here is the code: (Error occured @ Dim xii2 As New Excel.application). The identical code and idential Add Reference were fine when developed under window .net asp
application, not web app.
Imports Microsoft.Office.Interop
Partial Class _Default
Inherits System.Web.UI.Page
[Code]....
For 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 want to know how do I use outer joiin with microsoft visual web developer 2008.
I am using an access database. There are two table in the table t1 and t2.
I want to list the items in both table that have the same id.
my query is as follows:
select t1.id, t1.date, t1.count, t2.date, t2.count from t1 outer join t2 on t1.id=t2.id;
I am completely depressed ... I have been trying this for more than 200hrs.
am 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 RepliesCoding Platform: ASP.NET 4.0 with C#
Building a website using ASP.NET membership(forms authentication) and options to link Open IDs to it. I would like to have Microsoft Live as an OpenID option in this website. Well I have not seen Login using Windows Live ID except at forums.asp.net, but then both are Microsoft websites.
Today, I stumbled upon a website that seems to be using Microsoft Live Connect or whatever. I tried searching for it but I couldn't get any documentation regarding an API for Live Connect.
Here's the URL: http://messengerconnectidentity.mslivelabs.com/
I just installed VS 2005 on a Win Server 2003 box, and went to create a new web project. I noticed right away that the "Web" project was missing and found that the "Microsoft Web Application Projects" did not install on the server.I checked on a couple other boxes that have VS 2005 installed on them, and they all had "Microsoft Web Application Projects" installed. Does this not install on a Win 2003 box? How do I install this?
View 1 RepliesI have been using using Microsoft.Office.Interop.Word in my webserver (yes, i know it is not recommended). When I ran it on my machine, it runs fine, but when running on the server I get a timeout on the following line:Documents.Open //when trying to open the file.Is there something I'm missing? Is there a better way to edit a Word document within web servers/websites? (I can't create a new one using string builder or outputting into file; I need to edit an existing one that sits on the server.)
View 1 RepliesIam using the DBconnection object through out my applicationI use the same as a singleton objectWhen more operations are performed on the single objectit throws an error ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.But it occurs only some timesHow to solve this?Can any property can be set to avoid this type of error.Or can i overload and write any method to avoid thisTo Identify the same i wrote some Poc and tried alsoLike opening the connection object and looping through 1000 times and creating a command object for the connection and running a query.Some times iam getting the exception and some times its running
View 7 RepliesI have just deployed a MVC web application onto our intranet. The application is hosted on a Win 2003 R2 SP1 server and running on IIS 6.0. Everything works fine within the application. But our intranet uses the windows Indexing service for providing search functionality on our intranet website.The search brings up related links to files within the MVC web application. But the problem is the links don't work as MVC urls do not point to absolute files.Is there a way to resolve this?
View 6 RepliesI'm trying to configure the logging settings to log all events in a database and event viewer but email only errors and warnings. Database and Event Viewer part works fine except that I'm not getting any email for errors.
Note: There isn't any problem with smtp settings because I get event's emails if I add the listener to "General" and "All events" in category sources.
Here is my config: (I'm using Microsoft.Practices.EnterpriseLibrary.Logging 3.1.0.0)
<loggingConfiguration name="Logging Application Block" tracingEnabled="true" defaultCategory="General" logWarningsWhenNoCategoriesMatch="false">
<listeners>
<add databaseInstanceName="LOGGING_DB" writeLogStoredProcName="WriteLog"
[Code]....
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()
The problem is in the crv.js, at
Sys.Application.notifyScriptLoaded();
when I try to open a report is shows Microsoft JScript runtime error: 'Sys.Application' is null or not an object
If I click Ignore or Continue, it's show the report properly, but when I deploy it to the development server it does not work.
At this time I am trying to open a simple report with the date and page number.
there is a CrystalReportViewer at the Default.aspx page.
the code is
[Code]....
i am new to asp.net programming i am trying to connect asp.net web application with ms access 2007 database. i have taken with two text boxes and when i enter some data in it and press submit button the data must load in access db i created with same fields.
my code is :
[code]....
Syntax error in string in query expression what is the correct way of inserting data into access db and what is the Syntax error in string in query expression.