Comments by Member 10609511 (Top 27 by date)

The contents are the file name eg.123.jpg however I found a solution to the problem online but it seems to select only the first row(row index remains at 0)

int index;
bool bIsConverted = int.TryParse(e.CommandArgument.ToString(), out index);

When I try that I get this error:

Input string was not in a correct format.

It is coming from the line

int i = Convert.ToInt32(e.CommandArgument);

When I run the debugger...

I don't wish to select all the values from the entire row - just one value that is under the column heading 'Business Name' and has Datafield of 'Business_Name' in the gridview. This value will specifically depend on which row the user presses the link button 'View File' for that particular row. I then need to assign this value to a variable in my c# code...

I am getting error - object reference not set to an instance of an object. Basically depending on which row the users selects the link button 'view file' from I want to take the value of the cell in that row under column 'Business Name'

I can't even upload video - when I insert a video file in the FileUpload control and hit the upload button I get a 'Page cannot be loaded' error

sorry for the confusion - I just want to implement uploading and viewing of videos in what I already have, thanks

what would I change in the proc exactly?

Here is what I tried and still nothing:

WHERE T2.Username = @Username
AND T1.Business_ID=T2.Business_ID

No luck with that change - still not committing the changes from the textboxes to the database....

This is a college project so I am still learning! Not to disrespect but you haven't been one bit helpful to me - hopefully someone will have a good input or solution to my question....

I now have the updated textbox values being passed to the parameter in my c# code but when I am redirected back to business details page the updated details are not there so maybe there is a problem with updating two tables in my proc???

ALTER PROCEDURE dbo.SaveBusinessChanges
(
@Business_Name varchar(50),
@Address_Line_1 varchar(50),
@Address_Line_2 varchar(50),
@Address_Line_3 varchar(50),
@County varchar(50),
@Provence varchar(50),
@Telephone varchar(50),
@Username varchar(50),
@PasswordNew varchar(50),
@Email varchar(50)
)

AS
BEGIN TRANSACTION


UPDATE T1
SET T1.Business_Name = @Business_Name, Address_Line_1 = @Address_Line_1, Address_Line_2 = @Address_Line_2,
Address_Line_3 = @Address_Line_3, County = @County, Provence = @Provence, Telephone = @Telephone
FROM Business T1
INNER JOIN User_Acc T2 ON T1.Business_ID = T2.Business_ID
WHERE T2.Username = @Username

UPDATE
T2
SET
T2.Email = @Email, Password = @PasswordNew
FROM
User_Acc T2
INNER JOIN Business T1
ON
T2.Business_ID = T1.Business_ID
WHERE
T2.Username = @Username



COMMIT

I have just told you where I got the listbox from - the toolbox in Visual Studio. It is an asp:Listbox item. It is not multi line. It is blank and you can add information to it using lstBusinessDetails.Items.Add. You're not really being helpful to me with your comments - maybe you could list out the types of list boxes and I'll understand your question better since it is a bit vague what you are requesting....

I just dragged and dropped the listbox item from the toolbox in visual studio and the above code was generated from that

Not quite sure what you mean??

<asp:TableRow ID="TableRow3" runat="server">
<asp:TableCell ID="TableCell5" runat="server" HorizontalAlign="Center" VerticalAlign="Top">Business :
<asp:TableCell ID="TableCell6" runat="server" HorizontalAlign="Left" VerticalAlign="Top"><asp:ListBox ID="lstBusinesses" runat="server" Width="245px" OnSelectedIndexChanged="ShowBusinessDetails" AutoPostBack="true">


<asp:TableRow ID="TableRow4" runat="server">
<asp:TableCell ID="TableCell12" runat="server" HorizontalAlign="Center" VerticalAlign="Top">Business Details :
<asp:TableCell ID="TableCell7" runat="server" HorizontalAlign="Left" VerticalAlign="Top"><asp:ListBox ID="lstBusinessDetails" runat="server" Width="256px">

I have updated my code and it now runs - however when I make changes to any textboxes on the webpage and click the button to run the procedure, it doesn't take in the updated values but rather the values from the other data reader

protected void SaveChanges(object sender, EventArgs e)
{
SqlConnection conn;
SqlCommand comm;
String connectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand("SELECT * from Business a, User_Acc c Where c.Username = @Username AND c.Business_ID = a.Business_ID", conn);
comm.Parameters.Add("@Username", System.Data.SqlDbType.VarChar).Value = Session["User"];
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
if (txtOldPassword.Text == reader["Password"].ToString())
{
// I'm not confortable using the same connection as the read - especially as we appear to
// be inside a reader loop so I'll create a new connection for the stored proc update
SqlConnection connWrite;
connWrite = new SqlConnection(connectionString);
// For info on the using statement see http://msdn.microsoft.com/en-us/library/htd05whh.aspx
using (SqlCommand comm1 = new SqlCommand("exec SaveBusinessChanges @Business_Name,@Address_Line_1,@Address_Line_2,@Address_Line_3,@County,@Provence,@Telephone,@Username,@PasswordNew,@Email", connWrite))
{
// Let the command know it is to run a Stored Procedure
comm1.CommandType = CommandType.StoredProcedure;
// This bit unchanged from OPs code
comm1.Parameters.AddWithValue("@Business_Name", txtChangeBusinessName.Text);
comm1.Parameters.AddWithValue("@Email", txtChangeBusinessEmail.Text);
comm1.Parameters.AddWithValue("@Telephone", txtChangeBusinessTelephone.Text);
comm1.Parameters.AddWithValue("@Address_Line_1", txtChangeBusinessAddress.Text);
comm1.Parameters.AddWithValue("@Address_Line_2", txtChangeBusinessAddress2.Text);
comm1.Parameters.AddWithValue("@Address_Line_3", txtChangeBusinessAddress3.Text);
comm1.Parameters.AddWithValue("@Provence", DDLProvince.Text);
comm1.Parameters.AddWithValue("@County", DDLCounty.Text);
comm1.Parameters.AddWithValue("@Username", Session["User"]);
comm1.Parameters.AddWithValue("@PasswordNew", txtChangeBusinessPassword.Text);
// You need to execute the command to run the stored procedure
comm1.ExecuteNonQuery();
} // Because I've used a "using" statement I don't need connWrite.Close();
}
}
reader.Close();
conn.Close();

Response.Redirect("Welcome.aspx");
}
}

I have the error :

cannot implicitly convert type 'string' to 'bool'

here is the line of code

if (txtOldPassword.Text = reader["Password"].ToString())

If I change txtChangeBusinessName.text to = rather than += I get an error :

cannot implicitly convert type 'object' to 'string'. an explicit conversion exists.

I have my procedure working however there is one field that was causing problems and I had to remove it. I have a table called Incident_Type and within this table there are 2 fields - Incident_ID(Int) and Incident_Type_Name(Varchar). However when I go to add this to my join and run my procedure I am getting the error - Multi-part Identifier cannot be bound and when I play around I also get an error saying cannot find Incident_Type.Incident_Type_Name even though it is spelt correctly

Here is my Proc:

ALTER PROCEDURE dbo.DisplayContent
(
@BusinessName varchar(100))

AS
SELECT user_acc.username, business.business_name, Incident.Incident_ID, Incident.File_Path, Incident.Description, Incident.Date_Time, Business.Provence, Business.County FROM
user_acc JOIN incident ON user_acc.User_id=incident.user_id
JOIN business ON incident.business_id=business.Business_id
WHERE Business.Business_Name = @BusinessName
RETURN

When I write it like this I get errors:

ALTER PROCEDURE dbo.DisplayContent
(
@BusinessName varchar(100))

AS
SELECT user_acc.username, business.business_name, Incident_Type.Incident_Type_Name, Incident.Incident_ID, Incident.File_Path, Incident.Description, Incident.Date_Time, Business.Provence, Business.County FROM
user_acc JOIN incident ON user_acc.User_id=incident.user_id
JOIN business ON incident.business_id=business.Business_id
WHERE Business.Business_Name = @BusinessName
RETURN

It is still not working for me - I found an error however when I debugged the procedure. It seems for some reason that although I enter just one password into the txtOldPassword field it seems to double it when it is passed into the procedure??

Here is my Page Load code that fills the textboxes with data from the logged in user from the database.

protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "Welcome " + Session["User"];
lblUser.Text = Convert.ToString(Session["User"]);

SqlConnection conn;
SqlCommand comm;
String connectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;

conn = new SqlConnection(connectionString);
comm = new SqlCommand("SELECT * from Business a, User_Acc c Where c.Username = @Username AND c.Business_ID = a.Business_ID", conn);
comm.Parameters.Add("@Username", System.Data.SqlDbType.VarChar).Value = Session["User"];
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{

txtChangeBusinessName.Text += reader["Business_Name"];
txtChangeBusinessAddress.Text += reader["Address_Line_1"];
txtChangeBusinessAddress2.Text += reader["Address_Line_2"];
txtChangeBusinessAddress3.Text += reader["Address_Line_3"];
DDLProvince.SelectedItem.Text = "";
DDLCounty.SelectedItem.Text = "";
DDLProvince.SelectedItem.Text += reader["Provence"];
DDLCounty.SelectedItem.Text += reader["County"];
lblVatNo.Text += reader["Vat_No"];
txtChangeBusinessEmail.Text += reader["Email"];
txtChangeBusinessTelephone.Text += reader["Telephone"];
txtOldPassword.Text += reader["Password"];
txtChangeBusinessPassword.Text += reader["Password"];

}


reader.Close();
conn.Close();

}

Does that help?

I have some code written but it is not working fully. Here is what I have:

protected void UploadFile(object sender, EventArgs e)
{
if (btnBrowse.PostedFile != null && btnBrowse.PostedFile.ContentLength > 0)
{

string fileName = Path.GetFileName(btnBrowse.PostedFile.FileName);
string folder = Server.MapPath("~/BusinessProfilesContent/" + Session["BusinessName"]);
Directory.CreateDirectory(folder);
btnBrowse.PostedFile.SaveAs(Path.Combine(folder, fileName));
try
{

Response.Write("Uploaded: " + fileName);
}
catch
{
Label1.Text = "Operation Failed!!!";
}
}



}

protected void DownloadFile(object sender, EventArgs e)
{
string filePath = (sender as LinkButton).CommandArgument;
Response.ContentType = ContentType;
Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(filePath));
Response.WriteFile(filePath);
Response.End();
}

protected void DeleteFile(object sender, EventArgs e)
{
string filePath = (sender as LinkButton).CommandArgument;
File.Delete(filePath);
Response.Redirect(Request.Url.AbsoluteUri);
}

protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "Welcome " + Session["User"];
Session["BusinessName"] = lblBusiness.Text;

if (!IsPostBack)
{
string[] filePaths = Directory.GetFiles(Server.MapPath("~/BusinessProfilesContent/" + Session["BusinessName"]));
List<ListItem> files = new List<ListItem>();
foreach (string filePath in filePaths)
{
files.Add(new ListItem(Path.GetFileName(filePath), filePath));
}
GridView1.DataSource = files;
GridView1.DataBind();
}

I got both select statements to work and return the data linked correctly as per your syntax, however, when I modify the procedure with your code it still is not making the changes to the database with the updated information from the textboxes

Here is the procedure code:

ALTER PROCEDURE dbo.SaveBusinessChanges
(
@Business_Name varchar(50),
@Address_Line_1 varchar(50),
@Address_Line_2 varchar(50),
@Address_Line_3 varchar(50),
@County varchar(50),
@Provence varchar(50),
@Telephone varchar(50),
@Username varchar(50),
@PasswordNew varchar(50),
@Email varchar(50)
)

AS
BEGIN TRANSACTION


UPDATE T1
SET T1.Business_Name = @Business_Name, Address_Line_1 = @Address_Line_1, Address_Line_2 = @Address_Line_2,
Address_Line_3 = @Address_Line_3, County = @County, Provence = @Provence, Telephone = @Telephone
FROM Business T1
INNER JOIN User_Acc T2 ON T1.Business_ID = T2.Business_ID
WHERE T2.Username = @Username

UPDATE
T2
SET
T2.Email = @Email, Password = @PasswordNew
FROM
User_Acc T2
INNER JOIN Business T1
ON
T2.Business_ID = T1.Business_ID
WHERE
T2.Username = @Username



COMMIT

and here is my C# code

protected void SaveChanges(object sender, EventArgs e)
{
SqlConnection conn;
SqlCommand comm;
SqlCommand comm1;
String connectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;

conn = new SqlConnection(connectionString);

comm = new SqlCommand("SELECT * from Business a, User_Acc c Where c.Username = @Username AND c.Business_ID = a.Business_ID", conn);
comm.Parameters.Add("@Username", System.Data.SqlDbType.VarChar).Value = Session["User"];
conn.Open();
SqlDataReader reader = comm.ExecuteReader();

while (reader.Read())
{

if (txtOldPassword.Text.Equals(reader["Password"]))
{

comm1 = new SqlCommand("exec SaveBusinessChanges @Business_Name,@Address_Line_1,@Address_Line_2,@Address_Line_3,@County,@Provence,@Telephone,@Username,@PasswordNew,@Email", conn);


comm1.Parameters.AddWithValue("@Business_Name", txtChangeBusinessName.Text);
comm1.Parameters.AddWithValue("@Email", txtChangeBusinessEmail.Text);
comm1.Parameters.AddWithValue("@Telephone", txtChangeBusinessTelephone.Text);
comm1.Parameters.AddWithValue("@Address_Line_1", txtChangeBusinessAddress.Text);
comm1.Parameters.AddWithValue("@Address_Line_2", txtChangeBusinessAddress2.Text);
comm1.Parameters.AddWithValue("@Address_Line_3", txtChangeBusinessAddress3.Text);
comm1.Parameters.AddWithValue("@Provence", DDLProvince.Text);
comm1.Parameters.AddWithValue("@County", DDLCounty.Text);
comm1.Parameters.AddWithValue("@Username", Session["User"]);
comm1.Parameters.AddWithValue("@PasswordNew", txtChangeBusinessPassword.Text);
}

}
reader.Close();
conn.Close();
}

I don't get any error codes - I am calling the stored procedure from within Visual Studio 2010. It simply isn't updating any fields for that specific record in my database hence why I think there is something wrong with my procedure?