|
Hi
I have done a c# program , such that my program reads any schema file and inserts values for that fields in a new xml file. ie, for exx : for the datatype string (john mathew1, john mathew2,..) for decimal(900.90, 900.89/..) like so on for about 200 values for every datatypes.
Now, I require you to build a program further. Imagine that you have an xml file which is just a list of values for a single field. Then within my program if I come across that particualr field , then I have to load the values from that xml file into the output file.
Here is my coding which i had done previously. please give me an idea how to give the coding.
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Xml;
using System.Xml.Schema;
namespace testdatagenerator
{
///
/// Summary description for Form1.
///
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox txtSchema;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.TextBox txtXml;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Data.DataSet dataSet1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
///
/// Required designer variable.
///
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
///
/// Clean up any resources being used.
///
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.txtSchema = new System.Windows.Forms.TextBox();
this.button1 = new System.Windows.Forms.Button();
this.txtXml = new System.Windows.Forms.TextBox();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.dataSet1 = new System.Data.DataSet();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
this.SuspendLayout();
//
// txtSchema
//
this.txtSchema.Location = new System.Drawing.Point(232, 24);
this.txtSchema.Name = "txtSchema";
this.txtSchema.Size = new System.Drawing.Size(368, 20);
this.txtSchema.TabIndex = 0;
this.txtSchema.Text = "";
//
// button1
//
this.button1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.button1.Location = new System.Drawing.Point(616, 24);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(64, 23);
this.button1.TabIndex = 1;
this.button1.Text = "Browse";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// txtXml
//
this.txtXml.Location = new System.Drawing.Point(232, 64);
this.txtXml.Name = "txtXml";
this.txtXml.Size = new System.Drawing.Size(368, 20);
this.txtXml.TabIndex = 2;
this.txtXml.Text = "";
//
// button2
//
this.button2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.button2.Location = new System.Drawing.Point(616, 64);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(64, 23);
this.button2.TabIndex = 3;
this.button2.Text = "Load";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.button3.Location = new System.Drawing.Point(696, 64);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(64, 23);
this.button3.TabIndex = 4;
this.button3.Text = "Save";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.DataSource = this.dataSet1;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(0, 120);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(776, 320);
this.dataGrid1.TabIndex = 5;
//
// dataSet1
//
this.dataSet1.DataSetName = "NewDataSet";
this.dataSet1.Locale = new System.Globalization.CultureInfo("en-US");
//
// label1
//
this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.label1.Location = new System.Drawing.Point(32, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(184, 23);
this.label1.TabIndex = 6;
this.label1.Text = "Enter the Xml Schema";
//
// label2
//
this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.label2.Location = new System.Drawing.Point(32, 64);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(192, 23);
this.label2.TabIndex = 7;
this.label2.Text = "Enter the Xml file";
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(808, 454);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.txtXml);
this.Controls.Add(this.button1);
this.Controls.Add(this.txtSchema);
this.Name = "Form1";
this.Text = "TestDatagenerator";
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
this.ResumeLayout(false);
}
#endregion
///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void button1_Click(object sender, System.EventArgs e)
{
OpenFileDialog fdlg = new OpenFileDialog();
fdlg.Title = "select schema file" ;
fdlg.InitialDirectory = @"c:\CDEV\testdatagenerator" ;
fdlg.Filter = "schema files(*.xsd) |*.xsd| all files(*.*) | *.*";
fdlg.FilterIndex = 2 ;
fdlg.RestoreDirectory = true ;
if(fdlg.ShowDialog() == DialogResult.OK)
{
txtSchema.Text = fdlg.FileName ;
}
}
private void button2_Click(object sender, System.EventArgs e)
{
dataSet1.ReadXmlSchema(txtSchema.Text);
foreach (DataTable dTbl in dataSet1.Tables)
{
for(int j = 0; j <= 200; j++)
{
object[] oValues = new object[dTbl.Columns.Count];
int i = 0 ;
foreach (DataColumn dColmn in dTbl.Columns)
{
switch(dColmn.DataType.ToString())
{
case "System.String":
oValues[i] = (string) "Castle Hampers" + j;
break;
case "System.Int32":
oValues[i] = (int) 100 + j;
break;
case "System.DateTime":
oValues[i] = new DateTime(2004,01,30).AddDays(j * 1);
break;
case "System.Decimal":
oValues[i] = new Decimal(10000900.99) + j;
break;
case "System.Int16":
oValues[i] = (short) 32767 - j;
break;
case "System.Int64":
oValues[i] = (long) 400 - j;
break;
case "System.Double":
oValues[i] = (double) 888888 - j;
break;
case "System.Single":
oValues[i] = (float) 4.5f + j;
break;
}
i = i+1;
}
dTbl.Rows.Add(oValues);
}
}
}
private void button3_Click(object sender, System.EventArgs e)
{
dataSet1.WriteXml(txtXml.Text,XmlWriteMode.WriteSchema );
MessageBox.Show("Saved");
}
}
}
john santhosh
|
|
|
|
|
Hi Folks!
I was wondering if I could know about any mechanism for selection of language in prgramming e.g. C#. By language selection I mean that if we have more than one languages installed on WindowsXP(Contorl Panel -> regional n .. ***), a language bar appears there to provide a choice of language selection.
Any one knowing if it possible....thanku inadvance;)
+Solo
|
|
|
|
|
The short answer is that you typically shouldn't. Giving users a consistent UI for control tasks is important for user understand. In some cases doing this yourself can lead to problems if you don't do everything required. For example, setting the UI language (MUI language) requires the user session to end via a reboot or having the user simply log off and back on.
On MUI-supported Windows desktop platforms you can't set the UI language (though you can set the locale). You can on Windows CE-based platforms like Pocket PC, however, by P/Invoking SetUserDefaultUILanguage.
Depending on what you're doing, though, you don't need to do this. If you only want to display a different language and/or locale for your application via the built-in localization features, simply set Culture.CurrentUICulture and/or Culture.CurrentCulture to change the language and/or locale, respectively, for the current thread. Do this before displaying any UI, otherwise you'll need to re-initialize (not necessary re-instantiate) any controls.
Read Developing World-Ready Applications[^] in the .NET Framework SDK for more information.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
can someone give me some clues as to how to do this?
|
|
|
|
|
I would recommend searching the forum first by click "Search comments" above. This topic has been covered[^] many times in this forum in the past. In fact, I just answered a similar question earlier today about scrolling to a particular line in the RichTextBox, so you could simply browse for that (probably on the next page of this forum) to see how.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
how would i use a font such as terminal when it is not open type or true type?
|
|
|
|
|
cmd.CommandText="UPDATE CompTav SET "+
@"TeorBohen='"+RbTeorBohen.Text +"' "+
@"TechName='"+tbTech.Text +"' "+
@"TipolDate='"+dt1.ToShortDateString()+"' "+
@"TipolStartHour='"+dt2.ToShortTimeString()+"' "+
@"Statos='"+CbStatos.Text +", "+
"where CartisNum=" +lbCartisNum.Text
|
|
|
|
|
Where do I begin? First of all, why are you using the literal string operator @? The way you're using it doesn't add anything to your statements because they only matter at compile time and will not automatically escape what you have in your text boxes, etc. They simply mean that when the source is compiled the string at that point will not expand escape sequences and can span lines until terminating with another double-quote.
Second, NEVER use string concatentation to build SQL queries. All someone has to do is insert the following into one of your text boxes and you're 0wned:
2 or 1=1; delete from CompTax -- Now you're CompTav table is gone. Worse can happen, and don't think people won't figure it out because disassemblers and decompilers are readily available and obfuscation helps little for seasoned pros. ildasm.exe - a disassembler - even comes with the .NET Framework SDK.
Also use parameterized queries:
cmd.CommandText = @"UPDATE CompTax SET
TeorBohen = @TeorBohen,
TechName = @TechName,
TipolDate = @TipolDate,
TipolStartHouse = @TipolStartHour,
Statos = @Statos
WHERE CartisNum = @CartisNum";
cmd.Parameters.Add("@TeorBohen", SqlDbType.NVarChar, 40).Value =RbTeorBohen.Text;
cmd.Parameters.Add("@TechName", SqlDbType.NVarChar, 128).Value = tbTech.Text;
cmd.Parameters.Add("@TipolDate", SqlDbType.DateTime).Value = dt1;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}Notice how we even assign the appropriate types to the parameters? Not only does using parameters strengthen your security (this eliminates most - if not all - SQL injection attacks) but makes it easier to execute commands. You don't have to worry about encoding your commands anymore like you do with ASP, PHP, etc. This makes batch updates a breeze, too: add the parameters once, then loop through your values setting each parameter, executing the command, then repeating.
EDIT: The above parameter syntax is for SQL Server. Oracle uses ":name" and the OLE DB provider uses only "?" (unnamed; you have to add the OleDbParameters in order of how "?"'s are declared in the SQL expression). Read about the variable IDbCommand implementations like SqlCommand, OleDbCommand, etc., and their respective Parameters properties, for more information.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
the sample didint work
i am on a OleDB database
but thanks anywey .....
if u can help i will be greatful...
|
|
|
|
|
I said you need to read the documentation, and that the OLE DB provider (as in the OleDbCommand) doesn't support named parameters. You must use "?" in place of the values (without any quotes or other special characters) and then add the parameters in the order they should be. If you read the documentation[^] for the OleDbCommand.Parameters is clearly explains and details this in an example.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
i try that :
IDbCommand cmd = this.oleDbConnection2.CreateCommand();
cmd.CommandText = "UPDATE CompTav SET TeorBohen = ?, WHERE (CartisNum = ?)";
OleDbParameter parm = new OleDbParameter();
parm.ParameterName="@TeorBohen";
parm.Value = RbTeorBohen.Text;
cmd.Parameters.Add(parm);
OleDbParameter parm1 = new OleDbParameter();
parm1.ParameterName="@CartisNum";
parm1.Value = lbCartisNum.Text;
cmd.Parameters.Add(parm1);
oleDbConnection2.Open();
cmd.ExecuteNonQuery();
oleDbConnection2.Close();
but it still dont work ...
|
|
|
|
|
Because you didn't set the type for parm1, most likely. You need to assign the values using the appropriate type, which means you need to convert lbCartisNum.Text to an integer value.
It's hard to tell, though. It does work, though: thousands of people use it every day. You didn't post the exception being thrown, so how can I know exactly what's wrong? You need to be more specific about your problems, like posting the exception message and type (like System.Data.OleDb.OleDbException and that it returned "couldn't cast to the appropriate type", or something like that).
The following may work - but again this is without knowing what your actually problem is since you didn't tell me:
cmd.Parameters.Add("@TeorBohen", OleDbType.VarChar, 80).Value = RbTeorBohen.Text;
cmd.Parameters.Add("@CartisNum", OleDbType.Integer).Value = int.Parse(lbCartisNum.Text);Since you assigned text to parm1.Value then the value would've been quoted in the resultant command before being executed, meaning that it wasn't representing a number but instead a string containing the number.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
i all send u the file on Mail...
|
|
|
|
|
What good would that do? I don't have your database, nor do I want it over email.
Read the documentation for the OleDbCommand.Parameters property and the OleDbParameter class for information and examples. So long as your SQL expression is right in terms of what your database is expecting, what I told you and what the documentation covers solves your problem.
If you're getting an exception that seems to indicate something else, then reply with the exception type and message - the same thing I tell everyone when they simply say something like "it doesn't work". The other regular responders would do the same. How could we know the problem unless it's painfully obvious? You need to tell us the exact error or helping you is difficult.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
I have some code to take a screenshot of a window, it takes it's handle as a parameter. How can I make my code take a screenshot of a hidden, or covered window? Is it even possible?
/\ |_ E X E GG
|
|
|
|
|
When get down to it, a window can never be hidden (this isn't necessarily true with layered windows, however) - it's simply not drawn. The window manager doesn't draw portions of windows - or windows in their entirety - if they are obscured. So - to answer your question - it is not possible to take screenshots of hidden windows because they're simply not painted. The screenshot code is, after all, asking GDI or GDI+ to paint into a compatible DC for a bitmap instead of a screen, printer, or other display device.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Ok, then. Um, is there any way to get the image of a non-visable window???
/\ |_ E X E GG
|
|
|
|
|
I think you missed my point: hidden windows are not drawn to any device context (DC), which means you can't get an "image" of them - they're not drawn.
If you want a simple one-word answer to your original question, then "no".
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
hello
i want to generate the random number for the bignumber by using the bignumbers class. how to do it?
|
|
|
|
|
Read the article for the BigInteger class I gave you earlier. The guy created it specifically for RNGs for encryption. If you have questions about the article the the BigInteger class itself, ask in the message board at the bottom of the article - that's what it's there for. This forum is for general C# questions and questions about .NET development with C# that are covered under other forums (like the ASP.NET or ADO.NET forums), don't include article content, and aren't third-party controls (like you asked about in your previous question regarding Dundas).
BTW, you should know Dundas is a major supporter of this site. You shouldn't be announcing that you're trying to crack their product.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
This is a third-party control and is not supported by this forum, nor should it be since removing the Watermark in an evaluation version is wrong and most likely illegal (based on whatever the EULA that you agreed to says).
If you need help with third-party controls or applications you should consult the manufacturer/developer.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
hello
I am really very sorry for asking such a non-professional question. I dont want to ask it in this manner as i only required a control which i can use freely. I am again very sorry.
regards
asmyan
|
|
|
|
|
It's an evaluation version, as you clearly stated. That implies it is not free, and I think you knew that, too, since you were trying to crack it and get rid of the watermark.
If you want to know how to make your own charting control, then search or browse the articles on this site. I've seen several that cover the basics of charting (with a decent amount of math know-how and knowledge about owner drawing controls, it's actually quite easy).
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
|
Hi,
I created a simple application in C# using .NET visual studio. The release build seems to work just fine on my development machine but it does NOT seem to work on my "non-development" machine (a clean W2k machine with no visual studio .net). By the way, I was using the default release build setting to create the exe.
I get error complains such as "mscoree.dll is missing". When I provide this mscoree.dll it cries about some registry key not setup to point to the install path etc. etc.
Any idea, suggestion, help?
Thanks!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
