Query Change How To Rewrite String Details

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Query Change How To Rewrite String Details

Author

Topic

kevin24
Starting Member

13 Posts

Posted - 2012-02-17 : 22:26:00

I have a gridview which shows two columns, one of which is effectively a hyperlink (asp:linkbutton). The required data opens in a new page which gives additional data.

The code is:-

{
String ArtistName = Request.QueryString["ArtistName"];
if (ArtistName == "")
{
Response.Write("Invalid Artist Name");
return;
}
sqlcmd = new SqlCommand("select * from tblArtists where ArtistName='" + ArtistName + "'", sqlcon);
sqlcon.Open();
da = new SqlDataAdapter(sqlcmd);
dt.Clear();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Label1.Text = ArtistName;
Label2.Text = dt.Rows[0][1].ToString();
Label3.Text = dt.Rows[0][2].ToString();
Label4.Text = dt.Rows[0][3].ToString();
Label5.Text = dt.Rows[0][4].ToString();
//Label5.Text = dt.Rows[0][5].ToString();
}

This works perfectly.

THE PROBLEM:

I wish to show more data on the new page.

This would mean changing the Select statement
to:-

SELECT tblArtists.ArtistID, tblArtists.ArtistName, tblArtists.Origin, tblArtists.Genre, tblArtists.WebAddress, tblAlbums.AlbumName, tblYearReleased.YearReleased
FROM (tblAlbums INNER JOIN tblArtists ON tblAlbums.ArtistID = tblArtists.ArtistID) INNER JOIN tblYearReleased ON tblAlbums.YearReleasedID = tblYearReleased.YearReleasedID
where ArtistName='" + ArtistName + "'", sqlcon);

However, I am getting many errors and i do not know how to begin to correct.

Help please. Thanks.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-02-18 : 07:57:35

Can you post the exact error messages you are getting?

Looking at your query, I don't see anything wrong. You can try to run the query from a SSMS window and see if that runs correctly. For example, try to run this in SSMS.

SELECT tblArtists.ArtistID,
       tblArtists.ArtistName,
       tblArtists.Origin,
       tblArtists.Genre,
       tblArtists.WebAddress,
       tblAlbums.AlbumName,
       tblYearReleased.YearReleased
FROM   (
           tblAlbums INNER JOIN tblArtists ON tblAlbums.ArtistID = tblArtists.ArtistID
       )
       INNER JOIN tblYearReleased
            ON  tblAlbums.YearReleasedID = tblYearReleased.YearReleasedID
WHERE  ArtistName = 'Taylor Swift'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources