|
i using crystal report in my project. i want to add page wise total for a column(stock) please give me a idea.....
|
|
|
|
|
You should be able to have a running sum in the header or footer of the report.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi all,
In my project i am retriving some values from database. For eg: id,brand,status,comments.
After retriving this i am storing the values in the dataset. My doubt is, i want to get the count of records with the same brand, and also i want to bind the those records into datagridview which come under an specified category form the dataset.
For eg:
id brand status comments
1 aaa 1 test
2 bbb 1 test
3 aaa 1 test
4 ccc 1 test
5 bbb 1 test
6 aaa 1 test
7 aaa 1 test
In the above i want to dispaly only the record with brand "aaa" in datagridview, and want to display the count of "bbb","ccc" in a label control.
Plz any one help.
Thanks in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
You should change your SQL statement..
SELECT brand, COUNT(status), comments FROM Table1 GROUP BY brand,comments
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. 
|
|
|
|
|
hi Michael,
thank you very much for your suggestion., But i need it to be done using datatable, dataview. So plz suggest me an option to like so.
Thank you very much
Know is Drop, Unknown is Ocean
|
|
|
|
|
How did you bind the data to DataView?
In SQL statment, you have to change the statment like above....
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
Dear sir,
how i create a DB Connection module which will read Data Source (IP ) from .txt File. I only write IP in the .txt file and call that method from form load.
i done it in VB but i can't in C#.
plz help me
Shafik
|
|
|
|
|
hi,
imagine that i have five arraylists(ShapeTypeList,ColorList,CoordList,SizeList,PathList). All contains different types such as enum,Color,Point[] and etc. This arraylist is used in the form to store information on the Shapes to be drawn onto the form. Then, there is a Save function which is used to store all the informations in the arraylist using xml. I've create a AllData class inorder to serialize the class to an xml file. Can anybody give me some guides or tips on how to use xmlserializer to save the arraylist into xml file? the format i'm looking for is as below:
<RootClass>
<Arraylist1>
<ArrayItem1a>....</ArrayItem1a>
</ArrayList1>
<ArrayList2>
<ArrayItem2a>....</ArrayItem2a>
<ArrayItem2b>....</ArrayItem2b>
.......
........
........
</ArrayList5>
However other format also acceptable as long as i can deserialize it later.
Thanks in advance.
-- modified at 3:59 Wednesday 22nd August, 2007
|
|
|
|
|
|
|
You can either pass connection string as a parameter to the constructor or set the ConnectionString property of OleDbConnection.
For example:
<br />
string connstring="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"<br />
OleDbConnection con1 = new OleDbConnection(connstring);<br />
OR:
<br />
string connstring="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"<br />
OleDbConnection con1 = new OleDbConnection();<br />
con1.ConnectionString=connstring;<br />
If you have problem in constructing the connection string itself then this website will help you:
Connection Strings[^]
|
|
|
|
|
shemvignesh wrote: OleDbConnection con1 = new OleDbConnection();
con1.Open();
you're missing a line in there which tells the OleDbConnection how and where to connect to a database.
the line will look like:
con1.ConnectionString = "Your connection string here....";
See www.connectionstrings.com[^] for info on what to write in there.
|
|
|
|
|
I am trying to use the DbConnection and i used the following code.
public DbConnection mConnection = null;
mConnection.ConnectionString =value; //value has the connection string
but at the runtime its giving me
"Object reference not set to an instance of an object." Exception.
Can any body pls tell me how to use DbConnection.
Thanks.
|
|
|
|
|
The problem is that your object mConnection has not been instantiated. You need to instantiate a class to be able to use it. Instantiating means creating an instance, exactly what the exception message is telling you You do this by calling the constructor of the class.
public Dbconnection mConnection = new DbConnection();
mConnection.ConnectionString = value;
Voila
Talal
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
Talal Sultan wrote: public Dbconnection mConnection = new DbConnection();
mConnection.ConnectionString = value; // this should work now as the class exists.
Except it won't work becuase DbConnection[^] is an abstract class and cannot be instantiated. You need to use a concrete class derived from DbConnection (e.g. SqlConnection)
-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.
Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits
My website
|
|
|
|
|
oops, right about that. Sorry. I knew something was wrong with that class, I just didn't take the time to investigate more. Sorry about that. My mistake.
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
I was thinking he was messing out on something on a DAL factory front and not properly using the IDBConnection.
|
|
|
|
|
Hi
It seems like you are working with the wrong DB Connection class.
In order to connect SqlServer Database use the SqlConnection under the System.Data.SqlClient namespace otherwise you can use the OleDbConnection under the System.Data.OleDb namespace
|
|
|
|
|
I got the Solution. Actually that is a very generic database connection class which can be instantiated with any type of connection like oledb,sql etc.
i solved that problem by
public DbConnection mConnection =new OleDbConnection();
|
|
|
|
|
I have listbox control which is multiextended
Now i want to go to some of the values of listbox which are pre known
say item[0]
item[3] and item[6]
and check wether they are selected or not
Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"
|
|
|
|
|
You can get selected items by Listbox.SelectedItems property and then choose if it contains any of the items you are interested in.
|
|
|
|
|
I have to go through certain items
and perform action on them dependinng upon wether they are selected or not selected i am performing action in both cases
Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"
|
|
|
|
|
So what's the problem? If you have one array of items you should go through, you can get selected items by ListBox.SelectedItems, then iterate over your items array and check if it is in the selected items. You can use Contains method to do that
|
|
|
|
|
Generally You can use this.listBox1.SelectedItems orthis.listBox1.SelectedIndices properties for retrieving selected items
one of the solutions would be check the collection from SelectedIndeices property to see wether your desired indices are selected or not
System.Windows.Forms.ListBox.SelectedIndexCollection indices = this.listBox1.SelectedIndices;
if (indices.Contains(0) && indices.Contains(3) && indices.Contains(6))
but more alghoritmic way is
bool CheckIsSelected(int[] desiredIndices)
{
System.Windows.Forms.ListBox.SelectedIndexCollection indices = this.listBox1.SelectedIndices;
bool selected = true;
foreach (int index in desiredIndices)
if (!indices.Contains(index))
{
selected = false;
break;
}
if (selected) return true;
return false;
}
good luck
|
|
|
|
|
it's not showing "SelectedIndexCollection" after
System.Windows.Forms.ListBox.
i am using .net1.1
Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
