Get Table Column Description from SQLServer - C# Discussion Boards

Add existing VS.NET 2003 forms to Beta 2

22-Dec-05 1:40

Escape the quotation mark with the \ character:

string link = "<a href=\"www.codeproject.com\">";

Or use an @-delimited string and double qoutation marks:

string link = @"<a href=""www.codeproject.com"">";

---
b { font-weight: normal; }

Adarsh Shah21-Dec-05 23:49

Adarsh Shah

21-Dec-05 23:49

Hi,
We have created around 100 forms in VS.Net 2003. Just added controls to form for creating the flow of project. Now we have decided to work in Beta 2 and want to use all the forms created in 2003. Please suggest some easy way for converting the 2003 forms into 2005 forms.(There is an extra Designer.cs class in Beta 2)

Regards,
Shah Adarsh

Culture information

Mahi.Ragava21-Dec-05 23:05

Mahi.Ragava

21-Dec-05 23:05

Hi,

What is culture information in c#?
For what purpose it is used?
What functionality we can make use of it?

I know a little about it.
Kindly help me in programmatic point of view.....

Thanx...

Re: Culture information

albCode22-Dec-05 0:27

albCode

22-Dec-05 0:27

LINK

How to make a Setup File in Visual Studio 2003??

Abubakarsb21-Dec-05 22:34

Abubakarsb

21-Dec-05 22:34

Hello !

I want to develop a setup file of my project in Visual Studio 2003 by using dotnetfrmawork 1.1 can anyone tell me this procdure in detail plz....

Email me at my email address abubakar.malik@gmail.com

Regards,

AbuBakar Malik

Re: How to make a Setup File in Visual Studio 2003??

Curtis Schlak.22-Dec-05 2:41

Curtis Schlak.

22-Dec-05 2:41

How about if you read Creating Setup and Deployment Projects in VS.NET?

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Get Table Column Description from SQLServer

freshonlineMax21-Dec-05 21:49

21-Dec-05 21:49

Hi Friends
I want to get All Columns Description From sample Table taht i created it in SqlServer Database. I used below code and it worked, but i dont know why it doesn't work now ?

<br />
string strSqlSELECT = "SELECT o.id AS 'ObjectID', " +<br />
		      "CAST(o.Name AS varchar(25)) AS 'TableName', " +<br />
		      "CAST(c.Name AS varchar(25)) AS 'ColumnName', " +<br />
		      "CAST(p.Value AS varchar(50)) AS 'Description', " +<br />
		      "Type = CASE WHEN p.Type=3 THEN 'Table' WHEN p.Type=4  THEN 'Column' ELSE 'UNKNOWN' END " +<br />
  		      "FROM dbo.sysobjects o " +<br />
		      "INNER JOIN dbo.sysproperties p" +<br />
		      " ON o.id = p.id " +<br />
		      "INNER JOIN dbo.syscolumns c " +<br />
	  	      " ON p.smallid = c.colorder " +<br />
		      "WHERE o.id = c.id " +<br />
		      "AND p.type = 4 " +<br />
		      "ORDER BY o.id, o.Name, p.smallid" ;<br />
<br />
       sqlDataAdapter sqlDA = new sqlDataAdapter (strSqlSELECT,Connection) ;<br />
       sqlDA.fill (myDataSet) ;<br />
       <br />
       for (int i=0;i<myDataSet.Tables[0].Rows.Count;i++)<br />
          MessageBox.Show (myDataSet.Tables[0].Rows[i][3].ToString()) ;<br />

Do you have better Idea (Another Code) ?
Thank You

-- modified at 3:56 Thursday 22nd December, 2005

Guffa21-Dec-05 21:57

21-Dec-05 21:57

Standard question #1:
What do you mean by "not working"?

---
b { font-weight: normal; }

freshonlineMax21-Dec-05 22:04

21-Dec-05 22:04

At running i got an error that means DataSet couldn't fill successfully.
I think strSqlSELECT is not correct and may be corrupted.

I want another SELECT Query to retrive Column Description from Table.
I want to set my DataGrid's Column Header to Tables Column's Description.

Please Help Me.

Guffa21-Dec-05 22:30

21-Dec-05 22:30

What error message did you get?

From your description it's impossible to say what's wrong, it could just as well be the connection that is faulty as the query. In that case it doesn't matter what query you use.

---
b { font-weight: normal; }

freshonlineMax22-Dec-05 3:12

22-Dec-05 3:12

Hello Again
I Traced my Project and i saw there was an error in below line :
sqlDA.Fill(myDataSet) ;

Error was :

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.

Now can you help me ?

-- modified at 9:13 Thursday 22nd December, 2005

Guffa22-Dec-05 7:43

Re: check data availability

22-Dec-05 7:43

Have you set up the connection object properly?

I tried to execute your query in query analyzer. It runs just fine, but it doesn't return anything. There is only a few of my databases that has anything in the sysproperties table, and no records with type=4.

---
b { font-weight: normal; }

check data availability

sardonicus21-Dec-05 21:35

sardonicus

21-Dec-05 21:35

hi all, am new to C# programming and i got a little problem.
i made a windows application form used for login to another form, it has "username" & "password" text boxes. it's connected to an Access database which stores the authorized usernames & passwords, so what i want is when the user clicks the "login" button..the program should check the user input whether it's found in the database, then it can tell user "access granted" or "access denied".
thnx in advance

enjoycrack21-Dec-05 21:39

Re: check data availability

21-Dec-05 21:39

Hi there,

Did you know how to connect to Access DB? if so, you just make an sql query to check if the user's input is valid or not...

<< >>

sardonicus21-Dec-05 21:45

sardonicus

21-Dec-05 21:45

yes i made the connection already.....so how can i make this sql query to check for data existence in table ?!

Re: check data availability

enjoycrack22-Dec-05 6:47

in one project how to get other forms' handle

22-Dec-05 6:47

you just build an simple SELECT sql query...For this, you can refer from SQL Book Online which installed along with MS SQL.

<< >>

ater_liu21-Dec-05 20:23

ater_liu

21-Dec-05 20:23

In one project,i have some forms,some form need send message to some others,so i need other forms' Hnadle,Thank you for you help!

Hello World!

Re: in one project how to get other forms' handle

enjoycrack21-Dec-05 21:29

Re: in one project how to get other forms' handle

21-Dec-05 21:29

Hi there,

This Win API might be what you need...

Hope it helps

<< >>

Bassam Saoud21-Dec-05 22:59

Bassam Saoud

21-Dec-05 22:59

That is correct.First declare a pointer and initialize it:
IntPtr FormHwnd=IntPtr.Zero;
Then get the form handle you are looking for by using the following winapi function:
[DllImport ("coredll.dll", EntryPoint="FindWindowW")]
public static extern IntPtr FindWindow (string Class, string Title);

Hope this helps.

Re: in one project how to get other forms' handle

enjoycrack22-Dec-05 6:55

Drop down control in .NET Data Grid

22-Dec-05 6:55

Hi there,

You should answer his thread, 'cause if you answer my thread, he'll not receive your answer Sniff | :^)

<< >>

Sheshadrinath21-Dec-05 20:06

Sheshadrinath

21-Dec-05 20:06

Hello,
I am writing the application in the .NET Windows application using C#. I want to insert a drop down box in a column of the datagrid. So, can anyone suggest me, how can I do this?

With Regards,
Sheshadrinath.R

Re: Drop down control in .NET Data Grid

freshonlineMax21-Dec-05 21:35

Closing or ending a process

21-Dec-05 21:35

Hi there
Go below in MSDN :
msdn.microsoft.com/msdnmag/ issues/03/08/DataGrids/default.aspx

for more information please mail me at : freshonline2003@yahoo.com

ckruger21-Dec-05 19:28

ckruger

21-Dec-05 19:28

I have opened a Excel spreadsheet with c# by using the Excel.Application class. After I have closed the excel file in windows by clicking on the X in the upper right hand corner, the process EXCEL.EXE stil remains.???

Re: Closing or ending a process

enjoycrack21-Dec-05 21:41