Click here to Skip to main content
15,911,531 members
Home / Discussions / C#
   

C#

 
QuestionEncode MPEG2 Pin
Emiliano27-Jan-06 14:54
Emiliano27-Jan-06 14:54 
QuestionSliding window and always on top. Pin
RobS27-Jan-06 12:52
RobS27-Jan-06 12:52 
Questionweb services creation Pin
gregoire.b27-Jan-06 12:10
gregoire.b27-Jan-06 12:10 
GeneralRe: web services creation Pin
mast1727-Jan-06 17:53
mast1727-Jan-06 17:53 
QuestionSingle.Parse() Pin
atanamir27-Jan-06 12:05
atanamir27-Jan-06 12:05 
AnswerRe: Single.Parse() Pin
Colin Angus Mackay27-Jan-06 13:50
Colin Angus Mackay27-Jan-06 13:50 
GeneralRe: Single.Parse() Pin
atanamir27-Jan-06 15:11
atanamir27-Jan-06 15:11 
Questionapp.config file Pin
gregoire.b27-Jan-06 9:14
gregoire.b27-Jan-06 9:14 
AnswerRe: app.config file Pin
Michael P Butler27-Jan-06 10:05
Michael P Butler27-Jan-06 10:05 
Questiontype or namespace error in C#(Asp.net) Pin
idreesbadshah27-Jan-06 8:02
idreesbadshah27-Jan-06 8:02 
AnswerRe: type or namespace error in C#(Asp.net) Pin
Colin Angus Mackay28-Jan-06 5:51
Colin Angus Mackay28-Jan-06 5:51 
QuestionEvent for form has changed location Pin
Viktor Nilsson27-Jan-06 7:52
Viktor Nilsson27-Jan-06 7:52 
AnswerRe: Event for form has changed location Pin
Dave Kreskowiak27-Jan-06 8:25
mveDave Kreskowiak27-Jan-06 8:25 
AnswerRe: Event for form has changed location Pin
Robert Rohde27-Jan-06 10:43
Robert Rohde27-Jan-06 10:43 
QuestionGaussian blur troubles Pin
Eugene Kosevtsov27-Jan-06 7:12
Eugene Kosevtsov27-Jan-06 7:12 
AnswerRe: Gaussian blur troubles Pin
User 665827-Jan-06 7:38
User 665827-Jan-06 7:38 
QuestionMarquee Selection in ListView Pin
Alomgir Miah27-Jan-06 6:16
Alomgir Miah27-Jan-06 6:16 
AnswerRe: Marquee Selection in ListView Pin
Dave Kreskowiak27-Jan-06 6:48
mveDave Kreskowiak27-Jan-06 6:48 
QuestionComboBox Pin
aPerfectCircle27-Jan-06 5:52
aPerfectCircle27-Jan-06 5:52 
AnswerRe: ComboBox Pin
LighthouseJ27-Jan-06 7:43
LighthouseJ27-Jan-06 7:43 
QuestionDataColumn type Pin
denizmercan27-Jan-06 5:28
denizmercan27-Jan-06 5:28 
AnswerRe: DataColumn type Pin
tarasn27-Jan-06 9:16
tarasn27-Jan-06 9:16 
You can use SQLDMO to access specific DB Schema .Add reference to SQLDMO object - can be found under COM tab - add entry named "Microsoft SQLDMO Object Library".
The snippet shows how to get column details for table "Customers" in "Northwind" DB.
<br />
SQLDMO.SQLServerClass sqlServer = new SQLServerClass();<br />
//login<br />
sqlServer.Connect("MYSERVER", "username", "password");<br />
<br />
// go through databases list<br />
foreach (SQLDMO.Database db in sqlServer.Databases)<br />
{<br />
	if (! db.SystemObject)<br />
	{<br />
		if(db.Name=="Northwind")<br />
		{<br />
			// Northwind found <br />
			// go through tables list<br />
			foreach( SQLDMO.Table table in db.Tables )<br />
			{<br />
				if(table.Name=="Customers")<br />
				{<br />
					// table "Customers" found<br />
					// go through columns list<br />
					foreach(SQLDMO.Column column in table.Columns )<br />
					{<br />
						// print out column name<br />
						Console.WriteLine( column.Name );<br />
						// print out column length<br />
						Console.WriteLine( column.Length );<br />
						// print out column datatype<br />
						Console.WriteLine( column.Datatype );<br />
					}<br />
				}<br />
<br />
			}<br />
		}<br />
	}<br />
}		<br />


DevIntelligence.com - My blog for .Net Developers
GeneralRe: DataColumn type Pin
denizmercan27-Jan-06 10:37
denizmercan27-Jan-06 10:37 
QuestionC# IrDA communication between Pocket-PC and MCP-2155. Pin
dannygilbert327-Jan-06 5:19
dannygilbert327-Jan-06 5:19 
AnswerRe: C# IrDA communication between Pocket-PC and MCP-2155. Pin
leppie27-Jan-06 7:14
leppie27-Jan-06 7:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.