|
How to push data from Winforms to Crystal Report Dynamically..
How?????????
Muhammad Waqas Butt
|
|
|
|
|
What kind of data?
Have a read of these docs[^] for the most common ways of dynamically altering reporting data.
Michael
CP Blog [^]
|
|
|
|
|
Deos any body know how to convert Numbers to word mean
in text box user type: 100 it convert in One Hundard and how One Hundard in another textbox.
???????????
Muhammad Waqas Butt
waqasb4all@yahoo.com
|
|
|
|
|
|
how can i change the specific row color in a datagrid and also how can i make a row readonly in datagrid in windows forms using c#
|
|
|
|
|
You have to catch the events of Paint and Selection Changed for DataGrids. Then u can change the specific row color or making any specific row readonly.
However it will be better if u create ur own grid from scratch i.e. inheriting ur own grid control from any control.
|
|
|
|
|
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 ?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
