|
See if the eventargs parameter has an index property - I ran into the same kind of issue with a tab control (trying to determine which tab page generated the event) and found e.Index held the answer.
dpb
Darryl Borden
Principal IT Analyst
dborden@eprod.com
|
|
|
|
|
Dear All,
I know this section is regarding C# only,but I am entering regarding SQL Database. I am really sorry for this.
I want to Delete the SQL Database programmatically (using C#). I am using following code for Deleting Database.
----------------------------------------------------------
private void DeleteDatabase()
{
try
{
String conn = "server="+ strLocalIP +";database="+ "master" +";password="+ "sa" +";User id="+ "sa" +";";
SqlConnection sqc = new SqlConnection(conn);
sqc.Open();
SqlCommand sc = new SqlCommand();
sc.Connection = sqc;
sc.CommandText = "DROP DATABASE "+strDatabaseName;
sc.ExecuteNonQuery();
sqc.close();
}
-------------------------------------------------------------------
strLocalIP id computers IP
Through Query Analyzer 'DROP Database' is working fine but programmatically it's giving exception, 'connection is in use'
With Regards
Manoj
|
|
|
|
|
What exactly is the conn string and the sc.CommandText?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
Dear Colin Angus,
The conn String is is the connection String containg computer information in which Database exists , Database name, user and password through which i can login to database.
String conn = "server="+ strLocalIP +";database="+ "master" +";password="+ "sa" +";User id="+ "sa" +";";
strLocalIP is actually is the IP of computer inwhich Database exists.
And sc is sqlcommand through which I execute the sql query.
Some one has suggested me to flush the connection pool. Please let me know How i can flush connection pool through C#.
Thanks & Regards
Manoj Kumar
|
|
|
|
|
No, I wanted the exact values of conn and sc.CommandText. I did not want a description of them. I know what they mean, I want to know what you wrote.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
Connection is in use or database is in use???Normally, when you want to delete a database, you need to disconnect all current connections.
|
|
|
|
|
Dear Johny Ng,
Even after disconnecting all the connections related with Database it's still giving same exception. Some one has suggested me to flush the connection pool, Please let me know How i can flush connection pool in C#.
Thanks & Regards
Manoj
|
|
|
|
|
Don't know why it's hard for you but you can kill active connection by using kill command. Or if you just want to drop that db, simply stop and start SQL server or set that db to single_user mode so all active connections will be killed.
|
|
|
|
|
Please help me!!!
1.How do I pass a value from my C# application to a textfield on a webpage on the net??
2. I dont' know exactly how this works but can you login to a website through one line of code - through the addressbar of a web browser????
any help is much apprecated!!!
|
|
|
|
|
peshkunta wrote: How do I pass a value from my C# application to a textfield on a webpage on the net??
Do you mean any arbitrary web page? I would doubt that is easily achievable.
peshkunta wrote: I dont' know exactly how this works but can you login to a website through one line of code - through the addressbar of a web browser????
Again, is this an arbitrary website? I would doubt it unless the website is extremely badly designed.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
1. I would like to be able to 1) click a button in my C# application. 2) a browser window opens with a webpage that has a textfield in it - let's say yahoo.finance stock symbol. I want this value of the stock symbol to be passed from my C# text field to the textfield of the yahoo (example) site.
2. What I meant was let's say I want to login to my website and I have my password and username. I want to be able to click a button and login without putting in the password and username every time - and all this specifically from my C# application. Let's say you have WebRequest class object and you have to pass it a URL. There must be a way to pass a URL with with the password/username in it to connect. Kind of like this except this format doesn't work for some reason: "http://www.abc.com/pass_management/user_auth.php?name=USERNAME&pass=PASSWORD"
I should be able to pass the above URL(example) to the address bar of a browser and login to my email page bypassing the login page and already opening my emails. Not sure how this works.
-- modified at 8:56 Monday 26th December, 2005
|
|
|
|
|
Neither of these are eaily achievable.
1. Requires taking over the browser in order to inject values into a web page.
2. Requires that you know the design of the web-site in order to pass through its security system (this depends on the way the website is set up and I seriously doubt any website that is written by anyone with even a tiniest bit of competance would accept a user name and password in the URL)
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
Hmn...Strange.
I have a program that does exactly that but it's not my own and doesn't have the other options I need in it.
-- modified at 9:06 Monday 26th December, 2005
|
|
|
|
|
I didn't say it was impossible. I said that it wasn't "easily achievable". The reason for that is that you are maipulating the user interface. The UI layer is often a fickle thing that humans can easily compensate for but automated processes cannot.
I have a password manager that works for some websites but gets thorouly confused by others. The reason is that some websites change too frequenly, or provide no stable context mechanism.
Passwords cannot be passed as part of the URL unless the website allows it, and I would shun any such website like the plague because it is such an insecure way of passing such information.
Now, if the website has a public API for doing such things then use that - it was designed for automated processes to interact with it.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
1. The program I have has nothing to do with the website it logs into. Yet all I have to do is give that program my username and password and url and it gets into my website I don't have to do it every time as usual when I go to my website and put in the login info every time. It's obvious that program logs into my website somehow and even gets info from it. The problem is it's not the info I need. I know it's doable and I know it's quite simple. I just know it. But I can't seem to find the answer to it.
2.(question)
And what about the programs which automatically fill in your address, etc. when you go to a website that requires your info. That's what I'm talking about too.
-- modified at 9:44 Monday 26th December, 2005
|
|
|
|
|
When you find your simple, easily doable answer, tell the rest of us. Like Colin, I think this is neither easy nor simple to accomplish for an arbitrary web site. Are you sure your program is not logging into a web service (not exactly the same thing as an arbitrary website) that is designed to provide some specific information? This might well expect a suername/password login (which it passes via an encryption rtocol hopefully). If so then that web service was likely designed to return only the specific information you are getting....
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
I'm not sure if you understand exactly what I mean:
When you send a WebRequest to a server/website it checks the request (if it is correct - has the correct parameters - username/password) it sends you a response depeding on that. When that website requires password/username login it doesn't take you to that page but instead to a login page. The information your browser sends is the same as the information the WebRequest object does. When you have entered the login info in the web browser and press a button it still sends a request to the server with the right info and the server lets you in - it (the WebRequest object) sends a request and gets a response from the server, it doesn't send the button object or anything like that so the button pressing is not essential to sending that request.
Amazing so many programmers and no one knows an aswer to my question.
|
|
|
|
|
Hi techies,
Hope u all are fine. I have to develop an application to send fax in C#. So far the knowledge i gathered I need a modem for it. But I have internet connection through LAN not by telephone line through modem. Can I send Fax under this scenario ie without modem?
Regards
Rajeev
|
|
|
|
|
as far as i have got, you need to make and execute a service on server where Modem exists. and make an application for your LAN client whenever a fax is being sent you forward the fax document to server's service and it will send the fax. and all this will be invisible for User.
that is wot i would do ...
however there are many webservices available for you to use for this purpose .. 3rd parties provide services to send FAX from Internet
R A M
|
|
|
|
|
Thanks Rizvi for ur help. Actually I don't have modem here. But on personal note I make preposterous question to ask that u sport a display name which is different from ur religion. I hop u don't mind and sorry if u take an offence to it.
Regards
Rajeev
|
|
|
|
|
|
Talktorajeev,
Its not RAAAAAAM but RAM(pronounce it as Random Access Memory)..
Infact RAM = Rizwan Ahmed Malik  
R A M
|
|
|
|
|
when I drop html which select in IE to my textbox in winform .I use code below to hanlder the event and data.
private void textBox1_DragDrop(object sender, System.Windows.Forms.DragEventArgs e)
{
object obj = e.Data.GetData(DataFormats.Html,true);
string temp = (string)obj;
char[] ch = temp.ToCharArray();
byte[] Byte = Encoding.Unicode.GetBytes(ch);
textBox1.Text = Encoding.UTF8.GetString(Byte);
}
but the html has unicode characters,so use the code ,I get some reuslt html in textbox is:
<title>百度——全球最大中文搜索引?/TITLE>
some chinese characters mix "<" to "?".
who can help me?what can I do.thx...
|
|
|
|
|
Hello,
Why are you not assigning like this textBox1.Text = (string)obj;
Why are you putting extra efforts to get a character and then a byte array?
Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net
|
|
|
|
|
Hi guys. I've hit a wall I have two questions:
1. How do I send a value from my C# application to a webpage on the internet? For example: I write my username, password in my application -> click a button and it opens the login webpage and automatically puts the value of login and password on that webpage -> or better yet logs in automatically too, so I don't have to press the button on the website. Basically I want to be able to pass values to textfields from my application C#, to a textfield of a webpage on a remote server (somewhere on the internet).
2. I get realtime stock quotes from my ameritrade service as Java applet. How can I pass those streaming quotes in real-time to my C# program. I know it can be done I just don't know how? I'm new to C#.
Your help is greatly appreciated!!!!!!!!!!!!!!!
-- modified at 3:08 Monday 26th December, 2005
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
