|
You can merge your databases into one, so long as none of the table names clash.
An MDF file IS an access database, isn't it ? Or is that MDB ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
An MDB is Access; MDF is for SQL Server (or MSDE). Thanks for the tip! 
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Hey Roger, I didn't realise it was you. Yeah, there's no reason not to merge databases, I did the same thing, I developed a site with two DBs, saw that my ISP charged extra for the second one, so I just merged them.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
They have a bunch of common stuff in them, folders it looks like, each containing a bunch of items like stored procedures, but if there is no overlap I should be able to fix up the code to adjust the name of the DB being referenced to look in the same place for everything. Is there a tool to merge the DBs, or do I just drag and drop stuff?
I just noticed that all the ASPNETDB items start with aspnet_ so it should be easy to keep them separate. 
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Since you have to pay extra amount per db, it is better to ASPNETDB into CLUB database. There won't be any clash between the two DBs as the objects in the ASPNETDB are prefixed with aspnet_.
The ASPNETDB is basicall used for user and role access management. Therefore change connection string details for aspnetdb to CLUB database in the web.config after merging.
|
|
|
|
|
This is interesting; there are no references anywhere to the ASPNETDB in web.config, nor any other file in the solution, yet it works! I also connected to the local SQL Server Express DB with the Management Console and found all the tables from the club database, but none of the data from the ASPNETDB. Maybe I don't need to change anything. How do I do the merge operation?
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
You mean that you also found tables with prefix 'aspnet_' in CLUB database?. In that case the ASPNETDB is not used for anything by your application.
|
|
|
|
|
No, I mean that, using the SQL Server Management Console, I find no tables anywhere named with the aspnet_ prefix. All of the tables from the Club DB are listed, but none from the ASPNETDB. According to the documentation that came with the Club Starter Kit, the ASPNETDB is created automatically when I create a user. That I've done, and it works, so there ought to be some hint of this DB in the Management Console view. I think...
I do see an option in the ASP.Net Configuration Tool to let me select where and how I store user information, but I haven't used that yet; I just used the default for creating the Administrator user.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
If there is no references anywhere to the ASPNETDB in web.config, it will be stored in the machine.config file. The machine.config file will be available in the following path C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG.
|
|
|
|
|
Thanks!
I'm thinking I should do all the configurations on the live site - adding users and roles and such - and just add the Club DB in the database registration tool for the site. Maybe the ASPNETDB stuff will be taken care of on the hosting service system. If it's all being stored in my local machine.config file, it's a waste of time for me to enter it now, except for testing.
I'm also thinking it's way past my bedtime, and I should continue this tomorrow night. THanks for your help! I'll be back...
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
|
No need to write query for each template field.
Just mention the DataSource in the <asp:GridView> tag and define the DataSource seperately..
U can assign the respective column value to each template field using the following method.
<asp:TemplateField HeaderText="Status">
<ItemTemplate>
<asp:Label ID="lblStatus" runat="server" Text=<%# Eval("Column name") %> />
</ItemTemplate>
</asp:TemplateField>
U can also specify the DataSource in cs file as following if u use datatable/dataset as datasource.
Gridviewname.DataSource= DataTablename/DataSetName;
Gridviewname.DataBind();
Yazhini
|
|
|
|
|
I am in need of generate the XML file using XML schema with VB.net.
(how to fill the valves from database to this schema and finally how to generate Xml file form sample.xsd file
I mean My sample.xsd file looks like this
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="ProcessResults">
<xs:complexType>
<xs:sequence>
<xs:element name="KASAAcctID">
<xs:complexType>
<xs:sequence>
</xs:sequence>
</xs:complexType>
</xs:element>
<!--starts Results Tags-->
<xs:element name="Results">
<xs:complexType>
<xs:sequence >
<!--starts Candidate Tag Tags-->
<xs:element name="Candidate">
<xs:complexType>
<xs:sequence>
<xs:element name="FirstName" type="xs:string" />
<xs:element name="LastName" type="xs:int" />
<xs:element name="Uid" type="xs:int" />
<!--starts Demorgraphics Tag Tags-->
<xs:element name="Demorgraphics">
<xs:complexType>
<xs:sequence>
<xs:element name="Race" type="xs:string" />
<xs:element name="Gender" type="xs:int" />
<xs:element name="BirthMonth" type="xs:int" />
<xs:element name="BirthDay" type="xs:int" />
<xs:element name="BirthYear" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--Ends Demorgraphics Tag Tags-->
<xs:element name="DollarGeneralLocation" type="xs:int" />
<!--starts Responses Tag Tags-->
<xs:element name="Responses">
<xs:complexType>
<xs:sequence>
<xs:element name="Response" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--Ends Responses Tag Tags-->
</xs:sequence>
</xs:complexType>
</xs:element>
<!--Ends Candiadte Tag Tags-->
</xs:sequence>
</xs:complexType>
</xs:element>
<!--Ends Result Tag Tags-->
</xs:sequence>
</xs:complexType>
</xs:element>
<!--Ends ProcessResults Tag Tags-->
</xs:schema>
Raghvendra
|
|
|
|
|
I believe there are tools that can create XML that matches, the thing is, a schema matches more than one format, some groups of elements can have a variety of numbers of instances. Also, a schema doesn't really give you enough info to create 100% compliant XML, just a format.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Hi, thanks for looking
Im having a problem with my dataset
I have an Orders table and a details table
I want to save the total of the order in the orders table
My dataset has the same exact structure as my db tables
Orders:
OrderID
Total
Details:
DetailID
OrderID
ProductID
Price
When i try to save (using tableadaptermanager) im having problems
At first, i would get an error saying "The column mapping from SourceColumn 'Total' failed because the DataColumn 'Total' is a computed column.", So i removed the expression column before saving
But now, a 0.00 is being saved in the Total column in the DB
The best solution i see is removing the expression and iterate throug the orders table and recalculate the total manually
Any suggestions?? (Besides doing it manually 
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
HI,
I am new to ASP.NET.Can any one help out to find out best site where i can get resources to Learn ASP.NET.....
Thank you
|
|
|
|
|
|
Part of learning ASP.net is also about having a good understanding of basic web practices (in my opinion) that you can learn at www.w3schools.com but I also use www.asp.net a lot too.
John
|
|
|
|
|
Hi To all,
I got the this error in Following Line.
Line: Dim ExcelApp As New Excel.Application()
Error:Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.
I am Using IIS7.0, ASP.NET 2.0, Vista OS
Please Help me Soon...
|
|
|
|
|
It may be permissions. The account running the application pool may not have permissions to open excel.
BTW, if you are not using a pre-formatted spreadsheet then you don't need to use excel...
I didn't get any requirements for the signature
|
|
|
|
|
Thanks for your Replay.
Now, I am Getting Convertion problem in Convert Character Data to Number.
For Example
My Card No is:40563500012124
After convert the Excel Format Now, I am Getting Like This. 4.05635E+15
If I Convert that Cell, I am getting Perfect Result. Please give me the solution....
Thanks
|
|
|
|
|
I have the following coding but when I build it it gives me following error
public static DataFeedEntities2 entities = new DataFeedEntities2();
var type = (from p in entities.Address select p);
this.GridView2.DataSource = type;
this.GridView2.DataBind;
ERROR:-- Only assignment, call, increment, decrement, and new object expressions can be used as a statement
|
|
|
|
|
I would remove public static from the code
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
No it doesn't solve my problem when I remove public static from my code
|
|
|
|
|
then change DataBind; in DataBind();
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
