Comments by ramy nemer (Top 27 by date)

no this doesnt work for me , the values are in form2 ,i need to pass them to form1 to use it to insert to databaseto

yeah but can u give me an example of this please i apreciate it
thanks

index was out of range . must be non negative and less than the size of the collection. Parameter name = index

its better to use one sqlcommand for all queries ? am a little bit confused of this cz am having multiple tables to insert to and at last i need to use if all controls are !null it can save changes,so its more easy to use one sqlcommand for all queries to deal with this condition ??

you mean liike this :
string StrQuery = "INSERT INTO [dbo].[collaborationUnit] (incidentNo, PuserNickname, tokenId, PoliceUserRole) VALUES (@incidentNo, @PuserNickname, @tokenId, @PoliceUserRole)";

SqlCommand cmd10 = cnn.CreateCommand();
cmd10.CommandText = StrQuery;

for (int i = 0; i < dataGridView5.Rows.Count; i++)
{
cmd10.Parameters.AddWithValue("@incidentNo", newLastIncidentNo);
cmd10.Parameters.AddWithValue("@PuserNickname", dataGridView5.Rows[i].Cells["Column26"].Value);
cmd10.Parameters.AddWithValue("@tokenId", dataGridView5.Rows[i].Cells["Column31"].Value);
cmd10.Parameters.AddWithValue("@PoliceUserRole", dataGridView5.Rows[i].Cells["Column32"].Value);
cmd10.Connection = cnn;
cmd10.ExecuteNonQuery();
}

i have a question concerning iteration,while reading rows if there is a row having Id = newLastIncidentNo,i increment newLastIncidentNo,but i want the reader to start over again how should i do it ? this is the code :


using (var cmd105 = new SqlCommand("select incidentNoReserveId from [dbo].[incidentNoReserve]", cnn))
{
cnn.Open();

SqlDataReader reader = cmd105.ExecuteReader();

while (reader.Read())
{ //Every new row will create a new dictionary that holds the columns
if ((Convert.ToInt16(reader["incidentNoReserveId"])) == newLastIncidentNo)
{
newLastIncidentNo = newLastIncidentNo + 1;
//reader.Close();
}

}
cnn.Close();

}

very helpfull thanks , i am not deleting all rows,based on matching i am deleting a single row with the matching Id.
what am i trying to do is once running the application i bring the last Id +1 from incidentNo and then saving this id in incidentNoReserve tbl,if i exit the application this Id is deleted without saving anything but if application is saved this Id is saved in incidentNo tbl and deleted from incidentNoReserve ,by this work i can retrieve an Id upon form load and reserve a place for it in database. Now am changing and fixing the if statements to ensure safety in database.

it worked i erased the inner cnn.Open and close, but u mean adding in outer block a connection before using (var cmd106 = new SqlCommand("select * from [dbo].[incidentNoReserve]", cnn)) ??

yeah it make sense but am working on it to ensure security and safety. Thanks for your advice

the ID is incremented by 1 so no duplicate ID's is allowed, but there is a way to do that

the last query how should i put it in code

well i don't have a limited rows George, what i can do , i got lost here

on dataGridView7[e.RowIndex, 2].Value = drFound["fasileOne"];

private void dataGridView7_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if ((e.RowIndex > -1) && (e.ColumnIndex == 1)) // Assuming this is the streetId
{
int streetId = Convert.ToInt16(dataGridView7.Rows[e.RowIndex].Cells[e.ColumnIndex].Value);
DataRow drFound = tblSecondary.Rows.Find(streetId);
if (drFound == null)
{
MessageBox.Show("ddhhdhd");
}
else
{
dataGridView7[e.RowIndex, 2].Value = drFound["fasileOne"];
dataGridView7[e.RowIndex, 3].Value = drFound["fasileTwo"];
}
}

tblSecondary = new DataTable();

SqlCommand cmd2 = cnn.CreateCommand();
cmd2.CommandText = "select * from street";
SqlDataAdapter sdr2 = new SqlDataAdapter(cmd2);
cmd2.CommandType = CommandType.Text;
cmd2.Connection = cnn;
sdr2.Fill(tblSecondary);
tblSecondary.PrimaryKey = new DataColumn[] { tblSecondary.Columns["streetId"] };

i changed the position of the primary key,its working but an exception occurs :
Index was out of range. Must be non-negative and less than the size of the collection.

thanks george , but i have the tblsecondary having all columns,i marked the primary key in it, when running the program its giving me that this table doesnt have a primary key why ?

sorry can you give any suggestion or a simple code of how do it that please

with isfsectionId1 and isfsectionId2 (foreign keys for isfsectionId in isfsections)
i have the table street :
streetId streetName areaId isfsectionId1 isfsectionId2
1 street1 3 8 5
2 street2 5 4 null

i need when i click streetname in comboboxcolumn index 1 the two textboxes is filled automatically with isfSectionName

well thanks, am new to c# and collection i will try to search for it

well am completely lost have been spending a long time for fixing this issue but dead end ,can u provide me simple code or a reference i can get help please

Thanks my friend i will take it into consideration

nothing changed still the same