|
I have a textbox called "textBox6.text" in a C# Windows Application in Visual Studio, and i want that the text entered by the user in the textbox should be added to the "PURPOSE" field in a table "TABLE2_HDB1" in Oracle database "HDB1" on clicking a "submit" button.
the coding for submit button is as follows:-
private void button1_Click(object sender, EventArgs e)
{
string OracleStmt;
string ConString;
OleDbConnection cn = null;
OleDbCommand cmd = null;
try
{
OracleStmt = "insert into TABLE2_HDB1(PURPOSE) values(@PURPOSE)";
ConString = " Provider=MSDAORA;Data Source=HDb1;User Id=SYSTEM
;Password=*****;";
cn = new OleDbConnection(ConString);
cmd = new OleDbCommand(OracleStmt, cn);
cmd.Parameters.Add(new OleDbParameter("@PURPOSE", OleDbType.VarChar , 20));
cmd.Parameters["@PURPOSE"].Value = textBox6.Text;
cn.Open();
cmd.ExecuteNonQuery();
textBox8 .Text = "record inserted successfully";
}
catch (Exception ex)
{
textBox8 .Text = ex.Message;
}
finally
{
cn.Close();
}
}
on executing this code u get the error :-
ORA-00936:missing expression
plz. help
|
|
|
|
|
My Problem is when I debug my application I am getting broadcast messages from sever but not getting these broadcast when not in debugging mode.
portion of the code iss
do
{
byte[] myReadBuffer = new byte[tcpClient.ReceiveBufferSize];
int numberOfBytesRead = 0;
try
{
if ( networkStream.CanRead)
numberOfBytesRead = networkStream.Read(myReadBuffer, 0, myReadBuffer.Length);
}
catch (IOException)
{
networkStream = tcpClient.GetStream();
}
if (numberOfBytesRead!=0)
myCompleteMessage += System.Text.Encoding.ASCII.GetString(myReadBuffer,0,numberOfBytesRead);
}
while(networkStream.DataAvailable);
if (myCompleteMessage.Length!=0)
{
DeliverMessage(myCompleteMessage,"","","","");
RegisterCompletion();
myCompleteMessage="";
}
Close();
return true;
|
|
|
|
|
Hi friends,
I have 2 list box and a horizontal Splitter. When I resize the window, both the listbox does not resize proportionally. The top listbox remains in same height, the bottom listbox gets resized.
The properties for splitter is
cursor - HSplit
Dock - Top
The properties for listbox1 is
Dock - Top
Anchor - Top,Left
The properties for listbox2 is
Dock - Fill
Anchor - Top,Left
I tried changing the dock properties. It does not help me.
Please help me.
Thanks,
Thiaga
|
|
|
|
|
Hi Thiaga,
In order to get the desired resolution try setting the Dock property of first ListBox to Fill. This will ensure that the ListBox resizes proportionally to the window. Since the Dock property is set to Top, the width will resize in proportion to the window size.
Hope this helps.
Vinay
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
Hi,
I tried that option too. If the dock property of both the list box is set to FILL.
I can view only one listbox.
|
|
|
|
|
This is solved by using split container instead of splitter.
Thanks..
|
|
|
|
|
Use TableLayout, make 2 rows (1 column) and set the row height to 50% each. Dump the listboxes in each row.
Another way is to calculate the position of the splitter when the form size changes.
|
|
|
|
|
Do not cross post[^] 
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
I would like to know how one can install skins into applications built using Microst visual studio .NET 2005. Im currently coding using C#.NET. i've downloaded skin crager3 and skin engine but cant seem to get them to work.
Please help. are there any other simple rograms that can create skins and let me apply them to my applications?
Thanks.
|
|
|
|
|
One way to customize the appearance of an application is to override the toolstrip renderers. One of my articles might be able to help you with that: Custom ToolStrip Renderers[^]. However, if you want to go beyond that customization you will either have to buy a control suite with a skin engine or create your own skinning framework.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
I want the "label" for my checkbox (i.e. the text that you can click to check/uncheck the box) to have a link in it. My current solution is to put the empty string in the Text property of the checkbox, then just place a LinkLabel next to the checkbox where the "label" (i.e. Text) would normally be.
This doesn't work very well because clicking on the (non-hyperlinked parts of the) linklabel doesn't check/uncheck the checkbox. I suppose I could hack it with a Click event handler, but it seems like there must be a better way... I'm just not seeing it.
Any ideas?
Thanks!
-Domenic Denicola-
|
|
|
|
|
Hi Friends,
I need to create a windows application that will run in system tray, and should load on Startup.
It needs input of URL and value. Eg: www.google.com, and value=1,if Browser is opened with URL www.google.com?value=1 then application should give a message or say ballon tip.
Now all i am searching is which method is there which can know whether an explorer.exe or mozilla.exe has been opened. And read if the wanted URL is opened.
I see System.Diagnostics is used to start processes. I am trying to play around with it. I am not sure i am in the write direction.
Any suggestions related to this would be highly appreciated.
Cheers
Menon
|
|
|
|
|
Well I want I have password in my Form but I want to change it and how? what will you advice me
namespace WestNotePad
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void changePasswordToolStripMenuItem_Click(object sender, EventArgs e)
{
PasswordChange ps = new PasswordChange();
ps.ShowDialog();
}
}
}
namespace WestNotePad {
public partial class frnPassword : Form {
public frnPassword() {
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e) {
DialogResult = DialogResult.Cancel;
}
private void txtPassword_TextChanged(object sender, EventArgs e) {
}
private void button1_Click(object sender, EventArgs e) {
DialogResult = DialogResult.OK;
}
}
}
namespace WestNotePad
{
public partial class PasswordChange : Form
{
public PasswordChange()
{
InitializeComponent();
}
private void ChnButton1_Click(object sender, EventArgs e)
{
DialogResult = DialogResult.OK;
}
}
}
namespace WestNotePad
{
static class Program
{
public static bool a = true;
///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
int n = 0;
m:
if (ValidatePassword())
{
if (a)
{
Application.Run(new Form1());
}
}
else
{
n++;
while (n<4)
{
MessageBox.Show("Erorr");
goto m;
}
}
}
private static bool ValidatePassword()
{
if (string.IsNullOrEmpty(Settings1.Default.Password))
{
return true;
}
frnPassword f2 = new frnPassword();
if (f2.ShowDialog() == DialogResult.OK)
{
return f2.txtPassword.Text== Settings1.Default.Password;
}
else
{
a = false;
}
return true;
}
}
}
Settings1.cs
Password | string | User | ABCD
C# Developer
|
|
|
|
|
I've hit a stumbling block on trying to figure out this problem. I have a winform app written in C# that was started back with 1.0 frame, then upgraded to 1.1, and recently I created a test 3.5 version. The deployed app is still the 1.1 as we have a lot of old 98 machines several of which don't want to upgrade to the 2.0 framework.
Here's the simplified code that I'm having problems with:
//1
PrintDocument printDocument1=new PrintDocument();
printDocument1.PrinterSettings.PrinterName=LastPrinterName;
//2
PrinterSettings ps=printDocument1.PrinterSettings;
PageSettings dps=ps.DefaultPageSettings;
string defaultsourcename=dps.PaperSource.SourceName;
//3
foreach(PaperSource p in ps.PaperSources)
comboBoxPaperSources.Items.Add(p.SourceName);
//4
string defaultsizename=dps.PaperSize.PaperName;
//5
foreach(PaperSize p in ps.PaperSizes)
comboBoxPaperSizes.Items.Add(p.PaperName);
//6
Basically my software has some 280 different reports and different ones go to different printers and to different sizes of paper. So the full code brings up an option screen that remembers the last settings and allows the user to store the settings for the specific report section and select a checkbox to not ask them for settings the next time they generate the report. The comments with numbers are to help identify how long it takes to do each section.
On my machine, a dual-core Server 2008 64 bit 4 gigs of ram, 8 printers set up, my 3.5 version in release mode takes this long:
1->2 0ms
1->3 31.2ms
1->4 46.8ms
1->5 78ms
1->6 109.2ms
On another Vista 32 bit machine, 2 gigs of ram, 12 printers set up, my 1.1 version in debug mode:
1->2 0ms
1->3 73ms
1->4 101ms
1->5 201ms
1->6 289ms
On my machine in a Hyper-V XP 32 bit window, 7 printers set up, using my 1.1 version in debug mode:
1->2 0ms
1->3 78.08ms
1->4 93.7ms
1->5 171.79ms
1->6 234.26ms
On my bosses new machine he received last week, a quad-core Vista 32 bit, 3 gigs of ram, 2 printers set up, my 3.5 version in release mode:
1->2 0ms
1->3 4,056ms
1->4 6,864ms
1->5 11,856ms
1->6 15,600ms
Using the 1.1 debug version puts 1->6 up to 17,255ms
Obviously, there's some sort of titanic problem with my bosses machine. The machine itself is incredibly fast. Every other operation in my software beats the tar timing-wise compared to my machine. As soon as it touches printers, it craps out. Wordpad/notepad/word/excel/acrobat/etc all seem to pull up printers fine. The machine is pretty "clean", all the crapware was uninstalled off of it, no virus scanner running, I've task manager killed everything non-critical. I've deleted all his printers out, reinstalled just the Microsoft XPS Document Writer. I've cleared out his temp folders and run a chkdsk. I've eliminated all the standard "this is why its slow" reasons that I know of. If it had been any other program on the machine, I would think its a windows issue, but since its just my software I'm stuck.
Does anyone have any suggestions on where to go from here?
It doesn't seem to be Vista 32 bit.
It doesn't seem to be number of printers.
It doesn't seem to be amount of ram.
It doesn't seem to be something running in the background.
It doesn't seem to be disk or printer corruption
It not affecting any "mainstream" apps
It doesn't seem to be a specific .NET framework version
So I don't know if its
Quad core and .NET
Some chunk of code I'm missing
Something I haven't thought of.
|
|
|
|
|
Hi,
my guess is the slow machine has one or more printers set up that are hard to find, networked ones e.g.
so it takes a long time building the list of available printers or whatever other information it needs
to respond to your code. So check the list of installed printers. Or (temporarily) remove most of them.
|
|
|
|
|
Already tried that. I went down to having nothing but a local "virtual" printer(the XPS document writer that comes with Vista). Didn't change the speed very much.
|
|
|
|
|
Dear sir,
I am developing one windows application , in this we are using visual studio.net 2005, c#.net .
I have msi file package & set up file for this application.
To run the application I need windows encoder set up also.
So, Externally I install windows encoder set up also
Now my application is ready but In this situation, when I give it to client I ask him to install “windows media encoder “ also. Other wise I will go to customer home & I install both my set up and windows media encoder.
My requirement:
I want to make my msi file & setup automatically install the “windows media encoder” also , when customer install my setup.
How can I done this.
Similarly , when I uninstall my set up, it automatically uninstall windows media encoder also.
Please help me by giving solution for this.
Thank you ,
|
|
|
|
|
I have a DataGridView on a form with a number of columns that are calculated and hence set to readonly. What I wanted was to have these columns skipped whenever the user entered them. I thought to use the OnEnter event to test the readonly attribute of the current cell and set the currentcell to the next one. A problem arose using this methed in that by changing the currentcell in the event handler, I was invoking the non-reentrant changedcell method. Instead I resorted to a SendKeys.Send("{tab}") instead and this appears to work.
|
|
|
|
|
I had this same issue a while back. I did some searching and posted on forums and the SendKeys.Send("{Tab}") solution was the only one I was able to find. Let me know if you find something better.
|
|
|
|
|
This is the error which I am getting in this line-->dgDataItemgrp.DataMember = "myTable.RelLicData";
dsetView = dset.DefaultViewManager;
dgDataItemgrp.DataSource = dsetView ;
dgDataItemgrp.DataMember = "myTable.RelLicData";
DataRelation relLicData;
DataColumn colMaster1 = new DataColumn();
DataColumn colDetail1 = new DataColumn();
colMaster1 = this.dset.Tables["myTable"].Columns["LicensegroupID"];
colDetail1 = this.dset.Tables["myTable1"].Columns["LicensegroupID"];
relLicData = new DataRelation("RelLicData", colMaster1, colDetail1);
dset.Relations.Add(relLicData);
any clue what can be the reason ?
|
|
|
|
|
Hi I have one question, in my code if pasword is incorrect, when I click Ok, I want to change label like that "your password is incorrect"
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Drawing.Printing;
using System.Security;
namespace WestNotePad
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
...
public bool isModificed()
{
if (textBox1.Text==String.Empty)
{
return true;
}
else
{
return false;
}
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace WestNotePad {
public partial class frnPassword : Form {
public frnPassword() {
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e){
DialogResult = DialogResult.Cancel;
}
private void button1_Click(object sender, EventArgs e){
DialogResult = DialogResult.OK;
}
using System;
using System.Collections.Generic;
using System.Windows.Forms;
namespace WestNotePad
{
static class Program
{
public static bool a = true;
///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
if(ValidatePassword()) {
if(a) {
Application.Run(new Form1());
}
}
else
{
// MessageBox.Show("Erorr!");
<br />
here I wont my questions answer plz<br />
}
}
private static bool ValidatePassword()
{
if(string.IsNullOrEmpty(Settings1.Default.Password)) {
return true;
}
frnPassword f2 = new frnPassword();
if(f2.ShowDialog()==DialogResult.OK) {
return f2.txtPassword.Text==Settings1.Default.Password;
}
else {
a = false;
}
return true;
}
}
}
thx
C# Developer
|
|
|
|
|
label1.text = "whatever you want";
replace label1 with whatever you label is called
Bob
Ashfield Consultants Ltd
|
|
|
|
|
what you suggested me, I have already done, but It's not work...
C# Developer
|
|
|
|
|
Try adding
label1.Refresh();
after setting the text.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
frnPassword f2 = new frnPassword();
f2.label1.Text = "Error";
f2.label1.Refresh();
like that??
but It's not work again 
C# Developer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
