|
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; }
|
|
|
|
|
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
|
|
|
|
|
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; }
|
|
|
|
|
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
|
|
|
|
|
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...
<< >>
|
|
|
|
|
yes i made the connection already.....so how can i make this sql query to check for data existence in table ?!
|
|
|
|
|
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,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!
|
|
|
|
|
Hi there,
This Win API might be what you need...
Hope it helps
<< >>
|
|
|
|
|
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.
|
|
|
|
|
Hi there,
You should answer his thread, 'cause if you answer my thread, he'll not receive your answer
<< >>
|
|
|
|
|
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
|
|
|
|
|
|
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.???
|
|
|
|
|
Did you click on X of the main form or just close a document ?
<< >>
|
|
|
|
|
Yes, basically the user does...
|
|
|
|
|
Sorry! I've clicked on X of the main form.
|
|
|
|
|
lol, OK ... Happy Coding
<< >>
|
|
|
|
|
Sorry! I've clicked on X of the main form.
|
|
|
|
|
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
Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net
|
|
|
|
|
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
|
|
|
|
|
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();
}
|
|
|
|
|
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
|
|
|
|
|
The Message[^] structure that gets passed to the WndProc method has LParam and WParam properties. You need to look into how GET_APPCOMMAND_LPARAM(lparam) is implemented to get the value out of the LParam property.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
figured it out, there is a lparam property in the message structure that i have to interperet AFTER i catch on the wparam property of app_command....a long int get returned. simple switch statement and i got it all working. thanks for your help
|
|
|
|