Comments by Sumit Jawale (Top 29 by date)

can you please elaborate your problem more ? Exactly what is the scenario and what is the issue ?

In your table add one more column for ImagePath and while saving image in table save it's physical path. So you will get direct path form DB and for deleting you can use

string path = //Path fetched from query + "/" + file_name ;
FileInfo file = new FileInfo(path);
if (file.Exists)//check file exsit or not
{
file.Delete();
}

also please make sure that you have given permission to your image folder.

What is this??? What do want to ask ?

dont you think will be wrong ?? If user selected only three text box 1,3,6 then it will show 1-6. As per my understanding it is wrong. Beacause 1-6 means 1 to 6 (in other words user selected all checkbox from 1 to 6 ) .
please clarify your exact need.

Hi,
Do you want label to show in comma separated sequence or Min Value and Max Value of selected Check boxes ?
EX : 1,2,3,4 or 1-4 ???

Is that so then what if user select check box 3,5,8,6 ?? what do you expect in thi s scenario ??

Ok.. Can you please tell me where exactly your Image folder is ?? Server.MapPath works only if your folder is present where your project is deployed.

I can suggest one more solution, While saving image info in DB, try to save its physical address also. It will help you to get direct physical path from DB (no need to find file path again)

ok.. then it is difficult to identify exact cause. :(
Try to find out exact cause by yourself.and please share if you find it. :)

if scenario is not clear, then why you voted my answer 1 ?

Yes, but I think the question is for getting increment varchar value. So while user want to increase it he will simply call the Function. And thi swill work fine in this scenario.

In your other Function, are you calling same procedure "HasPrimaryKey" ??

ok. Use ISNULL in your select
ISNULL((case [IsReturned] when (0) then datediff(minute,dateadd(day,[Time],[StartDate]),getdate()) end),delay)

then use your column as it is.. I guess delay is your column which you want to keep as it is.

(case [IsReturned] when (0) then datediff(minute,dateadd(day,[Time],[StartDate]),getdate()) else delay end)

You can try one more thing, instead of taking int variable for result try it with string.

public bool HasPrimaryKey(string TableName)
{
string result = "";
using (SqlConnection connection = new SqlConnection(connection_string))
{
connection.Open();
SqlCommand command = new SqlCommand(HasPrimaryKey, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(@TableName, SqlDbType.VarChar).Value = TableName;
result = convert.ToString(command.ExecuteScalar());
connection.Close();

}
if (result == "1")
return true;
else
return false;
}

Hi Deepak,
Try to debug your code. Please see what path it is stored in path variable (For line string path = Server.MapPath("Img//" + file_name);)
And please try to hit that path, whether it is giving you a right path or not..
Please let me know your result of debugging.

Correct solution.

Can you please elaborate your exact need ?? Its not clear to understand what exactly you want.

This issue may not be realated with post back. Please try to debug your code to get exact reason for this issue.

I dont want to send mail, i want to send a sms to mobile through my application... The solution given by you is for sending e-mail not for sending sms.

I was trying to implement that code, but it throws the exception.

I already checked the link before but i don't want to use another window for sending SMS.

In my application, i am sending an email to particular user( information of user is stored in database). Now i also want to send sms to that user. Thats my problem. How can i send that???

my data grid is not on the window.
it is on the user control. I want to refresh it when i close the window. How should i do that???

sory for late reply but please help me..


I have data grid on user control in WPF.

And i have another window which is open after i click on one 'edit' button in data grid.

now, when i close the window, i want my data grid should re- bind means it should show new updated values.

How can i suppose to do that??

I have data grid on user control in WPF.

And i have another window which is open after i click on one 'edit' button in data grid.

now, when i close the window, i want my data grid should re- bind means it should show new updated values.

How can i suppose to do that??

I have data grid on user control in WPF.

And i have another window which is open after i click on one 'edit' button in data grid.

now, when i close the window, i want my data grid should re- bind means it should show new updated values.

How can i suppose to do that??