Please Friends Help me i have 4 tables 1. Master Book Table (MBookId,BookId,AuthorId,PubId) 2. Book Name ( BookId,BookName) 3. Author Name (AuthorId,AuthorName) 4. Publisher Name (PubId, PubName) DAL UI Layer DAL ---- Please suggest me how to achieve Datarelationship

DataRelation dr = new DataRelation("BookBookName",
ds.Tables["MBook"].Columns["BookId"],
ds.Tables["Book"].Columns["BookId"]);

        ds.Relations.Add(dr);

is this right ? and how to use this in UI to get data, insert,update, save.. etc i google a lot but didn't find the right solution for my purpose and is datarelation ship with dataset is better or NHIBERNATE if nhiberate is better then do ineed to start in from start i mean i have to create the tables and all that once.......... i have already created the datatable and DAL methods of Save Edit etc.... Please Help Thank you very much EveryOne..... (specially CODEPROJECT)

oops i am sorry........thanks for the reply

yes....

Sir i have created 4 tables in which 1 is the master table Case table 1 : Author_id (P.K) Author_name Table 2 : Pub_id (p.k) Pub_name table 3 : Book_id (p.K) Book_name Table 4 ( master Table) MBD (p.k) Book Name ( drop down box) Author Name ( drop down Box) Pub name ( drop down box ) Qty Price ==================================== as you seen in the 4th table i have to add the book name( from table 1), pub name(from table 2) and author name(from table 3). in the table 4 i don't want to store their names i want to store their ID ..... book_id, pub_name, author_name.... any suggestion friends ? Thanks

The application developer used the .Net Framework, just install the framework and Re-run the application Remember to Reboot HAPPY WORKING

Any more Suggestions from anyone :) thanks

ok thanks

Hello Everyone In my project i have a modules in which sub modules are as., 1. Admin( entering the Emp Details) 2. Operator ( Entering the Visitor Details) 3. Client (Emp's) at start the login window will come and then deponding the user name and password they will login i have already created Admin and Operator and working file Admin will enter all the details of employee. Operator : when visitor comes he will enter the details of visitor like name, company number Photo (using webcam) of Visitor etc..... then this information needed to send the person whom the visitor want to meet ( Client) (Employee) through LAN. As soon as the Operator send the information and Emp will see the photo and details, he has the option of accepting or rejecting....... if accepting print the Visitor Card..... or else leave i am not getting wat to use. Socket or Remoting or WCF ? does socket support image sending? i thought about WCF but finding it diffcult to implement kindly help me Thanks in adavance

Please Suggest me the Best Book for WCF. i have seen many articles of WCF but still my concepts are not clear. i am not that good :(, thanks for reply in Advance

your welcome........best of luck... happy coding

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.IO; namespace WindowsFormsApplication1 { public partial class Form1 : Form { static OleDbConnection con; //static OleDbCommand cmd; public Form1() { InitializeComponent(); Connect(); } DataSet ds = new DataSet(); DataTable dt = new DataTable(); private bool Connect() { string DB_Path= @"E:\Office Project\salary project\AttendanceSummary.xls"; string Con_Str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DB_Path + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\";"; con = new OleDbConnection(Con_Str); con.Open(); //string query = "SELECT SNO, ECODE, NAME, PRESENT, ABSENT, OFF, LEAVE, LWP, OTHOURS FROM [AttendanceSummary$]"; string query = "SELECT * FROM [AttendanceSummary$]"; OleDbDataAdapter oda = new OleDbDataAdapter(query, con); DataSet ds = new DataSet(); DataTable dt = new DataTable(); oda.Fill(ds); ds.Tables.Add(dt); string n = ds.Tables[0].Columns[0].ToString(); MessageBox.Show(n); for (int i = 1; i < ds.Tables [0].Rows .Count ; i++) { string result = (ds.Tables[0].Rows[i][ds.Tables [0].Columns [0].ToString ()]).ToString(); comboBox1.Items.Add(result); } //DataSet ds = new DataSet(); // DataTable dt = new DataTable(); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Update(); if (con.State == ConnectionState.Open) { MessageBox.Show("Connected"); return true; } else return false; //// oda.Dispose(); // con.Close(); } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { //ds.Tables.Add(dt); int index = comboBox1.SelectedIndex +1 ; textBox1 .Text = (ds.Tables[0].Rows[index][ds.Tables[0].Columns[2].ToString()]).ToString();

thanks sir i got......... thank you very much.......

Sir i am trying like this.... getting the todays date and then number of records and then adding +1 to the number of records...... if date is changed (means next day) then again start from 1 and then +1 .... is this right ? thanks for help

thanks for reply i am using SQL DB

in my project, i need Serial No like 1, 2, 3, in sequence in date wise for Example today is 28/10/2009......so the serial no should be like 1.2.3 and when the date changes it must start again 1.2.3 any idea ? thanks for help

thanks i will see it ....... thanks

thanks. can u give any example/sample reference link

Sir last time u told me to store the file on shared location. i used that i am running on 2 client and its working fine. but how come forwarding and pausing that option . As when server will forward the video the video on the client should also be forwards sorry sir,

I made a Server / Client ( socket Connection) in Server Form i am having a Panel in which a Video will be played selected by the Server Admin, i want to same file should be played on 25 client machine. whatever actions done by the admin like forwarding etc. should be showen on the client . is this possible. can we stream the video files like this. help me thanks in advance

sir then how to do that. :( cann't i call a method from the server and used it in the client ?