How do I read cnnection string from web config file - ASP.NET Discussion Boards

ReactiveX4-Dec-07 19:02

4-Dec-07 19:02

That is most definitely possible, with the following constraints:

In order to display the records for a certain time period, your rows need to have a created date column or something that you can base your query on.

You won't be able to report the time that the report was printed on because the event hasn't happened yet. You could alternatively store this date in the DB and report on it later.

To pass the person's name and phone number via a query string is easy. Once you're ready to redirect the user to the report page, do the following:

Response.Redirect("Report.aspx?name=" & sPersonName & "&phone=" & sPersonPhone)

Daniel Minnaar
Lead Software Developer

Re: Report viewer

Aptiva Dave5-Dec-07 3:16

Aptiva Dave

5-Dec-07 3:16

Yes, but how do I put that information into the report? I already have a date column that I can base my query on, but the issue is that I just don't know how to search by these parameters.

how to upload a sqlserver database

M.V4-Dec-07 8:09

M.V

4-Dec-07 8:09

hi I have a ASP.NET website.I work with sqlserver2000 database in it.
now I want to upload the site.
How I should upload the database?

Re: how to upload a sqlserver database

pmarfleet4-Dec-07 8:26

pmarfleet

4-Dec-07 8:26

2 ways spring to mind:

1. Detach the database and copy the MDF & LDF files to your production environment.
2. Backup the database and restore it in your production environment.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: how to upload a sqlserver database

Fred_Smith4-Dec-07 8:34

Fred_Smith

4-Dec-07 8:34

Use the DTS (Data transformation Services) import/export wizard that is a part of SQLServer management tools.

How to have different pages use the same master but different VB files?

Jordanwb4-Dec-07 7:45

Jordanwb

4-Dec-07 7:45

I have the following files:

~/index.aspx -> Uses ~/MasterPage.Master.VB but shares ~/MasterPage.master
~/west/index.aspx -> Uses ~/west/MasterPage.Master.VB but shares ~/MasterPage.master
~/north/index.aspx -> Uses ~/north/MasterPage.Master.VB but shares ~/MasterPage.master
~/central/index.aspx -> Uses ~/central/MasterPage.Master.VB but shares ~/MasterPage.master
~/east/index.aspx -> Uses ~/east/MasterPage.Master.VB but shares ~/MasterPage.master

What I have to do is make them use the same master page but different VB code files. Can this be done?

I would've searched but I don't know what to search for.

Thanks.

Re: How to have different pages use the same master but different VB files?

Guffa4-Dec-07 14:27

Guffa

4-Dec-07 14:27

Use nested master pages:

index.aspx uses master1.master which uses master.master
west/index.aspx uses west/master.master which uses master.master
et.c.

Experience is the sum of all the mistakes you have done.

How do I read cnnection string from web config file

Tomic4-Dec-07 3:14

Tomic

4-Dec-07 3:14

I had the following code:

Dim constr as string<br />
 Dim mysystem as system.configuration.configuration<br />
mysystem=system.web.configuration.webconfigurationmanager.openwebconfigura tion(Nothing)<br />
 Dim mycon as System.Configuration.ConnectionSettings<br />
 mycon=mysystem.connectionstrings.connectionstrings("CString1")<br />
 constr =mycon.connectionstring

he code above returned the error below:
"Object not sent to an instance of an object" on the line

constr =mycon.connectionstring<br />

Please where did I get it wrong.
Thanks

Re: How do I read cnnection string from web config file

pmarfleet4-Dec-07 8:24

pmarfleet

4-Dec-07 8:24

To read a connection string from web.config using WebConfigurationManager, all you need to do is:

Dim constr As String = WebConfigurationManager.ConnectionStrings("CString1")

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: How do I read cnnection string from web config file

Sunil Wise4-Dec-07 19:45

Sunil Wise

4-Dec-07 19:45

in web.config:

<appSettings><br />
<br />
        <add key="ConnString" value="server=(local);database=Northwind;Integrated Security=SSPI" /><br />
<br />
      </appSettings>

call in u r web page as

<br />
Imports System.Web.Configuration<br />
<br />
dim constr as string<br />
constr=ConfigurationManager.ConnectionStrings("ConnString").ConnectionString<br />
        <br />

use this
hope this helps

crystal report error in asp.net

Member 41706454-Dec-07 2:53

Member 4170645

4-Dec-07 2:53

hi it will run in localhost, when upload to server it will come error

the error..

Parser Error Message: Could not load file or assembly 'CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

Re: crystal report error in asp.net

Vasudevan Deepak Kumar4-Dec-07 18:20

Vasudevan Deepak Kumar

4-Dec-07 18:20

Check this out

http://support.businessobjects.com/communityCS/TechnicalPapers/crnet_deployment.pdf.asp[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Binding Drop down from another page.

Lijo Rajan4-Dec-07 2:48

Lijo Rajan

4-Dec-07 2:48

hai all plse help me to solve this problem.

I have two aspx pages.from one page i am calling 2nd page through java script(window.open). in second page i have one grid. when i select one recrod from tat grid i will get one id. based on that id i need to populate the dropdown in first page.

plse help me
Thanks in advance.
Lijo Rajan

Re: Binding Drop down from another page.

ReactiveX4-Dec-07 2:54

ReactiveX

4-Dec-07 2:54

In your parent's Page_Load event, add a block at the top to look for a Request.QueryString("id")

So...

Page_Load:

If Not Request.QueryString("id") Is Nothing Then
'Do databinding here to the drop down list based on this ID.
End If

Then redirect the parent page to itself using the ID query string ("id=value").

Daniel Minnaar
Lead Software Developer

Re: Binding Drop down from another page.

Lijo Rajan4-Dec-07 3:12

Lijo Rajan

4-Dec-07 3:12

Thank you verymuch Mr Daniel Minnaar for ur reply.In my case i am not redirecting my 2nd page to first page.I am calling 2nd page as a popwindow through javascript.so based on the id selecting from 2nd page grid at that time itself the dropdown list should be populated with out redirecting to parent page.in this case how i can use page load event?
plse give me a proper solution.

Lijo Rajan

Creating Website in SharePoint using C#/ASP.NET

md Nazeem4-Dec-07 2:32

md Nazeem

4-Dec-07 2:32

Hi Guys,
I need to create an Application in C#/ASP.NET (in Server1) which can create an Website in SharePoint 2007 (in Server2). Both C#/ASP.NET Application & Sharepoint 2007 are in different Servers.
Please send me information regarding this.

thank you

Mohamed Nazeem
Software Engineer
Bangalore

Re: Creating Website in SharePoint using C#/ASP.NET

Expert Coming4-Dec-07 14:50

Expert Coming

4-Dec-07 14:50

You'll need to look in to Programmatically modifying DNS, and IIS. Simple Google's on both will yeild tons of results.

You may also need to check out permissions.

Good luck.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

how can i retrieve the url of a child window from a parent window in Microsoft IE6/IE7?

Vishnu Narayan Mishra4-Dec-07 1:32

Vishnu Narayan Mishra

4-Dec-07 1:32

hello every one
I am facing a problem with the IFrame, I have to load the url into IFrame and when the user click on any link within this Iframe It will have to open a new browser window with the clicked link. So I am unable to open the clicked link from the Iframe into new browser window, When I opened clicked link from Iframe, each time it opens page(home page /first page loaded into Iframe of the url link).

1)How can I open clicked link from the Iframe into new browser.
Also I have to take the value of clicked link url from the child browser when the user close the child browser.
So
2) How can I get clicked link value into my form control eg in a TextBox from the child browser.

Thanks
Vishnu Narayan Mishra
Software Engineer

Re: how can i retrieve the url of a child window from a parent window in Microsoft IE6/IE7?

Vishnu Narayan Mishra4-Dec-07 20:18

Vishnu Narayan Mishra

4-Dec-07 20:18

From point 2 I means that for eg. In my form there is textbox and I frame. Textbox contains values of url and url have to be loaded into IFrame. Suppose http:\\www.yahoo.com is the value in the text box and http:\\www.yahoo.com is loaded into Iframe.
So problem start from here-- when user clicked on any link of yahoo.com from the Iframe, the clicked link have to open in a new browser and user can click any link of the new browser window, So finally when the user close the new browser window, the url value of the browser window have to be come into textbox. So i have to take the clicked link url values into my form , How can I do this..???

Vishnu Narayan Mishra
Software Engineer

Using Ref cursor(oracle) in asp.net

Amr M. K.4-Dec-07 1:26

Amr M. K.

4-Dec-07 1:26

Hello,
I am working in oracle 10g,
and I have done package that contains cursor
and I have use cursor to return rows from DB.

the package
TYPE T_CURSOR IS REF CURSOR;

output of stored procedure
-PISLAST : to check the last page (Yes/No)
-PCUROR :["PCUROR" OUT T_CURSOR] is the result of the query

The procedure works great in Oracle

I want to use cursor as datasource of data list
I have done the following

....
Iam using Oracle.DataAccess.Client; name space
....

OracleParameter ResultSet = new OracleParameter();
ResultSet.Direction = ParameterDirection.Output;
ResultSet.ParameterName = "PCUROR";
ResultSet.OracleDbType = OracleDbType.RefCursor;
cmd.Parameters.Add(ResultSet);
.....
I know how to use stored procedure in .net and out variable but I did know how to the cursor

thanks

Yes. CreatiVity withOuT limiTs

Re: Using Ref cursor(oracle) in asp.net

Vasudevan Deepak Kumar4-Dec-07 18:22

Vasudevan Deepak Kumar

4-Dec-07 18:22

Check this out

http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_refcursors.html[^]

sepatare the dropdoen values in the gridview textboxs

yardly4-Dec-07 1:05

yardly

4-Dec-07 1:05

I am having Numeric and character valuues in normal dropdown box .... noe i have to load the Numeric value in one gridview textbox and character in another GV textbox..
help me.

Re: sepatare the dropdoen values in the gridview textboxs

ReactiveX4-Dec-07 2:48

ReactiveX

4-Dec-07 2:48

In the SelectedIndexChanged event of your drop down list, seperate your value types using the IsNumeric function in Visual Basic.

If IsNumeric(myDropDownList.Items(0).ToString())
myNumericTextBox.Text = myDropDownList.Items(0).ToString()

Actually, the drop down list might use a property of SelectedText or something. Can't remember.

Daniel Minnaar
Lead Software Developer

Re: sepatare the dropdoen values in the gridview textboxs

yardly4-Dec-07 3:08

yardly

4-Dec-07 3:08

i have retun coding to bind the value from to gridview textbox.... if i select the dropddoewn value i am getting both the numeric and character value in a single gridview textbox... i need to display the numeric value in 1 txt box and char in another inside the gridview

Tree view asp.net 2.0

AnhTin3-Dec-07 21:40

AnhTin

3-Dec-07 21:40

hi all
In Treeview have function showcheckbox for node
I check it is true

Nomal when i check to the checkbox and click on text, treeview will postback to server on event TreeNodeCheckChanged

But i want to check on CheckBox so it will postback to server on event TreeView1_TreeNodeCheckChanged
dont need click on text.

How can i do that ?

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