I am using service-based Database and entity model for creating and recording data.I am able to record and view the data in gridview. But I need to search the data In the gridview. How I can I do this Plz help.
(suppose I record 3 data..the names are A,B,C...when I write in the textbox is A then I need to show the full data of A, that means only the table row of A....(means the name,bloodgroup,address and cellno of A)
form 1 code:
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;
namespace BloddBankManagement
{
public partial class BloodBankForm : Form
{
public BloodBankForm()
{
InitializeComponent();
}
private void Btnregister_click(object sender, EventArgs e)
{
RegisterUser user = new RegisterUser();
user.Show();
}
private void buttonview_Click(object sender, EventArgs e)
{
ViewRecords record = new ViewRecords();
record.Show();
}
}
}
RegisterUser code:
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.SqlClient;
namespace BloddBankManagement
{
public partial class RegisterUser : Form
{
private Database1Entities2 bloodbank= new Database1Entities2();
public RegisterUser()
{
InitializeComponent();
}
private void button1click_register(object sender, EventArgs e)
{
BloodBankM bank = new BloodBankM();
String name1 = textBox1.Text;
String bldgrp=textBox2.Text;
String address = textBox3.Text;
String cellno = textBox4.Text;
bank.Name = name;
bank.Bloodgroup = after;
bank.Address = address;
bank.Cellno = cellno;
bloodbank.AddToBloodBankMs(bank);
bloodbank.SaveChanges();
MessageBox.Show("Record Saved");
}
}
}
ViewRecordscode:
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.Objects;
using System.Data.SqlClient;
namespace BloddBankManagement
{
public partial class ViewRecords : Form
{
private Database1Entities2 bloodbank = new Database1Entities2();
public ViewRecords()
{
InitializeComponent();
dataGridView1.DataSource = bloodbank.BloodBankMs;
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
//I need the data search code here
}
}
}