|
Apart from the fact that you execute the command twice:
MyCmd.ExecuteNonQuery();
Int32 rowsAffected = MyCmd.ExecuteNonQuery();
I could not see anything wrong with the code, as it is. So I copied and pasted it into a project. To get it to compile on my machine I changed all your calls to RMDoor.whatever to Console.whatever and commented out the savelog line. I created a new database, added a table called UserData with two columns Name and telnetaddr both nvarchar(50).
In the project I created a new DataSource ConsoleUsersTestDataSource from the database above, and ran the project.
Because the command executes twice, it added two new records, with identical data.
Just so that you can see that my code is essentially identical to yours, here it is:
class Program
{
static void Main(string[] args)
{
add();
}
public static void add()
{
Console.Clear();
Person addr = new Person();
Console.Write("Enter Name : ");
addr.name = Console.ReadLine();
Console.Write("Address : ");
addr.telnetaddr = Console.ReadLine();
Console.Clear();
Console.WriteLine("BBS Name : " + addr.name);
Console.WriteLine("Telnet Address : " + addr.telnetaddr);
Console.WriteLine();
Console.Write("Is this what you want Y/N");
string Q = Console.ReadLine();
Q = Q.ToUpper();
if (Q == "Y")
{
string UserConnection = Properties.Settings.Default.ConsoleUsersTestConnectionString;
SqlConnection MyConnection = new SqlConnection(UserConnection);
String MyString = @"INSERT INTO UserData (Name, telnetaddr) VALUES('" + addr.name + "', '" + addr.telnetaddr + "')";
SqlCommand MyCmd = new SqlCommand(MyString, MyConnection);
MyConnection.Open();
try
{
MyCmd.ExecuteNonQuery();
Int32 rowsAffected = MyCmd.ExecuteNonQuery();
Console.WriteLine("RowsAffected: " + rowsAffected);
MyConnection.Close();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
else
{
Console.WriteLine("Save Aborted");
}
Console.WriteLine("Press Enter to Continue");
Console.WriteLine();
}
}
I can only suggest that you try cleaning your solution (Build | Clean Solution, just in case you don't know) and then rebuild it.
If it doesn't work then, I can only assume that there is something wrong with your database; or you have duplicate databases and that you are updating one of them and checking the other for changes, which obviously won't be there; or something really weird like that.
Apart from deleting the extra ExecuteNonQuery() line I am at a loss.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks. That's works now. It turned out to be the table name was wrong. That's why.
It Shows as UserData and it should be UaersData.
What I did was I went back and check my lines again making sure they were all spelled right and so. I changed so many times. I forgot to change it back.
I can't under stand why it didn't throw an error.
Ok, now. Now how about a search. How can I setup a search. Using the same code or is that not the same.
string sname = "Tom Cat";
So how would I search for this name and if it finds it, it displays the record. If not it throws an error.
|
|
|
|
|
For that you will need to use a SELECT Command, which would look something like:
SELECT * FROM dbo.UaersData WHERE Name = @userName
******************************** Note **************************
This is only approximate. and it uses a parameter (the @userName)
However instead of that you can do as you have done for the INSERT and break the string into bits, a bit like:
string commandString = "SELECT * FROM dbo.UaersData WHERE Name = '" + theVariableHoldingTheNameFromTheConsole + "'";
In order to use it efficiently however you really should use the Prameterized methodology.
In the mean time take a look at this[^], scroll down till you reach the Executing SQL Statements that Return Rows Using a Command Object section. This is very similar to the method you have been using. You will then need to research the SqlDataReader object to find out how to get the data from the reader
As this is really basic stuff, I think you will be better off if you do some reading in the MSDN Documentation, and by googling.
If you have any further questions, I would suggest that you start a new thread, as I will be away from my PC for a few hours.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Well I wanted to tell you too. That when I added the new record. It added it. But is didn't save it to the database. When I added the record. And I when to view all the records. The 3rd and new record was there. How ever when I closed the application and
look in the database explorer. to view the records. The 3rd record was missing. Looks like it never got added to the database file.
And all so I have been doing searches for all this at google and I go throw 100's of pages and still can't find what I'm looking for.
Thats why I desided to post.
|
|
|
|
|
Dear All
I want to updated the changes made in DataGridView back to SQL Table in an easiest way while i am working with 3-Tire approach (GUI, BusinessLogic, DataAccess)
I have search a lot on Google but i am not able to find a good,simple and easy solution.
Thanks for helping.
|
|
|
|
|
Try looking at this[^], it might help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi , if you want to save datagrid back to SQL database then there is a very simple rules :
- every table must have PK ( Exception will rise if don't )
ds = new DataSet("tb");
clsConnect.SqlDa = new SqlDataAdapter("SELECT * FROM tb1 WHERE ID = 2", clsConnect.SqlCon);
clsConnect.SqlCmdBuild = new SqlCommandBuilder(clsConnect.SqlDa);
clsConnect.SqlDa.InsertCommand = clsConnect.SqlCmdBuild.GetInsertCommand();
clsConnect.SqlDa.DeleteCommand = clsConnect.SqlCmdBuild.GetDeleteCommand();
clsConnect.SqlDa.UpdateCommand = clsConnect.SqlCmdBuild.GetUpdateCommand();
clsConnect.SqlDa.Fill(ds , "tb");
dataGridView1.DataSource = ds.Tables[0];
clsConnect.SqlDa.Update(ds.Tables[0]);
ds.Tables[0].AcceptChanges();
I know nothing , I know nothing ...
|
|
|
|
|
Hi Stark DaFixzer,
Just posting to say I like the image in your user profile. Cute!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thank you , this picture is "Baby Tux" .. linux stuff
here is a big one , you can have it ...
Click Here please
I know nothing , I know nothing ...
|
|
|
|
|
Thanks
But i need an example that is based on 3-Tire Architecture.(GUI, BusinessLogic, DataAccess)
i have tried such code with 3-Tire Arch.
but it cause an error like "DataTable already belongs to another DataSet".
|
|
|
|
|
I am sorry this beyond my knowledge ... 
forgive me ... ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
I know nothing , I know nothing ...
|
|
|
|
|
Hi.
I just want to get the absolute pixes of Html Element by using mshtml. This parsing and rendering engine of the web browser gives us these co-ordinates of a bounding rectangle of the Html Element. I don't know whether mshtml can help me out.
|
|
|
|
|
Hi
I'm using a typed dataset which was generated for me by adding a new data source via the visual studio wizard. My problem is, when I call the WriteXml
method on my dataset (e.g. dsDemo.WriteXml) it creates an XML file yes, but the only thing in the XML file is the following:
<?xml version="1.0" standalone="yes" ?>
<_Workstation_aXYZDataSet xmlns="http://tempuri.org/_Workstation_aXYZDataSet.xsd" />
Why does it not show all my table data?
|
|
|
|
|
Without seeing at least some of the code, it will be very difficult for anyone to help you.
The only question that springs to mind is; does the dataset contain any tables?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
try this idea with your code ...
dataset.Tables[0].WriteXml(....);
I know nothing , I know nothing ...
|
|
|
|
|
This does not work either.
Let me give you a sample of my code.
I've added a datasource via the Visual studio wizard, it then created DataSet for me called _Workstation_aXYZDataSet.
What I then did, is create a new instance of this by doing this: _Workstation_aXYZDataSet dsWorkStation = new _Workstation_aXYZDataSet, which I think my problem is since I create a NEW instance. I then try calling the WriteXml() method on dsWorkstation
When I type dsWorkstation. it shows me a drop down list of all the tables, meaning it has tables right? Or maybe not?
Isn't there a way to call WriteXml() direclty from _Workstation_aXYZDataSet which was created for me as a strongly typed dataset?
|
|
|
|
|
I really don't wanna answer you with puzzles , so I will give a clue about how do my projects ...
- Keep in mind , after create a new instance of dataset you must fill it with dataadpter.
- Try to Create Dataset by code : like this :
DataSet ds = new DataSet();
SqlDataAdapter Sqlda = new ("SELECT * FROM table" , SqlConnection);
Sqlda.Fill (ds);
ds.Tables[0].WriteXml(...);
Hope this help ....
I know nothing , I know nothing ...
|
|
|
|
|
I have class like Project, and UseCase AddProject.
Like below. How should I implement the service of event, message: "Project was added corectly", or "Project was not added (Project exist)" and send message to user.
Events in C#, or what?:/
Maby application class should have implement event?
public event myEventHandler ProjectAdded;
What is the best practice?
public MyMessage AddProject(params string[] ProjectData){
Project tempProject = new Project();
tempProject.Id = Guid.NewGuid();
tempProject.Name = ProjectData[0];
tempProject.Number = ProjectData[1];
if (!m_Project.Contains(tempProject))
{
m_Project.Add(tempProject);
return new MyMessage(true,string.Format("Project: {0} ADDED",tempProject.Number));
}
else
{
return new MyMessage(false,string.Format("Project: {0} NOT ADDED (Project exist).", tempProject.Number));
}
}
public struct MyMessage
{
private bool _executed;
private string _message;
public MyMessage(bool executed, string message)
{
_executed = executed;
_message = message;
}
public bool IsExecuted
{
get
{
return _executed;
}
}
public string Message
{
get
{
return _message;
}
}
}
In program....
Console.WriteLine(ap.AddProject("Name" , "0000000001","Description", DateTime.Now.ToString(), DateTime.Now.ToString()).Message);
modified on Saturday, May 30, 2009 7:59 AM
|
|
|
|
|
Well you should use events if you want to handle the message asynchronously.
Your "In program...." example shows you handle it synchronously, so what you did should be fine. 
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
Hi there.........
I am using text reader to read a text file. I have used the following code:
string str = "C:\\MKS.txt";
TextReader textreader = new StreamReader(str);
string inline = "";
while ((inline = textreader.ReadLine()) != null)
{
if (rtEngData.Text == "")
{
rtEngData.Text = inline;
}
else
{
rtEngData.Text = rtEngData.Text + Environment.NewLine + inline;
}
}
Here in my input file (in this code C:\MKS.Txt), a character ë is used.
(Go to the notepad and type ALT+0235, you will get the character.)
Now when I read this file, for this character it reads '�' .
Please tell me if there is any problem with my code block. or suggest me to get proper character.
Thanks....
Vishal.
|
|
|
|
|
Try replacing your TextReader line with this:
TextReader textreader = new StreamReader(str, Encoding.UTF7);
Note the explicit setting of the Encoding argument
|
|
|
|
|
Hi there....
Thanks for you suggestion. It worked.
The character I used ë is present in arial font. Can you please describe me why to use "UTF7".
Arial is a 1 byte font. So, in my opinion it should work without any encoding.
Thanks.......
Vishal.
|
|
|
|
|
Another useful suggestion is you should use a StringBuilder like:
StreamReader textreader = new StreamReader("C:\\MKS.txt", Encoding.UTF7);
string inline;
StringBuilder sb = new StringBuilder();
while ((inline = textreader.ReadLine()) != null)
{
sb.Append(inline);
sb.Append(Environment.NewLine);
}
rtEngData.Text = sb.ToString();
This will be much more performing.
2+2=5 for very large amounts of 2
(always loved that one hehe!)
|
|
|
|
|
You are right, however this isn't optimal either. Since you can easily get the file size, you should create the SB with an initial capacity equal to say 1.5 times that (allowing for the NewLines), so it never has to extend itself (which causes all data to be copied).
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hi,
why are you reading a stream yourself?
if you can hold all the data in memory, chances are you can afford to do this too:
string[] lines=File.ReadAllLines(str);
rtEngData.Text=string.Join(Environment.NewLine, lines);
and, depending on what line separators are in the file, maybe
rtEngData.Text=File.ReadAllText(str);
is all you need.
FYI: these File methods also accept an Encoding parameter if you need one.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
