database connection - ASP.NET Discussion Boards

Windows Installer - Preparing to Install?

AliAmjad19-May-09 18:16

19-May-09 18:16

Previously everything was working just fine but today when I opened Visual Web Developer and then opened the Web Form in design view it gives me this ever lasting dialog box "Windows Installer - Preparing to Install". Please Help!

AliAmjad(MCP)

First make it Run THEN make it Run Fast!

Re: Windows Installer - Preparing to Install?

Ramesh Swaminathan19-May-09 19:23

Ramesh Swaminathan

19-May-09 19:23

This error might be occured if you install a program but the installation failed.Or, maybe you have problems trying to remove an old program because the installation files are corrupted.

Uninstall the visual developer and re-install again.
Or you can use Windows Windows Installer CleanUp Utility[^] to
resolve installation problems for programs that use Microsoft Windows Installer.

Edit part of multi-upload file board.

lsh486love19-May-09 15:16

lsh486love

19-May-09 15:16

I'm making multi-upload file board.

and I'm done about uploading multi-files.

when I click "Edit" button, shows up the files that I uploaded on ListBox.

But when I would like to change the files that I uploaded, I don't know how to make it.

foreach (System.Web.UI.HtmlControls.HtmlInputFile HIF in hif)
{
try
{
string fn = System.IO.Path.GetFileName(HIF.PostedFile.FileName);

string fileName = Pds.SaveFile(fn, upDir);

HIF.PostedFile.SaveAs(upDir + fileName);

filename = fileName;
string userId = Session["memberID"].ToString();
string pathname = Session["pathname1"].ToString();
Pds.Insert(userId, User.Identity.Name, txtTitle.Text, txtContent.Text,filename, pathname);

This codes are about uploading.

are there sample sources for editing files that I uploaded.??

AJAX call: JSON/WCF vs ASPX

devvvy19-May-09 15:08

devvvy

19-May-09 15:08

hello

If your dropdown box onchange is to make call to AJAX to refresh other part of the page, Would you choose JSON/WCF? Or have a ASPX page to render the result instead?

How'd you choose? Seems to me like JSON has nicer syntax (i.e more like function calls) but it suffers from:
a. CSRF attack (eval function)
b. more complex
c. Any issue with Authentication? can we do "Windows Authentication" with webHttpBinding?

<br />
<services><br />
      <service name="Microsoft.Ajax.Samples.CityService"><br />
        <endpoint <br />
          address="ajaxEndpoint"<br />
          behaviorConfiguration="AjaxBehavior"<br />
          binding="webHttpBinding"<br />
          contract="Microsoft.Ajax.Samples.ICityService" /><br />
      </service><br />
    </services><br />

Thanks

REF
http://en.wikipedia.org/wiki/JSON[^]

http://www.west-wind.com/weblog/posts/164419.aspx[^]

http://msdn.microsoft.com/en-us/library/bb299886.aspx[^]

http://msdn.microsoft.com/en-us/library/bb412170.aspx[^]

http://msdn.microsoft.com/en-us/library/bb412167.aspx[^]

http://msdn.microsoft.com/en-us/library/bb885100.aspx[^]

dev

Session Transfer between Classic ASP and ASP.Net

medasatheesh19-May-09 10:00

medasatheesh

19-May-09 10:00

Hi,

I am working on a migration project, where we are converting from classic ASP to ASP.Net 2.0. We want to run both ASP and ASP.Net parallel. We want to update the site with new .net pages what ever we develop, instead of waiting complete site development. So here I am struggling with session variables passing between ASP and ASP.Net. I searched thru the internet and found couple of ways to do it.

http://msdn.microsoft.com/en-us/library/aa479313.aspx#converttoaspnet_topic6
http://www.eggheadcafe.com/articles/20041017.asp
http://www.eggheadcafe.com/articles/20021207.asp

But I dont understand which approach is the best way to do. Mine is a financial application, so looking for secured with little/noo changes in existing ASP.

Please help me in finding the solution.

Thanks,
Satheesh M

Re: Session Transfer between Classic ASP and ASP.Net

Christian Graus19-May-09 12:27

Christian Graus

19-May-09 12:27

You can't do it with no changes at all, you need a proxy to store your session data, and both apps need to call the proxy in order to share the data.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Re: Session Transfer between Classic ASP and ASP.Net

medasatheesh20-May-09 3:29

medasatheesh

20-May-09 3:29

Yes, that's why I mentioned I am looking for little/no changes. you mentioned we have to use proxy, means some database or some thing else. Can you please guide me.
Thanks,
Satheesh

database connection

jainiraj19-May-09 7:01

jainiraj

19-May-09 7:01

I have a database in sql server named as "stock" in which "custdetails" is a table which has various fields.
I have connection string as-

ConString = "Data Source=localhost;Initial Catalog=stock;Integrated Security=true";

and two method selecct and update as-

public DataTable select(String query)
{
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, ConString);
adp.Fill(ds);
return (ds.Tables[0]);
}
public void update(String query)
{
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, ConString);
adp.Fill(ds);

Now I have a button.when buton is clicked i want to take data from database.But it is not retrieved. I have cheked it by printing it in a textbox.the code is as follow-

DataTable dt=new DataTable();
common obj=new common();
dt = obj.select("select * from custdetails");
TextBox2.Text = dt.Rows.Count.ToString();
TextBox1.Text = dt.Rows[1][1].ToString();

It is not working.what problem can be????
plz help me.......

Re: database connection

MidwestLimey19-May-09 7:48

MidwestLimey

19-May-09 7:48

jainiraj wrote:
But it is not retrieved

How did it fail? What exception did you get?

10110011001111101010101000001000001101001010001010100000100000101000001000111100010110001011001011

Re: database connection

Manas Bhardwaj19-May-09 9:30

Manas Bhardwaj

19-May-09 9:30

First of all what does it has do with ASP.Net?

What have you done to even think that it is going to retrieve data from the database.
I dont see any piece of code which is actually interacting with the database?

jainiraj wrote:
common obj=new common();

what does it do?

Have a look here[^].

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: database connection

padmanabhan N19-May-09 15:22

padmanabhan N

19-May-09 15:22

use select query like this

string select = "select * from custdetails"
SqlDataAdapter da = new SqlDataAdapter(select.ToString(), con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;

Padmanabhan

Re: database connection

MidwestLimey20-May-09 5:09

MidwestLimey

20-May-09 5:09

And this helps him how?
Missing ;, pointless ToString() call on a string instance and an undeclared variable conn. His code was fine, bar the naming convention. The most likely problem he has is a connection issue.
I'm just really curious as to what your mindset was in posting this?

10110011001111101010101000001000001101001010001010100000100000101000001000111100010110001011001011

Re: database connection

padmanabhan N20-May-09 15:39

padmanabhan N

20-May-09 15:39

ConString = "Data Source=localhost;Initial Catalog=stock;Integrated Security=true";

string select = "select * from custdetails";
SqlDataAdapter da = new SqlDataAdapter(select, ConString);
DataTable dt = new DataTable();
da.Fill(dt);
//here comes ur code

TextBox2.Text = dt.Rows.Count.ToString();
TextBox1.Text = dt.Rows[1][1].ToString();
//now it will work fine

Padmanabhan

Internet Explorer cannot download file from server

Biju Sam19-May-09 5:19

Biju Sam

19-May-09 5:19

I have a custom File management ASP application that handles Large File uploads and download from a database (30 - 40 MB files) The application works fine on IIS5 but when I relocate it to IIS6 i get an error when I file not found error when i attempt to download out of the Database. IS there a reg setting or metabase setting that i need to change to handle large blob outputs.? Sorry I can't be more specific about the error msg but that is all it give's me a File not found error. it does however work fine with small files less then 2mb in size

When i checked for help i found this:http://support.microsoft.com/default.aspx?scid=KB;EN-US;q316431&[^]

And this is the error i get

Error message 1

Internet Explorer cannot download file from server.
Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.

I was using IIS 5.0 and win 2000 before. Now i have migrated to IIS6.0 and Win2003

Any help on this will be highly appreciated.

Biju Sam

Request autentication for Web Service (WSDL)

ryn00419-May-09 5:06

ryn004

19-May-09 5:06

I have a web service which I want only the people with a certain digital certicate only be allowed to access it. My question is do I secure the web service itself or is it some setting from the IIS?

DataGrid to Excel

Civic0619-May-09 4:44

Civic06

19-May-09 4:44

I am using an OracleDataAdapter to fill a dataset where i have a column with datatype float in database. So after i do the .fill into dataset and try to view the contents of the dataset in debug mode. for that column if a row has value 3500 and the row following that also has 3500 the second 3500 has blank value. How to fix this?

Re: DataGrid to Excel

Manas Bhardwaj19-May-09 4:49

Manas Bhardwaj

19-May-09 4:49

Civic06 wrote:
DataGrid to Excel

What does it has to do with excel? D'Oh! | :doh:

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: DataGrid to Excel

Civic0619-May-09 5:02

Civic06

19-May-09 5:02

At first i thought it had to with excel. but it doesn't after i debugged.

how can I make controls wrap down on resizing page?

SRKSHOME19-May-09 4:09

SRKSHOME

19-May-09 4:09

Hi,
I have several dropdown controls and input controls(let us say 10 controls)in a single td tag inside the table. Horizontal scroll is required to see all the controls. But when resize the the IE(i.e. make smaller the IE) how can I make the controls wrapdown?

any CSS can be used? I know with div tag it can be wrap down.But i wanted to keep it in a table itself?

any idea please?

Re: how can I make controls wrap down on resizing page?

blsong19-May-09 21:14

blsong

19-May-09 21:14

we can baidu,google,sohu,yoohu.com or so much!

Web Control Library (User Control)

rains197919-May-09 2:51

rains1979

19-May-09 2:51

Hi,

I wanted to create a user control to be used across multiple web applications under one solution.
How can I create it using a web control library.

In short how to work with a web control library and add those controls in your project.

I can create a .ascx file in each project and do it but I do not want that. I want only one file which I can reuse in each application without adding any code.

Rgds,
Rains

Re: Web Control Library (User Control)

Manas Bhardwaj19-May-09 2:57

Manas Bhardwaj

19-May-09 2:57