|
use microsoft sqlserver connection info dll files
private static Server srvSql;
private static ServerConnection srvConn;
void ReadDatabase(string _ServerName)
{
try
{
srvConn = new ServerConnection(_ServerName);
srvConn.LoginSecure = true;
srvSql = new Server(srvConn);
foreach (Database MyServer in srvSql.Databases)
{
cmboDB.Items.Add(MyServer.Name);
//Here you can check wheather database exist or not
}
}
catch (Exception DbExp)
{
MessageBox.Show("Error in Connection !!!!", "Database ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
|
|
|
|
|
Take One Textbox anb Button........
Write the following code for Button click....
SqlConnection cn = new SqlConnection("server=ms08; uid=sa; pwd=;");
string Qry ="SELECT Count(*) FROM master.dbo.sysdatabases WHERE name = '" + TextBox1.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(Qry,cn);
DataSet ds =new DataSet();
da.Fill(ds);
DataRow dr=ds.Tables[0].Rows[0];
if(dr[0].ToString() == "1")
MessageBox.Show(Exists..")
else
MessageBox.Show("Does not exists....");
venki
|
|
|
|
|
Try to connect to the database and catch any exceptions that it may throw back at you about not being able to connect to the specified database.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
to Abhijit Jana , Venki56 and Paul Conrad
Thanks for your help,
Cheers.
******************************
I just want to
know everything
|
|
|
|
|
Hi Friends,
I got a strange question on my application. Sometimes when I going to start my application, a installer will appear, and asking for reinsall. After reinstalled, the application can be run.
It was not happened everytimes, but very occasionally. I'm thinking what's wrong in my project design?
1. will it related to the problem of some missing folder? (coz I set all folder AlwaysCreate to true)
2. any wrong step I made on my installer?
My project is related to PDF, is it related to PDF problem?
Please help, and give some hints. Thanks so much
|
|
|
|
|
Hi!
I guess you've created a setup and deployment project to install your application and are starting the program using a shortcut created there, right?
In this case, Windows Installer checks if all the key files in your installation are still there and if not tries to reinstall them.
I can't describe it in all details but this should get you started.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Hi, I was woundering if some of the higher level C# programmers could help me with my code. I have read all the Doc. that i can find about it, But i still cant get it to fully work. If I comment out the keyboadx ref's the mouseclickx works fine. If I dont neather the mouseclickx nor the keyboardx works at all. I cant get the keyboardx to work in any fashion.
I made a link to a paste it site because i didnt know how it it is looked at about paste long code in forums.
http://rafb.net/p/bmuAVm81.html[^]
|
|
|
|
|
Hi,
the problem is with your INPUT struct; its original C definition has a union which
puts MOUSEINPUT and KEYBDINPUT at the same location; yours has not, so the substructs
are located sequentially.
There is a way to mimic union behavior in C# using explicit offsets, but in this case
it would be easier to come up with two different INPUT structs (say INPUTK and INPUTM),
and two prototypes for SendInput accordingly.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
And as usual, Luc has the answer.
I wouldn't even have thought of checking the original structs.
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
when it fails no part is beyond suspicion...
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Thank you for the reply. I have modifed my code serveral time to try to make the struct more like you said. but to no avail can i get it to work. this is the code I have this time.
Let me know what you see wrong on this one..
Thank you very much
Danzar
http://rafb.net/p/uPx4EW73.html[^]
|
|
|
|
|
Hi danzar,
the way I read the documentation on KEYBDINPUT structure, you must specify a valid
dwExtraInfo
"Specifies an additional value associated with the keystroke. Use the GetMessageExtraInfo function to obtain this information"
so I think your zero value is not good enough.
BTW: I noticed the mouse struct is smaller than the keyboard struct, but the original INPUT
has a union, so its size must accomodate the largest of them (once you try my INPUTM, it
would fail if you don't take care of that!).
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
I want to be able to create generic event procedures that can be used for a number of controls (the same type) on a form.
For example (assume the object sender would always be a text box);
private void tbCallBlockPct_Click(object sender, EventArgs e)<br />
{<br />
sender.SelectAll();<br />
}
However when I try somehting like this I get a syntax error that the “object sender does not contain a definition for SelectAll”.
If the function is being passed a textbox as the variable sender should not all of its methods and properties be accessable?
David Wilkes
|
|
|
|
|
sender is of type object, which doesn't have a SelectAll() method in its interface. You should cast sender to an object variable of type TextBox in order to invoke properties/methods particular to this class.
TextBox tb = (TextBox)sender;
tb.SelectAll();
Paul Marfleet
|
|
|
|
|
Thanks.
That is alomost exactly what I ended comming up with not too long after posting the message. It seemed a bit round about and redundant, so i was not sure about it.
Would it be correct to assume that since the tb.SelectAll works (selects the text in the original control) means that the tb is a pointer to the actual text box and not a copy of it?
It would seem that you should be able to do it more directly, like (TextBox)sender.SelectAll(); or something similar.
David Wilkes
|
|
|
|
|
amatbrewer wrote: Would it be correct to assume that since the tb.SelectAll works (selects the text in the original control) means that the tb is a pointer to the actual text box and not a copy of it?
Yes.
amatbrewer wrote: It would seem that you should be able to do it more directly, like (TextBox)sender.SelectAll(); or something similar.
Try this one: ((TextBox) sender).SelectAll();
"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." - Rick Cook www.troschuetz.de
|
|
|
|
|
It would be safer not to assume that the sender is a TextBox (one day it won't be). Code like this:
TextBox tb = sender as TextBox;
if (tb != null)
{
tb.SelectAll();
}
else
{
}
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
|
|
|
|
|
hy everyone!
i do already have an idea for this but i thought, maybe there is a better solution than mine (easier, more stable etc.) so that's why i ask:
i do have datafields with one line containing the fielddescription and the second line containing the values. now i do want to store these info so i am able to use it later on.
my idea would be to store it in arrays, one for every dataset. one array field is the fielddescription (FD) and the second one is the value to this description field (VF).
so it would look like this
---------------------------
| 1 | 2 | ....
.....................
|FD1 |VF1 |FD1 |VF1 |
.....................
|FD2 |VF2 |FD2 |VF2 |
.....................
|... |... ||... |... |
......................
|FDn |VFn ||FDn |VFn |
......................
i chose this way because i do want to allow reordering of the "fields" (e.g. datafield11 and datafield22 change places) or there is a new field append to the old ones (lets say a n+1 field).
what way would you define this structure (i would define a two dimensional array, where the second array contains another two dimensional array)?
or do you have a better idea of how to store this info in a datastructure?
the infos in my txtfile i do parse look like this (this are two pairs of info!)
name1, name2, name3, name4, ...
value1, value2, valure3, value4, ...
name1, name2, name3, name4, ...
value1, value2, valure3, value4, ...
where the first pair is the first element in my arraystructure, the second one is the second arrayelement etc.
i do know how many lines they are. because of the structure i am able to count how many pairs are available. so i know the dimension of the datastructure which i do have to provide (with dynamic arrays this is quit easy to do).
but from my point of view my structure looks a little strange, because if you want to access the first value of the first element then you have to do the following
access the first dataelement in the array and then enter the second array to get the required data.
eg.
datalement[1,[2]]
(not correct coded i guess, but you might get the meaning of it.
so my question is: how would you define a datastructure to store the info
name1, name2, name3, name4, ...<br />
value 1, value 2, valure3, value4, ...<br />
name 1, name2, name3, name4, ...<br />
value 1, value2, valure3, value4, ...<br />
....<br />
name1, name2, name3, name4, ...<br />
value1, value2, valure3, value4, ...<br />
name1, name2, name3, name4, ...<br />
value1, value2, valure3, value4, ...<br />
so any idea how to store this info in a more simpley way is welcome.
thanks!
stephan.
|
|
|
|
|
i found a better or easier solution to my problem.
i do not use array in array anymore i decided to use an extra array to store the infos where the data is located in. so my new structure looks like that
<br />
string[,] indexinfo;<br />
string[,] data;<br />
so in indexinfo the first arrayfield gets the fieldname and the second one gets the index.
in data i do store the data, field on is the dataindex (meaning which line) and the second index is the value.
so the indexinfo looks like this
fieldname1 10
fieldname2 13
and the data looks like that
10 20
11 21
12 22
13 23
(each row is a dataline)
that's a lot easier. 
but well i have to use two fields to get the info.
stephan.
|
|
|
|
|
Hello,
The problem is .. I want to see my application window sticks on to the desktop (i.e it should never minimize)always like a gadget (but its not a gadget) .It should ignore Lwin+D . And toggledesktop command also (I mean it should not minimize even though we click on showdesktop.scf file).Please help me, that is heart of my academic project.I'm using c#.net 2005.
Example for my requirement is Yahoo gadget .In that we can set the property of the gadget as below so that it will never minimize.
(THANKS IN ADVANCE)
Mahi
|
|
|
|
|
I don't think you can "stop" the show desktop (Win+D) from hiding your application. Even items that cannot be minimized (e.g. applications with a modal dialog open) are hidden.
But I think what you looking for is an Application Desktop Toolbars[^].
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Sorry, Actually Im looking for the gadget kind of thing which stays always on desktop.I have seen that application desktop toolbar .But it is visible always when we are on some other application also.
I have seen yahoo gadget and installed gadget engine to see what is the property that makes the window to stay always below some other applications and sticks to desktop that is
these are the properties values of window level of widget .
konspose, desktop, below, normal, topmost, or floating.
I want to implement one of the value that is below .
Thank you.
Mahi
|
|
|
|
|
Are you talking about This.Topmost?
|
|
|
|
|
No.If I keep that it always shows my application only.My requirement is it should be on desktop just like wallpaper .whenever we see wallpaper we should able to see our application.
Thank you.
Mahi
|
|
|
|
|
Wow, Lwin+D powerfull stuff. I have stopped all forms of minimizing / maximizing, but Lwin+D still gets the app out of the way.
And as for keeping it at the back... i'm not sure. Then again, you might be able to do something in WndProc to stop your window coming forward.
-- modified at 21:06 Tuesday 30th October, 2007
From what i can tell, an application gets no message when a user presses win+d. It just gets minimized.
From what i can tell of other things, the OS hides all windows, and draws the desktop over everything, and sets some active window property, or somthing similar to null. As a test for yourself, find a window you cannot minimize (try opening up the options for your browser). Do Lwin+D, now, restore or maximize any window other than your browser. As you can see, your browser is restored, though it will have received no message to maximize or restore.
And thats enough of my ramblings. I'm sure they're quite wrong, but who knows...
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
