C#

emran834 wrote:

But I dont know the right Snippet to refresh the Disconnected DataSet So that The DataSet should Open The Connection Again and load the the new data from the Physical Database Just After Clicking a button responsible for ADD or Delete.

<br />
public void fillgriddd()<br />
{<br />
SqlDataAdapter sd = new SqlDataAdapter("select * from country",Con);<br />
DataSet ds = new DataSet();<br />
sd.Fill(ds);<br />
dg.DataSource=  ds.Tables[0].DefaultView;;<br />
}<br />
<br />
private void button1_Click(object sender, System.EventArgs e)<br />
{<br />
fillgriddd();<br />
}<br />
<br />
private void button2_Click(object sender, System.EventArgs e)<br />
{<br />
SqlDataAdapter sd = new SqlDataAdapter("delete from country where ctryname = 'austria'",Con);<br />
Con.Open();<br />
sd.SelectCommand.ExecuteNonQuery();<br />
Con.Close();<br />
fillgriddd();<br />
}<br />
<br />

fmardani wrote:

does this mean that we only require one license for all the users to connect to sql server?

<br />
System.Collections.Hashtable h = new Hashtable();<br />
foreach (Microsoft.Office.Interop.Excel.Worksheet ws in wrkBook.Worksheets)<br />
{<br />
<br />
  if (ws.Name != null)<br />
  {<br />
    this.lstSheets.Items.Add(ws.Name);<br />
    strWorksheet = ws.Name.ToString();<br />
    h.Add(strWorksheet, ws);<br />
  }<br />
}<br />