|
public SqlDataReader listArticlesByPopularity(int howmanyrows)
{
// Create Instance of Connection and Command Object
SqlConnection conn = new SqlConnection(this.ConnectionString);
SqlCommand cmd = new SqlCommand("GenerateScript", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param= new SqlParameter("@server", SqlDbType.NChar,32);
param.Value = "server";
cmd.Parameters.Add(param);
...
param = new SqlParameter("@filename", SqlDbType.NChar,64);
param.Value = "c:\File_Name.sql";
cmd.Parameters.Add(param);
// Execute the command
conn.Open();
SqlDataReader result = cmd.ExecuteReader(CommandBehavior.CloseConnection);
// Return the datareader result
return result;
}
Live Life King Size
Alomgir Miah
|
|
|
|
|
I have 2 forms frst: containing DataGrid and snd:Containg filter fields.
i need to open the second form and applay a filter on the DataGrid.
the 2 forms must be opend at the same time.
Abdalah
|
|
|
|
|
This is the first time I am programing to read the contents of mail from outlook. I am using Microsoft Outlook 11.0 Library which comes with Outlook 2003. I am able to read the emails and its conents but I am not able to read the attachments. Can anybody help me out please.
SVSP
|
|
|
|
|
Hi Man,
I read you question but i am not able to answer you infact i have a request to you if you kindly tell me how you actually use Outlook library and able to read the mails. If possible you send me code..
I shell be very thankfull to you.
Muhammad Waqas Butt
waqasb4all@yahoo.com
|
|
|
|
|
Hey guys, I have a makefile called "makefile" with the following contents
all: RemoteAssembly.dll
RemoteAssembly.key:
sn -k RemoteAssembly.key
RemoteAssembly.dll: RemoteAssembly.cs RemoteAssembly.key
csc /t:module RemoteAssembly.cs
al /v:1.0.0.0 /keyfile:RemoteAssembly.key \
/out:RemoteAssembly.dll RemoteAssembly.netmodule
clean
-del *.netmodule
-del *.dll
What is the correct syntax for using nmake on makefile.
I type "nmake.exe:makefile" on the .NET command prompt on the directory where I stored all the dependents and the makefile.
But, they said the filename, directory name or volume label syntax is incorrect.
|
|
|
|
|
Why mouse wheel message doesn't work?
I made a control, derived from Form, and want to carry messages of mouse, i made all except mouse wheel... What's wrong?
|
|
|
|
|
hello
i have 2 forms .
how do i change form2 button control text from form1?
what interface do i need to add?
thanks
Have a nice Day
|
|
|
|
|
There are three steps involved in using form to form communication:
1. Create a reference to form2 from form1.
2. Set your reference equal to your instance.
3. Set your control to public.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1. Since we are dealing with objects here, you have to make sure they know about each other (at least form1 knows about form2). The way to do this is to create a reference to form2 from form1:
public class Form1 : System.Windows.Forms.Form<br />
{<br />
private Form2 form2 = new Form2();<br />
...}
2. Setting your reference to the instance of form2. Something like this:
private void button1_Click(object sender, System.EventArgs e)<br />
{<br />
Form2 frm2 = new Form2();<br />
frm2.Show();<br />
form2 = frm2;<br />
}
3. Set the control to public (in form2):
public class Form2 : System.Windows.Forms.Form<br />
{<br />
public System.Windows.Forms.Button button1;<br />
...}
NOTE: your autogenerated code should already have a definition of the button1 but it will be set to private, what you are doing here is changing it to public.
Any question let me know.
Peter Corcoran
peter@corcoranp.com
www.corcoranp.com
|
|
|
|
|
Thank you very much
exactly what i needed
Have a nice Day
|
|
|
|
|
I want to encode some url parameter in my Windows Form Application but
I can't use System.Web.HttpServerUtility or System.Web.HttpUtility from my application. Please help me.
|
|
|
|
|
Add a reference to the System.Web dll.
---
b { font-weight: normal; }
|
|
|
|
|
Add System.Web.dll using Refrence folder context menu. And then try to refer in your application
Using System.Web;
private void button1_Click(object sender, System.EventArgs e)<br />
{<br />
MessageBox.Show(System.Web.HttpUtility.HtmlDecode("http://www.codeproject.com"));<br />
}<br />
Sreejith Nair
[ My Articles ]
|
|
|
|
|
Hello there
I am new in CSharp. I created a doubleClick event and attached it with multiple controls. Now I want to get the name of the control when user double clicks. in the event I have Sender as object and when I write Sender.Name or any other property it gives error that Object Does not Contain the definition of Name. Please Guide me how to get the name or how to convert the object into the required control. for eg panel control.
Rizwan Bashir
|
|
|
|
|
Try to cast your 'sender' to you known type.
Eg:
private void Form1_DoubleClick(object sender, System.EventArgs e)<br />
{<br />
Form frm=sender as Form;<br />
if(frm!=null)
MessageBox.Show(frm.Name);<br />
}
Sreejith Nair
[ My Articles ]
|
|
|
|
|
Just cast it to Control, it should work. Unless you are firing events and providing some other object as the sender.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
Hello All,
I am currently working in Honeywell and developing Licensing Utility .
I am in a stage where I want to decrypt a previously encrypted file in VC++ in C# i.e. file encrypted in VC++ using windows cryptAPI and to be decrypted in C# . The problem is that in VC++ we create hash using CryptCreateHash , then add to it secret password using CryptHashData and then derive session key based on tht has hash key . The session key is further used for encryption and decryption .
In C# , I found the basic encryption / decryption classes , setting of IV , key etc but I did find anything related to the hash key . In VC++ we are using RC2 for cryptography of plaintext and MD5 for hash key .
Pls helpme out guys !
|
|
|
|
|
|
Hey , Those are the links for Cryptography APi in VC++ , actually i'm successfully encrypting in VC++ as well as c# ,but i'm having problems decrypting a file in c# which is previously encrypted in vc++ .
Anyways Thnx for the reply !
Amey
|
|
|
|
|
|
Hello
i hope it desn't sound like a dumb question ..
i have application which i want to have several forms the first one will create the second and will hide and when second is disposed i want to show the first one.
both of them are toplevel forms .
when i try the following code i get an error :"Cannot add a top level control to a control"
Form a1 = new Form2();<br />
<br />
a1.Parent = this;<br />
a1.Show();
any help will do .
i want to be able to unhide the Form1 from form2.
Thanks
Have a nice Day
|
|
|
|
|
Create a new constructor for Form2 with a form1 parameter
Form2(Form1 frm1)
{
}
when opening form2, hide form1 and when closing form2 show form1
|
|
|
|
|
thanks a lot
i will try this as soon as possible
Have a nice Day
|
|
|
|
|
Good
|
|
|
|
|
WORKS GREAT 
Have a nice Day
|
|
|
|
|
Hello All,
I have 2 text boxes for User Name and Password. After I enter User Name and Password and try to validate. The below code throws the error "Input String is not in correct format" for password field.
string sSQL = "SELECT USR_Password FROM Users WHERE USR_LogonID = '" + userName + "'";
cmd = new OdbcCommand(sSQL, con);
cmd.Parameters.Add( "@userName", OdbcType.NVarChar, 8 );
cmd.Parameters["@userName"].Value = userName;
// Execute command and fetch pwd field into lookupPassword string.
lookupPassword = (string) cmd.ExecuteScalar();
lookupPassword = System.Convert.ToString(lookupPassword).Trim();
Could anyone please tell me what is wrong with the code...
Thanks in advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
