select from a datatable - C# Discussion Boards

Re: Microsoft Code Blocks?

27-Sep-06 5:23

Hello

What's the format of the integer? Is it YYYDDMM, days, monthes, weeks???

Regards

Microsoft Code Blocks?

kumar.bs27-Sep-06 4:38

kumar.bs

27-Sep-06 4:38

Can anybody tell me something about Microsoft Code Blocks?

kumar
(Beginner)

Nader Elshehabi27-Sep-06 5:03

Re: Microsoft Code Blocks?

27-Sep-06 5:03

Hello

Click here.[^]

Regards

Judah Gabriel Himango27-Sep-06 6:06

Judah Gabriel Himango

27-Sep-06 6:06

Whoa! It's all in sanscript/Arabic, and it's right-to-left! Smile | :)

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: For Christians: The Significance of Yom Teruah
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: Microsoft Code Blocks?

Michael P Butler27-Sep-06 6:30

Michael P Butler

27-Sep-06 6:30

kumar.bs wrote:
Can anybody tell me something about Microsoft Code Blocks?

Do you mean application blocks[^]?

What do you want to know?

As the site says

Application Blocks are reusable source-code components that provide proven solutions to common development challenges. They can be integrated as is into applications, or they can be extended or customized. patterns & practices Application Blocks address specific recurring problem domains such as data access, logging, user interface process, and composite user interfaces.

Michael

CP Blog [^] Development Blog [^]

select from a datatable

playout27-Sep-06 4:26

27-Sep-06 4:26

Hi,

I am trying to run a select query on a datatable.
The datatable holds information I get from an Access database.

My code:

<br />
            OleDbConnection myConn = new OleDbConnection();<br />
            myConn.ConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=" + DBPath;<br />
<br />
            OleDbCommand myCommand = new OleDbCommand();<br />
            myCommand.Connection = myConn;<br />
            myCommand.CommandText = "Select * from [tblMembers] where Active = false";<br />
            myCommand.CommandType = System.Data.CommandType.Text;<br />
            System.Data.DataTable myTable = new System.Data.DataTable("myTable");<br />
<br />
            OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myCommand);<br />
            myDataAdapter.Fill(myTable);

I have to query three columns in the datatable (MemberID, MemberLanguage, MemberName), and bind those info to the following variables:

intMemberID, strMemberLanguage, strMemberName

How can I do this?

Nader Elshehabi27-Sep-06 4:37

27-Sep-06 4:37

Hello

You can do that using OleDbCommand.ExecuteReader() that will return a DataReader object. Using it you can get your results.
About the columns selection, then you sould modify your SELECT statement. Binding them to these three variables is quite unclear. Data binding is done with bindable controls, not variables.

Regards

Not Active27-Sep-06 4:53

27-Sep-06 4:53

Nothing wrong with using the DataTable he has. The DataReader is a connected object which may not be optimal for the situation.

only two letters away from being an asset

playout27-Sep-06 19:53

27-Sep-06 19:53

Nader Elshehabi wrote:
You can do that using OleDbCommand.ExecuteReader() that will return a DataReader object. Using it you can get your results.
About the columns selection, then you sould modify your SELECT statement. Binding them to these three variables is quite unclear. Data binding is done with bindable controls, not variables.

This is not really what I wanted, I already have the info in the datatable, I just need to query it, using some sort of select statement, where I can select the current row that has the values I need, and bind those values to variables.

Not Active27-Sep-06 4:51

27-Sep-06 4:51

intMemberID = Convert.ToInt32(myTable.Row[0]["MemberID"]); ...

only two letters away from being an asset

Nader Elshehabi27-Sep-06 4:59

27-Sep-06 4:59

I'd be extremely surprised if that's what he was asking about?!! I had all sorts of guesses jumping in my mind of what really he was asking about. A guy who makes an SqlConnection didn't know how to convert a string to Int32?!! WTF | :WTF:

Regards

playout27-Sep-06 19:51

27-Sep-06 19:51

Nader Elshehabi wrote:
I'd be extremely surprised if that's what he was asking about?!! I had all sorts of guesses jumping in my mind of what really he was asking about. A guy who makes an SqlConnection didn't know how to convert a string to Int32?!!

I am not sure if you were talking of my message, but what I meant was. I have a datatable, already filled with information from the database. Now I need to use some of the data in that datatable, bind to a variable I can use throughout my application. I am building the app as a windows app.

The problem is, I have a MemberID(it's unique and primary key), that I need to use to get the member's language and name from the datatable. So I wanted to do something like

SELECT MemberID, MemberLanguage, MemberName FROM "mytable" where MemberID = strCurrentMemberID<br />
'mytable = the datatable

I dont know how to do this select from a datatable.

Not Active28-Sep-06 2:09

28-Sep-06 2:09

playout wrote:
SELECT MemberID, MemberLanguage, MemberName FROM "mytable" where MemberID = strCurrentMemberID
'mytable = the datatable

That should do it

only two letters away from being an asset

playout27-Sep-06 19:56

27-Sep-06 19:56

Thanks, this might be helpful, only problem is, I dont know what row the value is in, so how can I search via row?

EG: The member details for the current row can be in row 5 or 68 for that matter, the only reference I have, is an employee number.

Not Active28-Sep-06 2:11

Re: Access metod from thread

28-Sep-06 2:11

Given your scenario and my understanding of it, if you have more that one record returned then you have something wrong in your database.

only two letters away from being an asset

Access metod from thread

Neuromancer_27-Sep-06 4:20

Neuromancer_

27-Sep-06 4:20

Please help! How can i access metod UpdateRows from another thread in this code?
Thanks.

using ...

namespace pddServer
{
public partial class Form1 : Form
{
public class ThreadedTcpServer
{
public void StartServer()
{
ConnectionThread newconnection = new ConnectionThread();
Thread newthread = new Thread(new ThreadStart(newconnection.HadnleConnection));

newthread.Start();
}

class ConnectionThread
{
public void HadnleConnection()
{
connections++;

//
// How can i call method UpdateRows from this place?
//
connections--;
}
}
}

private Thread ServerThread;

public Form1()
{
InitializeComponent();

ThreadedTcpServer Server = new ThreadedTcpServer();
ServerThread = new Thread(new ThreadStart(Server.StartServer));
ServerThread.Start();
}

private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
ServerThread.Abort();
}

public void UpdateRows()
{
dataGridView1.Rows.Add();
}
}
}

Nader Elshehabi27-Sep-06 4:34