Hi, I'm using Visual Studio 2008 and SQLExpress 2005.My OS system is win XP.I want to access my database from

"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Coupon Management.mdf"

.I am confused that it attacg database from App_data.When i run my program it show error CREATE DATABASE permission denied in database 'master'. Cannot attach the file 'C:\Inetpub\wwwroot\WebSite2\App_Data\Coupon Management.mdf' as database 'Coupon Management'. here is my connection string

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Coupon Management.mdf;Database=Coupon Management;

Trusted_Connection=Yes;Persist Security Info=True;Integrated Security=False

Plz help. thnx in advance

i have face an error in this connection string **"Keyword not supported: 'initial catalogue'."**Please help

<add name="conn" connectionString="Data Source=.\SQLEXPRESS;Persist Security Info=True;Integrated Security=SSPI;AttachDbFilename=|DataDirectory|\Coupon Management.mdf;Initial Catalogue=Coupon Management"
providerName="System.Data.SqlClient" />

I have a simple code in asp and VB which is used for search in a database (MS Access).All search are done but only one creates an error.When i search by a keyword it show this error. Error is ADODB.Recordset error '800a0cc1'.Item cannot be found in the collection corresponding to the requested name or ordinal

<%

Dim Sqlbooks
dim checkkeyword, checkarticle
checkarticle="False"
checkkeyword="False"

Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")
dbGlobalWeb.Open("BookDB")

Sqlbooks = "SELECT * FROM Booklist"
Sqlkeyword="SELECT * FROM Keyword11"
sqlarticle="SELECT * FROM Article"

If Request.Form("TypeSearch") = "Accno" Then
Sqlbooks = Sqlbooks & " WHERE Acc_No LIKE '%" & Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Callno" Then
Sqlbooks = Sqlbooks & " WHERE Call_No LIKE '%" & _
Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Author" Then
Sqlbooks = Sqlbooks & " WHERE Author LIKE '%" & _
Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Title" Then
Sqlbooks = Sqlbooks & " WHERE Title LIKE '%" & _
Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "ISBN" Then
Sqlbooks = Sqlbooks & " WHERE ISBN LIKE '%" & _
Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Publisher" Then
Sqlbooks = Sqlbooks & " WHERE Publisher LIKE '%" & Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Binding" Then
Sqlbooks = Sqlbooks & " WHERE Binding LIKE '%" & Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Subject" Then
Sqlbooks = Sqlbooks & " WHERE Subject LIKE '%" & Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Keyword1" Then
checkkeyword="True"
Sqlkeyword = Sqlkeyword & " WHERE Keyword1 LIKE '%" & Request.Form("DaInBox") & "%'"
End If

If Request.Form("TypeSearch") = "Article" Then
checkarticle="True"
Sqlarticle = Sqlarticle & " WHERE Article LIKE '%" & Request.Form("DaInBox") & "%'"
End If

Set rsGlobalWeb = Server.CreateObject("ADODB.Recordset")

If checkkeyword="True" then
rsGlobalWeb.Open Sqlkeyword, dbGlobalWeb, 3

<%End If
End If
End If

How i solve this error i check almost all the solution in google but not find any change. plz help

thnx 4 reply.my reports not contain so much code it simply bind a record with a button.

protected void Button1_Click(object sender, EventArgs e)
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("C:\\WebSite1\\CrystalReport2.rpt");
CrystalReportViewer1.ReportSource = cryRpt;
CrystalReportViewer1.RefreshReport();

}

i have a crystal report which is bind with oledb database. tommorrow its working but now it show error that "Table could not found". i googled my problem and can't find any satisfactory solution if anyone knows it solution plz share with me. advance thnx 4 help

i have 2 crystal reports both of them have different datasource.These reports were working tommorrow but now when i run reports it show errors one report shows**"the table could not found"** and another report shows "the report need more information". i rebind my reports with database but error is still there i googled my problem but no solution works.plz help if u know its solutions

Hi all i have a code in to show Date to Date report.When i compile and run it, it cannt show any error but when it run in browser it takes too much time to load and no result is shown. I take this code from an article and i want to implement it. Plz help y it even show parameters and reports???

protected void btnShow_Click(object sender, System.EventArgs e)
{

       ReportDocument cryRpt = new ReportDocument();
        cryRpt.Load("CrystalReport3.rpt");

        TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
        TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
        ConnectionInfo crConnectionInfo = new ConnectionInfo();
        Tables CrTables;

        ParameterFieldDefinitions crParameterFieldDefinitions ;
        ParameterFieldDefinition crParameterFieldDefinition ;
        ParameterValues crParameterValues = new ParameterValues();
        ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

        crParameterDiscreteValue.Value =txtFrom.Text;
        crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
        crParameterFieldDefinition = crParameterFieldDefinitions\["Date1"\];
        crParameterValues = crParameterFieldDefinition.CurrentValues;

        crParameterValues.Clear();
        crParameterValues.Add(crParameterDiscreteValue);
        crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

        crParameterDiscreteValue.Value = txtTo.Text;
        crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
        crParameterFieldDefinition = crParameterFieldDefinitions\["Date2"\];
        crParameterValues = crParameterFieldDefinition.CurrentValues;

        crParameterValues.Add(crParameterDiscreteValue);
        crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
  
        crConnectionInfo.ServerName = "Server1";
        crConnectionInfo.DatabaseName = "Coupon Management.mdf";
        crConnectionInfo.UserID = "";
        crConnectionInfo.Password = "";

        CrTables = cryRpt.Database.Tables;
        foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
        {
            crtableLogoninfo = CrTable.LogOnInfo;
            crtableLogoninfo.ConnectionInfo = crConnectionInfo;
            CrTable.ApplyLogOnInfo(crtableLogoninfo);
        }

        CrystalReportVie

Hi all, crystal reports are new for me. i need help for creating a report having two parameter which takes Start Date and End Date which contain the range of dates and when i select dates it show related reports.i want to fix date ranges at run time using C# code. I take a code from an article but it doesn't work. If u have any article plz give me link i will consult it. advance thnx 4 help

i code a connection string in web.config in appsetting now i want to use that connection in dropdownlist which i want to bind through wizard. How i give that connection using wizard to bind it???

i copy this code from an article which is use to take a run time parameters when i run it,it show an error "String doesnot have a definition for ApplycurrentValues" i think i miss a directive for it plz help as i m novice in crystal report reporting. i use only one directive which is

using CrystalDecisions.Shared;

ParameterValues ParamCurrentValues = new ParameterValues();

    ParameterRangeValue p\_OrderDate\_Value = new ParameterRangeValue();

    p\_OrderDate\_Value.StartValue = this.txtOrderDateFrom.Text;

    p\_OrderDate\_Value.EndValue = this.txtOrderDateTo.Text;

    ParamCurrentValues.Add(p\_OrderDate\_Value);

    rep.DataDefinition.ParameterFields();
    ("Date1").**ApplyCurrentValues**(ParamCurrentValues);

thnx 4 the suggestions but i want to get Date parameters value at run time.what should i do?

but in my situation there is no auto generate scroll bars. U suggest Silverlight plz explain it. Is it like AJAX controls or something else. thnx again 4 help

hi everyone i have a dropdownlist which has more than 60 items.when i click on it its list become so long that my website design looks bad.i want to include scroll bars (vertical scroll bar)in my dropdownlist. Is it possible? if yes than how???? plz help

crystal reports r new to me i want to make a query using Add Command and want to include a condition Between for a Date. How i can do that? when i done it i create parameters also usin CREATE PARAMETER but when i give value to Date1 and click ok it show error Permission violation, or other nonsecific error and give another error failed to open a rowset. here is my query plz chk and reply. thnx in advance

SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
where b.Transactiondate Between ({?Date1},{Date2})
GROUP BY a.Category,a.[Transaction];

sorry i can't find a forum for crystal reports so i send my query in this forum plz help

i m new to work with crystal reports i write a query in sqlcommand which is an option in addcommand DATA BASE EXPERT. i have two parameter Date and Date2 i want the ouput between these parameter but it show errors when i finished it. **"failed to open a rowset"**plz chk and reply

SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
where b.TransactionDate BETWEEN ({?DATE}) AND ({?DATE2})
GROUP BY a.Category,a.[Transaction];

thnx Nigel now its working when i change its datatype. again thank u very much

here is my query and i use it for making a crystal report when i run it in database MS Access it show the values but same query when i run it in sql server it show error "The text,ntext and image data type cannot be compared or sorted except when IS NULL or LIKE" there are its datatypes TotalSale int Price money Category Text Transaction Text same datatype used in sqlserver and MS access. Plz help

SELECT Sum(b.TotalSale*b.Price) AS total, a.Category , a.[Transaction]
FROM TransactionType AS a INNER JOIN CouponTransaction AS b ON a.TransactionTypeID = b.TransactionTypeID
GROUP BY a.Category,a.[Transaction];

u mean i will write

ddlCType.DataBind();

in page load or i write all my code in pageload????

Thanx 4 ur kind suggestions. I will try my best to work on the issues u have mentioned in ur reply.