hi , i would like to fire set of queries when a select query is fired on to particular table, can any one help in this ..

hi i am using following code to auto complete educational institutes .. but my requirement is to fill educational institutes as per country id .. i am unable to send country id as parameter to web method .. can any one help .... plz ?? <asp:TextBox ID="txtKey" runat="server" CssClass="regtxtbox" MaxLength="50"></asp:TextBox> <asp:Panel runat="server" ID="myPanel1" Height="100px" ScrollBars="Vertical" style="overflow:hidden;width:50px;display:none;"> </asp:Panel> <cc1:AutoCompleteExtender ID="AutoCompleteExtenderDemo" runat="server" TargetControlID="txtKey" ServiceMethod="GetCompletionList" MinimumPrefixLength="1" CompletionInterval="1000" EnableCaching="true" CompletionSetCount="20" CompletionListElementID="myPanel1"> </cc1:AutoCompleteExtender> public static string[] GetCompletionList(String prefixText, int count) { List<String> suggestions = new List<string>(); DataTable dtSchools = new DataTable(); Education education = new Education(); //List<String> suggetions = education.GetAllSchoolsSearch("",prefixText); DataSet dsSchools = education.GetAllSchoolsSearch("", prefixText); if (dsSchools != null) { dtSchools = dsSchools.Tables[0]; } if (dtSchools != null && dtSchools.Rows != null && dtSchools.Rows.Count > 0) { foreach (DataRow dr in dtSchools.Rows) { string suggestion = dr["sschoolName"].ToString(); suggestions.Add(suggestion); } } return suggestions.ToArray(); }

i have given the following code to get pdf file from crystal report but at last line browser is not moving forwars its just showing process ... can any one help in this regard SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = "Data Source=raj;User ID=sa;PWD=****;Initial Catalog=****"; SqlCommand MyCommand = new SqlCommand(); MyCommand.Connection = myConnection; MyCommand.CommandText = "Select top 5 * from items"; MyCommand.CommandType = CommandType.Text; SqlDataAdapter MyDA = new SqlDataAdapter(); MyDA.SelectCommand = MyCommand; DataSet myDS = new DataSet(); MyDA.Fill(myDS, "items"); testrpt oRpt = new testrpt(); oRpt.SetDataSource(myDS); ReportDocument doc = new ReportDocument(); string fileName = Server.MapPath("testrpt.rpt"); TableLogOnInfo LogInfo = new TableLogOnInfo(); LogInfo.ConnectionInfo.ServerName = "raj"; LogInfo.ConnectionInfo.UserID = "sa"; LogInfo.ConnectionInfo.Password = "sa!2009"; LogInfo.ConnectionInfo.DatabaseName = "fssads"; CrystalDecisions.CrystalReports.Engine.ReportDocument O_Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); O_Report.Load(Server.MapPath("testrpt.rpt")); O_Report.Database.Tables[0].ApplyLogOnInfo(LogInfo); O_Report.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "rptpdf");

i have configured my application in windows 2003 OS and also in windows 2008 OS when i am browsing reports in windows 2003 its opening properly but when i browse the same page from windows 2008 server its taking almost 10 minutes time to open it .. can any one suggest what to do !

i am using crystal report which is having 5 sub reports in that. its working fine in local system but when i configure it in server subreports not taking latest data source... can any one please help in this .. i am using rpt.verifydatabase() for mail database (rtp - oject of mail report)

hi, i am using following code to download file from application its working fine in local system but when i configure in server a file is opening with sourse of aspx page can any one help me ? string FilePath = Globals.ApplicationVRoot + "/Downloads/DemoUser.CSV"; string FileName = "DemoUser.CSV"; HttpResponse response = HttpContext.Current.Response; response.ContentType = "application/octet-stream"; response.AddHeader("Content-Disposition", "attachment; filename=" + FileName); response.WriteFile(FilePath.ToString()); response.End();

hi .... i am using stored procedure to bind the crystal report, can any one help in adding parameters to stored procedure when binding it to crystal report.

abhijit can i have ur email so that i can send u my sample application if r intrusted in solving this ...

yeah i am sorry i was bit confused with that persons signature .. there is a link in his signature ... in fact i am bit hurry in finishing this task ..

http://lakshmik.blogspot.com/2006/06/aspnet-20-deployment-installer-for.html[^] i am using above code .. but my focus is not entering into following method. protected override void OnAfterInstall(IDictionary savedState)

i need to update the connection string when istallation wizard is running by taking the data source name , userid and pwd ... .. .. its like before installation event or after installation event ...how to use these events ?

i am using following code but its not working Protected override void OnAfterInstall(IDictionary savedState) { //base.OnAfterInstall(savedState); string server = this.Context.Parameters["DATASOURCE"]; MessageBox.Show(server); string userId = this.Context.Parameters["USERID"]; MessageBox.Show(userId); string password = this.Context.Parameters["PASSWORD"]; MessageBox.Show(password); //string newConnectionString = "User Id=" + userId + ";Password= " + password + ";Data Source =" + server + ";"; string newConnectionString = "Provider=SQLOLEDB.1;User Id=" + userId + ";Password=" + password + ";Data Source=" + server + ";"; string xmlConfigFile = ""; xmlConfigFile = Context.Parameters["INSTALLDIR"] + "web.config"; UpdateConfigFile(xmlConfigFile, newConnectionString, "wfMasterConStr"); MessageBox.Show("Updated"); }

hello, can any one help me in writing code to update web.config when installing web application. need to update when installation wizard is running .. (datasourse, userid,password)...

hellow can any one help me in getting week number (sunday - sunday) as week in sql server query. i am using this but its not giving as sunday to sunday SELECT StartTime,DATEPART(DAY, StartTime - 1) / 7 + 1 AS theWeekWithinMonth from TT where cardid = '3344'

hi i am trying to create a new database role with the name "EmpSelf" but i am getting the error as role already exist but i am unable to find that role ? please help me any one who know this !... Awaiting Reply .... TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for DatabaseRole 'EmpSelf'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+DatabaseRole&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ User, group, or role 'EmpSelf' already exists in the current database. (Microsoft SQL Server, Error: 15023) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15023&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------

i am able to get date in the field while debugging but when assigning it to variable it giving value NaN.

Var startdate=new Date(getElem("ctl00_ContentPlaceHolder1_txtEndTime").value); i am capturing date from field in to stratdate variable but when i am debugging the value NaN is storing in startdate variable ! i donr even know what is NaN .. why it is not storing date ?? can any one help me in this ....

just write insert statement ..... pass the value dropdown1.selecteditem

hi , is there any property in grid view which takes confirmation like "ARE YOU SURE" ....... please let me know how to do this...

can we enter text into list box as like we enter into text box ?