C#

Line 1224:            DataColumn c1 = ds.Tables["category"].Columns["ID"];

SayamiSuchi wrote:

i dont know why the error in this line ?

I are Troll

objDA.Fill(ds);
...

try {
    if (objDA==null) MessageBox.Show("Oh dear, objDA seems to be null");
    objDA.Fill(ds);
    ...
} catch(Exception exc) {
    MessageBox.Show("exception: "+exc.ToString());
}

DataColumn c1 = ds.Tables["category"].Columns["ID"];

select i.ID,j.Item,j.catID from category i, item j where i.ID = j.catID 

if (ds==null) MessageBox.Show("ds is null");
DataTable dtCat=ds.Tables["category"];
if (dtCat==null) MessageBox.Show("dtCat is null");
DataColumn c1=dtCat.Columns["ID"];
MessageBox.Show("we got a DataColumn!");

if (!ds.Tables.Contains("category") || !ds.Tables["category"].Columns.Contains("ID"))
   throw new ArgumentException("The category table or column does not exists!")
//
if (!ds.Tables.Contains("item") || !ds.Tables["item"].Columns.Contains("catID"))
   throw new ArgumentException("The item table or column does not exists!")

DataColumn c1 = ds.Tables["category"].Columns["ID"];Line 
DataColumn c2 = ds.Tables["item"].Columns["catID"];
dRel = new DataRelation("categoryItem", c1, c2);

select i.ID,j.Item,j.catID from category i, item j where i.ID = j.catID 

string query = @"select i.ID,j.catID,j.item from category i, item j where i.ID = j.catID";
SqlCommand objCmd = new SqlCommand(query, cnx);
SqlDataAdapter objDA = new SqlDataAdapter(objCmd);
DataSet ds = new DataSet();
objDA.Fill(ds,"category");
objDA.Fill(ds, "item");
DataColumn c2 = ds.Tables["category"].Columns["ID"];
DataColumn c1 = ds.Tables["item"].Columns["catID"];
dRel = new DataRelation("category_Item", c1, c2);
ds.Relations.Add(dRel);

 These columns don't currently have unique values.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: These columns don't currently have unique values.

Source Error:

Line 1231:           
Line 1232:            dRel = new DataRelation("category_Item", c1, c2);
Line 1233:            ds.Relations.Add(dRel);
Line 1234:            Repeater1.DataSource = ds;
Line 1235:            Repeater1.DataBind();

PostMessage(hWnd, WM_KEYDOWN, VK_F, VK_ALT);

HWND hOldForegroundWindow = ::GetForegroundWindow();
::SetForegroundWindow(hWnd);
::ShowWindow(hWnd, SW_MAXIMIZE);
::SetFocus(hWnd);
Sleep(100);

INPUT inputs[2];
memset(&inputs[0], 0, sizeof(INPUT) * 2);
inputs[0].type = INPUT_KEYBOARD;
inputs[0].ki.wVk = VK_CONTROL;
inputs[1].type = INPUT_KEYBOARD;
inputs[1].ki.wVk = 70; // f

::SendInput(2, &inputs[0], sizeof(INPUT));

Sleep(100);

inputs[0].ki.dwFlags = KEYEVENTF_KEYUP;
inputs[1].ki.dwFlags = KEYEVENTF_KEYUP;
::SendInput(2, &inputs[0], sizeof(INPUT));