ASP.NET

Hiren solanki23-Dec-10 19:43

23-Dec-10 19:43

If your database file is inside a datadirectory then you can use.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;Persist Security Info=true"

See HERE[^] for more.

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.

Message Removed

23-Dec-10 19:51

sheemap

23-Dec-10 19:51

Message Removed

TweakBird24-Dec-10 5:51

TweakBird

24-Dec-10 5:51

Hi sheemap,

Hiren Solanki wrote:
See HERE[^] for more.

What Hiren said is absolutely true.

BTW if you go through that link, you can learn how to configure connections string with different databases, data files ..etc.
Happy Coding...

RaviRanjanKr24-Dec-10 1:30

RaviRanjanKr

24-Dec-10 1:30

you should store you connection string in web.config file and then retrieve connection string from web.config file. because of this, you able to use your connection globally without creating connection every time.
navigate the given link
Storing and Retrieving Connection Strings in ASP.NET [^] and
MS Access Connection Strings[^]

Hiren solanki24-Dec-10 3:25

24-Dec-10 3:25

Dear Ravi,

Matter here is not about storing a connection string in a safe place.

Please get into the question properly. Smile | :)

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.

Server.MapPath() Problem!!!

RaviRanjanKr24-Dec-10 23:46

RaviRanjanKr

24-Dec-10 23:46

Hiren Solanki wrote:
Please get into the question properly.

Of-course I did it before posting my answer.

Hiren Solanki wrote:
Matter here is not about storing a connection string in a safe place.

He just want to know how to create a connection for Web programming and I just referring him Links with valuable advice whatever, thanks for your advice.

Varun Sareen23-Dec-10 19:11

Varun Sareen

23-Dec-10 19:11

Dear Friends,

I want to open a file on the click of a link in the Grid named as VIEW. The path I am binding to is the local path i.e., ~/Documents/ScanDoc/[FileName] but when i am opening it on the local server; I am getting the error as follows:-

File does not exist.
System.Web.HttpException: File does not exist. at System.Web.StaticFileHandler.GetFileInfo(String virtualPathWithPathInfo, String physicalPath, HttpResponse response) at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context) at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

But when I updated the PathColumn in database with this value:-"http://localhost:1383/~/Document/ScanDoc/[FileName]" which is actually being saved as "Documents/ScanDoc/[FileName]", the thing worked and i was able to see the file when i clicked on the link.

Now my problem is that how could i bind "http://localhost:1383/~" path to "Documents/ScanDoc/[FileName]" which is being saved in the database.

Thanks

Varun Sareen (Dot Net Developer)

Re: Server.MapPath() Problem!!!

Hiren solanki23-Dec-10 19:40

Re: Server.MapPath() Problem!!!

23-Dec-10 19:40

Just grab the Url Authority like

String UrlAuthority = String.Format("http://{0}",Request.Url.Authority);

Now make a string of your static path

String Path = "Documents/ScanDoc/[FileName]";

Combine both for final Output

String FullPath = Path.Combine(UrlAuthority,Path);

And you're done.

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.

Varun Sareen23-Dec-10 22:13

Varun Sareen

23-Dec-10 22:13

Thanks Hiren, the thing you told worked

Varun Sareen (Dot Net Developer)

Re: Server.MapPath() Problem!!!

Hiren solanki23-Dec-10 23:07

Export data to Excel problem

23-Dec-10 23:07

Glad it helped you.

You can always rate Answer if it helped you.

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.

Asif Rehman23-Dec-10 0:45

Asif Rehman

23-Dec-10 0:45

Following code does not handle columns that start with +. for example,
'+923339933886' is not rendered well(some kind of charmap characters shown).

HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=Employee.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter stw = new StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(gvEmployee);
this.Controls.Add(form);
form.RenderControl(htextw);
Response.Write(stw.ToString());
Response.End();

Please let me know what is the changes required in this code.

Re: Export data to Excel problem

Hiren solanki23-Dec-10 1:05

Re: Export data to Excel problem

23-Dec-10 1:05

Are you sure you will get a better response this time then That[^]?

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - Remove HTML Tag, get plain Text

thatraja23-Dec-10 7:29

thatraja

23-Dec-10 7:29

Check my answer here[^] for your question.

BTW please wait for the replies don't post duplicate questions. cheers.

thatraja |Chennai|India|

Brainbench certifications
My Dad had a Heart Attack on this day so don't...

Custom Validation

Jammer22-Dec-10 1:24

Jammer

22-Dec-10 1:24

Hi All,

I've got the following lines in my button click handler.

if (!this.CheckObjectivesCheckBoxesValid())
{
    var repeaterValidator = new CustomValidator();
    repeaterValidator.IsValid = false;
    repeaterValidator.ErrorMessage = "Please select at least one objective.";
    Page.Validators.Add(repeaterValidator);
}

if (string.IsNullOrEmpty(this.txtDetails.Text) && string.IsNullOrEmpty(this.txtSuggestions.Text) && string.IsNullOrEmpty(this.txtSupportingEvidence.Text))
{
    var requiredFields = new CustomValidator();
    requiredFields.IsValid = false;
    requiredFields.ErrorMessage = "You must include information in at least one of Details, Suggestions or Evidence";
    Page.Validators.Add(requiredFields);
}

But the validation never seems to happen ...

Any ideas?

Jammer
My Blog | Articles | DMon | SampleSort

Hiren solanki22-Dec-10 1:40

22-Dec-10 1:40

I tested your code and It's passing through IF and later adding to Validators it doesn't seem to display an Error Message.

You can have a Look to This CP Article[^]

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - Remove HTML Tag, get plain Text

fjdiewornncalwe22-Dec-10 3:39

fjdiewornncalwe

22-Dec-10 3:39

Exactly what I thought.

I wasn't, now I am, then I won't be anymore.

Hiren solanki22-Dec-10 3:41

22-Dec-10 3:41

Oh sorry, But you're 1.59 hrs late. Poke tongue | ;-P

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - Remove HTML Tag, get plain Text