|
if some clients accessing s/w with MYSQL as data base and some with oracle.(interface same but backend storage is different).
how do it in asp.net?
what are the methods i must use it to implement above concept?
thank you
vijaya
|
|
|
|
|
You need to create different dataaccess layers to do this. Because MySQL is conneted with ODBC and Oracle using OracleClient. So you need to create seperate DAL and call the appropriate one.
|
|
|
|
|
You may use like that.
Classes and Interface
<br />
interface IDatabase{<br />
public int Execute(String sqlStmt);<br />
}<br />
<br />
public class MySQLDatabase() : IDatabase{<br />
public int Execute(String sqlStmt){<br />
}<br />
}<br />
<br />
public class OracleDatabase() : IDatabase{<br />
public int Execute(String sqlStmt){<br />
}<br />
}<br />
<br />
public class DatabaseProxy(){<br />
IDatabase iDb;<br />
<br />
DatabaseProxy(){<br />
if(config.ReadDbSetting() == "1")<br />
iDb = new MySQLDatabase();<br />
else<br />
iDb = new OracleDatabase();<br />
}<br />
<br />
public static int Execute(String sqlStmt){<br />
return iDb.Execute(sqlStmt);<br />
}<br />
<br />
}<br />
ASP.NET Code-behind
<br />
DatabaseProxy.Execute("Statemet");<br />
P.S: you may need to change some syntax since I typed it just like that..
I would like to suggest you to check the sourcecode of this opensouce multi-database forums "http://dnfbb.sourceforge.net/"
|
|
|
|
|
If he's using .NET 2, then this is unnecessary. .NET 2 provides a better abstraction layer which can remove a lot of these issues. Take a look at things like the DbConnection, DbCommand classes to see what I mean.
|
|
|
|
|
Excellent. You got 5 from me. But do you have any examples ?
|
|
|
|
|
This might get you started:
DbProviderFactory factory = DbProviderFactories.GetFactory("MySample.Oracle");
DbConnection conn = factory.CreateConnection();
conn.ConnectionString = "...";
conn.Open();
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM MyTable";
DbDataReader rdr = cmd.ExecuteReader(); and so on...
|
|
|
|
|
please help me..
how to show a pop message when wrong button is clicked.
harika
|
|
|
|
|
Window.Open(filename) ??
|
|
|
|
|
javascript!! wat else
check syntax for alert and confirm and all!!
Choose one as per ur requirement!!!
I was born dumb!!
Programming made me laugh !!!
--sid--
|
|
|
|
|
Hi,
I am using gridview in one of my pages, and have set the option AutoGenerateDeleteButton="true"
The delete button is coming on the left hand side, however i want it on the right most column of the gridview.
How can we do that.?
Deepak Surana
|
|
|
|
|
Click the Header of the Delete Column. This would selected that column. Now click the Move (Right/Left) option in the Smart Tag. The Smart Tag can be toggled using the arrow in the top-right conner.
|
|
|
|
|
Thanks Buddy,
But there is no header for the delete, as it is generated by the gridview itself.
Deepak Surana
|
|
|
|
|
Even though it is autogenerated, the Header will be visible without any caption. Click that.
|
|
|
|
|
I tried shifting the next column of the delete option to its left.
But only move right option is available for the column just next to delete.
Deepak Surana
|
|
|
|
|
Hi,
If I set visible =false for an asp Panel while declaring the control in aspx page, when I try to toggle its visibility in a JavaScript function, the object is returned as null. i.e.
document.getElementById('<%=Panle2.ClientID%>') is returning null, if I make its visible as true, then it returns the appropriate object.
Why does this happen. How can this issue be solved.
Regards,
Blumen
|
|
|
|
|
Dont set Server-side "visible" property to False. If you do like that, the Javascript wont be able to find the object.
So, If you wanna hide the panel, just play with CSS Style(eg: display or visibility)
|
|
|
|
|
Thank you, I'll try using CSS.
|
|
|
|
|
blumenhause wrote: If I set visible =false for an asp Panel while declaring the control in aspx page, when I try to toggle its visibility in a JavaScript function, the object is returned as null.
You are right Blumen... ASP.NET will not place that control inside the page if set the Visible property to True. Instead of that use Attributes or Style to hide the control.
|
|
|
|
|
thank you Venkatesh, I'll try your suggestions.
|
|
|
|
|
Hi,
I want to Upload a .resx file to the App_GlobalResource folder.It is uploading the file successfully but aftre uploading the application crashes.If anybody has any clue on this please let me know.
Thanks,
Prajin
|
|
|
|
|
Prajin wrote: I want to Upload a .resx file to the App_GlobalResource folder.
Why you have to upload the .resx files? Just publish the website locally... You would get the binaries. Just upload those binaries which have all the resx files embedded.
|
|
|
|
|
Hi,
My application should provide an option for the user to add a new .resx file dynamiccaly(In runtime) . Suppose the application right now support only english and the customer wants to add spansh later.He will create a .resx file for spanish using a transalator and form my application he should be able to upload it to App_GlobalResource so that from there onwards my application can be displayed in spanish also.This should happen without touching the code
Thanks,
Prajn
|
|
|
|
|
Hi
I am trying to generate a XML file from a SQL Server table's data in a formatted way.
I'm struggling to start.
Please suggest me an example.
I have not failed. I've just found 10,000 ways that won't work. -Thomas A. Edison
Thank u
Chandu
|
|
|
|
|
chand10 wrote: I am trying to generate a XML file from a SQL Server table's data in a formatted way.
select * from tablename for XML auto
This will give you XML output. Get this into a dataset and use dataset's WriteXML method to write it to XML file.
|
|
|
|
|
I am facing strange problems while working in VS.NET, when I try to debug the program by putting a break point on a event method of the button click and than run the ASP.NET application and click that paticular button than instead of running in the debug mode it proceeds normally without giving me chance to press F10 and proceed,it behaves that as if no break point has been inserted.
|
|
|
|