C# Discussion Boards - CodeProject

Re: Get Table Column Description from SQLServer

Guffa21-Dec-05 21:57

Guffa

21-Dec-05 21:57

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

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

Re: Get Table Column Description from SQLServer

freshonlineMax21-Dec-05 22:04

freshonlineMax

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.

Re: Get Table Column Description from SQLServer

Guffa21-Dec-05 22:30

Guffa

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; }

Re: Get Table Column Description from SQLServer

freshonlineMax22-Dec-05 3:12

freshonlineMax

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

Re: Get Table Column Description from SQLServer

Guffa22-Dec-05 7:43

Guffa

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

Re: check data availability

enjoycrack21-Dec-05 21:39

enjoycrack

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...

<< >>

Re: check data availability

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

enjoycrack

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.

<< >>

in one project how to get other forms' handle

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

enjoycrack

21-Dec-05 21:29

Hi there,

This Win API might be what you need...

Hope it helps

<< >>

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

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

enjoycrack

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 | :^)

<< >>

Drop down control in .NET Data Grid

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

freshonlineMax

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

Closing or ending a process

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

enjoycrack

21-Dec-05 21:41

Did you click on X of the main form or just close a document ?

<< >>

Re: Closing or ending a process

ckruger21-Dec-05 21:44

ckruger

21-Dec-05 21:44

Yes, basically the user does...

Re: Closing or ending a process

ckruger21-Dec-05 22:20

ckruger

21-Dec-05 22:20

Sorry! I've clicked on X of the main form.

Re: Closing or ending a process

enjoycrack22-Dec-05 6:48

enjoycrack

22-Dec-05 6:48

lol, OK ... Happy Coding Rose | [Rose]

<< >>

Re: Closing or ending a process

ckruger21-Dec-05 22:21

ckruger

21-Dec-05 22:21

Sorry! I've clicked on X of the main form.

Re: Closing or ending a process

Maqsood Ahmed22-Dec-05 0:54

Maqsood Ahmed

22-Dec-05 0:54

Hello,
Please try to do this in Closing event of the main form.

if(excelApplication != null && excelApplication.Workbooks.Count > 0)<br />
{<br />
    foreach(Workbook wb in excelApplication.Workbooks)<br />
    {<br />
       wb.Close(false,Type.Missing,Type.Missing);         <br />
    }<br />
    excelApplication.Quit();<br />
    excelApplication.Visible = false;<br />
}

where excelApplication is an Excel.ApplicationClass object.

HTH. Cheers Smile | :)

Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net

Datagrid problem

yaminilathatv21-Dec-05 19:19

yaminilathatv

21-Dec-05 19:19

Hi everyone, i have a problem indatagrid.Here is the code below and my problem is i want to retrieve the data from database on to the datagrid based on the selection of dropdowlist. After me selecting the dropdownlist option, datagrid is not displayed. Please help me where am i doing wrong.

private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
connectdb();
Cmd.CommandText = "Select * from emp order by Empno where Dept='" + DropDownList1.SelectedItem.Value.ToString() + "'";
da.SelectCommand = Cmd;
da.Fill(ds,"Emp");
DataGrid1.DataSource = ds;
DataGrid1.DataMember = "Emp";
DataGrid1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
Con.Close();
}

thanx in advance
yamini

Re: Datagrid problem

albCode21-Dec-05 21:21

albCode

21-Dec-05 21:21

try this

private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
SqlConnection con = new SqlConnection("ur connection string");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from emp order by Empno where Dept='" + DropDownList1.Value.ToString() + "'",SqlConnection);
//connectdb();
//Cmd.CommandText =
//da.SelectCommand = Cmd;
DataSet ds = new DataSet();
da.Fill(ds,"Emp");
DataGrid1.DataSource = ds.Tables["emp"];
//DataGrid1.DataMember = "Emp";
DataGrid1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
Con.Close();
}

IR Remote Control, Help....WM_APPCOMMAND

Xodiak21-Dec-05 18:22

Xodiak

21-Dec-05 18:22

Alright, I'm trying to integerate an IR remote control into one of my apps.

I used Spy++ to try to figure out what messages were being sent to the app. The WM_APPCOMMAND message is begin sent.

But this message is being sent for the every media key. i read somewhere that you ahve to use GET_APPCOMMAND_LPARAM(lparam) to get the unique media key but i dont know how to implement this in C#.

I am currently overloading the WndProc(ref Message m) even and attempting to do something when the message == WM_APPCOMMAND...but again i dont know how to differentiate between the different WM_APPCOMMAND's....

Play...Stop....Next Track....Previous Track....are all the same message...help guys.

-- modified at 0:30 Thursday 22nd December, 2005

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