|
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.
|
|
|
|
|
ë is part of the ANSI code set; code page 1252.
You do not want to use UTF-7; it has nothing to do with ANSI and will do odd translations of characters.
Use System.Text.Encoding.GetEncoding(1252);
Anyone who thinks he has a better idea of what's good for people than people do is a swine.
- P.J. O'Rourke
|
|
|
|
|
Hello,
I've put a TabControl on a Form and added some buttons to add pages and change the Alignment.
When the Tabcontrol is left aligned (vertical tabs) I'd like it to display only one row of tabs with scroll buttons when it overflows. Just like when its alignment is Top.
private void button1_Click(object sender, EventArgs e)
{
tabControl1.TabPages.Add(new TabPage());
}
private void button2_Click(object sender, EventArgs e)
{
if (tabControl1.Alignment == TabAlignment.Top)
{
tabControl1.Alignment = TabAlignment.Left;
}
else
{
tabControl1.Alignment = TabAlignment.Top;
tabControl1.Multiline = false;
}
}
Any help on this would be sincerely appreciated.
|
|
|
|
|
hi
Increase the height of the Tab control
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
