|
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
|
|
|
|
|
Whats the error message you are getting?
|
|
|
|
|
Hi,
I am not getting any error. The ExecuteNonQuery method is executing continuously.
Thanks
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
Use the DTS (Data transformation Services) import/export wizard that is a part of SQLServer management tools.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|