kkunodziya

In your CTE columns you have a column named InitDate but in the selected columns you have the column as InqDate. Same applies to CE2 you have a column named Transdate and yet in your select statement you have it as InqDate. You might need to begin by fixing that …

The tricky part is how he stored the image in the database. Did he save the url to the image or did he save the actual image as data type Image in the database. If second scenario, then he would need to create another page lets just call it ImageWrite.aspx …

'It is probably because you are adding your parameters within a for loop. In that case 'only the first line will be updated without an error, i.e when i=0. but when i=1, you 'are going to be having 12 parameters for your cmd, and so on and so on. 'try …

You don't have to be lazy. Thats the best practice, Thats the demand of coding. You would need to create 2 tables, one for the city and another for the country. You obviously need to link up the 2 tables by having the primary key of country table as a …

//Put a FileUpload control on your form. //and then try something like below. private Boolean UploadFile { Boolean valid = true; string ext; string fileName; ext = System.IO.Path.GetExtension(fileUpload.PostedFile.FileName); fileName = System.IO.Path.GetFileName(fileUpload.PostedFile.FileName); string filePath = ""; if (ext == ".jpg") valid = true; else if (ext == ".bmp") valid = true; …