I have an ASP.net security database which is normally ASPNetDB.MDF however I have created the same database structure in MS Access. All works great. However, I need to add a couple of other tables but I can't find how to do that in VWD. I'm pretty sure I was able to when the first database I created was an MDF file but not in MS Access.
View 5 RepliesIs there a way to create dynamic access database, tables and it's columns in c# and export or insert the data in it from excel file in c#?
How can I create the Access database and tables at run time using c#?
I have a form wilh couple of Drop downs and text boxes and a Data Grid View which displays data from Access Table. When I hit add button on the form, I can see the data being added to the Grid View. But when I close the form and open the Access Database File (.mdb), the respective table is empty. The Access Table is not being updated. Second time if I open the form, the Grid View is also empty.I am pasting my code here.
Public Class Home
Shared OleDbConnection As System.Data.OleDb.OleDbConnection
Shared ExpensesDataAdapter As System.Data.OleDb.OleDbDataAdapter [code]....
How do database and tables get created when I am pressing create user wizard in asp.net?
View 1 RepliesHow to create a table which is the combination of different columns in database tables.
I know how to make the var table using single table.
What is I have to combine multiple coolumns and create a table.
My requirement is a gridview which has a datasource which is loading from columns from multiple tables.
I'm working on a new asp.net 4.0 resume web site. I'm starting off with SQL Server Express 2005 and using the standard security and login features given with ASPNETDB.mdf. My site will be hosted on GoDaddy.com.
Quesiton. Should the tables that will contain the information that users will be putting in like resumes, contact information and such go into ASPNETDB.mdf or should it go into a separate database.
Really new to C# & Web developing - but have used the DAL & BLL model from a number of the turorials. Have a situation that I not sure the best way to accomplish. I have an application dealing with courses, books, etc. utilizing an Access Database. All was going well in creating an on-line catalog using Formview and tables to display the db values stored in the Course Table (Course ID the key). User is able to use dropdown list to locate the course - dropdown list showed the Course Nbr & Name, but used the Course ID to get the detail. This issue appeared when they introduced a Prerequisite field in the Course Table. This contains the Course ID of the prerequisite course, but they want to display the Course Nbr and Name in the table field. So today it show 18 (Course ID) and they want B101 Intro to Biology. Hope I have provided enough information of what the code looks like below
Here is the FORMVIEW & TABLEROW
<asp:FormView ID="FVGeeralidades" runat="server" DataKeyNames="ClaveAsignaturas"
DataSourceID="ObjectDataSource1">
<ItemTemplate>
<asp:TableRow ID="TableRow5" runat="server">
<asp:TableCell ID="TableCell11" runat="server" HorizontalAlign="Left" Text="<STRONG>1.6</STRONG> Prerrequisito"
Width="150px"></asp:TableCell>
<asp:TableCell ID="TableCell12" runat="server"></asp:TableCell>
<asp:TableCell ID="PrerrequisitoValue" runat="server" HorizontalAlign="Left">
<%# Eval("AsignaturaPrerrequisito")%>
</asp:TableCell>
Here is also the OBJECT DATA SOURCE
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}"
SelectMethod="GetCourseByCourseID" TypeName="CoursesBLL">
<SelectParameters>
<asp:ControlParameter ControlID="DDLCourse" Name="CourseID" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
I am trying to create a DataReader to return a counted value from an Access Database. It all works if it finds some rows, but falls apart when there is no total.
My code is as follows (highlights);
[Code]....
The error that gets thrown is:
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: BoxesOut
Source Error:
Line 43: if(reader2["BoxesOut"] != System.DBNull.Value)
I have used a microsoft tool before that was allowing me to automatically generate admin web pages from database tables. By admin web pages I mean pages that allow me to do CRUD operations on my tables.
View 1 RepliesI am working on a multi-lingual application Assume the following:
Database has 50 tables and application has to support 5 languages
Which is the best way to design the database:
1. Include a langugae column for each table. Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)
2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.
Which is more efficient out of the above two.
[Code]....
When I am trying to insert some data I am getting error.
Could not find file 'C:WINDOWSsystem32ikcit.mdb'.
Unable to understand Why??
In Visual Web Developer-2010, I have been trying to connect to IBM DB2 Database after installing the DB2 9.7 client (both supports VS2010/.Net4) so that I can use "ADO.NET Entity Data Model", but while clicking "New Connection" I can only see the list of Data Sources and Data Provider only related to MS SQL server. This is totally blocking my work, I am not able to work further since I cannot even establish the connection to my db2 database using this new editor so that I can create the edmx files in the solution for non MSSQL databases. Kindly provide me the solution ASAP, since my further work is blocking due to this.
View 2 Replies[Code]....
and i am receiving error as
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description:An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Iīm learning how to use a web service with flash.
Now I need to connect the web service to my db.
This is what I tried:
Code:
Public Function HelloWorld() As String
Dim orgcon As New OLEDBConnection("Provider=Microsoft.jet.oledb.4.0;data source=c:dataDB.MDB")
Dim OrgDA As New OleDbDataAdapter("select * from organization order by orgname", orgcon)
Dim Orgds As New System.Data.DataSet
OrgDA.Fill(Orgds, "Organization")
Dim hwstring As String
hwstring = orgds.tables(0).rows(0).item(3).tostring
Return hwstring
End Function
The flash just gives me an error that there was an error opening the web service. For some reason I canīt debug it in vwd.
I am trying to create Web Application using ASP.Net via Visual Studio 2010. The Database that I use is Access, with connection Method OleDb
When using the query "Update" or "Delete", the programs shows no errors, but the data in Access does not change.
While for query "Select" and "Insert", the data is displayed and inserted successfully.
The Following code is the sample query "Delete" that I used..
Code:
Imports System.Data.OleDb
Partial Class frmTEst
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code] ....
Previously I tried a direct query using AccessDataSource, but the result just the same, Update and Delete can't be done. But the Select and Insert can be executed successfully.
Is there any problem with my Access configuration or whether the problem is in the coding itself..?
I have created a script with pulish to provider button on VS 2010 and I need to deploy my database to my sql server.How can I do that ?
I cannot create a copy of my database on sql server with sql script file.
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
[Code]....
I am able to create database through script generated by SQL Server 2008 but unable to create tables from generated script. Please indicate if any step is missing.
************* Code *******************
[Code]....
****************** Contents of text file appended below ***********************
[Code]....
Using Visual Web Developer 2008 Express with what I'm assuming is Sql 2008 Express. Using SqlDataSource, when I try to configure a data source, I'm able to input a server name: (local)sqlexpress and the "Test Connection" button shows that it was successful. However, if I type in a new database table name and VWD 2008 asks if I would like to create it, I keep getting the message: "OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT." No idea what that means or how to fix it. I can't open theDatabase Explorer View.
View 2 RepliesI am unable to create dynamic menu from database. I have made two tables for this work.First table is Menu which stores menu id and its relevant name.
MId Text
------------
1 File
2 Edit
3 View
..
..
Second table is subMenu which stores submenus which will be linked to the menu table with menu id.
SId Text MID
-------------------
1 New 1
2 Open 1
3 Save 1
4 Cut 2
5 Copy 2
the menu should be created dynamically from the database, each menu should be displayed in single row
when we click on a menu the submenus are displayed in rows that in expand & contrast form
how to design & develope this page
i am facing some problem in update, edit and even create new data into my access database using data detail view. i am using microsoft visual web developer 2008, i can do the same when sql server database were to tore the data. but when i try to do the same using access database, an application error. may i know whats going wrong? and how to solve this problem?
View 7 RepliesCan I create an ADO.NET Entity Data Model for a MySQL database using Visual Web Express 2010? If yes, are there any documentation or tutorials?
View 1 RepliesI have a store procedure as below:
using(DataStoreContext ctx = new DataStoreContext())
{
int value = ctx.RequestProc(filename, message).First().Result;
}
I would like to create Asynchronus access to database to execute this above procedure, where I am using LinqToSql.
How can i create dbml file for MS Access or suggest me any other method so that i can use LINQ with MS Access database.
View 4 RepliesI'm new here and really, new to asp.net except the very basic things.
I am trying to create a very simple (I think simple) web form with five textboxes and three dropdown boxes and one submit button. The user enters information in the textbox fields and selects from the dropdown lists (which are populated from the database), hits enter and the database runs the query and returns information on a separate page (or can it return to the same page via panels?) The original page returned to a separate page using server transfer.
I have this page already existing in asp but feel that it would be much better served in asp.net.
Can someone point me to a post where I would guess this has been answered many times?
How do I submit the new data to the database, update the records and return the query?