|
Sorry but that is nonsense.
Looking at DataGridColumnStyle - especially overriding GridTextBoxColumn - is the way to go.
That has been done thousand of times here. Search the forum and/or CodeProject to find samples.
|
|
|
|
|
I am writing a c# application that save record into two table that has a relationship. But when inserting new data, the auto id suppose to be in the detail table but not. I could not figure it out. Please turn the light on. Here is the code.
================================================
static void ExPnamesAdapter_OnRowUpdate(object sender, OleDbRowUpdatedEventArgs e)
{ OleDbCommand oCmd = new OleDbCommand("SELECT @@IDENTITY", e.Command.Connection);
e.Row["ID"] = oCmd.ExecuteScalar();
e.Row.AcceptChanges();
}
private void btnSav_Click(object sender, System.EventArgs e)
{
OleDbConnection myConnection = new OleDbConnection( CONNECTION_STRING );
//// Create the DataSet
DataSet ds1 = new DataSet();
// Fill the Dataset with Names, map Default Tablename
//// "Table" to "names".
OleDbDataAdapter namesAdapter = new OleDbDataAdapter("Select LastName,FirstName,Initial,SSN,ExpungeID FROM Name",myConnection);
namesAdapter.RowUpdated += new OleDbRowUpdatedEventHandler(ExPnamesAdapter_OnRowUpdate);
OleDbCommandBuilder namesCmdBuilder = new OleDbCommandBuilder(namesAdapter);
namesAdapter.TableMappings.Add("Table","Name");
namesAdapter.Fill(ds1);
/// Fill the Dataset with Orders, map Default Tablename
/// "Table" to "detail".
OleDbDataAdapter detailAdapter = new OleDbDataAdapter("SELECT Type,ReceiveDate,ProcessDate,RejectDate,ReasonReject,PJ_ClafLet,Misc,Misc1,Misc2,Misc3,Status,ID FROM Detail",myConnection);
OleDbCommandBuilder detailCmdBuilder = new OleDbCommandBuilder(detailAdapter);
detailAdapter.TableMappings.Add("Table","Detail");
detailAdapter.Fill(ds1);
System.Data.DataRelation relCustOrd;
System.Data.DataColumn colMaster1;
System.Data.DataColumn colDetail1;
colMaster1 = ds1.Tables["Name"].Columns["ID"];
colDetail1 = ds1.Tables["Detail"].Columns["ID"];
relCustOrd = new System.Data.DataRelation("RelCustOrd",colMaster1,colDetail1);
ds1.Relations.Add(relCustOrd);
DataRow namesRow = ds1.Tables ["Name"].NewRow();
namesRow["LastName"] = this.txtlastname.Text;
namesRow["FirstName"] = this.txtfirstname.Text;
namesRow["Initial"] = this.txtInitial.Text;
ds1.Tables["Name"].Rows.Add(namesRow);
DataRow detailRow = ds1.Tables["Detail"].NewRow();
detailRow["Type"] = "A";
detailRow["Misc"] = "Testing and Working not";
detailRow["Misc1"] = "I hope this will work";
ds1.Tables["Detail"].Rows.Add(detailRow);
detailRow.SetParentRow(namesRow);
namesAdapter.Update(ds1, "Name");
detailAdapter.Update(ds1, "Detail");
myConnection.Close();
}
Mso
|
|
|
|
|
Are you kidding?
Look at this 3 lines (copied from your pasted code):
...
ds1.Tables["Detail"].Rows.Add(detailRow);
detailRow.SetParentRow(namesRow);
ds1.Tables["Detail"].Rows.Add(detailRow);
...
Last hint: One line exists twice.
|
|
|
|
|
Hi
I need a help Pls Itsvery urgent , help me to get out
I have doen a pgm to read
any schema file(.xsd) and load data's into a xml file(resultant file).
Here what I had done inside the Load button is that for any datatypes
in the schema, enter the values as james for string, 100 for interger
like that, I have specified by using the SWITCH statement. But my
requirement is such that , when I entered the .xsd file and resultant xml file then when i click the Load Button, It should create around 200 data's but, the data's should differ form each other.
I dont know how to do this. Pls help me. Here I am sending the coding
again.create a new project with c# windows application, copy this
coding and run and see.
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;
///
/// 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();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
this.SuspendLayout();
//
// txtSchema
//
this.txtSchema.Location = new System.Drawing.Point(88, 24);
this.txtSchema.Name = "txtSchema";
this.txtSchema.Size = new System.Drawing.Size(440, 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(536, 24);
this.button1.Name = "button1";
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(88, 64);
this.txtXml.Name = "txtXml";
this.txtXml.Size = new System.Drawing.Size(440, 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(536, 64);
this.button2.Name = "button2";
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(616, 64);
this.button3.Name = "button3";
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");
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(808, 454);
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)
{
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) "This is string";
break;
case "System.Int32":
oValues[i] = (int) 100;
break;
case "System.DateTime":
oValues[i] = new DateTime(2004,10,12);
break;
case "System.Decimal":
oValues[i] = new Decimal(999999999.99);
break;
case "System.Int16":
oValues[i] = (short) 32767;
break;
case "System.Int64":
oValues[i] = (long) 9223372036854775807;
break;
case "System.Double":
oValues[i] = (double) 888888888888888;
break;
}
i += 1;
}
dTbl.Rows.Add(oValues);
}
}
private void button3_Click(object sender, System.EventArgs e)
{
dataSet1.WriteXml(txtXml.Text,XmlWriteMode.WriteSchema );
MessageBox.Show("Saved");
}
}
}
|
|
|
|
|
Hi,
I have looked at the API of WM Encoder 9.0 and could able to capture the screen in the form of a video. But instead of saving to a file i want to send across the network and play it as an video file.
This can be done by WM Encoder 9.0 broadcast mechanism. But i am using another high level API for the networking. Since i cannot use the Windows Media Encoder 9.0 API for transmitting, is there any way i can get the frames of the encoding video format asynchronous (or some way) so that i can send there frames across the wire using the custom API?
Is it possible to do this using the Windows Media Format 9.0 API?
Thanks,
vinod
|
|
|
|
|
I'm writing a program that needs to capture the Fn key on my laptop, but have not been able to capture it.. I've tried using of the keyboard hooking using SetWindowsHookEx, but it doesn't capture the key stroke. Any ideas?
|
|
|
|
|
It's not a key with any assigned value, but a modifier. You could P/Invoke GetKeyState that is used to determine the state of other modifier keys, or wait until a following key is pressed and mask the state of the modifier. Through some simple reverse engineering you could easily figure out what that virtual key code is.
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]
|
|
|
|
|
Let me see if I understand. Here's a scenario. I press the Fn key and another key, say F10, and I have a program that will capture keystrokes using the SetWindowsHookEx, etc. I will get the virtual key code for the F10 and pass it to the GetKeyState method. The GetKeyState method will return me a value. That value will let me know whether the Fn key was pressed at the same time as the F10 key. Is that correct?
Question then becomes what is the return value from GetKeyState? MSDN says:
"If the high-order bit is 1, the key is down; otherwise, it is up.
If the low-order bit is 1, the key is toggled. A key, such as the CAPS LOCK key, is toggled if it is turned on. The key is off and untoggled if the low-order bit is 0. A toggle key's indicator light (if any) on the keyboard will be on when the key is toggled, and off when the key is untoggled."
So could the value be somewhere inbetween?
Please forgive me if my questions are simple. I'm new to this type of programming and am just trying to have it make sense.
Thanks
|
|
|
|
|
No, you pass the keycode of the Fn key to GetKeyState. See the remarks about the Alt, Ctrl, and Shift keys, for example. Those are also modifier keys.
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've tried everything I can think of to write this troublesome character to a text file..
I'm writing a program to generate CSS files and I can write "{" and "}" to the console either directly or using its ascii code:
// These both work
Console.WriteLine("{");
Console.WriteLine(((char)123).ToString());
Now when I try to write to a streamwriter (or textwriter) I get an error saying:
"Additional information: Input string was not in a correct format."
This is even though I read in a template file (containing "{" and "}") and it reads it fine and displays to the console..
What am i doing wrong? Can i write "{" and "}" to a file at all? Is there an escape character i just dont know about?!
Thanks guys,
James
|
|
|
|
|
This worked fine for me....
StreamWriter SW = new StreamWriter("c:\\temp\\test.txt",false);
SW.Write("{");
SW.Close();
|
|
|
|
|
|
Does anybody know how to update listview subitems without redrawing the whole row?
Cheers.
|
|
|
|
|
Folks, I'm looking for an 'easy' answer here. The .Net 2.0 version of the TabControl doesn't have a 'no tabs' setting for Appearance. (I read elsewhere that it should. That may have been an MFC version of the control.) I'm using the Whidbey C# development environment and I would like to use a control similar to a TabControl, but I don't want to display any tabs. I want to switch the currently displayed 'tab page' from code. I'm trying to avoid having to develop the control from scratch. I could just use panels and flip between them, but many separate panels are difficult to manage in the IDE. It's just easier to use a control that flips them for you. (Anyone who has tried to place a lot of overlapping panels on a form will feel my pain. ;c)) If anyone can provide me with a suggestion, I'd be thankful.
Thanks,
Bob
|
|
|
|
|
How to initilize a textBox with background color that you want.
I tried this
"textBox25.BackColor=Color.Green;"
but the dropdown has predefine colors (e.g Red, Green, Gray...)
I want to use my own custom color.
|
|
|
|
|
Use Color.FromArgb method for using ur own custom color.
For example:
textBox25.BackColor = Color.FromArgb(255, 133 , 144);
//You need to know RGB values for your custom color
You can see Color.FromArgb in MSDN for more on this.
|
|
|
|
|
You can set the background color, provided you know the values of the different color elements. The following code sets the background to Yellow:
textBox25.BackColor = Color.FromArgb( 255,255,0 );
Color.FromArgb() can be used to set a color with different attributes. Check out the different calling options.
Bob
|
|
|
|
|
hello ,
I have created a Control array for a ComboBox to populate on a tabPage .
My concern is that I 'm using a List to populate the Combo Box like this ..
ComboArray[i].Items.Add(List[i)];
ComboArray[i].DataSource = List;
The Combo Box gets populated with all the values in the List ( Thats what I
wanted )
But when i select a value in the First Combo box the Changes reflects in all
the boxes created
Example
if if there were 6 values from 1,2,3 ..6 in the all Combo Dropdown list .
when I select 5 in the 3rd all the Combo's selected value changes to 5.
How do I get specifice values in different Combo According to my selection ?
Thanks
Sylesh Nair
|
|
|
|
|
I think your problem might be in assigning all the ComboBox's DataSource property to the same object. Is there a reason your are assigning the DataSource Property ?
|
|
|
|
|
object[] dest=new object[List.Items.Count];
List.Items.CopyTo(dest,0);
ComboArray[i].DataSource = dest;
This will solve ur problem 
|
|
|
|
|
Thanks Ibraheem , for the code snippet you had send to me .
but the ComboArray[i].DatSource = dest still gives me the same problem .
So I tried a different way which was
ComboArray[i].items.AddRange(dest). This is working now as Addrange needs a an collection class which implements IList Interface .
Anyways thanks a lot
Sylesh
|
|
|
|
|
Well u welcome
However the same piece of code worked for me. Thats interesting i might have done something wrong.
Regards
Ibraheem
|
|
|
|
|
Here in your application you are using same datasource for all combo control. This is the reason for your issue. Here you can make a deep copy the datasource and bind it.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
All,
I am looking for a code which retrieves a HTML source for a given website. I got few but none of the code really works for all websites. Some has security issues, some has timeout issues, some has redirect issues, some has session management issues. I am looking for the code which works for all kinds of websites.
given a website say www.xyz.com/default.aspx I want to retrieve the HTML source(same as when this page get rendered). I want to achieve this without any UI.
Does anyone knows where I can get one?
Thanks,
Anand
|
|
|
|
|
Unless you have knowledge of the specific site, you're always going to run into problems with a secured site or one with complex session management. Implementations will differ from site to site, making a one-size-fits-all component very difficult.
For example, lets assume that have valid credentials to log into a secured site, how does that site manage them? Do you need to pass them in the form of a cookie, or do you have to post to a specific page? What happens if the site changes their implementation details?
Creating a component that could handle all of the different variations would most likely require a constantly updated data source with the implementation details for each non-public site. I can't imagine that anyone would argue that disclosing the inner workings of your authentication mechanism is a good security practice.
I don't think that you're going to find a component that meets your requirements. Your best bet would be to see if the desired sites offer an RSS or ATOM syndication, or perhaps a web service to supply details to your application.
Not the answer that you were looking for, but I hope it helps a bit.
--Jesse
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
