ASP.NET

Michael Sync7-Nov-07 6:21

7-Nov-07 6:21

Have you tried #1? "#1. Create the HTML file named default.htm in your webpage. and try to call and see whether you are still getting "Page Not Found" error.. "

Can you see the html page without calling explicitly???

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

dboy2217-Nov-07 6:31

dboy221

7-Nov-07 6:31

I tried #1 and was able to pull the default page without explicitly calling it. When I move the default.aspx first on the document listing i then get the error (even calling it explicitly).

dboy2217-Nov-07 8:42

dboy221

7-Nov-07 8:42

Found the solution to my problem...Go to this link
http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=254

Michael Sync7-Nov-07 16:51

Best layout for Subscriptions Page

7-Nov-07 16:51

oh. man.. i thought you have configured it already... okay.. thanks for the link..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

.NetRocker7-Nov-07 4:50

.NetRocker

7-Nov-07 4:50

Hi,

I am working on a ASP.Net page in which I need to display ALERTS available for a user, and the user can subscribe to what ALERTS he can get. I have a Subscriptions table in the database which has the ALERTS and CATEGORY.

I need to show the categories and alerts for each category and show check boxes for the user to select which alerts he/she wants to subscribe to.

I know I could create the controls on run time but would want to use a better technique.

Thanks,
Sandeep

Michael Sync7-Nov-07 5:54

7-Nov-07 5:54

Sandeep3678 wrote:

I know I could create the controls on run time but would want to use a better technique.

What about using GridView with Checkedbox column?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

.NetRocker7-Nov-07 6:00

.NetRocker

7-Nov-07 6:00

yes thats what im thinking but I need grouping here by category. Any best way to do it?

Michael Sync7-Nov-07 6:14

7-Nov-07 6:14

then, you will need the control that can work like treeview + gridview... or you can use two gridviews for that.. one for category and one for subscription... you can show the list of categories with hyperlink in gridview at the top.. if the user clicks on a particular category, you can show the list of related information with checked boxes.. but it won't be look nice.. Frown | :(

it is better if you have a control that can use like TV + GV..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

.NetRocker7-Nov-07 6:16

.NetRocker

7-Nov-07 6:16

Or I could have a bound column for category and template column with Check box for subscription and group the gridview right? This seems to be a very viable option right now. Could you guide me through it?

Michael Sync7-Nov-07 6:39

Problem with Login Control [modified]

7-Nov-07 6:39

Check this for grouping row in Gridview..
http://blog.zygonia.net/PermaLink,guid,c093836d-8d97-4e5b-8a1c-8218742cb686.aspx\

Check-out this for manipulating with chked boxes in GridView..
http://www.codeproject.com/aspnet/SelChkboxesDataGridView.asp

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

ocabrera707-Nov-07 4:33

ocabrera70

7-Nov-07 4:33

Hello. I'm working with a Custom Membership Provider and a login control. In Internet Explorer the Login Button of the Login Control does not work(it does not submit the page). The page has a master page. Somebody knows why?

-- modified at 10:43 Wednesday 7th November, 2007

Problem with UpdatePanel, ListBox, and the back button..

Dio227-Nov-07 4:25

Dio22

7-Nov-07 4:25

I have a Listbox in an Ajax UpdatePanel, when the user clicks the submit button and navigates away from the page, I clear the data using ListBox.Items.Clear(); However, when the user clicks the back button in the browser the data is still in the ListBox.Items collection.. (Its invisible at first, but when you try and add a new item to the listbox, the old items show up again). *shrug* anyone ever had this problem?

Process cannot access the file because it is being used by another process

samerh7-Nov-07 3:48

samerh

7-Nov-07 3:48

Hi all,
Iam using the following code to send email attachments

<br />
HttpContext.Current.Response.Charset = ""<br />
Dim tw As New System.IO.StringWriter<br />
Dim hw As New System.Web.UI.HtmlTextWriter(tw)<br />
report.RenderControl(hw)<br />
'My.Computer.FileSystem.DeleteFile(HttpContext.Current.Server.MapPath("~\Attachments\" & ReportName))<br />
<br />
Dim attachment As String = HttpContext.Current.Server.MapPath("~\Attachments\" & ReportName)<br />
<br />
My.Computer.FileSystem.WriteAllText(attachment, tw.ToString, False)<br />
AppEmailService.SendMail(subject, body, attachment, receiver)<br />
tw.Close()<br />
hw.Close()<br />
tw = Nothing<br />
hw = Nothing

the first time any user sends an email, it is successfully sent. If i try to send the same attachment again, it is giving me an error that the attachment is being in use.
"The process cannot access the file 'c:\inetpub\wwwroot\ORM\Attachments\Number of operational Loss Events.xls' because it is being used by another process"
Any ideas

Help me with this Pl/Sql procedure (ORACLE 9i) call from asp.net

solami7-Nov-07 3:24

solami

7-Nov-07 3:24

this is my stored procedure in oracle, am using oracle client,
cmd.parameter.add() to RETURN the value of the parameter but its not working.

PROCEDURE "SCOTT"."PROCEDURE2" (
"PARAM1" IN NUMBER, "PARAM2" out VARCHAR2) IS

varEname VARCHAR2(40):='xxx';
varComm REAL;
varSalary CONSTANT NUMBER:=1000;
comm_missing EXCEPTION;

BEGIN
SELECT ENAME,
COMM
INTO varEname,
varComm
FROM EMP
WHERE EMPNO = param1 ;---7369;

IF varComm IS NULL THEN
RAISE comm_missing;
else
dbms_output.put_line('Commision is ' || varcomm );
END IF;

param2:=varEname;
dbms_output.put_line(param2);

EXCEPTION WHEN comm_missing THEN
dbms_output.put_line('Commision is NULL');
WHEN no_data_found THEN
dbms_output.put_line('Employee Does not Exist');
END "PROCEDURE2";

I need to retrieve the value of param2 inside my Asp.net code.

Please help me with Ideas.

Salami

Re: Help me with this Pl/Sql procedure (ORACLE 9i) call from asp.net

VenkataRamesh7-Nov-07 5:26

How can I use a connection string stored in the web.config file

7-Nov-07 5:26

check out this link ..hope it will help u...

http://aspnet.4guysfromrolla.com/articles/062905-1.aspx

regards

Ramesh

Big Ralph7-Nov-07 3:01

Re: How can I use a connection string stored in the web.config file [modified]

7-Nov-07 3:01

How can I use a connection string stored in the web.config file to get a datatable from the sql server 2005 ?
thx in advance.

BiG RaLpH

alexfromto7-Nov-07 3:10

alexfromto

7-Nov-07 3:10

Hi.

Your connection string of course might be different but here's what you do with that. Put the following inside <configuration></configuration> right after let's say </system.web> (Make sure it doesnt go inside system.web node)

<appSettings>
<add key="SQLConString" value="packet size=4096;data source=SERVER;persist security info=True;user id=USERUD;password=PASSWORD;initial catalog=DATABASE"/>
</appSettings>

In your code do the following to get connection:

Dim sConn As String<br />
sConn = ConfigurationSettings.AppSettings("SQLConString")<br />
Dim con As New System.Data.SqlClient.SqlConnection(sConn)<br />
con.Open()<br />
....<br />
....<br />
....<br />
con.Close()

That's it.

-- modified at 9:20 Wednesday 7th November, 2007

Re: How can I use a connection string stored in the web.config file

Big Ralph7-Nov-07 3:51

Re: How can I use a connection string stored in the web.config file

7-Nov-07 3:51

Thx
Now how can I get the table in that database lets name the table "Tabl1".
I want to copy it and put it in a instance of the table.
i.e.:
dim table as datatable
"table = Table1"

thx

BiG RaLpH

alexfromto7-Nov-07 3:57

alexfromto

7-Nov-07 3:57

Use connection to connect to database. Create datagrid, dataset and dataadapter.
Fill your dataset using dataadapter and assing dataset to your datagrid.

NOTE: dg is the datagrid on your page. You can AutoGenerateColumns(True or False).
If you do just bind dataset to datagrid and that's it. If you want to play around you will have to built custom columns for your datagrid.

'Open connection<br />
con.Open()<br />
<br />
Dim strSQL As String = "SELECT * FROM Tabl1"<br />
<br />
'Create command and assign timeout value<br />
Dim cmdSelect As New System.Data.SqlClient.SqlCommand(strSQL, con)<br />
<br />
'Create data set<br />
Dim ds As New DataSet<br />
<br />
'Created adapter and fill dataset<br />
Dim da As New System.Data.SqlClient.SqlDataAdapter(cmdSelect)<br />
da.Fill(ds, "ANYTABLENAME")<br />
<br />
'Verify if data exists<br />
If ds.Tables(0).Rows.Count > 0 Then<br />
   'Create dataview and assign sort by field and direction<br />
   Dim dv As DataView = ds.Tables("ANYTABLENAME").DefaultView<br />
   dg.DataSource = dv<br />
<br />
   'Bind data to datagrid<br />
   dg.DataBind()<br />
End If<br />
<br />
'Close connection<br />
con.Close()

Re: How can I use a connection string stored in the web.config file

Big Ralph7-Nov-07 4:20

Re: How can I use a connection string stored in the web.config file

7-Nov-07 4:20

thx alot but I'm having the error that con has not been initialized.

BiG RaLpH

VenkataRamesh7-Nov-07 4:18

Re: How can I use a connection string stored in the web.config file

7-Nov-07 4:18

Dim sConn As String
sConn = ConfigurationSettings.AppSettings("SQLConString")
Dim con As New System.Data.SqlClient.SqlConnection(sConn)

Dim selectCMD As SqlCommand = New SqlCommand("SELECT * FROM Customers", con)
selectCMD.CommandTimeout = 30

Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD

con.Open()

Dim custDT As DataTable = New DataTable
custDA.Fill(custDT, "Customers")

con.Close()

Now u have customers table in custDT ..

Regards,
Ramesh.

Big Ralph7-Nov-07 4:34

Re: How can I use a connection string stored in the web.config file

7-Nov-07 4:34

thx alot but I'm having the error that con has not been initialized.

BiG RaLpH

VenkataRamesh7-Nov-07 4:42

Re: How can I use a connection string stored in the web.config file

7-Nov-07 4:42

are you running on a sql Server?

If so shouldn't you do any authentication? User Id=;Password=;

check out the connection string in web.config

Big Ralph7-Nov-07 4:51

Re: How can I use a connection string stored in the web.config file

7-Nov-07 4:51

No I don't have any ID or Password this is y I'm amazed.
is there anything else that might go wrong that may coz this error.

BiG RaLpH

VenkataRamesh7-Nov-07 4:58