|
But my table name varry every time.i created tables dynamically when new employee added.i want facility to choose new table name every time when i open same crystal report.
Can u please show me it with code(C#)
|
|
|
|
|
KIDYA wrote: i created tables dynamically when new employee added
You WHAT, are you nuts, that is a disaster, give it up.
Read up on database design and data structures, chuck what you have and start again. There is no hope for you with that structure!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
I need a datagridview like excel spreadsheet .
would you mind helping me?
thanks alot
|
|
|
|
|
Can you be a bit more descriptive?
जय हिंद
|
|
|
|
|
Hi.
I want to build a small application that has the ability to open and interact with other applications. So far I've figured out how to open files with the Process class, and I can get my application to send a mouse click to the other application. The problem I have now is that I want to get my application to click on a specified control in the other application, and not just a hard coded coordinate.
Is there a way to programatically open an application, check for a specific control, and send a mouse click to that control no matter where its location might be?
|
|
|
|
|
Read some MSDN info on FindWindow and SendMessage(..., WM_CLICK, ...) win API functions. Other than that, you may want to use Spy++ utility (optionally installs with VS) to learn some info about the controls you wish to click.
H.
|
|
|
|
|
Search for Inter-process communication. You will find a lot of help. Or, look into this[^].
जय हिंद
modified on Saturday, May 2, 2009 5:47 AM
|
|
|
|
|
I don't think hooks are what he is looking for. He doesn't want to capture clicks on controls of other processes, he wants to initiate them. This is how I understood it.
|
|
|
|
|
Yes, watching programs for events is not exactly what I've had in mind, but thanks anyways for the advice.
I just need a way of finding a specific control on a application outside of my own. I'm hoping that if I could do this, then I would be able to extract the location of that single control and send mouse clicks to that location.
|
|
|
|
|
Read again what I said in my first reply. FindWindow (and/or FindWindowEx), is going to find the control you wish to click on and SendMessage can simulate clicking (I believe). I wouldn't say it is neccessary to click on some screen-coordinates, just send WM_CLICK message to the control (Button, whatever) found by FindWindow(Ex) and forget about coordinates altogether.
Bottom line: do some research on FindWindow/FindWindowEx and SendMessage win32 api functions, they're going to help you.
H.
|
|
|
|
|
Hi all,
I'm facing a problem in Ipc with remoting in .net 2.0
objAuction = (AuctionWeb.AuctionService.clsAuctionProcess)Activator.GetObject(typeof(AuctionWeb.AuctionService.clsAuctionProcess),
"ipc://AuctionService/RunService");
Here i have created an object using activator.getobject.
after creating the object if i want to go for any method with that object then i'm getting the Null Reference exception
"Object reference is not set to the instance of an object"
Can any one give me a solution.
Thanks in advance.
|
|
|
|
|
Hey,
I'm building some automation tool of some web site.
It has the following code:
<TD style="cursor:pointer" align="right" dir="ltr" onClick="javascript:function1(list of params);" id="12345">qwerty</TD> .
I'm using EtmlDocument HtmlElementCollection and HtmlElement and my HtmlElement variable has:
OuterHtml =
<TD style="cursor:pointer" align="right" dir="ltr" onClick="javascript:function1(list of params);" id="12345">qwerty</TD>
OuterText = "qwerty"
What should I do in order to generate mouse click and fire function1 and get the reply?
Thanks.
|
|
|
|
|
Do I get it right that you are writing some bot that clicks on web pages and processes the replies, pretending to be human?
|
|
|
|
|
|
Sounds suspicious.
जय हिंद
|
|
|
|
|
Well, I don't know. When I did this, none of the pages I targeted used javascripts for server interaction so it was easy to simulate clicking with HttpWebRequest/Response classes. In your case, I guess you'll have to emulate the javascript flow, as browsers do, to get the idea what the actual request should be. Unless someone else has something to say.
H.
|
|
|
|
|
Hello All,
I am running on .Net Framework 2.0.
creating WEB Application.
I have a different users from different country. And I have property LOCATION for a User as well.
Now if UserA logged in and it's from UK country then all time should be display as per UK time. So i want to globalize the application. How can I do this ?
Kindly help into this.
Thanks.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
I am working on server 2003.i am trying to connect excel database but it shows error could not find installable ISAM.
Please Help me.
here is my code
string strcnn=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +strpath + ";Extended Properties=Excel 8.0;HDR=Yes";
oledbcon=new oledbcon(strcnn);
oledbcmd=new oledbcmd("select * from[QE150409$]",oledbcon);
oledbda=new oledbda(oledbcmd);
ds=new dataset();
oledbda.fill(ds,"e1");
DataGridView.Datasource=ds.Tables[0].DefaultView;
|
|
|
|
|
|
Hi,
I want to know if this is the way to work with ListViews:
I noticed that ListViews contain strings only.. so.. if I have a List of persons List<Person>, and each Person has properties Id, Name, Age, and much more.
I want to display only name and age (there are two columns in the ListView: Name, Age),
My question:
I'd like to work with the Person (object Person!) selected.. I'm currently doing it this way:
Adding the items to the list:
foreach (Person person in personList)
{
ListViewItem lvi = new ListViewItem();
lvi.SubItems.Add(person.Name);
lvi.SubItems.Add(person.Age.ToString());
lvi.SubItems.Add(person.Id.ToString());
listView1.Items.Add(lvi);
}
And the subitem Id is not listed because of "lack of column", i mean: There are two columns.. so Id is not displayed because it would need 3 columns..
Then, that way i can use the Id of the person and refer to the object..
Is this the way one would do that ? I suppose not because it doesnt look very nice..
In fact if i would add later a new column i would have to change things
Help please!
|
|
|
|
|
You've got it almost right. The property used for storing info about items is called Tag . For other purposes (when addressing items in the ListView if you don't know the index) you might like Name .
Also - the leftmost column is somewhat main and contains SubItems that specify text displayed in other comlums. Therefore set the Text and Tag property of the leftmost column and populate its subitems (the way you do) to specify the text of other coumns.
The code:
foreach (Person person in personList)
{
ListViewItem lvi = new ListViewItem(person.Name);
lvi.Tag = person.Id;
lvi.SubItems.Add(person.Age.ToString());
listView1.Items.Add(lvi);
}
Hope it helps, H.
|
|
|
|
|
The previous answer was good!
If you're going to need this functionality alot then it can be useful to create a ToListViewItem method in the Person class.
Also, if a reference to the person object itself would be useful (sometimes it can be easier to deal with the object rather than one of its properties to save multiple lookups etc) then you can put that into the Tag instead - just cast the Tag back to Person when you need it.
public ListViewItem ToListViewItem()
{
ListViewItem result = new ListViewItem(Name);
result.Tag = this;
result.SubItems.Add(Age.ToString());
return result;
} Add like this:
foreach (Person person in personList)
{
listView1.Items.Add(person.ToListViewItem());
} To get the object:
Person selectedPerson = (Person)listView.Items[itemIndex].Tag;
Nothing wrong with the previous answer, just throwing a couple more ideas out there
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
The two ways totally helped me understanding how to work with ListView, thank you guys!!
Though I have a doubt about the two replies,
you both told me to put person.Name in the first column.. but, if I need to put a checkbox column?
And Dave, respect to your answer,
I really find it a good idea, in fact i'm going to do it that way, but..
I've been told not to produce cycles between packages, and I have the ClassLibrary package which contains the Persons, etc, etc. and the WindowsFormsApp which would have the ListView and etc. Is it ok to return a ListView from the ClassLibrary?
Thanks again
|
|
|
|
|
If you want name in a different column then add it as a sub item.
Your other point is a good question. It depends on just how fussy you want/need to be.
Quake2Player wrote: Is it ok to return a ListView
Making the Person class reliant on a list view would be a bad idea:
public void AddToListView(ListView listView)
{
ListViewItem listViewItem = new ListViewItem(Name);
listView.Items.Add(listViewItem);
} but in my opinion, returning a ListViewItem from the class is OK as it doesn't rely on any existing object instance to be able to perform the method. I would draw the line at a ListViewItem (or a List<ListViewItem> or ListViewItem[] for a collection), returning an entire ListView would be taking it too far.
Not everyone would agree that returning a ListViewItem is OK - if this is for work/college, ask your boss/tutor for their opinion. The way you were doing it is good, but the reusability of having a method like that in the class (especially if it's going to be used a lot) can be advantageous.
Another minor thing that's often worth doing (along the same lines) is to override the ToString method e.g.
public override string ToString()
{
return string.Format("Name: {0}, Age: {1}", Name, Age);
} This is a very standard thing to do and not that disimilar to what I suggested.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Hi ppl
In my sql server 2005 database I have a column named "VistDate" in a table. Data type is DateTime and formate is short Date. when I try to get a date from that column and take it in a textbox it appears, if the date is 10/10/2009, it works fine. But if the date is
like 6/7/2009, it splits. Reason is I want to get indivisual formate: like
VisitorDate = row["VistDate"].ToString();
txtVisDay.Text = VisitorDate.ToString().Substring(0, 2);
txtVisMon.Text = VisitorDate.ToString().Substring(3, 2);
txtVisYr.Text = VisitorDate.ToString().Substring(6, 4);
Result:
6/
7/
09...
result is spliting.
But if the date is 10/10/2009 then it appears perfect.
Ques is converting 6/7/2009 to 06/07/2009?
whats the solution
Thanks in advance
|
|
|
|