C# apllication for Authentication through data link layer.

Question

Need to connect to datalinklayer(3 tier architecture) using SQL Server 2000 and develop an application for authentication using C#. Please reply immediately. DK

Answer 1

Yes, getting values from data-bound comboboxes and listboxes can be tricky.

I'd try:

if (comboBox1.SelectedIndex >  -1)
{

    DataRowView drv = (DataRowView)comboBox1.SelectedItem;

    int garbr = Convert.ToInt32(drv[comboBox1.DisplayMember].ToString());

    com.Parameters.AddWithValue("@Garbr", garbr);
}

Answer 2

I its not working by selectedValue and dataview type casting only for datatable then use following code:

string matchValue= textbox.Text;

int _id,MainId;

foreach (DataRow row in datatableobject.Rows)

{

if (row["Name"].ToString().Contains(matchValue))

{

_id = Convert.ToInt32(row["ID"]);

MainId = _id;

}

}

You can use this is for textbox also and if you want to check like search then use Contains otherwise use row["Name"].ToString()==matchValue.

If it works then give me feedback.

Answer 3

Hi Vulpes,
Can you please help me how it would be the opposit situation?
I  have a combobox and when clicking on a datagridview row I retrieve the values of  the row in the combobox, datatimepicker.... But the combobox.selecteditem  doesn't return the correct value. Again because of the DataGridView  type.

I have

comboBox1.SelectedItem =

Convert.ToInt32(dataGridView2.SelectedRows[0].Cells[0].Value);

but it is not changing when clicking on different rows in  the datagridview.
Can you please help me?
I will post this as a new post  now.

Thanks in advance

Answer 4

Thank you very much Vulpes:)