|
|
Windows API has 2 functions that returns time :
- GetLocalTime() returns the current local time.
- GetSystemTime() returns the UTC(GMT) time.
Cheers!!
Brij
|
|
|
|
|
i am using windows aplliction using c#...
i have 1000 records in my table....
which has fields CUSTOMER_ID,NAME,CITY,SALARY.....
I HAVE TO SEE ONLY THE CUSTOMER WHO ARE LIVING THE CITY CALLED "DOWNTOWN"
HOW CAN I SEE THIS IN DATAGRIDVIEW...
PLS REPLY...
GIVE ME SUGGESTION OR SAMPLE CODING...
THNX IN ADVANCE
|
|
|
|
|
on load of the screen or where ever you are loading the grid
just before binding to the dataGrid you can loop through each row and check the condtion where Rows[0].Cells[0].tostring()=="xyz"
vikas da
|
|
|
|
|
 are you insane? I would hate to see crap like that in a program i have to maintain...
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
are you mental.. go to some hospital..
bloddy this was just a suggestion
if you know something better then me .. did i stop you to answer...
vikas da
|
|
|
|
|
tasumisra wrote: did i stop you to answer
Nope, but there are much easier ways see my reply...
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
I have seen your answer ... but some times we can't hardcode any querry from sql command it will cost more if u need to change your condition.
anyway if you have ever used WCF then in services
we are binding the reader object with our business object for each row that time we can filter it out more easily...
vikas da
|
|
|
|
|
tasumisra wrote: some times we can't hardcode any querry
In that case, create a stored procedure for SQL and call that in your application... problem solved
OR
Use the DataView object, i use this frequently to filter data dynamically
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
Harvey Saayman wrote: In that case, create a stored procedure for SQL and call that in your application... problem solved
what if you dont have acess to the stored proc....???
its written in COBOL and residing in Mainframe...
vikas da
|
|
|
|
|
tasumisra wrote: COBOL
Then you get your ass out of the C# forum 
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
do you know ??????
a stored proc can be written in COBOL..
and sorry you can acess these stored proc using your ass..from C# also
vikas da
|
|
|
|
|
Calm d0wn dude, i was JOKING... sheesh
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
Hi,
Why don't you use the BindingSource Filter property?
For example, you can have myDataSource.Filter = "City = 'DOWNTOWN'"
Here is the example from MSDN:
private void PopulateDataViewAndFilter() {
DataSet set1 = new DataSet();
// Some xml data to populate the DataSet with.
string musicXml =
"" +
"<music>" +
"<recording><artist>Coldplay<cd>X&Y" +
"<recording><artist>Dave Matthews<cd>Under the Table and Dreaming" +
"<recording><artist>Dave Matthews<cd>Live at Red Rocks" +
"<recording><artist>Natalie Merchant<cd>Tigerlily" +
"<recording><artist>U2<cd>How to Dismantle an Atomic Bomb" +
"";
// Read the xml.
StringReader reader = new StringReader(musicXml);
set1.ReadXml(reader);
// Get a DataView of the table contained in the dataset.
DataTableCollection tables = set1.Tables;
DataView view1 = new DataView(tables[0]);
// Create a DataGridView control and add it to the form.
DataGridView datagridview1 = new DataGridView();
datagridview1.AutoGenerateColumns = true;
this.Controls.Add(datagridview1);
// Create a BindingSource and set its DataSource property to
// the DataView.
BindingSource source1 = new BindingSource();
source1.DataSource = view1;
// Set the data source for the DataGridView.
datagridview1.DataSource = source1;
source1.Filter = "artist = 'Dave Matthews'";
}
Regards,
Lev
|
|
|
|
|
Assuming the 1000 rows are coming from a data base, you have two options...
1) Query only the data your looking for and not everything, remember "any monkey can SELECT * FROM
2) Use a DataView to filter out the data you want to display
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
as mentioned use the filter option or change the query to have a where clause.
but FYI. THE USE OF CAPITALS is considered shouting in forums. 
|
|
|
|
|
DataGridView is populated with all coumns from database since i need some
column's data for condition statement (user will select columns at run time for display), so how to filter DataGridView column in order to
show whatever column user want?
-- Ravi Munde
|
|
|
|
|
Each DataGridViewColumn has a Visible property you can change so that you only display what you need.
|
|
|
|
|
How to add a splash screen to a C# project
|
|
|
|
|
Search CP. I am sure there is one article on this topic.
C isn't that hard: void (*(*f[])())() defines f as an array of unspecified size, of pointers to functions that return pointers to functions that return void
"Always program as if the person who will be maintaining your program is a violent psychopath that knows where you live." - Martin Golding
|
|
|
|
|
Here's one for example: http://www.codeproject.com/KB/cs/prettygoodsplashscreen.aspx
Regards,
Lev
|
|
|
|
|
Hi friends,
Could anybody help me in finding fault with my web parts which r not moving?Previously I could move them,but now they cannot be moved!Other things r working well like renaming web parts ,closing,minimizing web parts etc...I checked if there is any problem in the less space of web parts,but there isn't any!Kindly help me asap,friends! 
modified on Monday, December 8, 2008 4:31 AM
|
|
|
|
|
There are 5 Display Modes in WebParts.
DesignDisplayMode
BrowseDisplayMode
EditDisplayMode
CatalogeDisplayMode
ConnectDisplayMode
If you are in BrowseDisplayMode the you cannot move the webparts.
To move the parts you have to set it to either DesignDisplayMode or EditDisplayMode.
or If you never want the BrowseDisplayMode then add this code to your Page_Load() where wpManager is the name of your Web Parts Manager (WebPartManager1)
if(!Page.IsPostBack)
wpManager.DisplayMode = WebPartManager.EditDisplayMode;
if (!wpManager.DisplayMode.AllowPageDesign)
wpManager.DisplayMode = WebPartManager.EditDisplayMode;
|
|
|
|
|
Alreday I have done those things..I alreday have mentioned that I can do other things with web parts except moving now!So can i get help?
|
|
|
|
|
If you are using the ajax update panel, then you should put the webpartmanager inside the update panel. otherwise it will not allow you move webparts.
Also check that javascript is enabled in your web browser (dont use firefox).
Or just create a test project with two web part zone and test. if it is working fine then post some code, that you feel causing problem, otherwise something wrong with the browser.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
