.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

How to do with MySQL RO Project and MSSQL RO project in the same solution

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

Dear all,

Now I have two projects, one is windows form and the other is RO project of DataSet with dataadapters and SQL of MySQL DB.

Now I need to make another set of DataSet with dataadapters and SQL of MSSQL DB.

What is the best way to create another RO project with only amending SQL? Is it possible?? How can I amend the windows form project by switching to use which MySQL or MSSQL RO Project??




View Complete Post


More Related Resource Links

Solution/project structure

  

Hello, I am working in a aspx web application that must be built in several separate "modules" with different functionality which will be partly developed by different teams.

However, I need the completed app to reside in ONE virtual directory. There will be a single startup page. I need session state to be preserved across pages in different modules.

I structured it as one solution with different Web Projects and one class library project with common functionalities.

Questions:

1) is this the right approach to do this? Or which one would be better?

2) each time I add a new web project to the solution, a new web.config gets created. What do I do and where do I put them?

VS 2010 + framework 4.0 + TFS

Regarding TFS and source control, I have a single Team project, the solution and web projects are inside it.

 

Thanks!


Installed Visual Studio 2005 on new laptop - can't open C# web services project solution.

  
Installed Visual Studio 2005 on new laptop - can't open C# web services project solution - get the 'project not supported by this installation' error. Tried re-installing to no avail. Have run various flavors of devenv as recommended in various posts. Still the same message. I can open the solution fine on my old laptop.    Update: We re-installed service pack 1 for VS and the problem was resolved.

host and consume wcf rest service in web project in single solution

  
I have  create a solution which have multiple class library project and a web application Like Web(UI),BL,DAL etc. I have also add a WCF REST starter kit Collection project in the same Solution.WCF Rest API is working fine if I host it on IIS but i want to consume this in my web project without using IIS. Is this possible? if yes then what will be the URI  for my WCF Rest services? Add service reference is also not working because WSDL is disable in rest.

convert 2003 project to vistudio 2005 get solution is unavailable

  
I have  three  folders , which original is build by vistual 2003 , recent ly  I install vistuall 2005 on Win 7 and succesful covert one  folder from vistual 2003 t0 2005 ( I forget how , I am new on win 7) , when I deat with my second folder I always get Test2( unviable) under the Solution Exporer ( vistual 2005)  But I can access this folder  by brows ( when I try http://localhost/test2/) I get all the files under this folder , why I can see them on my vistual studio 2005 ???

VS2010 Deploying Database Project - Error: Cannot create file [...]MSSQL10.MSSQLSERVER\MSSQL\DATA\m

  
I had SQL Express from a previous installation of VS2010. I uninstalled All SQL and VS2010 and re-installed VS2010 (without Express) and then re-installed SQL Server 2008 Developer Edition. Now when I try to deploy a database project I am receiving the following error:     Creating EDDY.Cheetah.Database.Server... ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 5170, Level 16, State 1, Line 1 Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf' because it already exists. Change the file path or the file name, and retry the operation. ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 1802, Level 16, State 4, Line 1 CREATE

Reading in values in text file in a project solution to an array

  

Hi,

I have a tab delimited text file that has 6 columns (all integers) and 500 rows (and no column headings) called ProjectData.txt that I have added to my Windows Form Application (c#) (by added I mean I have it in my project solution). 

I have declared an array in my code called ProjectDataArray which has dimensions [500, 6].

I wish to load each column of each row into the array.

All the code I have seen shows how to do this for text files that are not included in the project solution. 

Is this easy to do?


Application_Start event stops happening when another project is added to the solution

  

I'm having something unusual happening with a Web Service created using Visual Studio 2008.  Basically, the Application_Start event stops getting called when I add another project to the solution.  Here's what I'm doing (note that I'm using the ASP.NET Development Server):

1. Create a new Web Service project.
2. Add a new WebService class.
3. Add Global.asax.
4. Add a single line "System.Diagnostics.Debugger.Break();" to Application_Start in Global.asax.
5. Change Web.Config compilation debug="true" (actually VS did it for me when I first try to run it).
6. Run the solution.  Result: Visual Studio breaks in the Application_Start event.
7. Manually stop the ASP.NET Development Server.
8. Re-run the solution.  Result: Visual Studio breaks in the Application_Start event.

All good so far.  However, when I continue...

9. Manually stop the ASP.NET Development Server.
10. Add new project (a Windows Class Library) to the solution.  This is NOT set as the startup project (the startup project is still the web service project).  No references are added to either project and no other changes are made to either project.
11. Delete the default Class1.cs that automatically gets added to the class library project.<

Can't change the code in Solution (Project)

  

Hi,

I have problem using Visual Studio.NET 2003. When I open solution made early ago, choose the code of the existing .aspx page, could not change it, because when type nothing happened, no letter, no sign, like the keyboard is "dead" (but it is not, ofcourse). If I type the code in other application, then put it in .aspx.vb code page using copy-paste, everything is ok, can build the solution and it's working.

I appreciate for Your time, any help is welcome.

Thnks,

Katarina


How to: include more project in a SharePoint 2007 Workflow solution in Visual Studio 2008

  
Hello!
I just develop  a little bit complex workflow and I want some objects put into an library (simple c# class project) project  in the solution. It is signed, referenced, but when I debug  it send a "System.IO.FileNotFoundException: Could not load file or assembly ..." How to resolve?
Thanks in advance, bts
bts

Unable to deploy solution,getting "The OutputPath property is not set for project " error

  

Hi Guys,

I am having this configuation issue which I can't seem to resolve. When I am deploying my SP2010 solution to my farm Ii ge thi error mesage when I deploy a solution which contains output dll references.

Error 1 The OutputPath property is not set for project 'XXX.SharePoint2010.KnowledgeBase.Helper.csproj'.  Please check to make sure that you have specified a valid combination of Configuration and Platform for this project.  Configuration='Release'  Platform='AnyCPU'.  This error may also appear if some other project is trying to follow a project-to-project reference to this project, this project has been unloaded or is not included in the solution, and the referencing project does not build using the same or an equivalent Configuration or Platform. KnowledgeBaseSite

Any help would be appreciated.

Cheers

Pieter


SharePoint Developer

Referencing a project in the same solution from script tasks

  

Hello,

I have a solution with an SSIS project and now I added a class library project and I want to reference it from the script tasks of the SSIS project. Is there any way to do that without creating a shared assembly?

Thanks.

 


XAML intellisence not working for one VS2010 project in Solution

  

I've got a WPF solution with 5 projects in it. For some reason...the XAML intellisense quit working and it's driving me nuts. All other intellisense is working just fine (C# for code behinds). I am "not" using any network shares as I saw on other forum posts that this might be the problem. Again...this solution was working fine before. Problem exists where ever I take it XP, W7....Please help!!!

Thanks


Paul Reed

No dim as database for Access 2010 project with MSSQL 2008 r2 developer

  

I am trying to populate some tables in a MSSQL 2008 database using a VBA module an Access project. I can create Access forms that update the MSSQL tables, and access the MSSQL tables directly.

I used similar code with earlier Access and MSSQL. When I try to dimension an object as database,  no such method is in the list, and an error occurs when I try to run. I can't create a recordset until I have a data object.

The MSSQL is 64 bit, and the Access 2010 is 32 bit.

 


use service reference in other project in the same solution

  

Hi!

i have a windows service that sends information to another project(let's call it Project A) that hosts a wcf service.  the windows service business rules are in another project(project B) within the same solution. Do i have to add the service reference(to wcf service) in both projects (windows service and project B) in order to communicate with project A?

 

thank you in advance!

Marie

 


Solution (sln) & Project Files rptproj in SQL2008

  

Hi,

I'm working on a Team of 12 report developers and we have a single Solution defined by our IT Manager. we all have a local copy of this Solution (lets call it Reports2008), which we are developing our own reports into. 

It's structured is roughly defined below,

Reports2008

       Department 1

             Shared Data Sources

             Shared DataSets

             Reports

       Department 2

             Shared Data Sources

             Shared DataSets

             Reports

       Department 3 

             Shared Data Sources

             Shared DataSets

             Reports

       Department 1 

             Shared Data Sources

             Shared DataSets

             Reports

 

The project file is not bound to source control, but the solution contains source control binding in

  
This may be more of a SQL Server Management Studio question, but I couldn't find a SSMS forum...

I've got a database solution that contains several projects.  They're just to keep track of changes to stored procedures, triggers, views, etc in a few databases I maintain.  There is a problem with two of the projects though.  No matter what I do, I can't seem to get them bound to source control right.  When I open the solution, I get:

The project file is not bound to source control, but the solution contains source control binding information for it.

With two options, use solution binding and remove solution binding.  If I keep the solution binding, everything works fine.  But it's really annoying to have to deal with every time I open the solution.  If I remove the solution binding, the projects are now unbound again.  If I try to fix them (using the change source control or Add Selected Projects to Source Control options under the File->source control menu), I just end up in the same situation.  I've even tried deleting the projects and re-creating them from scratch, then re-adding them to VSS.  If I open the solution files in a text editor I can see the SCC tags in every project, but these two.  Since I can't manually add the tags, and Management Studio itself only seems to want to bind them the wrong way, I'

How to do with Mysql and MSSQL in the same solution

  

Dear all,

Now I have two projects, one is windows form and the other is RO project of DataSet with dataadapters and SQL of MySQL DB.

Now I need to make another set of DataSet with dataadapters and SQL of MSSQL DB.

What is the best way to create another RO project with only amending SQL? Is it possible?? How can I amend the windows form project by switching to use which MySQL or MSSQL RO Project??


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend