|
I am creating a sample application to access multiple DB (ORACLE, SQLSEVER and EXCEL).
With best of my knowledge i have below two approaches:
1. TO use OLEDB.
Define multiple connection strings in Web.config.
Based on the DBType argument in OpenConnection method, decide which ConnectionString to use.
2. Have two seperate classes, one for OracleClient and one for SQlClient.
Define a factory class (Factory Pattern) and based on the DBType argument value decide which class to use.
I am not certain if there exists any other approach.
And more importantly which approach will be the best.
Please help me to sort out this.
Thanks in advance.
|
|
|
|
|
|
| Try using Linked server in Sql server.... sorry if i wasted your time Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
I have to develop a website on which users can post question and the members can answer the question. Please guide me. How should i proceed ?
|
|
|
|
|
|
|
actually, i want yahoo answers sort of thing or Quick answers section of this website.
MS access will be good for it or should i go for SQL server.
|
|
|
|
|
I would recommend to use Sql Server. MS Access is better if you are distributing your database to some clients with nominal data storage for your windows application.
For websites, always Sql Server is preferable. It is capable to handle large number of concurrency and also lesser probability of data corruption.
|
|
|
|
|
Hi.
I programmed a FileUpload which is already working fine.
But, there is a problem.
I'd like to allow all formats of files , for example, jpg, mpeg, mp3, zip,
exe., but ".exe file format" can't be uploaded.
When I upload a file with .exe format, it shows an error page.
How can I allow all formats containing .exe??
Ah, Actually the .exe format file is an install file.
Thank you.
|
|
|
|
|
Tell me what error page ur getting.
AFAIK, file upload should allow exe to be uploaded. Might be some config settings are blocking in your server to upload exes. 
|
|
|
|
|
|
|
|
It is quite suspicious that you appear to have just signed up and your first post is not a question, which these forums are for. This is not the place for such postings, which, if you look at the rating, others agree with also.
Being new here you should be cautious and understand the rules before trying to use them.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
|
hi
my requirement is
when typing some data in textbox i want to search that data in database and show the below the textbox other wise add to listbox when any one selected in that listbox i want to show the details of that selected value.
for example i am typed 'G' in text box i want to search the 'G' related emails when any one selected the based on email id i want to show email name,address, like.....
how it is possible in asp.net 2.0
can u give me suggession
|
|
|
|
|
Use the AutoCompleteExtender like you have tried in the post directly below.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
In aspx page
I am trying like this this is not functioning.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<title>Untitled Page
<asp:scriptmanager id="ScriptManager1" enablepagemethods="true" runat="server">
<services>
<asp:servicereference path="MyAutocompleteService.asmx">
<asp:textbox id="TextBox1" runat="server">
<asp:listbox id="lstMails" visible="True" runat="Server">
<cc1:autocompleteextender id="AutoCompleteExtender1" runat="server" servicepath="MyAutocompleteService.asmx"
="" servicemethod="GetLisBox" targetcontrolid="TextBox1" minimumprefixlength="1" completioninterval="10" enablecaching="true" completionsetcount="12" completionlistcssclass="AutoExtender" completionlistitemcssclass="AutoExtenderList" completionlisthighlighteditemcssclass="AutoExtenderHighlight" completionlistelementid="lstMails">
In WedbService
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Collections.Generic;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls;
///
/// Summary description for MyAutocompleteService
///
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class MyAutocompleteService : System.Web.Services.WebService
{
public MyAutocompleteService()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
public ListBox GetLisBox(string prefixText, int count)
{
ListBox lstEmail = new ListBox();
DataSet ds = new DataSet();
string conString = ConfigurationManager.ConnectionStrings["SqlOpenRopes"].ToString();
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlDataAdapter da;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd = new SqlCommand("SELECT ReservationId,Email FROM Reservations where email !='' AND Email Like '" + prefixText + "%'", con);
da = new SqlDataAdapter(sqlCmd);
da.Fill(ds);
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem lItem = new ListItem();
lItem.Text = ds.Tables[0].Rows[i]["Email"].ToString();
lItem.Value = ds.Tables[0].Rows[i]["ReservationId"].ToString();
lstEmail.Items.Add(lItem);
}
}
con.Close();
//for (int i = 0; i < count; i++)
// responses.Add(prefixText + (char)(i + 65));
return lstEmail;
}
}
|
|
|
|
|
One, format the code you are posting using the pre tags. This is the second time you have been told this.
Two, Do not post the same question, even if you use a different title and frame it differently.
Three, Do not post the same question in multiple forums.
If you follow the rules and conventions you will get better results here.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
READ the responses!!!
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Same question as below, just asked a different way.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi
i am writing the code in aspx page
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" EnablePageMethods="true" runat="server">
<Services>
<asp:ServiceReference Path="MyAutocompleteService.asmx" />
</Services>
</asp:ScriptManager>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<div id="divWidth">
</div>
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" ServicePath="MyAutocompleteService.asmx"
ServiceMethod="GetEmailsIdString" TargetControlID="TextBox1" MinimumPrefixLength="1"
CompletionInterval="10" EnableCaching="true" CompletionSetCount="12" CompletionListCssClass="AutoExtender"
CompletionListItemCssClass="AutoExtenderList" CompletionListHighlightedItemCssClass="AutoExtenderHighlight"
CompletionListElementID="divWidth">
</cc1:AutoCompleteExtender>
</div>
</form>
</body>
</html>
in webservice
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Collections.Generic;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
/// &lt;summary&gt;
/// Summary description for MyAutocompleteService
/// &lt;/summary&gt;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class MyAutocompleteService : System.Web.Services.WebService
{
public MyAutocompleteService()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string[] GetSuggestions(string prefixText, int count)
{
List&lt;string&gt; responses = new List&lt;string&gt;();
for (int i = 0; i &lt; count; i++)
responses.Add(prefixText + (char)(i + 65));
return responses.ToArray();
}
[WebMethod]
public string[] GetEmailsIdString(string prefixText, int count)
{
List&lt;string&gt; responses = new List&lt;string&gt;();
DataSet ds = new DataSet();
string conString = ConfigurationManager.ConnectionStrings["SqlOpenRopes"].ToString();
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlDataAdapter da;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd = new SqlCommand("SELECT ReservationId,Email FROM Reservations where email !='' AND Email Like '" + prefixText + "%'", con);
da = new SqlDataAdapter(sqlCmd);
da.Fill(ds);
if (ds != null)
{
for (int i = 0; i &lt; ds.Tables[0].Rows.Count; i++)
responses.Add(ds.Tables[0].Rows[i]["Email"].ToString());
}
con.Close();
//for (int i = 0; i &lt; count; i++)
// responses.Add(prefixText + (char)(i + 65));
return responses.ToArray();
}
}
when running this code is executed the code but the output is not displaying what changes i want to do......
|
|
|
|
|
hi,
try adding this before your methods: [System.Web.Script.Services.ScriptMethod]Sara, CAPM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
