Unclear How to Get SQL Server Developer 2005 to Work with VS.NET - Web Development Discussion Boards

Hi everyone,

Please forgive me if this seems like a dumb question. I'm not very familiar with web development so whilst I go trawling the web for answers I thought I put up a quick post to see if anyone out there could help...

Since a member of our team left I've been asked to look at a problem with our Internet Explorer based windows app and I'm not really too sure a) exactly what the problem is and b) how to fix it.

When our app is minimised and an event causes the page to reload the text shrinks so that when the page is restored the text is unreadable. As soon as the page is reloaded the normal text size is restored. In the template for all pages is some script that is called from the body tags' onresize event handler that I think applies:

function SetTextSize()<br />
{<br />
    document.styleSheets[0].rules[0].style.fontSize = document.body.offsetWidth/40;<br />
}

I believe this is a way of dynamically resizing the text depending upon the width of the window, however it is though the width of the window becomes very small when minimised, hence the text shrinking. Does anybody know if this is a stadard thing to do? Is there a better way to do it that will maintain the dynamic resizing of text but not shrink the text when the page is minimised?

I've never seen anyone do anything like that before. I'd ditch it. Seems like an obvious way to solve the problem.

Or even just have code so it doesn't go below a certain base level.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Having looked around the web I've seen a couple of examples where it's done. I've looked a little closer at my template and realised why it won't work. There is a body tag 'onresize' event handler that calls the SetTextSize function but that isn't working, presumably because it's not valid html anymore. This should overcome the small font problem because the resize event will be fired when the page is maximised (I think) and so reset the font size. I think a new valid implementation of the resize event should be implemented in the form of:

window.onresize = function;

I have tried this and it won't work for me either. Any guesses? I've included the code for reference.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml"><br />
<head><br />
    <title>None</title><br />
    <link id="pagestyle" rel="Stylesheet" href="default.css" type="text/css" /><br />
    <base target="_parent" /><br />
    <script type="text/javascript" src="css?keyhandling.js"></script><br />
    <script type="text/javascript" src="css?selectbuttons.js"></script><br />
    <script type="text/javascript" language="javascript"><br />
<br />
function LoadActions()<br />
{<br />
	SetTextSize();<br />
	window.navigate('event?IP=PAGELOAD');<br />
}<br />
<br />
function SetTextSize()<br />
{<br />
    document.styleSheets[0].rules[0].style.fontSize = document.body.offsetWidth/40;<br />
}<br />
<br />
window.onresize = SetTextSize;<br />
<br />
    </script><br />
</head><br />
<body onload="LoadActions();" class="normal"><br />
$$BODY_CONTENT$$<br />
</body><br />
</html>

Christian's suggestion was good - ditch the technique. I'd be very annoyed with a website if it started changing the size of fonts when I resized the browser, and would more than likely never use it again.

Also, I'm not sure if you're aware, but the onload attribute is spelled önload (note the umlaut)

Ok guys, thanks very much for your help. I've taken your advice and I'm going for a font defined by the fixed screen width.

Cheers,

Chris.

HI,

We have an application which was developed in Java for this we provided a web service using .net this web service basically helps in converting documents to pdf format.

Everything works fine however the issue is with anonymous access given to the web service. The client feels it could be a threat and wants us to remove the anonymous access to the web service.
On doing so there is no communication betwwen the application and the web service.

Question: ON removing anonymous access what are the other steps that i should follow at the application level and at the web service level.

gauthee

I have a login page, IE7 has a capability of multi tab in one browser when the user log off on page site, then open again the same site on that same browser it did not under go to login page, the user already log in. How can i ended the session so that the user will redirect again to login page?

Thanks
Vanhawk

Hello,

I am a total noob to VS.NET so please forgive my ignorance...

My environment is: Windows Vista Business, and Microsoft Visual Studio.NET 2005 Professional Edition, with SQL Server Developer Edition 2005 installed (the disc for SQL Server Developer came with the VS.NET 2005 discs).

When I follow the steps below, the process fails:

1. Open VS.NET

2. I click the File menu, click New, and then click Project.

3. I click Visual C# in the Project Types pane.

4. I click ASP.NET Web Application in the Templates pane.

5. I type 'MyASPNET' for the project name (I'm not picky, folks)

6. I click OK.

7. I click the Project menu, and then click Add New Item.

8. In the Templates box, I click SQL Database.

9. In the Name edit box, I type 'MySample.mdf,' and I then click Add.

10. Visual Studio displays the following prompt:
<quote>You are attempting to add a .mdf to an ASP.NET Web Application. For a .mdf to be generally consumable in your web application, it should be placed inside the 'App_Data' folder. Would you like to place the .mdf in the 'App_Data' folder?

This seems like a Good Thing, so I click Yes.

11. Then Visual Studio.NET 2005 displays the following message:
<quote>Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: [omitted]

The only option is to choose OK. So I do so.

And then I am bounced back to the Add New Item box.

I am doing these steps because I want to learn databases etc and I am following tutorials.

I have SQL Sever Developer Edition 2005 installed, shouldn't that be good enough to make adding new .mdf files in VS.NET work? How do I point VS.NET to know that a SQL Server is in fact installed?

Thank you for any help in advance.

Sincerely Yours,
Brian Hart
Department of Physics and Astronomy
University of California, Irvine

q

Brian Hart wrote:
In the Name edit box, I type 'MySample.mdf,' and I then click Add.

This is an access file.

Brian Hart wrote:
I have SQL Sever Developer Edition 2005 installed, shouldn't that be good enough to make adding new .mdf files in VS.NET work? How do I point VS.NET to know that a SQL Server is in fact installed?

I would always create my database through writing SQL scripts, not by letting the IDE do it. Then you can recreate your DB by running those scripts, any time you like. I would do it in the SQL Server IDE, not Visual Studio.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

I am not communicating clearly...

What I am wanting to do is just use the IDE for everything cuz I am lazy Smile | :)

SO what seems to be my problem is it seems like the VS.NET IDE only will work with SQL Server Express...if you've got Developer Edition installed, you're screwed. Does that pretty much sum it up?

Or is there a setting or Registry key I can tweak to get the VS.NET IDE to 'play nice' with SQL Server Developer Edition?

I just hate to think that Microsoft went to all the trouble of making up a special, "Developer" edition of SQL Server only to have the VS.NET IDE refuse to even work with anything else other than SQL Server Express.

Brian

Sincerely Yours,
Brian Hart
Department of Physics and Astronomy
University of California, Irvine

Could someone tell me where to find a good server capture applicatio, i want to see what is post back to the server any time i make a request.
i just went to Adobe MAX and I saw someone using it, but i couldnt find the name of it.
thanks

I'm trying to pass multiple DataKeynames after a selection is made in the Gridview, and to view them in a DataList where the selection matches them. Right now it will only display the first selected parameter (jacket).
Here is my code:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" Visible="false"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" DataKeyNames="jacket, closure, shielding" ForeColor="Black" GridLines="Vertical" Width="750px" OnPageIndexChanging="gridViewPublishers_PageIndexChanging" OnSorting="gridViewPublishers_Sorting"
AllowPaging="True" PageSize="20" AllowSorting="True" PagerSettings-Mode="NumericFirstLast">
<FooterStyle BackColor="#CCCCCC" />
<Columns>
<asp:CommandField ItemStyle-Width="70" ShowSelectButton="True" />
<asp:BoundField ItemStyle-Width="130" DataField="partnumber" HeaderText="Partnumber" ReadOnly="True" SortExpression="partnumber" />
<asp:BoundField ItemStyle-Width="100" DataField="jacket" HeaderText="Jacket" SortExpression="jacket" />
<asp:BoundField ItemStyle-Width="220" DataField="closure" HeaderText="Closure" SortExpression="Closure" />
<asp:BoundField ItemStyle-Width="110" DataField="shape" HeaderText="Shape" SortExpression="shape" />
<asp:BoundField ItemStyle-Width="130" DataField="shielding" HeaderText="Shielding" SortExpression="Shielding" />
</Columns>
<SelectedRowStyle BackColor="#7c7979" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#CCCCCC" />
<PagerSettings Mode="NumericFirstLast" />
</asp:GridView><br /><br />

<asp:DataList ID="DataList1" runat="server" BackColor="#1679d5" BorderColor="#999999"
BorderStyle="Solid" BorderWidth="1px" CellPadding="3"
ForeColor="White" GridLines="Vertical" DataSourceID="SqlDataSource1" Visible="false">
<FooterStyle BackColor="#CCCCCC" />
<SelectedItemStyle BackColor="Blue" Font-Bold="False" ForeColor="White" />
<ItemTemplate>
<table>
<tr>
<td style="width:120px; font-weight:bold;">
<asp:Label ID="materialLabel" runat="server" Text='<%# Eval("material") %>' />
</td>
<td style="width:450px;">
<asp:Label ID="Label" runat="server" TabIndex="1" Text='<%# Eval("marketing_tagline") %>' />
</td>
<td style="width:150px; text-align:center;">
<div class="SearchDataLink">
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("material", "dataSheet.aspx?id={0}") %>' TabIndex="2" Target="_blank" Text="View datasheet" />
</div>
</td>
</tr>
</table>
</ItemTemplate>
<AlternatingItemStyle BorderWidth="1" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
</asp:DataList>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ZippertubingConnectionString %>" SelectCommand="SELECT * FROM [ProductVerbage] WHERE ([material] = @jacket) OR ([material] = @closure) OR ([material] = @shielding) " >
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="jacket" PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="GridView1" Name="closure" PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="GridView1" Name="shielding" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

Hi!
I'm using Visual web developer 2005 express edition. I want to create a Solution which could contain a Web project and a Class library project, but I'm unable to find the option to create Class library project.
Can anybody help me for this problem?
Best regards.

this is what i am doing:
query the database to return 100 records into a dataset
then binding to a grid and enabling paging, with a page size of 3.
when changing page all 100 records are rebound to the grid

what i want to do:
to improve efficiency
query the database to return 100 records into a dataset
then binding to a grid and enabling paging, with a page size of 3 AND just send the 3 records to the users gridview, then when page 2 is requested just send the second page of data (records 4,5,6) to the grid from the dataset.

Thanks

If you are using asp.net 2.0 you can use a sqldatasource and turn on caching. If you are using asp.net 1.1 you can use a cache object to hold the dataset. Check to see if it is in the cache if it is use it if not then re-query for the data.

Hope that helps.
Ben

I am doing an application in which i have textboxes and grid control...

When i click on the row header, the values in ultrawebgrid, get populated on to the appropriate text boxes...

that too works fine..but when i click multiple row headers one after other, it
shows a java script error like this;

Error : 'getRow(....) is null or not an object
Code: 0
URL: http://teles/LPEMP/emp.aspx

I dont know why this is happening...?

Anyone please help me ....

SAJAN A PILLAI

C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE

"Winners don't do different things. They do things differently. ...

Hi all,
I have developed a spring java web service which will be consumed by .net client
when ever I am adding a web reference from .net it fetching me error
The document was understood, but it could not be processed.

- The WSDL document contains links that could not be resolved.

- There was an error downloading 'http://iss2w900:7001/GetIssuerWS/ServiceSchema/Services/Core/v1/Issue/GetIssue/input.xsd'.

- The request failed with HTTP status 405: Met

'http://iss2w900:7001/GetIssuerWS/ServiceSchema/Services/Core/v1/Issue/GetIssue/input.xsd'.
this is path for my xsd file that internally call another schema location.

Cabn u please help me out

vijaya

The url you have above for you web service is on your local PC port (7001). This is not available to anyone outside your PC. You will need to install your web service on a web service that has the correct dns entries so that othere systems can access the web service and use it.

Hope that helps.
Ben

Hi,

I'm trying to pass a text input box to an activex control, written in C#, but I keep getting "class doesn't support automation". Is it not possible to pass html element instances to activex controls? If it is, what type should the C# UserControl use as its parameter?

Thanks for any info!

Actually i have some URL Normalization issues but can you please tell me what more should i consider while normalizing the URLs. Like for example right now i am following these rules:

1. Converting the URL to lowercase.
2. Removing the fragment.
3. Removing the default port.
4. Removing the www part like http://www.example.com to http://example.com
5. Adding the trailing slash.

Now what else should I follow in order to make a URL a unique URL to Crawl. Thanks for your cooperation.

AliAmjad (MCP)

What exactly do you mean by making a unique URL for crawling? Your normalization process seems to turn a valid URL into one that may or not may not be valid.

Johnny ² wrote:
What exactly do you mean by making a unique URL for crawling?

Here i am actually applying the URL Normalization Rules to make the URL equivalent to that URL which may be discovered later on that is why i am using the unique keyword here.

For example if i have discovered a URL http://www.example.com:80/ and later on discovered the same URL on another site as http://www.example.com/ then by applying normalization rules i can compare these two URLs.

But i am not sure whether these rules a sufficient or not need your suggestions.

AliAmjad (MCP)

On a page i have a bunch of checkboxes, and a gridview. I want the checking of a checkbox to filter the records showing in the gridview, basically if checkbox A checked then filter results to show where Column A is true - is this something AJAX can do, and if so how is it done?

Many Thanks

Hi,

Are you using AJAX to bind grid?If so you cannot get the Grid Data at the clientside as it doesnt keep history.The best way is to call a javascript function which identifies the checked checkbox and pass it as querystring to the target URL using AJAX Call.In the codebehind create a method which connects to Database (assuming there is no session holding the Data.If so you can get from session)passing the filter condition and retreive the result.Once done bind the grid with the HTML content of Grid.
All this can be done asynchronously.

Let me know of any clarifications.

Rajesh Thomas

Hai,

I am working in Php and Mysql 5.0.
I need to create an online newsletter.
I have to send newsletter (Html files or Email with a pdf file as an attachment) to all email – ids which are stored in an online database.
The html newsletter and pdf file are stored in a folder on the webspace.

I login to our website and send the newsletters through a link or button. This should bind the newsletter to the email id and send the email to the recipient. All this should happen online server-side and automated. The website SMTP should be used minimizing our local bandwidth.

Please, help me to solve this problem. Thanks in advance

Regards,
G.Manivannan M.Sc.,[IT],
Software Programmer (VBA),
AKUVA Infotech, Bangalore.