|
I have two forms:
the first contains a dataGridView containing a list of staff members.
it also contains 4 buttons.
1. refesh
2. update
3. add
4. delete
The add_click event opens a second form for inserting the staff member's details.
when you click the OK button on this form it must update the Staff DB
the code in this event is as follows:
public void OKbutton_Click(object sender, EventArgs e)
{
SqlCommand insertCommand = new SqlCommand("insert into Staff (Lastname,Firstname,TelephoneExtension) values (lastname,firstname,telephoneExtension)");
insertCommand.Parameters.Add("lastname", SqlDbType.NVarChar, 80, "Lastname");
insertCommand.Parameters.Add("firstname", SqlDbType.NVarChar, 80, "Firstname");
insertCommand.Parameters.Add("telephoneExtension", SqlDbType.NVarChar, 0, "TelephoneExtension");
//mySqlDataAdapter2.InsertCommand = insertCommand;
//mySqlDataAdapter2.Update(myDataSetAddandUpdateForm, "Staff");
this.Close();
}
My code is not working. can anyone help me please. I am a trainee programmer.
|
|
|
|
|
Can you be more specific? Is there any exception thrown during execution or just database doesn't get updated?
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
helloise wrote: insertCommand.Parameters.Add("telephoneExtension", SqlDbType.NVarChar, 0, "TelephoneExtension");
Why would telephoneExtension have a length of 0?
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
|
|
|
|
|
I have the complete code here:
how do I excecute the insertCommand then, ie what is the code for it? thank you very much....
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)
{
}
}
}
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Thanks for your suggestion, i need some sample code to understand this. Plz guid me.
Know is Drop, Unknown is Ocean
|
|
|
|
|
|
Thanks for your help. i found the solution.
Know is Drop, Unknown is Ocean
|
|
|
|
|
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
|
|
|
|
|
yes you can do so by making dll of your control
and embedding your windows contol to htmls object tag.
rahul
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
Why you send same things with different titles
from your questions this post and your post about the zips are the same problem!
|
|
|
|
|
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
|
|
|
|
|
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 />
<br />
hope the post would help
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
Bhuwanesh Joshi
|
|
|
|
|
you can try
foreach(CHILD2 cl in Parent1.Controls)
{
cl.properties of user control;
}
rahul
|
|
|
|