C#

uroojkhanpk wrote:

can v create an array or collection of SqlParameter and how?

SqlParameter[] parameters = new SqlParameter[numParameters];
parameters[0] = new SqlParameter.....

uroojkhanpk wrote:

if so then how it will be added to the SqlCommand object?

string currentText; // text obtained from file<br />
string [] seperated = currentText.Split(',');

using(StreamReader sReader = new StreamReader(@"c:\temp\test.txt"))
{
	string text = string.Empty;
	while((text = sReader.ReadLine()) != null)
	{
		Console.WriteLine(text);
	}
}

<br />
protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)<br />
{<br />
const int DEFAULT = 0;<br />
const string SQL = "EXEC GetStateListByID {1}"<br />
<br />
int liIndex;<br />
string lstrSQL;<br />
<br />
// Get Key value (Or Tag if Win Forms)<br />
liIndex = (int)DropDownList1.SelectedItem.Value;<br />
<br />
// Exit if default<br />
if(liIndex == DEFALT)<br />
return;<br />
<br />
// Format SQL string<br />
lstrSQL = string.Format(SQL, liIndex)<br />
<br />
<br />
// Populate DataGrid with results of query<br />
this.PopulateDataGrid(lstrSQL);<br />
<br />
}<br />
<br />

MethodInfoArray[i].Invoke(new object(), new object[] { datafrominputs });

Ista wrote:

Can I define events for an interface?