|
i can connect to serial comm port with C# 2003 .
It's very simple.
you only need to use MScomm32.ocx .
if anyone take care , you can email to me.
|
|
|
|
|
Hi,
I am trying to get the SqlDependency to work in an application. Here is the problem:
One windows application connects to northwind database using a user login. It then diplays the data in the Employees table.
Another project is using the the login as the previous App to display the same data BUT it displays an error when it gets to da.Fill(ds, "Customer");
The error is:
Message "When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance." string
Thanks
Here is code that I am using.
ds.Clear();
SqlConnection conn = new SqlConnection(txtConnect.Text);
conn.Open();
SqlCommand cmd = new SqlCommand(txtSelect.Text, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
//SqlDependency.Start(txtConnect.Text); //test...
SqlDependency dep = new SqlDependency(cmd);
//The ERROR is on this line...///////
da.Fill(ds, "Employees");
/////////////////////////////////////
grdDemo.DataSource = ds;
grdDemo.DataMember = "Employees";
|
|
|
|
|
im sorry to see that you're having this problem. i have a library class that does sql connections and returnes data sets, etc. you dont have to use the class but it might help to look at/implement the code and see if you get the same error. Hope this link leads you to a solution to your problem
http://www.codeproject.com/dotnet/COperationsSQL.asp
all sqlconnections, commands, data adapters, are encapsulated in this class making things a little bit easier when it comes to interfacing with a sql back end. best of luck
|
|
|
|
|
Hi,
My query is to do with the SqlDependency only.
Thanks
|
|
|
|
|
Hi there.
I am wondering regarding the Label control. I assigned some random numbers to some Label controls that then appear on screen, for example:
tnr8.Text = r.Next(117, 138).ToString();
tnr8.Location = new Point (20,20);
where tnr8 is the Label and r is an instance of the Random class.
I tried this but it didn´t work :
label3.Text = label1.Text + label2.Text;
How can I capture the value that is placed in the Labels? How can I add, subtract, multiply or divide the current value of the Labels that are on the screen as a result of the code?
Thanks in advance and merry christmas.
FJ
|
|
|
|
|
The Text property of the Label control is a string property. Therefore, when you do label1.Text + label2.Text, the runtime concatenates the strings.
To do what you want, you need to convert the strings to some numerical type. Therefore, you need something like
double result = double.NaN;
try
{
result = double.Parse( label1.Text ) + double.Parse( label2.Text );
}
catch( Exception ){}
label3.Text = result.ToString();
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
Hi.
Thanks for the answer. I don´t get what the NaN is in :
double result = double.NaN;
Thanks again for your help!
FJ
|
|
|
|
|
double.NaN is "Not A Number" defined in IEEE floating-point specifications. This way, if you have non-numerical values in your Labels, then the "result label" will show "NaN" meaning that no arithmetic operation could get performed on the values.
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
Hi.
I tired what you suggested and it works. Thanks a lot 
FJ
|
|
|
|
|
I feel glad that I could help. Happy coding!
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
Hello!
I am trying to implement a context menu for several different controls (more than one control have the same context menu) in C#.NET 2.0.
In .NET 1.1 we could just compare the 'sender' parameter in order to see which control has actually displayed the context menu and issued the command.
But in .NET 2.0 I get a reference to the tool strip item of the context menu in 'sender'...
How to see which control has actually used the context menu? 
I already tried several different ways (like checking the controls with .Focused, etc.), but nothing worked 
Best regards
Dominik
_outp(0x64, 0xAD);
and
__asm mov al, 0xAD __asm out 0x64, al
do the same... but what do they do??
(doesn't work on NT)
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
