how to use executereader() with oralce? - ASP.NET Discussion Boards

Malcolm Smart31-Oct-07 3:41

31-Oct-07 3:41

You need to persist the value somewhere, ie a database, along with the datetime it was written. Then, perhaps in an onsession event, read this value from the database, compare the date it was written with 'todays' date, and update if necessary.

If you don't persist the value, if you site ever goes down, or you modify the webconfig, or the process gets recycled for any reason, you will lose this value.

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."

refresh DDL without refreshing whole page

Sarfaraj Ahmed31-Oct-07 1:48

Sarfaraj Ahmed

31-Oct-07 1:48

hello everybody
this is the second time i put the same message.
I am using vb so vb code will be graet full.

my ddl data is coming from sql server 2005 database, if antything from ddl1 then corresponding data will fill ddl2.

do i need a xml document for this? if yes then how can i do it?

Please do not read the beginner one. If you know the guideline please tell me step by step information.

Thanks in Advance

Sarfarj Ahmed

Re: refresh DDL without refreshing whole page

John-ph31-Oct-07 2:02

John-ph

31-Oct-07 2:02

Step 1: On the Page Load Event, Populate the First DropDown.
Note: In Page Load Event Add (IF Not Page.IsPostBack) and write the code in it.
Step 2: Enable the PostBack Property of the First DropDown
Step 3: On the SelectedIndex Change of the First DropDown, write the Code to Populate the Second DropDown by passing the Selected value of the First Drop Down.

Regards
- J O H N -

Re: refresh DDL without refreshing whole page

Sarfaraj Ahmed31-Oct-07 2:51

Sarfaraj Ahmed

31-Oct-07 2:51

Dear John
Thanks for your instruction,
Problem is, if selected index change from FIRST DDL then refreshing the whole page.
Only SECOND DDL will refresh not whole page.
thanks

Sarfarj Ahmed

Re: refresh DDL without refreshing whole page

John-ph31-Oct-07 3:21

John-ph

31-Oct-07 3:21

Do you mean that you want avoid the Page Postback while Populating the second DropDown? If yes, try to implement AJAX which will send a request to the server and do the task without posting your page.

Regards
- J O H N -

Re: refresh DDL without refreshing whole page

Sarfaraj Ahmed31-Oct-07 3:29

Sarfaraj Ahmed

31-Oct-07 3:29

thanks john
i have solved my problem

Sarfarj Ahmed

No data output to lbl_header and LabelText fields

Cruisar31-Oct-07 1:39

Cruisar

31-Oct-07 1:39

I have been trying to modify a code that had 4 questions to 3 questions. I get no errors whatsoever when I build the webiste. Only issue is, The TYPE page that should assign a type to the user based on what answers were chosen doesnt show anything when it loads only the button that allows the user to choose a present. How do I fix this. I am totally new to .NET I can easlily amil the project if someone is willing to help..thanks

Cruisar

how to use executereader() with oralce?

babutkchn31-Oct-07 1:32

babutkchn

31-Oct-07 1:32

hi,

In my appication i'm using Oracle as a back end. In that when i'm using ExecuteReader() it shows an exception. Can any one of help me to solve this issue.

<br />
oleDBConnection = new OleDbConnection(connectString);                   <br />
                    string query = "SELECT V_FIRST_NAME,V_LAST_NAME,V_PHONE_NUMBER,V_EMAIL,V_FAX_NUMBER,V_ADDRESS,V_TITLE,V_POSTAL_CODE,V_COUNTRY from UserDetails where (V_USER_ID = ?) AND (V_PASSWORD = ?)";<br />
<br />
                    OleDbCommand oledbCmd = new OleDbCommand(query, oleDBConnection);<br />
                    oledbCmd.CommandText = query;<br />
<br />
                    oledbCmd.CommandType = CommandType.Text;<br />
<br />
                    OleDbParameter par = oledbCmd.Parameters.Add("UserName", OleDbType.VarWChar, 50);<br />
                    OleDbParameter parm = oledbCmd.Parameters.Add("password", OleDbType.VarWChar, 50);<br />
<br />
                    oledbCmd.Parameters["UserName"].Value = userName;<br />
                    oledbCmd.Parameters["password"].Value = password;<br />
<br />
                    oledbCmd.Connection = oleDBConnection;<br />
<br />
                    oleDBConnection.Open();<br />
                    <br />
                    OleDbDataReader dr ;<br />
                    dr = oledbCmd.ExecuteReader();<br />

It threw an exception when executing the last line. The exception states that Unspecified error.Oracle error occured,but error message could not retrieved from Oracle.Data Type is not supported.

Paging problem in GridView [modified]

Thavika31-Oct-07 1:30

Thavika

31-Oct-07 1:30

That i know But i have to move to next page grid and retrieve the records and assign it to the data table.How should i?

my UpdateCustomerDetails method is as below

private void UpdateCustomersDetails()
{

Customers oCustomers = Customers.GetCurrentSingleton();
int iRowCount = oCustomers.CustomersList.Rows.Count;

for (int iRowIndex = 0; iRowIndex < iRowCount; iRowIndex++)
{

TextBox oTextBoxCustomerName = (TextBox)GridViewCustomers.Rows[iRowIndex].FindControl("TextBoxCustomerName");
oCustomers.CustomersList.Rows[iRowIndex]["cCustomerName"] = oTextBoxCustomerName.Text;

TextBox oTextBoxEmailID = (TextBox)GridViewCustomers.Rows[iRowIndex].FindControl("TextBoxEmailID");
oCustomers.CustomersList.Rows[iRowIndex]["cEmailID"] = oTextBoxEmailID.Text;

RadioButton oRadioButtonActive = (RadioButton)GridViewCustomers.Rows[iRowIndex].FindControl("RadioButtonActive");
RadioButton oRadioButtonInActive = (RadioButton)GridViewCustomers.Rows[iRowIndex].FindControl("RadioButtonInActive");

if (oRadioButtonActive.Checked == true)
{
oCustomers.CustomersList.Rows[iRowIndex]["bIsActive"] = true;

}
else if (oRadioButtonInActive.Checked == true)
{
oCustomers.CustomersList.Rows[iRowIndex]["bIsActive"] = false;
}
oCustomers.CustomersList.AcceptChanges();
}

-- modified at 7:40 Wednesday 31st October, 2007

kavitha

how to read Excel file and show records into the Grid.

Tejesh Kamble31-Oct-07 1:09

Tejesh Kamble

31-Oct-07 1:09

Hi All,
I want to read Excel file and show records into the Grid.
for that i have written vb.net code,this code is successfully running as follows:
DataGrid1.DataSource =
Excel.GetWorkSheetByName(Excel.ExcelWorkSheets.Item(0).TableName);
DataGrid1.DataBind();

while writting same code in c# as follows:

DataGrid1.DataSource =
Excel.GetWorkSheetByName(Excel.ExcelWorkSheets.Item[0].TableName);
DataGrid1.DataBind();

it gives an error message as follows:
Cannot apply indexing with [] to an expression of type 'WorkSheet'

Please Help.

Thanks in advance.

Tejesh Kamble.

Re: how to read Excel file and show records into the Grid. [modified]

Jintal Patel31-Oct-07 2:05

Jintal Patel

31-Oct-07 2:05

hi
i m not getting what's the error ...

but u try like this

string strcon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\jintal\\test\\test.xls; Extended Properties=Excel 8.0;";
OleDbConnection con = new OleDbConnection(strcon);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connection);

DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "Sheet1$");
GridView1.DataSource = myDataSet.Tables["Sheet1$"].DefaultView;
GridView1.DataBind();

-- modified at 8:15 Wednesday 31st October, 2007

Jintal Patel

Re: how to read Excel file and show records into the Grid.

Tejesh Kamble31-Oct-07 2:30

Tejesh Kamble

31-Oct-07 2:30

Thanks for ur reply.

I will try this.

Tejesh Kamble.
Software Engineer.

Paging problem in GridView [modified]

Thavika31-Oct-07 0:55

Thavika

31-Oct-07 0:55

With the Index I m finding control so wen it reaches 5th record it searches for 6th then says out of range error because pagesize is 5

-- modified at 7:22 Wednesday 31st October, 2007

kavitha

Re: Paging problem in GridView

Imran Khan Pathan31-Oct-07 1:24

Imran Khan Pathan

31-Oct-07 1:24

Because here gridview's datasource contains only 5th records.

bEst rEgard
pAthan

please don't forget to vote on the post that helped you.

Re: Paging problem in GridView

Thavika31-Oct-07 1:31

Thavika

31-Oct-07 1:31

I m very clear i know that only 5 rows are ther in the grid .but i need all the records from the grid

kavitha

Re: Paging problem in GridView

Imran Khan Pathan31-Oct-07 1:35

Imran Khan Pathan

31-Oct-07 1:35

Thavika wrote:
5 rows are ther in the grid .but i need all the records from the grid

please don't forget to vote on the post that helped you.

sachinkalse31-Oct-07 0:44

sachinkalse

31-Oct-07 0:44

Dear All,
I have a web application (ASP.NET / framework 2.0 / Windows Server 2003) on one machine, i.e. Web Server and corresponding database (SQL Server 2005) on second machine.
If I access the application from Web Server, it works fine, but when I access from a third client machine it gives following error
-------------------------------------------------------
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
-------------------------------------------------------

I think this has some thing to do with the permissions to access DB from client machines

my Web.config file has following things added
---------------------------------------------------------
<add name="ConnString" connectionString="workstation id=MY_WORKSTATION;packet size=4096; integrated security=SSPI;data source=MY_DB; persist security info=False;initial catalog=MY_CATALOG"/>
<system.web>
.....
<identity impersonate="true"/>
.....
</system.web>
---------------------------------------------------------

Moreover, the SQL Server is configured as per following link
"http://support.microsoft.com/kb/914277"

Please guide

Regards
Sachin

How to close a frame in a webpage?

Spunky Coder31-Oct-07 0:36

Spunky Coder

31-Oct-07 0:36

How to close a frame from either javascript or from code behind in a page? Suppose if in a page two frames are present and in one frame an aspx page is present...in onClick of a button in the aspx page the other frame should be closed and the aspx page should occupy the whole window ...is there any way to do this?

Koushik

Re: How to close a frame in a webpage?

N a v a n e e t h31-Oct-07 1:01

N a v a n e e t h

31-Oct-07 1:01

I guess you can't close a frame. You can redirect to other page which don't have any frames.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

HTML Source From URL

raju melveetilpurayil31-Oct-07 0:35

raju melveetilpurayil

31-Oct-07 0:35

code for get HTML Source from input URL

using System.Web.Caching;
using System.Net;
using System.IO;

string URL = TextBox1.Text;//INPUT URL
if (URL.Substring(0, 7) != "http://")//CHECK URL CONTAIN http://
{
URL = "http://"+TextBox1.Text;
}
string ConvertURL =(string)Cache.Get(URL);
if (ConvertURL == null)
{
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(new Uri(URL));
HttpWebResponse res = (HttpWebResponse)req.GetResponse();
StreamReader srdr = new StreamReader(res.GetResponseStream());
ConvertURL = srdr.ReadToEnd();
}
Response.Write(ConvertURL);

Raju.M
http://aspdotnetprogrammer.blogspot.com/

Re: HTML Source From URL

Guffa31-Oct-07 1:00

Guffa

31-Oct-07 1:00

makhaai wrote:
URL = "http://"+TextBox1.Text;

Why reading it from the text box again? Just do:

URL = "http://" + URL;

makhaai wrote:
string ConvertURL =(string)Cache.Get(URL);

Why do you look in the cache for the source? Do you have any code elsewhere that stores anything in the cache?

You forgot to dispose the HttpWebResponse and the StreamReader.

---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams

Re: HTML Source From URL

N a v a n e e t h31-Oct-07 1:04

N a v a n e e t h

31-Oct-07 1:04

He was not asking a question, it seems like he is advertising this[^]

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: HTML Source From URL

Guffa31-Oct-07 9:49

Guffa

31-Oct-07 9:49

N a v a n e e t h wrote:
He was not asking a question

Yeah, I didn't see any question, but he got an answer anyway. Smile | :)

N a v a n e e t h wrote:
it seems like he is advertising this[^]

Seems you can take any crappy code and make a blog out of it... Wink | ;)

Re: HTML Source From URL

Guffa31-Oct-07 9:47

Guffa

31-Oct-07 9:47

makhaai wrote:
please tell wat is the prob in my code?

I just did.

button id in gridvew

Sonia Gupta31-Oct-07 0:28

Sonia Gupta

31-Oct-07 0:28

i have a jaascript function. and a gridview , which contains a button.My problem is , how i should add the attributtes of that utton.i am doing it in the following manner.
on form load i am extracting the id of button (whichh is in gridview).
Button l = (Button)GridView1.FindControl("p");
l.Attributes.Add("onClick", "javascript:return abc();");

and in java script i am extracting the button id in the following manner.

function abc()
{
var a = document.getElementById("<%=GridView1.subassembly.ClientID%>");
alert(a);
}
after doing this , i am gettng an error, does not contain the definition for
subassembly.
Where is the problem lying?

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

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