Re: how execute multi SQL command (C# - ADO.NET) - C# Discussion Boards

Re: How to Display Data (Urgent)

25-Apr-07 21:12

Well, you mean pass data, I presume ? If the child is modal, just expose it as a property. Otherwise, use a delegate to pass it along.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Jaiprakash M Bankolli25-Apr-07 22:06

Jaiprakash M Bankolli

25-Apr-07 22:06

I would suggest that create a property and assign this property in the child form. Use parent property to display at the required place

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
Blog: http://jaiprakash.blog.com/
Suggestions: http://jaitoimprove.blog.com/

Re: How to Display Data (Urgent)

Nouman Bhatti26-Apr-07 0:29

Nouman Bhatti

26-Apr-07 0:29

one way of doing that.. is to declare a object of parent form on the client form and access the properties of of parent from child through that object and do whatever u want to do.

but u have to typecast that parent object on the child's parent object so that u get the same object reference

other way of doing it (i think) is through delegates

how execute multi SQL command (C# - ADO.NET)

zeroonea25-Apr-07 20:14

zeroonea

25-Apr-07 20:14

i use

[code]
string strQuery =
"USE HMDTest"
+ " \nGO"
+ " \nsp_addrole 'HMEmpManager'"
+ " \nGO"
+ " \nsp_addrole 'HMEmpViewer'";

SqlCommand sqlCom = new SqlCommand(strQuery, sqlCon);

sqlCom.ExecuteNonQuery();
[/code]

but it throw a exception with message: "incorrect syntax near 'GO'...", i need help, thanks.

Re: how execute multi SQL command (C# - ADO.NET)

Vikram A Punathambekar25-Apr-07 20:59

Vikram A Punathambekar

25-Apr-07 20:59

The three queries are separate, so you must execute them with three statements.

Cheers,
Vikram.

"But nowadays, it means nothing. Features are never frozen, development keeps happening, bugs never get fixed, and documentation is something you might find on wikipedia."
- Marc Clifton on betas.

Join the CP group at NationStates. Password: byalmightybob

Re: how execute multi SQL command (C# - ADO.NET)

Jaiprakash M Bankolli25-Apr-07 22:15

Jaiprakash M Bankolli

25-Apr-07 22:15

I would suggest that write a SP and call that from Application .... here it will take two parameter <hmempmanager> and <hmempviewer>

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
Blog: http://jaiprakash.blog.com/
Suggestions: http://jaitoimprove.blog.com/

How to parse csv file into xml file

DON34525-Apr-07 19:44

DON345

25-Apr-07 19:44

Thanks&Regards
RENU

coolestCoder25-Apr-07 19:49

coolestCoder

25-Apr-07 19:49

DON345 wrote:
Iam facing a lot of problem to parse this file into XML file.

I am sure, everybody will have problems reading this file. BTW is this a single record or multiple records ? Also my understanding about CSV (Comma Seperated Values) is comma seperated fields and new line seperated records. Is the file in same format ? Or even this file can be called as CSV ?

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

DON34525-Apr-07 20:09

DON345

25-Apr-07 20:09

Hi Thank you for ur response,
actually that Data contains multi records.
I think this is one type of csv file,but seperated fields with pipe symbol.
field and value contains side by side.
please give me any solution.

Thanks&Regards
RENU

Rudolf Jan26-Apr-07 0:41

Rudolf Jan

26-Apr-07 0:41

I do not think anybody can help you with this. I suggest you to separate the file into individual records and fileds first. Yuo may use the String.Split() method for that purpose. Then you must find out what structure the file has. You should create the XML datatype and finally you can parse the data and convert it to XML. Don't expect us to do this for you.

DON34526-Apr-07 2:39

DON345

26-Apr-07 2:39

Thank you for your response,actually that data belongs to single record it contains 636 fields,then how can we parse the pipe symbols.can u send any sample code.

Thanks&Regards
RENU

save file as atext...using v.s 2003 !

Vikram A Punathambekar25-Apr-07 21:04

Vikram A Punathambekar

25-Apr-07 21:04

Cheers,
Vikram.

"But nowadays, it means nothing. Features are never frozen, development keeps happening, bugs never get fixed, and documentation is something you might find on wikipedia."
- Marc Clifton on betas.

Join the CP group at NationStates. Password: byalmightybob

Mouse over a control

Keshav V. Kamat25-Apr-07 18:37

Keshav V. Kamat

25-Apr-07 18:37

Hello All,

I need to find out if mouse is present over any control, say a button.
Please tell me how can I proceed on with this.

Keshav Kamat Smile | :)

India

Re: Mouse over a control

Nouman Bhatti25-Apr-07 19:04

Nouman Bhatti

25-Apr-07 19:04

one way to do it
u should write code in every control's MouseEnter event.

Re: Mouse over a control

Martin#25-Apr-07 20:16

Martin#

25-Apr-07 20:16

Hello,

Maybe this thread helps you out:
http://www.codeproject.com/script/comments/forums.asp?msg=1869977&forumid=1649&XtraIDs=1649&searchkw=Mouse+Position&sd=26+Jan+2006&ed=26+Apr+2007&stype=1#xx1869977xx[^]

All the best,

Martin

mr jets25-Apr-07 17:53

mr jets

25-Apr-07 17:53

i wanna to make aprogram that can draw (ellips , line,..) but i have problems with the save & open ..thats apart of the code:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using System.Runtime.Serialization.Formatters.Binary;
using System.Runtime.Serialization;

namespace graphics_practis
{
///

/// Summary description for Form1.
///

public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.PictureBox pictureBox1;
private System.Windows.Forms.Button line;
private System.Windows.Forms.Button square;
private System.Windows.Forms.Button circle;
private System.Windows.Forms.Button ellipse;
private System.Windows.Forms.Button polygon;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Button ok;
private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem menuItem2;
private System.Windows.Forms.MenuItem menuItem3;
private System.Windows.Forms.MenuItem menuItem4;
private System.Windows.Forms.MenuItem menuItem5;

private BinaryFormatter formtter = new BinaryFormatter();
private FileStream str_reader;

private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;

private System.Windows.Forms.SaveFileDialog saveFileDialog1;
private System.Windows.Forms.OpenFileDialog openFileDialog1;
///

/// 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
//
dr = new draw(this.pictureBox1);
}
static void Main()
{
Application.Run(new Form1());
}

private void menuItem4_Click(object sender, System.EventArgs e)
{
//saving
FileStream outStream=File.Create(saveFileDialog1.FileName);//To create text file
Stream streamWriter=new StreamWriter(outStream);
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
//opening
FileStream outStream=File.Create(saveFileDialog1.FileName);//To create text file
StreamWriter streamWriter=new StreamWriter(outStream);
}

the error...>>(cannot implicity convert type 'System.IO.StreamWritet'to 'System.IO.Stream'.

Christian Graus25-Apr-07 19:22

25-Apr-07 19:22

Oh, you're using VS2003. Then WriteAllText is not an option.

mr jets wrote:
cannot implicity convert type 'System.IO.StreamWritet'to 'System.IO.Stream'.

You keep posting this, there's no such thing as StreamWritet, is this really not a typo ?

System.IO.FileStream fs = new System.IO.FileStream("c:\\testing.txt", System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.Write, System.IO.FileShare.ReadWrite);

// create a stream writer
System.IO.StreamWriter sw = new System.IO.StreamWriter(fs, System.Text.Encoding.ASCII);

// write to file (buffer), where textbox1 is your text box
sw.Write("text");

// flush buffer (so the text really goes into the file)
sw.Flush();

// close stream writer and file
sw.Close();
fs.Close();

Perhaps the defaults for the params you're not passing in, are not the ones you need ?

mr jets26-Apr-07 5:22

mr jets

26-Apr-07 5:22

i reaally appreciat ur time bro..okie ur code creating atext in c drive but it doesnt save the values of (x,y,..) remember bro my program like Paint ..so when i open the text it doesnt display my drawings (line,polygon,..)
thats my open code :
{
OpenFileDialog fileChooser=new OpenFileDialog();
DialogResult result = fileChooser.ShowDialog();
String fileName ; // name of file to containing data
// exit event handler if user clicked "cancel"
if (result == DialogResult.Cancel)
return;
// get specified file name
fileName= fileChooser.FileName;
//show error if user specified invalid file
if (fileName=="" || fileName==null)
MessageBox.Show("Invalid File Name ","Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
else
//creat Filestream to obtain read access to file
input = new FileStream(fileName,FileMode.Open,FileAccess.Read);

}

Regards ; Sigh | :sigh:

Christian Graus26-Apr-07 11:16

26-Apr-07 11:16

I'm not sure that I understand. I see you opening a file stream, but I don't see you reading anything, nor does the fact that you read the text have anything to do with seeing polygons ( there's a step in the middle where the text is intepreted to give you the data to show that )

mr jets26-Apr-07 13:00

mr jets

26-Apr-07 13:00

thank god u back ..iam soo close to break my pc...u said
(there's a step in the middle where the text is intepreted to give you the data to show that )
can u just tell me what that step..iam baggginngg Christian D'Oh! | :doh:

Regards ;

Christian Graus26-Apr-07 22:08