Re: connection string Web.config + ASP.net C# - ASP.NET Discussion Boards

Re: connection string Web.config + ASP.net C#

Richard MacCutchan1-Oct-12 1:13

1-Oct-12 1:13

If you use values like this in your connection string then i think you will need to modify it at execution time in order to replace the %programfiles% with the real path. See Web.config File - ASP.NET[^] for some useful information on the web.config file.

One of these days I'm going to think of a really clever signature.

Re: connection string Web.config + ASP.net C#

Member 94738091-Oct-12 4:23

Member 9473809

1-Oct-12 4:23

Thanks for solution but i didnt get anything..plz give an example how to do that.
Thanks in advanced

Re: connection string Web.config + ASP.net C#

Richard MacCutchan1-Oct-12 4:31

Richard MacCutchan

1-Oct-12 4:31

You need to spend some time getting familiar with MSDN, which contains documentation for just about everything you will ever need, including this section on environment variables[^].

One of these days I'm going to think of a really clever signature.

Re: connection string Web.config + ASP.net C#

Richard MacCutchan1-Oct-12 4:33

Richard MacCutchan

1-Oct-12 4:33

Why have you created a new CodeProject id for this?

One of these days I'm going to think of a really clever signature.

Re: connection string Web.config + ASP.net C#

Member 94738091-Oct-12 7:05

Member 9473809

1-Oct-12 7:05

It was mistake that i create two id...
How can i use Environment.ExpandEnvironmentVariables in web.config for connectionstring?
Thanks in advanced!

Re: connection string Web.config + ASP.net C#

Richard MacCutchan1-Oct-12 7:37

Richard MacCutchan

1-Oct-12 7:37

Member 9473809 wrote:
It was mistake that i create two id...

Then please post a message here[^] to ask the administrators to remove the duplicate.

Member 9473809 wrote:
How can i use Environment.ExpandEnvironmentVariables

The link to the documentation that I posted contains a code sample, I cannot offer anything that is clearer than that.

One of these days I'm going to think of a really clever signature.

Re: connection string Web.config + ASP.net C#

jojoba20111-Oct-12 22:04

jojoba2011

1-Oct-12 22:04

Thanks !

But i didnt find the solution. Isn't there anybody to do that !

Re: connection string Web.config + ASP.net C#

Richard MacCutchan2-Oct-12 2:52

Richard MacCutchan

2-Oct-12 2:52

You have the solution, it's just that you need to to spend some time modifying it so it suits your specific problem.

One of these days I'm going to think of a really clever signature.

Re: connection string Web.config + ASP.net C#

jojoba20112-Oct-12 3:04

jojoba2011

2-Oct-12 3:04

thanks

i dont know the solution .
Help! if possible give example!

Re: connection string Web.config + ASP.net C#

Richard MacCutchan2-Oct-12 3:26

Richard MacCutchan

2-Oct-12 3:26

jojoba2011 wrote:
i dont know the solution .Help! if possible give example!

There is really no point in you repeatedly posting the same cry. I have given you a link to the method you need to use, which includes a code sample which demonstrates exactly how it can be used to expand an environment variable in a string. Unless you give some more details about how exactly you are trying to use it and why it does not work, then it is unlikely that we can guess what your problem is.

One of these days I'm going to think of a really clever signature.

Re: connection string Web.config + ASP.net C#

jojoba20112-Oct-12 6:05

jojoba2011

2-Oct-12 6:05

Hi sir,
this is exactly what i wanna to use in webconfig:

<connectionStrings>
    <add name="SqlConnStr" connectionString="Data Source=.\CMSNegin;AttachDbFilename=%ProgramFiles%\CMSNegin\Data\MSSQL10.CMSNegin\MSSQL\DATA\1\NeginDB.mdf;uid=sa;pwd=A@D#F$G%" providerName="System.Data.SqlClient"/>

  </connectionStrings>

i dont know which drive is system drive (C or D).cause my setup copies the database to %programfiles% .
may be C:\program files OR D:\Program files.

modified 2-Oct-12 12:51pm.

Re: connection string Web.config + ASP.net C#

Richard MacCutchan2-Oct-12 6:39

Richard MacCutchan

2-Oct-12 6:39

I still don't understand what your problem is. If you follow the documentation in the link I gave you[^], it shows exactly how to get the real path from an environment variable, including the system drive. What more do you need?

One of these days I'm going to think of a really clever signature.

Re: connection string Web.config + ASP.net C#

jkirkerx2-Oct-12 18:00

jkirkerx

2-Oct-12 18:00

I think this is what your looking for.

Your example makes no sense to me, and I don't see the point of it. If your sql server is loaded on your hard drive, why not use the standard connection string?

As far as using a programmable path like %ProgramFiles%, that's a Windows thing, which works in certain scripting languages and the cmd prompt. I don't think the application that reads the web.config file is smart enough to translate %ProgramFiles% to the proper file path, and if it did, you need to see if it adds the final slash to the end of the path.

You still have to code the database name to make it work. Since it's on your hard drive, a trusted connection should work fine.

Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname;
Trusted_Connection=Yes;

[Edit]

If you need connection strings, go here
http://www.connectionstrings.com/[^]

Richard, I was talking to the OP, still getting use to the new look and feel.

Re: connection string Web.config + ASP.net C#

Richard MacCutchan3-Oct-12 1:42

Richard MacCutchan

3-Oct-12 1:42

jkirkerx wrote:
I was talking to the OP

And you did it correctly.

One of these days I'm going to think of a really clever signature.

connection string in webconfig Asp.net C#

Member 94738091-Oct-12 0:05

Member 9473809

1-Oct-12 0:05

XML

Hi every one.
I have copying my database via setup to Program File of customer system.
now how can i give the conection string that can attach the DB (in webconfig):

<connectionStrings>
    <add name="SqlConnStr" connectionString="Data Source=.\CMSNegin;AttachDbFilename=<code>%programfiles%</code>\TSMS.mdf;Initial Catalog=NeginDB;uid=sa;pwd=u1$%^ggrf0923" providerName="System.Data.SqlClient"/>

  </connectionStrings>
I have used "<code>%ProgramFiles%</code>" but no use...

Please Help

Thanks in Advanced !

word document open without dialog

rajaramanperumal30-Sep-12 20:44

rajaramanperumal

30-Sep-12 20:44

hi, i'm developing a asp.net application ,it's concept for open word document using asp.net ,
it's work fine in local when i upload iis it dispay error

like "On the File menu, click Open. Search for the file using this dialog box.(//path)"

How to get advanced graphic controls in ASP.Net

Vaibhav Laxman Survase30-Sep-12 19:16

Vaibhav Laxman Survase

30-Sep-12 19:16

Hi all,

If you know any site providing advanced graphic controls for web development, please suggest.

Controls like AJAX controls, different colored check box, radio option etc..

Thanks a lot in advance!
Vaibhav

Data Controls in ASP.NET

jkmehmi30-Sep-12 7:38

jkmehmi

30-Sep-12 7:38

why we have a number of data controls in asp.net (like, repeater, datalist, gridview, form view etc )? What is differnece between form view, list view, and datalist Controls.

Re: Data Controls in ASP.NET

Sandeep Mewara30-Sep-12 7:46

Sandeep Mewara

30-Sep-12 7:46

jkmehmi wrote:
why we have a number of data controls in asp.net (like, repeater, datalist, gridview, form view etc )?

Because each of them has different use and need. All are important and used for data presentation in form or other.

jkmehmi wrote:
What is differnece between form view, list view, and datalist Controls.

Why did you not try to look for it on Google/Bing[^]?
One of the link: http://itmall.blogspot.in/2008/10/what-is-difference-between-gridview.html[^] - In a nutshell, it says:
GridView:
(1)Can select one row to do something.
(3)update, delete records in database, but not insert
(4)Sort, paging
(5)Concurrency handling
(6)Display empty data
(7)Formatting (e.g. alternative row style)
(8)Customize field (e.g. use TemplateField to edit record)
(9)Extend (e.g. create LongTextField for GridView)

ListView:
(1) template driven
(2) can add data to database
(3) can edit, page through, sort database data
(4) ListView is the only control implementing IPageableItemContainer interface, so it is the only one which can use DataPager control.

ListView is the most flexible List control in all. I can safely use ListView in place of GridView.

Repeater:
(1) display database records. It cannot edit/insert records
(2) entirely template driven

DataList:
(1) display database records(can edit?)
(2) entirely template driven
DataList is very similar to Repeater except that DataList's default behavior is rending the content using a table. However, you can override the default behavior.

DetailsView:
(1) Display/edit/delete/Insert records in database
(2) Render a table for a single record. always render each field in a seperate table row.

FormView:
Exactly like DetailsView except that FormView is entirely template driven.

ListControl:
there are RadioButtonList, DropDownList, CheckBoxList, BulletedList, ListBox.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Re: Data Controls in ASP.NET

jkmehmi30-Sep-12 8:15

jkmehmi

30-Sep-12 8:15

Thank you sir for giving a quick reply in a brief way. I m new in code project. it was my first query. thanks.

asp.net pdf file

Member 946996328-Sep-12 22:44

Member 9469963

28-Sep-12 22:44

hi,i wanna start learning asp.net with c# but nowhere can i find a pdf file please aid me,its my humble request.Thanks in advance.

Re: asp.net pdf file

Sandeep Mewara28-Sep-12 23:23

Sandeep Mewara

28-Sep-12 23:23

In general, a PDF cannot cover all. Either you pick any ebook's PDF or better (in my opinion), read through various online materials.
Start from here: ASP.NET Tutorial: Your first website[^]

Look at these too to learn:
ASP.Net get started[^]
ASP.NET Projects from CodePlex [^]
MSDN: ASP.NET Developer Center[^]
ASP.NET website[^]

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

File Upload control in Asp .net Page methods

kkrangs28-Sep-12 22:02

kkrangs

28-Sep-12 22:02

I am struggling converting image to byte array using client side script.

I have to convert image to byte array, and pass this array to web service or Page methods, so that the web services or Page methods can save the image in sql server. Any one please help me

Thanks in advance,

Please help me....

Re: File Upload control in Asp .net Page methods

jkirkerx29-Sep-12 19:30

jkirkerx

29-Sep-12 19:30

[edit]

At first I didn't think that was possible. I know javascript can do many things, but to read an image file sounds far fetched.

Apparently, there are many articles about reading a image file as a base64 array of chars. Transmitting it to a web service would be easy, but since it's not a primitive data type like a string or integer, you would have to consume the array in a class first, and then as a primitive type. That's get a bit tricky especially in vb, but there are many c# examples out there that work fine.

I use uploadify with a sub process attached to it. I suppose I'm one step away from being able to complete your task, I just need to do the javascript end, and update my class. and modify a web service for it.

As far as starting from scratch, write the javascript first, and then work on the web service side, and just write the file to the disk drive for testing to make sure the byte array is intact.

[sample link^]

modified 30-Sep-12 17:13pm.

Re: File Upload control in Asp .net Page methods

kkrangs30-Sep-12 22:04

kkrangs

30-Sep-12 22:04

hi jkirkerx,

Thank you so mush for your reply,

I have tested below code

var p;var canvas = document.createElement("canvas");
var img1=document.createElement("img");

function getBase64Image(){
    p=document.getElementById("fileUpload").value;
    img1.setAttribute('src', p);
    canvas.width = img1.width;
    canvas.height = img1.height;
    var ctx = canvas.getContext("2d");
    ctx.drawImage(img1, 0, 0);
    var dataURL = canvas.toDataURL("image/png");alert("from getbase64 function"+dataURL );
    return dataURL;
}

My problem is , above logic IE cant support

Any idea plz advise me ...

modified 1-Oct-12 5:04am.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.