C# Discussion Boards - CodeProject

Re: SQL Server 2008 in C# Console Appications

30-May-09 11:52

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.”

bigjoe11a30-May-09 12:03

bigjoe11a

30-May-09 12:03

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.

Updating changings back to DB from DataGridView

WinSolution30-May-09 3:11

WinSolution

30-May-09 3:11

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.

Re: Updating changings back to DB from DataGridView

Henry Minute30-May-09 4:12

Re: Updating changings back to DB from DataGridView

30-May-09 4:12

Try looking at this[^], it might help.

I Believe In GOD30-May-09 10:08

Re: Updating changings back to DB from DataGridView

30-May-09 10:08

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 ...

Henry Minute30-May-09 10:51

Re: Updating changings back to DB from DataGridView

30-May-09 10:51

Hi Stark DaFixzer,
Just posting to say I like the image in your user profile. Cute!

I Believe In GOD30-May-09 12:38

Re: Updating changings back to DB from DataGridView

30-May-09 12:38

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 ...

WinSolution31-May-09 1:31

WinSolution

31-May-09 1:31

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

Re: Updating changings back to DB from DataGridView

I Believe In GOD31-May-09 1:49

Get the absolute pix of Html Element Using mshtml

31-May-09 1:49

I am sorry this beyond my knowledge ... Frown | :(

forgive me ... Rose | [Rose]

I know nothing , I know nothing ...

Member 437807730-May-09 3:00

Member 4378077

30-May-09 3:00

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.

Please help

Etienne_12330-May-09 1:57

Etienne_123

30-May-09 1:57

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?

Henry Minute30-May-09 4:02

30-May-09 4:02

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?

I Believe In GOD30-May-09 10:11

30-May-09 10:11

try this idea with your code ...

dataset.Tables[0].WriteXml(....);

I know nothing , I know nothing ...

Etienne_12330-May-09 23:31

Etienne_123

30-May-09 23:31

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 Believe In GOD31-May-09 1:54

service of Events in C# [modified]

31-May-09 1:54

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 ...

arturw8230-May-09 1:40

arturw82

30-May-09 1:40

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

Re: service of Events in C#

Moreno Airoldi30-May-09 7:15

Moreno Airoldi

30-May-09 7:15

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. Smile | :)

2+2=5 for very large amounts of 2
(always loved that one hehe!)

wrong behaviour of Text Reader

vishal moharikar30-May-09 1:03

vishal moharikar

30-May-09 1:03

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.

Apocwhen30-May-09 1:49

Apocwhen

30-May-09 1:49

Try replacing your TextReader line with this:

TextReader textreader = new StreamReader(str, Encoding.UTF7);

Note the explicit setting of the Encoding argument

vishal moharikar31-May-09 18:16

vishal moharikar

31-May-09 18:16

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.

Moreno Airoldi30-May-09 7:21

Moreno Airoldi

30-May-09 7:21

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. Smile | :)

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Luc Pattyn30-May-09 7:32

Luc Pattyn

30-May-09 7:32

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).

Smile | :)

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.

Luc Pattyn30-May-09 7:38

Luc Pattyn

30-May-09 7:38

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.

Smile | :)

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.