how can i read multiple connection string from datagridview

Feroz Khan

how can i read multiple connection string from datagridview like see below details..
i want that if source column and userid and password is ok then update data...

for example:

soruce column,       userid column,      password column
192.168.1.2             abcd                       1234
192.168.1.3             abcde                      2389
192.168.1.4            abcdef                      45612

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Feroz Khan11y ago
ok ..

i have 5 computers in all computer connected with network and i have install database oracle10g in all computer table name same column same but database name difrent database name like 12345 and password in all computer same and i create one more table in my system in this table i have mention all computers ip addresses, database name, and password.. i have created one user in all table same name so i want update password in same user id in all computers.. so i want show the table in datagridview in which table i have all computer IP address database name and password so i want just mention user id and password then click button should be update in all computers tables....
Joginder Banger11y ago
if you want get data from grid, what you think about this code.
foreach (DataGridViewRow row in dataGrid.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
string value = cell.Value.ToString();

}
}
Joginder Banger11y ago
@feroz Khan,

I have no idea what you want and what are trying. Please explore the problem for better understand. what type of data you want update.
Feroz Khan11y ago
Dear,

How can i mention in below code complete row i dont want mention row index i want just mention column index and i want read mention column index complete data..

private void button1_Click_1(object sender, EventArgs e)

{

string ip = GridView.Rows[0].Cells[5].Value.ToString();
string user = GridView.Rows[0].Cells[4].Value.ToString();

}
Akhil Garg11y ago
If you are using MVVM then you can pass entire datagrid view on any event say click event of button(put button after datagridview) or on Loaded command also you can pass datagridview and iterate.
Feroz Khan11y ago
you have any idea about so please tell me.. or just tell me how can i read particular column and rows... thanks..
Akhil Garg11y ago
Obviously you need to iterate through each row and pass servername ,userid and password to your database function instead of hardcoding or fetching connection string from config files.