C# Discussion Boards - CodeProject

Re: updating a DB using a windows form

Giorgi Dalakishvili16-Aug-07 23:55

Giorgi Dalakishvili

16-Aug-07 23:55

Can you be more specific? Is there any exception thrown during execution or just database doesn't get updated?

#region signature
my articles
#endregion

Re: updating a DB using a windows form

Rocky#17-Aug-07 1:20

Rocky#

17-Aug-07 1:20

I think ur making a lot of mistakes in this... I'd recommend that you go thru a few walkthoughs on MSDN and next time plz take the time to tell us about ur platform. like C# 1.1,2.0 ... SQL Server 2000 uknow!

by the way you're not ExecutenonQuery here and are the syntax of the insert command is all wrong aswell u give parametes in SQL starting with the @ sign. In summary your all messed up here. First study the basics thorougly then start coding ok, dont worry u'll get over it in quick time. Remember... Every body falls the first time!

Rocky

You can't climb up a ladder with your hands in your pockets.

Re: updating a DB using a windows form

helloise17-Aug-07 1:40

helloise

17-Aug-07 1:40

Thank you...

I use Visual Studio 2005 with SQL Server Express.
I need to hard code everything and not make use of the data adapter configuration wizard.

I need to do this small project so I can learn how this all works, but was just told: go figure it out yourself...

Can you suggest a walkthrough on MSDN I can follow please. im desperate.

thank you
from a sunny south africa.

Re: updating a DB using a windows form

Rocky#17-Aug-07 1:47

Rocky#

17-Aug-07 1:47

just copy paste this URL in your MSDN 2005 URL bar
ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_raddata/html/15a88fb8-3bee-4962-914d-7a1f8bd40ec4.htm

There's whole list of walkthroughs

This one's from that list showing you how to save data

ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_raddata/html/68befa96-7463-43e8-abcf-dc2f42ccd53d.htm

hope thats helpful for and dont get so desperate, its all abt using ur mind, MSDN and Google intelligently, concentrate on learning more rather than just completing the job somehow

Rocky

You can't climb up a ladder with your hands in your pockets.

Re: updating a DB using a windows form

Talal Sultan17-Aug-07 1:33

Talal Sultan

17-Aug-07 1:33

helloise wrote:
insertCommand.Parameters.Add("telephoneExtension", SqlDbType.NVarChar, 0, "TelephoneExtension");

Why would telephoneExtension have a length of 0? Confused | :confused:

And, you didn't execute the insertCommand you declared so the database will not get updated.

-- If this is a post that has been helpful to you, please vote for it. Thank you!

"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."
--Rich Cook

Re: updating a DB using a windows form

helloise17-Aug-07 4:45

helloise

17-Aug-07 4:45

I have the complete code here:

how do I excecute the insertCommand then, ie what is the code for it? thank you very much.... Smile | :)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace MyWindowsApp
{
public partial class AddAndUpdateForm : Form
{
public AddAndUpdateForm()
{
InitializeComponent();
}

private void LastnameTextBox_TextChanged(object sender, EventArgs e)
{
string lastname = LastnameTextBox.Text;
}

private void FirstnameTextBox_TextChanged(object sender, EventArgs e)
{
string firstname = FirstnameTextBox.Text;
}

private void NicknameTextBox_TextChanged(object sender, EventArgs e)
{
string nickname = NicknameTextBox.Text;
}

private void UserNameTextBox_TextChanged(object sender, EventArgs e)
{
string username = UserNameTextBox.Text;
}

private void TelExtTextBox_TextChanged(object sender, EventArgs e)
{
string telephoneExtension = TelExtTextBox.Text;
}

public void OKbutton_Click(object sender, EventArgs e)
{

SqlConnection mySqlConnection = new SqlConnection("server=ISS\\SQLEXPRESS;database=Staff;uid=sa;pwd=xbcprfly");
mySqlConnection.Open();

SqlCommand myCommand = mySqlConnection.CreateCommand();
myCommand.CommandText = "SELECT Lastname, Firstname, TelephoneExtension FROM Staff ORDER BY Lastname";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(myCommand);

DataSet myDataSet = new DataSet();

SqlCommand insertCommand = new SqlCommand("insert into Staff (Lastname,Firstname,TelephoneExtension) values (lastname,firstname,telephoneExtension)",mySqlConnection);
insertCommand.Parameters.Add("lastname", SqlDbType.NVarChar, 80, "Lastname");
insertCommand.Parameters.Add("firstname", SqlDbType.NVarChar, 80, "Firstname");
insertCommand.Parameters.Add("telephoneExtension", SqlDbType.NVarChar, 50, "TelephoneExtension");

//the following code is making me confused.
//myCommand.ExecuteNonQuery();

//mySqlDataAdapter.Fill(myDataSet, "Staff");
//mySqlDataAdapter.InsertCommand = insertCommand;
//mySqlDataAdapter.Update(myDataSet, "Staff");

//SqlCommand cmd = new SqlCommand(cmdStr, con);
//cmd.ExecuteNonQuery();
//SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);

this.Close();
}

private void Cancelbutton_Click(object sender, EventArgs e)
{
this.Close();
}

private void AddAndUpdate_Load(object sender, EventArgs e)
{

}
}
}

How to export datagridview columns to MS Word using c#

Exelioindia16-Aug-07 23:22

Exelioindia

16-Aug-07 23:22

Hi all,

Any one know how to export datagridview columns(values) to MS Word using c#(windows application).

Thanks in advance

Know is Drop, Unknown is Ocean

Re: How to export datagridview columns to MS Word using c#

Giorgi Dalakishvili16-Aug-07 23:30

Giorgi Dalakishvili

16-Aug-07 23:30

You can use word object library to create new word document and put some text in it so iterate through all the rows of datagridview and put the text in word document.

#region signature
my articles
#endregion

Re: How to export datagridview columns to MS Word using c#

Exelioindia16-Aug-07 23:41

Exelioindia

16-Aug-07 23:41

Thanks for your suggestion, i need some sample code to understand this. Plz guid me.

Know is Drop, Unknown is Ocean

Re: How to export datagridview columns to MS Word using c#

Giorgi Dalakishvili16-Aug-07 23:51

Giorgi Dalakishvili

16-Aug-07 23:51

Can't you search for the keywords yourself? I have given you directions. If you can't here are some links: Creating and Opening Microsoft Word Document from .NET Using C#[^]

http://www.dotnetspider.com/qa/Question14155.aspx

#region signature
my articles
#endregion

Re: How to export datagridview columns to MS Word using c#

Exelioindia17-Aug-07 0:11

Exelioindia

17-Aug-07 0:11

Thanks for your help. i found the solution.

Know is Drop, Unknown is Ocean

Using WIndows Controls on a ASPX Page...

amitkadamo16-Aug-07 23:10

amitkadamo

16-Aug-07 23:10

Hello friends,

I have developed many controls for my Window based application in C# .net. However i want to know whether i can utilise those controls on a web page. I have tried but so far no success.

Regards
Amit

Re: Using WIndows Controls on a ASPX Page...

rah_sin16-Aug-07 23:32

rah_sin

16-Aug-07 23:32

yes you can do so by making dll of your control
and embedding your windows contol to htmls object tag.

rahul

Character Mode Printing in .Net

amitkadamo16-Aug-07 23:07

amitkadamo

16-Aug-07 23:07

Hello Friends,

I want to print contents of my Crystal report .Net to a Generic text Only Printer say an Epson 300+. But some how my printing gets disturbed.This happens only when my printer is using the Generic Text Only driver. My main concern is to print the report as fast as possible.

Thanks
Amit Kadam

Compare Word docs

Nitin.raj16-Aug-07 22:54

Nitin.raj

16-Aug-07 22:54

Hi,
I have to compare MS Word Documents ie., the original document is to be compared with the same document after some editing and the process should be able to show the changes made. Please help me. The code should be in C#

thanx,

Nitin.

Nitin Raj Bidkikar

Re: Compare Word docs

Hessam Jalali16-Aug-07 23:56

Hessam Jalali

16-Aug-07 23:56

you can use office interop for doing that

here is some articles

http://www.c-sharpcorner.com/Articles/ArticleListing.aspx?SectionID=1&SubSectionID=146

good luck

Merge Word docs

Nitin.raj16-Aug-07 22:51

Nitin.raj

16-Aug-07 22:51

Hi,
Iam able to merge MS Word documents using c#. For using this code i have to select each and every Word document to be merged. Can any one tell me how to merge all the documents present in a folder at one go.

thanx
Nitin

Nitin Raj Bidkikar

Re: Merge Word docs

Hessam Jalali16-Aug-07 23:46

Hessam Jalali

16-Aug-07 23:46

Why you send same things with different titles

from your questions this post and your post about the zips are the same problem!

Locating Zip folders

Nitin.raj16-Aug-07 22:47

Nitin.raj

16-Aug-07 22:47

Hi,
I have to unzip multiple folders present in a single folder using c#. I have the code for doing this and it is working fine. For using this code I have to select the file that is to be unzipped and then after unziping it I have to select the next zip file and unzip it and so on. This is a very long process. Can anyone tell me how to unzip all the zip folders present in the parent folder at one go.
thanx
Nitin.

Nitin Raj Bidkikar

Re: Locating Zip folders

Hessam Jalali16-Aug-07 23:41

Hessam Jalali

16-Aug-07 23:41

You can use Directory.GetFiles method for locating all the zip files and then use your code
I think general scheme whould be like this

<br />
<br />
string[]zipFiles;<br />
<br />
foreach(string zf in zipFiles)<br />
.<br />
.<br />
.<br />
<br />
//your code here<br />
<br />

hope the post would help

Re: Locating Zip folders

Nitin.raj6-Sep-07 0:16

Nitin.raj

6-Sep-07 0:16

hey

ur soln has helped me........but along with the zip files there are some word documents present....so when the control comes to the word files it is throwing exception.......how do i make the code to ignore the word docs and just unzip the zip files.....

thanx
nitin

Nitin Raj Bidkikar

Re: Locating Zip folders

Hessam Jalali7-Sep-07 9:21

Hessam Jalali

7-Sep-07 9:21

you can filter the files with using the overloaded version of the GetFiles(string path,string searchPattern)

it would be somewhat like this for zip files

<code>
string[] files=System.IO.Directory.GetFiles(path, "*.zip");
</code>

good luck

Using Dynamically created user control with its parent control

b_the_technocrat16-Aug-07 22:43

b_the_technocrat

16-Aug-07 22:43

Dynamically created user control with its parent control

Hi..
how could i access the user control's objects from its parent control.

i've created a control which includes a listbox and a another usercontrol(CHILD1)..say control CHILD2.

now m dynamically adding CHILD2 control within a control say Parent1. now i wants to access the values entered within the CHILD2..which provides me the values of the listbox and the CHILD1's control.

but the debugger shows that the listbox is no more exist in the class of CHILD2 itself...

is there any way to get the values from all the control ... in the parent control..

thanks in advance
Smile | :)

Bhuwanesh Joshi

Re: Using Dynamically created user control with its parent control

rah_sin16-Aug-07 23:22

rah_sin

16-Aug-07 23:22

you can try

foreach(CHILD2 cl in Parent1.Controls)
{

cl.properties of user control;

}

rahul

Deserialization question

PACO7716-Aug-07 22:39

PACO77

16-Aug-07 22:39

Hi,
i have a little quiestion, about deserializing a custom type...I want to deserialized this custom type but actually i dont know it. What i mean is for example i have a type called TypeA - i serialized it. But when i want to deserialized i dont know what type i have at the xml file(for xml serialization). I want to find it out.
Is there way to find what type i have?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.