C#

private void li_name_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)<br />
{<br />
e.DrawBackground();<br />
			     <br />
Brush myBrush = Brushes.Black;<br />
//<br />
// Determine the color of the brush to draw each item based on <br />
// the index of the item to draw.<br />
//<br />
long AID=0;<br />
DataRowView D_Author_name=(DataRowView)li_name.Items[counter_item];<br />
string Author_name=D_Author_name["Name"].ToString().Trim();<br />
Authors author=new Authors();<br />
AID=author.find_AuthorID(connection.make(),string_process.editition(Author_name));<br />
counter_item=counter_item+1;<br />
if(AID !=0)<br />
{<br />
myBrush = Brushes.DarkGray;<br />
}<br />
e.Graphics.DrawString(((ListBox)sender).Items[e.Index].ToString(), <br />
e.Font, myBrush,e.Bounds,StringFormat.GenericDefault);<br />
//<br />
// If the ListBox has focus, draw a focus rectangle around the selected item.<br />
//<br />
e.DrawFocusRectangle();<br />
<br />
<br />
}

<br />
public class Authors<br />
{<br />
OleDbConnection con;<br />
OleDbCommand cmd;<br />
<br />
public long find_AuthorID(string cnstring,string Author_name)<br />
{<br />
try<br />
{<br />
con=new OleDbConnection(cnstring);<br />
string cmdstr="select id from authors where name='" + Author_name.Trim() + "'" ;<br />
int id=0;	<br />
cmd=new OleDbCommand(cmdstr,con);<br />
cmd.CommandType=CommandType.Text;<br />
con.Open();<br />
OleDbDataReader rd;<br />
rd=cmd.ExecuteReader();<br />
if (rd.Read())<br />
{   <br />
<br />
id=(int)rd[0];<br />
con.Close();<br />
<br />
return id;<br />
					<br />
}<br />
else<br />
{<br />
con.Close();<br />
return 0;<br />
					<br />
}<br />
}<br />
catch (Exception ex)<br />
{<br />
MessageBox.Show(ex.Message);<br />
return -1;<br />
				<br />
}<br />
}<br />
}<br />