@ThatThatGuy
Yes I was already use that,
but its not working,
Please just check it at once with my snippet in which I was trying to put autosuggest text box only:-
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;
namespace DatagridExample
{
public partial class Form1 : Form
{
AutoCompleteStringCollection scAutoComplete = new AutoCompleteStringCollection();
public Form1()
{
//AutoCompleteStringCollection scAutoComplete = new AutoCompleteStringCollection();
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string strCon = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DBAccount.accdb";
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbConnection conn = new OleDbConnection();
DataSet ds = new DataSet();
conn = new OleDbConnection(strCon);
da = new OleDbDataAdapter("Select *from Bill", conn);
da.Fill(ds, "Bill");
dataGridView1.DataSource = ds.Tables("Bill");
OleDbCommand cmd = new OleDbCommand("Select ItmCode from Bill", conn);
OleDbDataReader reader = new OleDbDataReader();
OleDbDataReader dr = new OleDbDataReader();
conn.Open();
dr = cmd.ExecuteReader;
while (dr.Read)
{
scAutoComplete.Add(dr.GetString(0));
}
conn.Close();
}
private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
if (dataGridView1.CurrentCell.ColumnIndex == 1 && e.Control is TextBox)
{
((TextBox)e.Control).AutoCompleteMode = AutoCompleteMode.SuggestAppend;
((TextBox)e.Control).AutoCompleteSource = AutoCompleteSource.CustomSource;
((TextBox)e.Control).AutoCompleteCustomSource = scAutoComplete;
}
}
}
}
====================================
I got some error on these below line:-
1. dataGridView1.DataSource = ds.Tables("Bill");
" Error 1 Non-invocable member 'System.Data.DataSet.Tables' cannot be used like a method."
2. OleDbDataReader dr = new OleDbDataReader();
("Error 2 The type 'System.Data.OleDb.OleDbDataReader' has no constructors define ")
please help in this snippet............