Re: how to upload a sqlserver database - ASP.NET Discussion Boards

kjosh4-Dec-07 11:05

4-Dec-07 11:05

Hi,
I tried to upfate the date field of table from .net. I have tried like the below:

Database db = DatabaseFactory.CreateDatabase();
using (DbConnection connection = db.CreateConnection())
{
connection.Open();

DbTransaction transaction = connection.BeginTransaction(IsolationLevel.Serializable);
//DateTime dt = Convert.To(TextBox1.Text);
string s = "Update table1 set update_dttm = To_Date('" + DateTime.Now.ToShortDateString() +
"','dd/mm/yyyy')";
DbCommand pcmd = db.GetSqlStringCommand(s);
db.ExecuteNonQuery(pcmd, transaction);
transaction.Commit();
}
When I execute the string in s in Oracle it is working fine. But from .net I am not getting any error. It is executing continuously.
Whats wrong in my code.

Thanks in advance

Re: Insert date into oracle

Venkatesh Mookkan4-Dec-07 16:20

Venkatesh Mookkan

4-Dec-07 16:20

Whats the error message you are getting?

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

Re: Insert date into oracle

kjosh5-Dec-07 4:04

kjosh

5-Dec-07 4:04

Hi,
I am not getting any error. The ExecuteNonQuery method is executing continuously.

Thanks

Report viewer

Aptiva Dave4-Dec-07 10:32

Aptiva Dave

4-Dec-07 10:32

Here is my problem:

I have a web app connected to a SQL database. I need to create a report that displays counts of certain records during a certain time period. Also, within the report I need to display the name of the person who created the report, their phone number, and the date that the report was printed, but all of this is entered from a different page and I was passing it via query string. Can this be done and how can I do it?

Re: Report viewer

ReactiveX4-Dec-07 19:02

ReactiveX

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[^]

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