DataSourceSelec tArguments error

[ashkaan57]

Hi all,
I am new to ASP.NET and VS 2005 Express.

I am having problems with an error message and can't figure out why.
I am trying to run a "SELECT" query triggered by a change in dropdown .
When I hit the line:

DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));
in the code below, I get:
"Format of initializaion string does not conform to specification
starting at index 0".

I changed it so DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
and used args as the parameter, but I got the same error message. her
is the code:

("SiteName" is the name of the dropdown in the form, "SiteID" is a
field in table "Sites", also used as the value in the dropdown.)

protected void SiteName_Select edIndexChanged( object sender,
EventArgs e)
{
SqlDataSource SiteInfoDS = new SqlDataSource() ;
DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
String SelQuery = "SELECT * FROM Sites WHERE (SiteID
=@SiteID)";
SiteInfoDS.Conn ectionString = "siteConnection String";
SiteInfoDS.Sele ctCommandType = SqlDataSourceCo mmandType.Text;
SiteInfoDS.Sele ctCommand = SelQuery;
SiteInfoDS.Sele ctParameters.Ad d("siteID",
SiteName.Select edValue);

DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));

foreach (DataRow dr in dv.Table.Rows)
{
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
}

Thanks for your assistance.

[Harolds]

Is there a reason you are using SqlDataSource & DataView? Both of these have
a lot of unneeded overhead in your case.

Maybe this will work (I have changed vb to c# in notepad so it may not be
correct):

String SelQuery = "SELECT * FROM Sites WHERE (SiteID=" &
SiteName.Select edValue & ")";

SqlCommand oCMD = New SqlCommand(SelQ uery, New
SqlConnection(" siteconnections tring"));
oCMD.Connection .Open();
SqlDataReader dr oCMD.ExecuteRea der(CommandBeha vior.CloseConne ction);
While dr.Read {
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
rdr.Close();

Far less overhead and by far a lot faster.
--
Harolds
"as*******@hotm ail.com" wrote:

Hi all,
I am new to ASP.NET and VS 2005 Express.

I am having problems with an error message and can't figure out why.
I am trying to run a "SELECT" query triggered by a change in dropdown .
When I hit the line:

DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));
in the code below, I get:
"Format of initializaion string does not conform to specification
starting at index 0".

I changed it so DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
and used args as the parameter, but I got the same error message. her
is the code:

("SiteName" is the name of the dropdown in the form, "SiteID" is a
field in table "Sites", also used as the value in the dropdown.)

protected void SiteName_Select edIndexChanged( object sender,
EventArgs e)
{
SqlDataSource SiteInfoDS = new SqlDataSource() ;
DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
String SelQuery = "SELECT * FROM Sites WHERE (SiteID
=@SiteID)";
SiteInfoDS.Conn ectionString = "siteConnection String";
SiteInfoDS.Sele ctCommandType = SqlDataSourceCo mmandType.Text;
SiteInfoDS.Sele ctCommand = SelQuery;
SiteInfoDS.Sele ctParameters.Ad d("siteID",
SiteName.Select edValue);

DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));

foreach (DataRow dr in dv.Table.Rows)
{
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
}

Thanks for your assistance.

[ashkaan57]

Harolds wrote:

Is there a reason you are using SqlDataSource & DataView? Both of these have
a lot of unneeded overhead in your case.

Maybe this will work (I have changed vb to c# in notepad so it may not be
correct):

String SelQuery = "SELECT * FROM Sites WHERE (SiteID=" &
SiteName.Select edValue & ")";

SqlCommand oCMD = New SqlCommand(SelQ uery, New
SqlConnection(" siteconnections tring"));
oCMD.Connection .Open();
SqlDataReader dr oCMD.ExecuteRea der(CommandBeha vior.CloseConne ction);
While dr.Read {
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
rdr.Close();

Far less overhead and by far a lot faster.
--
Harolds
"as*******@hotm ail.com" wrote:

Hi all,
I am new to ASP.NET and VS 2005 Express.

I am having problems with an error message and can't figure out why.
I am trying to run a "SELECT" query triggered by a change in dropdown .
When I hit the line:

DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));
in the code below, I get:
"Format of initializaion string does not conform to specification
starting at index 0".

I changed it so DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
and used args as the parameter, but I got the same error message. her
is the code:

("SiteName" is the name of the dropdown in the form, "SiteID" is a
field in table "Sites", also used as the value in the dropdown.)

protected void SiteName_Select edIndexChanged( object sender,
EventArgs e)
{
SqlDataSource SiteInfoDS = new SqlDataSource() ;
DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
String SelQuery = "SELECT * FROM Sites WHERE (SiteID
=@SiteID)";
SiteInfoDS.Conn ectionString = "siteConnection String";
SiteInfoDS.Sele ctCommandType = SqlDataSourceCo mmandType.Text;
SiteInfoDS.Sele ctCommand = SelQuery;
SiteInfoDS.Sele ctParameters.Ad d("siteID",
SiteName.Select edValue);

DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));

foreach (DataRow dr in dv.Table.Rows)
{
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
}

Thanks for your assistance.

Thanks for the reply Harold.
I am very ew to ASP.NET. I am from a C++ and PHP background and not
familiar with VB. The source you supplied generates a lot of erros in
C# and things like sqlCommand don't exist in C#.
Also, I had googled for this issues before posting to the group and all
the xamples used sqlDatSource. Same thing in tutorials I checked out.
What I don't understand is that the argument to SiteInfoDS.Sele ct is
exactly what every example has used but mine generates an error.

Thanks.

[Harolds]

Here is the debugged version of my code, which you could have easily had
done. Keep in mind that some lines of code get wrapped here and you will need
to unwrap them.

String SelQuery = string.Concat(" SELECT * FROM Sites WHERE
(SiteID=",SiteN ame.SelectedVal ue.ToString()," )");

System.Data.Sql Client.SqlComma nd oCMD = new
System.Data.Sql Client.SqlComma nd(SelQuery, new
System.Data.Sql Client.SqlConne ction("siteconn ectionstring")) ;
oCMD.Connection .Open();
System.Data.Sql Client.SqlDataR eader dr =
oCMD.ExecuteRea der(CommandBeha vior.CloseConne ction);
while (dr.Read() ){
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
dr.Close();

And the problem with your code is your "siteconnection string" has to
actually be a connection string to your datasource, not just the word
siteconnections tring. Which I discovered by debugging your code.
--
Harolds
"as*******@hotm ail.com" wrote:

>
Harolds wrote:

Is there a reason you are using SqlDataSource & DataView? Both of these have
a lot of unneeded overhead in your case.

Maybe this will work (I have changed vb to c# in notepad so it may not be
correct):

String SelQuery = "SELECT * FROM Sites WHERE (SiteID=" &
SiteName.Select edValue & ")";

SqlCommand oCMD = New SqlCommand(SelQ uery, New
SqlConnection(" siteconnections tring"));
oCMD.Connection .Open();
SqlDataReader dr oCMD.ExecuteRea der(CommandBeha vior.CloseConne ction);
While dr.Read {
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
rdr.Close();

Far less overhead and by far a lot faster.
--
Harolds
"as*******@hotm ail.com" wrote:

Hi all,
I am new to ASP.NET and VS 2005 Express.
>
I am having problems with an error message and can't figure out why.
I am trying to run a "SELECT" query triggered by a change in dropdown .
When I hit the line:
>
DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));
in the code below, I get:
"Format of initializaion string does not conform to specification
starting at index 0".
>
I changed it so DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
and used args as the parameter, but I got the same error message. her
is the code:
>
("SiteName" is the name of the dropdown in the form, "SiteID" is a
field in table "Sites", also used as the value in the dropdown.)
>
protected void SiteName_Select edIndexChanged( object sender,
EventArgs e)
{
SqlDataSource SiteInfoDS = new SqlDataSource() ;
DataSourceSelec tArguments args = new
DataSourceSelec tArguments();
String SelQuery = "SELECT * FROM Sites WHERE (SiteID
=@SiteID)";
SiteInfoDS.Conn ectionString = "siteConnection String";
SiteInfoDS.Sele ctCommandType = SqlDataSourceCo mmandType.Text;
SiteInfoDS.Sele ctCommand = SelQuery;
SiteInfoDS.Sele ctParameters.Ad d("siteID",
SiteName.Select edValue);
>
DataView dv =
(DataView)(Site InfoDS.Select(D ataSourceSelect Arguments.Empty ));
>
foreach (DataRow dr in dv.Table.Rows)
{
AreaName.Text = dr["AreaName"].ToString();
SiteType.Text = dr["SiteTypeNa me"].ToString();
SiteFinance.Tex t = dr["FinanceNo"].ToString();
}
}
>
Thanks for your assistance.
>
>

Thanks for the reply Harold.
I am very ew to ASP.NET. I am from a C++ and PHP background and not
familiar with VB. The source you supplied generates a lot of erros in
C# and things like sqlCommand don't exist in C#.
Also, I had googled for this issues before posting to the group and all
the xamples used sqlDatSource. Same thing in tutorials I checked out.
What I don't understand is that the argument to SiteInfoDS.Sele ct is
exactly what every example has used but mine generates an error.

Thanks.