|
Hi All,
I want to connect a crystal Report dynamically with database which changes accordingly but the table is same in all the database table name = “Stock “ Also I want to add condition “SELECT * FROM Stock Where Date BETWEEN ‘xyz’ AND ‘abc’” Database is used by me is ACCESS.
Any one help me. Thanks in advance.
Nikesh Kr. Yadav
CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)
|
|
|
|
|
I just asked you what is the problem in the other forum. Pick one forum please, it is rude to cross post 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Looking at your message history, you post every question you have to at least three forums. Please don't do that, it's rude and annoying. Pick the right forum and ask there.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi, I have connected to and retrieved data from the database. I have yet to bind the data to any control since I'm uncertain which one is the most suitable control for storing large text files and displaying large text files. Please point me to a tutorial using asp.net 1.x, most of the ones I came across only show how to display records from the database where the records have only a couple of words instead of a whole page of paragraph. Thank you in advance for your help.
|
|
|
|
|
Text is text. Your main concern is, if the file is huge, the page will be huge. No control exists for the purpose of viewing large text files specifically, a label is as good a control as any. You may want to put it inside a div and use CSS to make a scrollable window, or something like that, depending on how big, is big.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hey there Christ, just the person I want to talk to. Let me give you the details of my problem. The other day when I posted a similar question, I had data from a database bound to a listbox then when I display it I noticed that my listitems were replaced by the data from the database. I realized that I have to bind the data to another control if I want to keep my listitems so I can use them to make more selections. Someone who had responded to that post said that I can bind data to a second control, when I select a listitem from my first listbox. Then I can display the data thats bound to the second listbox. I've tried to make that work but thus far it doesn't work. Can you perhaps shed a little light on that? And please don't be vague, after all I'm new to this stuff. I took your advice and bought a book, its not the latest version since I'm still using Framework 1.1.
-- modified at 2:12 Friday 27th July, 2007
|
|
|
|
|
ASPnoob wrote: Hey there Christ, just the person I want to talk to.
LOL - Christ ?
If you set the datasource for a listbox, it will replace the contents. Instead, you can take a datatable and iterate over it, as in
foreach(DataRow row in myTable)
{
}
Inside this loop you can access data from the row by index ( row[0] ) or by column name ( row["CarName"] ) These methods return an object, use ToString() to turn them into strings, which they probably are. Or cast them.
Then you can add items to the listbox via myListbox.Items.Add(
In that way, you can add items without losing the ones that are there.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i am workling on the crystal reports.I saw - the design of the crystal page is reduced drastacially.Is there any way to get original page back
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
What original page ? How is it 'reduced' ? What did you do that you want to undo ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
problem is i was trying to dag drop the table fields in my crystal reports design.But due to less design space i am not being able to see the data fields completely , their a little portion gets hides are run time.
I don;t know how come the space got shrinked.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
arrange ur width hight or do ur width and hight 100%
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
|
|
|
|
|
hi piyush,
where i can find this option ?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
wait
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
|
|
|
|
|
Can you have idea abt my problem if you have help me
I want to connect a crystal Report dynamically with database which changes accordingly but the table is same in all the database table name = “Stock “ Also I want to add condition “SELECT * FROM Stock Where Date BETWEEN ‘xyz’ AND ‘abc’” Database is used by me is ACCESS.
Thanks in advance.
Nikesh Kr. Yadav
CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)
|
|
|
|
|
Sorry to say , but i think u need a new thread.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Please don't cross post. This is like the third time I've seen this...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
It's my fourth...
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Looking at his post history and seeing so much on Crystal Reports, I think someone ought advise him to read up on Crystal Reports 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
please try to search some articles in Code Project..there is plenty example project for Crystal Report there..
Regard,
Tomi
|
|
|
|
|
Hi,
I have the following code declaration:
<asp:CreateUserWizard
ID="CECreateUser"
CancelButtonText="Cancel"
CancelDestinationPageUrl="../../Default.aspx"
CreateUserButtonText="Register"
runat="server">
<WizardSteps>
<asp:WizardStep ID="CECreateUserStep1" runat="server">
<!-- Here I have my custom fields like first, last name, etc. -->
</asp:WizardStep>
<asp:CreateUserWizardStep ID="CECreateUserStep2" runat="server">
<ContentTemplate>
<!-- Here I have my custom login controls -->
</ContentTemplate>
</asp:CreateUserWizardStep>
</WizardSteps>
</asp:CreateUserWizard>
With the CreateUserButtonText="Register" how do I specify an event handler for this button where I can write my own code to add the data to the tables?
Regards
ma se
|
|
|
|
|
Not sure if this is the right place for this.
My knowledge base is design type stuff, flash / photoshop and so on, but i want to get a
website off the ground, and im confused and a complete novice when it comes to servers.
Should i go the apache /php / sql route - would that be, with a linux server, or could that
work in a windows one, or go microsoft, .net - im not even sure if i have to change things
i do to suit the type server im using. i.e. working in dreamweaver do i have to do things
differently if im on a php/ apache set up rather than a .net set up. And of course there is
the cost issue, as, correct me if im wrong but is .net more (maybe much more) than the other
way. Wow, basically im saying i know NOTHING lol about this issue. Another reason I like
the php/sql/apache way is becasue its all open source and there are lots of scripts out there.
|
|
|
|
|
I'm not sure what you are asking. I think you wanna know whether you should use opensource or microsoft technologies.
Window hosting is expensive. but ASP.NET is so powerful to develop the web application within the small amount of budget in short period of time.
Linux hosting is much cheap than window hosting..
For me, I used to use window hosting for client's projects that I have developed. but I didn't develop my own software for my blog. I'm very happy to use workpress for my blog and happy to host my blog on linux hosting..
|
|
|
|
|
Hi, I'm using two databases one is ASPDBNET and another I created myself, and while entering the users date into ASPDBNET, I also need to enter additional info into one table of my another DB, but I have this kind of exception;
System.Data.SqlClient.SqlException was unhandled by user code
Message="Must declare the scalar variable \"@username\"."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
here is the code:
<br />
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)<br />
{<br />
TextBox txtUserName = (TextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("UserName");<br />
SqlDataSource DataSource = (SqlDataSource)CreateUserWizardStep0.FindControl("SDSInsertUserDetails");<br />
<br />
MembershipUser User = Membership.GetUser(txtUserName.Text);<br />
string username = User.UserName;<br />
<br />
DataSource.InsertParameters.Add("@username", username);<br />
DataSource.InsertParameters.Add("@date", Convert.ToString(DateTime.Today));<br />
DataSource.Insert();<br />
}
and the REgister.aspx code is here:
...
...
<br />
<asp:SqlDataSource ID="SDSInsertUserDetails" runat="server" ConnectionString="<%$ ConnectionStrings:PapersDBConnectionString %>"<br />
InsertCommand="INSERT INTO Users(username, name, lastname, addressline1, addressline2, city, state, country, zipcode, phone, newuser, moderator, date, organization, confirmed) VALUES (@username, @name, @lastname, @address1, @address2, @city, @state, @country, @zipcode, @phone, 0, 0, @date, @organization, 0)"><br />
<InsertParameters><br />
<br />
<asp:ControlParameter Name="name" Type="String" ControlID="txtFirstName" PropertyName="Text" /><br />
<asp:ControlParameter Name="lastname" Type="String" ControlID="txtLastName" PropertyName="Text" /><br />
<asp:ControlParameter Name="address1" Type="String" ControlID="txtAddressline1" PropertyName="Text"/><br />
<asp:ControlParameter Name="address2" Type="String" ControlID="txtAddressline2" PropertyName="Text"/><br />
<asp:ControlParameter Name="city" Type="String" ControlID="txtCity" PropertyName="Text"/><br />
<asp:ControlParameter Name="state" Type="String" ControlID="txtState" PropertyName="Text"/><br />
<asp:ControlParameter Name="country" Type="String" ControlID="txtCountry" PropertyName="Text"/><br />
<asp:ControlParameter Name="zipcode" Type="String" ControlID="txtZip" PropertyName="Text"/><br />
<asp:ControlParameter Name="phone" Type="String" ControlID="txtPhone" PropertyName="Text"/><br />
<asp:ControlParameter Name="organization" Type="String" ControlID="txtOrganization" PropertyName="Text"/><br />
<br />
</InsertParameters><br />
</asp:SqlDataSource><br />
..
..
thanx
|
|
|
|
|
I have two different Virtual Directories for two folders. I want to Redirect from a page in one folder to another. How do I do this?
|
|
|
|
|
By specifying the external address of the page.
The redirect is done by sending a redirect page to the browser, and the browser will request the new page from the server. Therefore the address has to be an address that the browser can use to reach the page.
---
single minded; short sighted; long gone;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
