|
hello everybody,
I descovered lately that SetDatabaseLogon will not allow us to change the server name.... i find some blogs but all of it ends up n vain.... my code below encountered an error "Procedure 'gg_TestSource' expects parameter '@pServer', which was not supplied"....
im almost running out of time with myu project deadline.... i need someone who could help..... please please please... tnx n advance....
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ParameterDiscreteValue discreteBranch = new ParameterDiscreteValue();
ParameterFields paramFields = new ParameterFields();
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("~/MyCrystalReport.rpt"));
// changing my testing servername to production servername
Database crSubDB;
Tables crTables;
ConnectionInfo cInfo = new ConnectionInfo();
cInfo.ServerName = "ProductionServer";
cInfo.UserID = "myUserID";
cInfo.Password = "myPassword";
cInfo.DatabaseName = "MyTable";
crSubDB = rpt.Database;
crTables = crSubDB.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
TableLogOnInfo crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = cInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
///
ParameterDiscreteValue paramDiscreteBranch = new ParameterDiscreteValue();
ParameterField paramFieldBranch = new ParameterField();
paramFieldBranch.Name = "@pServer";
paramDiscreteBranch.Value = "XX";
paramFieldBranch.CurrentValues.Add(paramDiscreteBranch);
paramFields.Add(paramFieldBranch);
rpt.SetParameterValue("@pServer", paramDiscreteBranch);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.ReportSource = rpt;
}
}
xxx
|
|
|
|
|
How to export images to Excel/PDF/WORD in ASP.NET using VB?
I can only export the gridview to excel, but not images.
Help will be greatly appreciated.
Thanks
|
|
|
|
|
This has nothing to do with ASP.NET, working with different formats is a pure VB task. You export to office using the Microsoft tools, and to PDF by buying an SDK.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Dear Graus,
Would you please teach me in detials how to archieve this or any web site that can teach me to archieve my purpose?
Thanks
|
|
|
|
|
|
Everyone knows "google"
if I can find my answer in "google", i wil not post this questions in this web site.
Telling me to "google" is a very bad answer!!
|
|
|
|
|
leungoiyu wrote: Everyone knows "google"
oh yea. Prove it.
leungoiyu wrote: if I can find my answer in "google", i wil not post this questions in this web site.
what do you do if I pulled off the answer right from google?
leungoiyu wrote: Telling me to "google" is a very bad answer!!
Quote Selected Text
So, do you this asking someone to "teach you in detail" is good question?
|
|
|
|
|
I Do not want to waste my time talking to you.
So DO NOT write anything in my questions forum!!!
Thanks
|
|
|
|
|
I have to agree with Yusef. If you don't know how to do this, a forum is the wrong place to ask . You could pay me to write it for you, or you could do some research and ask specific questions when you get stuck, but 'how do I write xxx' is not a valid question, nor is a forum a place to expect an in depth answer to so broad a question
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
OK, Since i haven seen in the FAQ column that this web site is free to share knowledge, so i ask questions here!
if i had known that it was not a free forum, i would NOT posted a questions here.
I will go and asked for other programmers for help since i do not think this web site offers a good service nor is helpful.
I will not post questions again and recommend my friends to see this web site since this fourm is the most terrible and unhelpful forum i have ever seen!!
|
|
|
|
|
leungoiyu wrote: i do not think this web site offers a good service
You get what you pay for 
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi friends i have one serious problem i m unable to pass an array like string[] seatLayout=new string[100]; from one page named SelectBus.aspx to PassDetails.aspx.....i m stuked there? i need to pass array from one page to another. Can any one please help? 
|
|
|
|
|
well there are several ways you can pass data between pages, Query String, Session variables etc. string[100] is potentially huge data, depending on the content of each element.
Why don't you persist the data to either database or file and pass a handle from one page to another
page1.aspx: Save string[100] to database then call page2.aspx?id=some_id
|
|
|
|
|
Your first question is, why do you need to pass this array ? You should probably store it in a DB, and pass the id used to pull it from the DB. Having said that, you could concievably place the array on the URL, or use the Session.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
simply i m given it as [100] but i need only 5 to 10 thats all......because in one page user will select seats in the bus for reservations i need to pass these values to next page thats all...........
|
|
|
|
|
Hi,
You can Use Querystring for Passing Array from one Page to Another page.
I hope the following Sample Code will Help You.
Let's start by creating the array in CreateArray.asp
'Create an array that contains
'the days of the week
Dim aWeekDays(6)
aWeekDays(0) = "Sunday"
aWeekDays(1) = "Monday"
aWeekDays(2) = "Tuesday"
aWeekDays(3) = "Wednesday"
aWeekDays(4) = "Thursday"
aWeekDays(5) = "Friday"
aWeekDays(6) = "Saturday"
Now, to store the array contents in the querystring, we will loop from LBound(aWeekDays) to UBound(aWeekDays). For each element, we'll add an item to the querystring, having the array name, an equals sign, and then the value of the particular array element.
'Build the querystring
Dim iLoop, strQueryString
For iLoop = LBound(aWeekDays) to UBound(aWeekDays)
strQueryString = strQueryString & "WeekDays=" & aWeekDays(iLoop)
strQueryString = strQueryString & "&"
Next
'Cut off the last character
strQueryString = Left(strQueryString, Len(strQueryString) - 1)
'Now, create the actual hyperlink
%>
ReceiveArray.asp
Bye
Jai
|
|
|
|
|
but how to retrieve the elements in the next page??????    
|
|
|
|
|
Hi, I would like to develop an application in ASP.NET (using c#) which would consist of an image of a football pitch and icons, each having a player's name.
The user will use the mouse to drag an icon image (which represents a particular player) and drop it somewhere on the pitch image. Finally the user will save it, for it to be displayed somewhere else.
Something similar to this: http://news.bbc.co.uk/sport2/hi/football/score_on_bbci/7631245.stm[^]
Anyone got a solution or tutorial?
Thanks 
|
|
|
|
|
If you found a web page that does this, then read the source to see how they do it. It will be lots of javascript, ASP.NET strictly speaking, cannot do this, that is, it brings nothing to the table for this.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Any idea, free open source project?
|
|
|
|
|
Hi
I have a GridView which I have constructed using a template. For my links at the top of the gridview, I have buttons in order to allow users to sort the values in the columns. My question is whether I can programmatically change the sort direction to be a direction I want it to be on first click. In other words, if you click the button and the first direction is Ascending, then I want it to be Descending first on first click and vice versa.
Can anyone help me, please?
|
|
|
|
|
Yes, of course you can do that. I'd typically have the button just set a flag and pass that to the SQL to change the sort order.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
You can Use ViewState to set the sort Direction of the Gridview
on Button Click Event write the following Code :
if (ViewState["SortDirection"] != "Asc" ||ViewState["SortDirection"] == null)
ViewState["SortDirection"] == "Desc"
else
ViewState["SortDirection"] == "Asc"
// Here dv is the dataView Object. Product is the Field in Gridview Based on that Field we Sort Asc or Des.
dv.Sort = ViewState["Product"].ToString() + " "+ViewState["SortDirection"].ToString();
gvBusinessSourcingList.DataSource = dv;
gvBusinessSourcingList.DataBind();
Ok, Bye
Jai
|
|
|
|
|
Hi
I have found away of converting MS Word into HTML by following a solution I found at the following link:
http://www.wherecanibuyit.co.uk/ASP/converting_word_doc_files_to_html.html
However, even though I can get it to work, I have three problems:
1. When it opens in my asp:panel it doesn't fit neatly into the width of the panel and you have to scroll side ways to read it. I have changed the code the Word.WdSaveFormat.wdFormatHTML another format, but this loses some of the formatting. Does anyone how I can keep the formatting - namely MS Word tables and to get it fit into a panel
2. Is there away of creating HTML docs on the fly without having to save it first?
3. When the code runs it runs without error, but if I try and shut down windows, MS Word is still open even though it is not in my task bar. Is there another way of getting MS Word to close?
Thanks
|
|
|
|
|
Sounds like you need to talk to the people who wrote that page.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
