|
Try this sample code
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlConnection();
cmd.CommandText ="your query";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
datagridview1.DataSource = ds;
Regards,
Karthik K...
|
|
|
|
|
Hi,
I have created a Windows Form as "usercontrol" using vs.net 2003 with c#. In that Form I placed a Panel and below a horizontal scrollbar control. While I am trying to view the extreme right content of the Panel with the help of horizontal scroll bar the panel content is not viewable.(ie Panel content is not moving left- right)
And also I set "this.pnlWorkArea1.AutoScroll = true;" and its showing scrollbar but its not moving beyond the current viewable area.
Example: From the panel i am plotting graph with numbers 1 to 40 only its viewable up to 25.
Please advice me.
Thanks,
Palanivel
|
|
|
|
|
Hi,
I have a grid that displays multiple images (the grid can scroll horizontally and vertically)
At runtime I draw rectangles on each of the images which i intend to act as buttons.
I want to perform functions when when the user clicks on these drawn images.
How can I get the coordinates of the click event relative to the location of the cell? ie assuming the top left of each cell is 0,0
Thanks,
Chas
|
|
|
|
|
Found the answer:
it was the CellMouseClick event e.X and e.Y...
|
|
|
|
|
Hi,
How to erase a windows event log file programmatically.
Any idea..
Thanks
Md. Marufuzzaman
|
|
|
|
|
Assuming you have the relevant permisions, you can use EventLog.Delete to delete a particular log. Here's how I figured it out (who knows, this thought process may help you):
First of all, I thought to myself - this is an operation on the EventLog. Now, I know that there is an EventLog class, but if I hadn't known this the name would have seemed a logical place to start.
Then I thought - perhaps it has a DeleteLog entry.
I typed EventLog.DeleteLog into Google, and it suggested that it should actually be EventLog.Delete.
From there, I hopped over to the docs just to check that it was the item I thought it was - job done.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
You should buy a lottery ticket today 
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hi,
Whenever I tried to sort the mail item, it does not effect.
Microsoft.Office.Interop.Outlook.MAPIFolder mItem = TraverseTee(outlook.Session.Folders, "myfolder");
if(mItem!=null)
{
mItem.Items.Sort("Received", false);
int i=0;
foreach(Microsoft.Office.Interop.Outlook.MailItem item in mItem.Items)
{
listBox1.Items.Insert(i,item.Subject);
i++;
}
}
|
|
|
|
|
Hello,
I can't seem to find a solution that would allow me to connect through a chain of proxies using HttpWebRequest object. HttpWebRequest class does have a Proxy property but it only allows you to assign a single Proxy hop and this works as expected. What I need though is to create a connection throgh 3 proxy servers and I would like to know if this is possible with HttpWebRequest. If not I would like to know if there is any other way of doing this in .NET 3.5, maybe an open source library, or an example, anything that would help. If even this does not exist I would like to know if there are any open source 3rd party tools that would allow me to do this.
Thank you for your answers in advance
Yours sincerely,
Andrea
|
|
|
|
|
My application having two datagrids-->datagrid1 and datagrid2
datagrid1 is having ID,FileName,Comments columns
datagrid2 is having FileName column.
i wantt to drag and drop value from datagrid1 to datagrid2.
can anyone help me
|
|
|
|
|
private void datagrid2_DragEnter(object sender, DragEventArgs e)
{
if (e.Data.GetDataPresent(typeof(DataGridViewRow)))
{
e.Effect = DragDropEffects.Copy;
}
}
private void datagrid2_DragDrop(object sender, DragEventArgs e)
{
DataGridViewRow row = e.Data.GetData(typeof(DataGridViewRow)) as DataGridViewRow;
if (row != null)
{
DataGridViewRow newrow = row.Clone() as DataGridViewRow;
//for (int i = 0; i < newrow.Cells.Count; i++)
//{
newrow.Cells[0].Value = row.Cells[1].Value;
//}
//this.datagrid2.Rows.Add(newrow);
datagrid2.Rows.Add(newrow);
}
}
private void datagrid1_MouseMove(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Left)
{
this.gvDocuments.datagrid1(this.gvDocuments.CurrentRow,
DragDropEffects.All);
}
}
|
|
|
|
|
i having a smartcard of 4kb but i have only 800 bytes
hw can i compress webcam image into less then 1 kb
nd store it to smart card
becoze this card having some fields like name address etc. nd the fingure prints
but we need to store a image to webcam nd store it in smart card anyone can help me?????????
i must hav to store it i have only 800 byte free in smart card
modified on Thursday, July 16, 2009 5:25 AM
|
|
|
|
|
shekhar258395 wrote: hw can i compress webcam image into less then 1 kb
Dont you think, 1 KB for a any image file is too ambitious. 
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
You've asked this before. The answer is, make the image REALLY small, and store it in a compressed format. greyscale jpeg is probably a good choice.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Dear Friends,
I stuck at a point, to download a file from HTTPS site.
I have a secured web site https/www.mySite.com/.
I havent any idea which Certificate that server is using.
I just want to down load a file from that site.
For that I have written the code:
private static bool ValidateRemoteCertificate(<br />
object sender,<br />
X509Certificate certificate,<br />
X509Chain chain,<br />
SslPolicyErrors policyErrors<br />
)<br />
{<br />
<br />
if (policyErrors == SslPolicyErrors.None)<br />
return true;<br />
else<br />
return false;<br />
<br />
<br />
));<br />
<br />
but it always shows the error "System.Net.Security.SslPolicyErrors.RemoteCertificateNameMismatch"
and if i forcefully return true it works fine...
what is proper solution??????
thnaks in advance
|
|
|
|
|
If you are happy to disable the checking of the certificate (not recommended) then use something like
ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(
delegate
{
return true;
});
If you are using a WebClient for instance, it should go just before you do the call that will connect (i.e. client.UploadFile(), client.UploadValues(), etc)
|
|
|
|
|
Hi
please check my coding and guide me why record not insert
my coding is
OdbcConnection cn;
OdbcCommand cmd;
OdbcDataReader odr;
string MyString;
MyString = "Select empid , sysdte from timemgmt";
if (radioin.Checked == true)
{
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl8i;UID=itehad;PWD=creative;");
cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "Select empid , sysdte from timemgmt where empid = '"+textBox1.Text+"' and sysdte ='"+label19.Text+"'";
//MessageBox.Show("Connected");
//cmd.CommandText = "select empid,sysdteinsert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";//,'" + label18.Text + "','" + label18.Text + "')";
//MessageBox.Show(cmd.CommandText);
//cmd.ExecuteNonQuery();
odr = cmd.ExecuteReader();
while (odr.Read())
{
if (textBox1.Text == (odr["empid"].ToString()) && label19.Text == (odr["sysdte"]).ToString())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
}
}
cn.Close();
|
|
|
|
|
It would be helpful if you posted the error generated!
This assumes there are only 4 field in the table.
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
If there are more you need
cmd.CommandText = "insert into timemgmt (field1, field2, field3, field4) values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I give feild name like this
cmd.CommandText = "insert into timemgmt values(empid,sysdte,intime,outtime)('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
no record Insert 
And no error show
please guyz help me
|
|
|
|
|
There is a error in insert statement
try this
cmd.CommandText = "insert into timemgmt(empid,sysdte,intime,outtime) values ('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
Regards,
Karthik K...
|
|
|
|
|
No my problem is not solve
ok tell me how i search record in oracle database if record find record not save else save record
i code this for search record
cmd.CommandText = "Select empid , sysdte from timemgmt where empid = '"+textBox1.Text+"' and sysdte ='"+label19.Text+"'";
then i create condition like this
while (odr.Read())
{
if (textBox1.Text == (odr["empid"].ToString()) && label19.Text == (odr["sysdte"]).ToString())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt values(empid, sysdte, intime, outtime)('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
}
|
|
|
|
|
mjawadkhatri wrote: cmd.CommandText = "Select empid ,sysdte from timemgmt where empid = '" + textBox1.Text + "' and sysdte ='" + label19.Text + "'";
your search query is ok.
After that use like this way,
if(odr.read())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt empid, sysdte, intime, outtime) values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
}
Try the above code.Use the Breakpoints and try to rectify where the error comes.
Regards,
Karthik K...
|
|
|
|
|
I already told you to use the 'code block' tags when posting code
(see here[^] )
I also already told you to use parameters (to prevent sql-injunctions). Not only are they safer they will also prevent a lot of errors.
|
|
|
|
|
Where to start?
- Give your variables meaningful names. At a glance, what does textBox1 do?
- Your code is wide open to a SQL Injection attack. You need to look into using parameterised queries here.
- Your insert statement does nothing. You create the command text and then close the connection - you need to execute the command using cmd.ExecuteNonQuery();
- You have no exception handling. What happens if you can't connect the database, for instance?
If you had bothered to debug your code, you would have found the problem out in an instant. Learning to debug is one of the most valuable lessons you can master as a developer, and you should learn how to do it before too much longer.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hello Everyone,
I wrote an application which send and receive data from a pinpad(device with RS-232 which use serial port) and i start testing the application, when i finised testing the application on my computer, I upload it to the server machine to do another test but when I run the application from client computers it does not recognize the pin pad, but when I run the application from my computer it works properly. My question is that is there any way I can access the pin pad remotely?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
