Comments by P.C Shabangu (Top 35 by date)

Peter Leow you meant doing it like this context.rect(startX, startY, mouseX - startX < 0 , mouseY - startY < 0); ?
I did this way but nothing happened.

Thanks fellow developers. We tried all these and they worked the way we wanted them to. Thnk u.

I was assigning a value that I got from a querystring to a devxpress 2012 datetime picker on form load. did I answer your question correctly?

I tried it and it worked like a bomb. I thought it had something to do with the publish but it turns out it was my code.

Thanks Manikandan!

Hi Manikandan

I am not sure if I understand?

Any help/sugestions please?

thanx Jameel this does work, but what if I want to display the same information on a different View which is called by a different Controller?

Ok I understand. In my case the pdf document that I want to download is in a folder in my solution explorer. Will it work if I take the name of the document from the folder?

Hi Pheonyx, I changed my code a bit on the virtual path section. I ammended the VirtualPath with the name of the project as the file that I am downloading is on a folder in my solution explorer:
public ActionResult Download(string name)
{
return new DownloadResult { VirtualPath = "~/Velociti.ScriptEngine/files/" + name, FileDownloadName = name };

}
When I click on the link to try and download the file I get an error on this line of code below:
string filePath = context.HttpContext.Server.MapPath(this.VirtualPath);
context.HttpContext.Response.TransmitFile(Path.Combine(filePath, FileDownloadName));
The error says:
"Value cannot be null.
Parameter name: path2"
I think it is the FileDownloadName as when I step through my code it is NULL.

Hi, when i changed the code I got an error that says "The name 'Path' does not exist in the current context"

Hi all
Below is the code that I researched and it is working fine. But when I went through it, when you are uploading an excel file the code restricts the sheet name to be "Sheet1" on this line "string query = string.Format("select * from [{0}$]", "Sheet1");". How can I tweek the application to actually accept any sheetname and display. Code is below:

private void btnbrowse_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
DialogResult dlgresult = dlg.ShowDialog();

if (dlgresult == DialogResult.OK)
{
txtpath.Text = dlg.FileName;
}

}


private void btnload_Click(object sender, EventArgs e)
{
if (System.IO.File.Exists(txtpath.Text))
{
try
{
string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", txtpath.Text);

string query = string.Format("select * from [{0}$]", "Sheet1");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataset = new DataSet();
dataAdapter.Fill(dataset);
dgrvInfo.DataSource = dataset.Tables[0];


}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

else
{
MessageBox.Show("Please select a file!", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

}



}

I am extremely sorry about that richb.

Hi naz I have managed to solve this query. Thanks for some of the hints you gave to me.

or can I first diplay them and then take them from the datagrid?

Would it be possible if can assign the values that I get from the datatable to the variables I declared:
for (int i = 0; i < GridRowCounnt; i++)
{
StoreId = Convert.ToInt32(dgrgPnPStores.Rows[i].Cells[0].Value.ToString());
address = dgrgPnPStores.Rows[i].Cells[5].Value.ToString();


_PnPStoresListDataTable = _AddressServiceData.GetGoogleSearch("", address + " South Africa", "", "");

NewLongitude =
NewLatitude =

_PnPStoresListTableAdapter.UpdateLatitude_Longitude(StoreId, NewLongitude, NewLatitude);

}

This is where I am stuck here for the longitude nad latitude:
_PnPStoresListTableAdapter.UpdateLatitude_Longitude( Int32 StoreId,

I am not sure if I follow. I am using the store id for updating the newlongitude and newlatitude which I get from the GetGoogleSearch method and save it in the respective columns in the database.

Hi this is the code I have now. I want to update using the store id from the database but update the New longitude and New latitude which I get from the internet using GetGoogleSearch method. Please advise on how to pass the values as I want to update the database.
Code below:
private void btnMapStoreAddresses_Click(object sender, EventArgs e)
{

AddressServiceData _AddressServiceData = new AddressServiceData();
DataTable _PnPStoresListDataTable = new DataTable();
int GridRowCounnt = 0;
PnPStoresListTableAdapter _PnPStoresListTableAdapter = new PnPStoresListTableAdapter();
string address = string.Empty;
int StoreId = 0;
string NewLongitude = string.Empty;
string NewLatitude = string.Empty;

try
{

GridRowCounnt = dgrgPnPStores.RowCount;


for (int i = 0; i < GridRowCounnt; i++)
{

address = dgrgPnPStores.Rows[i].Cells[5].Value.ToString();

_PnPStoresListDataTable = _AddressServiceData.GetGoogleSearch("", address + " South Africa", "", "");
_PnPStoresListTableAdapter.UpdateLatitude_Longitude( Int32 StoreId,


}
}

I have actually created a stored procedure and tried calling it in my code but it does not run at all. I get errors.

This is the stored procedure that I have:
create proc UpdateLatitude_Longitude
(
@address varchar (max),
@NewLongitude nvarchar(50),
@NewLatitude nvarchar(50)
)
as
Update PnPStoresList
Set NewLongitude = @NewLongitude , NewLatitude = @NewLatitude

I am not sure if I follow you. Please can you clarify it for me in code. I am confused.

but is there code that I have to write for this kind of validation because it looks as if there is alot of code that has to be written?

ok.thank you.

ok I understand.but will it be also a big problem if I use javascript code to display my message box?

I dont understand. It is not working because I tried it many times and it is not working.

The problem is that I know how to retrieve the images using the sql datasource but now I want to return the images using the business logic layer using the object datasource

Thank you it worked very nicely.Thank you

Thank you.It worked nicely.

yes it is copied directly from my program.

I dont quite frankly understand.