Comments by Member 10794814 (Top 28 by date)

private void button3_Click(object sender, EventArgs e)<br>
{<br>
try<br>
{<br>
using (SqlConnection con = new SqlConnection("Data Source=ROHIT-PC\\SQLEXPRESS;Initial Catalog=FMS;Integrated Security=True"))<br>
using (SqlCommand cmd = new SqlCommand("select * from DEGREE_STUDENT UNION select * from JUNIOR_STUDENT where UID UNION select * from PAYMENT where STUD_UID =@UID",con))<br>
{<br>
cmd.Parameters.AddWithValue("@UId", txtUid.Text);<br>
con.Open();<br>
using (SqlDataReader reader = cmd.ExecuteReader())<br>
{<br>
if (reader.Read())<br>
{<br>
txtUid.Text = reader["UID"].ToString();<br>
txtName.Text = reader["STUDENT_NAME"].ToString();<br>
txtRoll.Text = reader["ROLL_NO"].ToString();<br>
txtGender.Text = reader["GENDER"].ToString();<br>
cbxYearname.Text = reader["YEAR_ID"].ToString();<br>
txtRemarks.Text = reader["REMARKS"].ToString();<br>
txtAcademicYear.Text = reader["ACADEMIC_YEAR"].ToString();<br>
txtAdmissiontype.Text = reader["ADMISSION_TYPE"].ToString();<br>
cbxCategory.Text = reader["CATEGORY_ID"].ToString();<br>
txtSubcategory.Text = reader["SUB_CATEGORY"].ToString();<br>
courseName.Text = reader["CLASS_ID"].ToString();<br>
mbxChequeno.Text = reader["CHEQUE_NO"].ToString();<br>
txtBankname.Text = reader["BANK_NAME"].ToString();<br>
textAmtpaid.Text = reader["AMOUNT_PAID"].ToString();<br>
 <br>
} reader.Close();<br>
con.Close();<br>
}<br>
}<br>
}<br>
catch (Exception er)<br>
{<br>
MessageBox.Show("There was an Error : " + er, "BFMS CRITICAL ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);<br>
 <br>
}<br>
}<br>
 <br>


this code not retrieve value from database

@ Jose Amilcar Ferreira Cassimiro
yes it is... it has some value

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 BhavansFMS.Cancel_ReportTableAdapters;

namespace BhavansFMS
{
public partial class Cancel_Admission_Report : Form
{
public Cancel_Admission_Report()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
Cancel_Admission_Report car = new Cancel_Admission_Report();
Cancel_Report ds = new Cancel_Report();
CANCEL_STUDENT_RECORDSTableAdapter ctr = new CANCEL_STUDENT_RECORDSTableAdapter();
ctr.Fill(ds.CANCEL_STUDENT_RECORDS);
car.SetDataSource(ds);
crystalReportViewer1.ReportSource = car;


}

private void SetDataSource(Cancel_Report ds)
{
throw new NotImplementedException();(The method or operation is not implemented.)
}




}
}