[Help] Data two tables with c#

[User 9987049]

problem solved

[DamithSL]

where you set @Name_Directo parameter value? and also in your MappingDB2OO method you need "Id" column but I can't see in your query a column name with "Id"

[User 9987049]

@Name_Director is to get the value of the textbox.

But i think is impossible because a need construtor director. I don't know if you are understanding my problem. About mapping, is wrong ..but the problem isn't there.

[roya irani]

using the following code you write.

using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
using System.Data.SqlClient;

DataTable dataset = new DataTable();

dataset = Ds.DataTab("select M.*,P.Name,P.Id From Pay P Mem M where M.Id = " + Ds.TrueInt(Member.Text));

dataset = Ds.DataTab("select * from Pay where Member =" + Ds.TrueInt(Member.Text + ""));

dataset = Ds.DataTab(string.Format("select (Name+' ' + FName) as fullName from Mem where Id = '{0}'", Convert.ToInt32(Member.Text)));
NameFName.Text = dataset.Rows[0].Field<string>("fullName");

With this command you can use the SQL table at your disposal form (C #)