ManicCW

Code for connecting to Microsoft Access databse, opening and closing connection

When you are programming web pages it is very important to optimize your code for better and faster performance. In this part I will show you how to optimize code for filling multiple dropdownlists with data from Microsoft Access. The same thing is with SQL Server. I'm using asp.net 2.0 …

Do you know how to populate one combo? If you don't i suggest that you read some tutorials before.

[QUOTE]Macs are easy to use, have all the software a user will ever need incorportated in it.[/QUOTE] And Windows is not easy, does not have all the software? :rolleyes: [QUOTE]There are a lot less viruses for linux than windows.[/QUOTE] That is normal because Linux is not used so much as …

But isn't wiki data protected by copyright or something?

ASP.net 2.0 introduced themes. Theme consists of several files: CSS styles, skin file and images. You create theme by adding App_Themes folder in your project in solution explorer panel. Right click on project - Add ASP.net folder - Theme Now that we created theme we can add files into it. …

You can use URL rewriting, but it is much better, in my opinion, to use folders with default.aspx page inside. Instead Home.aspx, use Home/Default.aspx.

Use Global.asax file and add this [code] Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) Application("OnlineUsers") = 0 End Sub Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs) Application("OnlineUsers") += 1 End Sub Sub Session_End(ByVal sender As Object, ByVal e As EventArgs) Application("OnlineUsers") -= 1 End Sub [/code] …

My little advice: [B]Never mess with the client computer![/B] I hate when web pages try to do that.

When passing query use parameters: [QUOTE]cmd.CommandText = "SELECT ID, Title, Job FROM Jobs WHERE Title=@Title" cmd.Parameters.Add("@Title", SqlDataType.NVarChar).Value = Me.txtTitle.Text.Trim [/QUOTE] To hide some element while print: [url]http://www.daniweb.com/techtalkforums/thread54946.html[/url]

Try this: [CODE]Me.MyLiteral.Text = Me.MyTextBox.Text.Replace(ControlChars.NewLine, "<br />")[/CODE]

You can use AJAX UpdatePanel and UpdateProgress to solve that problem. [URL="http://ajax.asp.net"]http://ajax.asp.net[/URL]

You can create virtual directory with application in your IIS.

[QUOTE]No, ruby is mainly use for web applications.[/QUOTE] Ruby is NOT just for web applications! This sub forum should be renamed "Ruby on Rails".

This is valid XHTML code for inserting swf. <object type="application/x-shockwave-flash" data="SWFPath" width="SWFWidth" height="SWFHeight"> <param name="movie" value="SWFPath" /> </object>

Can you post some code from aspx and code behind?

Did you enable SMTP in your local IIS?

Server.MapPath("~\MyData\grades.mdb")

Why don't you track it with statistics? Anyway, if you really want it, you can use [B]global.asax[/B] file for that. In Application_Start and Application_End event of global.asax set something like this: [code] Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) Application("Online") = 0 End Sub Sub Application_End(ByVal sender As …

Just put it in Session or QueryString. In first page set on button click event: [CODE] Session("Number") = Me.MyTextbox.Text.Trim --or-- Response.Redirect("Secondmenu.aspx?Number=" & Me.MyTextbox.Text.Trim) [/CODE] Then in second page use something like this: [CODE]Dim myFilter as Int16 Try myFilter = CInt(Session("Number")) --or-- myFilter = CInt(Request.QueryString("Number)) Catch ex As Exception --code for …

You can use any Linux mail server for this. Just change your MX records in your Windows hosting panel.

I don't think you can do that on individual files in asp.net. In vb.net (local programming) it is possible.

Yes, you have all the controls in your Toolbar if you are using Visual Studio 2005, or 2008.

You can use regular expressions but that is complex for this. To use simple formating, just replace control characters with html, like: [QUOTE]Dim htmlText As String = BlogBox.Text htmlText = htmlText.Replace(ControlChars.CrLf, "<br />")[/QUOTE] Then just use htmlText in your insert command.

I agree. Use form authentication. You can protect your site with simple two line code in web.config file.

Is your column [B]deptCode[/B] string (varchar, nvarchar ...) type?. LIKE operator should be used only for string values.

[QUOTE=sierrasoft;272304] Can anyone guide me [B](in detail)[/B] [/QUOTE] :eek: You ask to much. Start planning, coding and then ask some specific question.

Create Main table with (example) two rows and three columns. Then merge columns in second row and insert new table in that row. That should do it. Btw. I recomend using div tags for layout and tables just for tabular data.

Where is your swf file placed? Use getUrl path relative to swf file.

Why do you even redirect using javascript? :-/ Use code behind to redirect it. In click event of the button: [CODE] Response.Redirect("~/MyPage.aspx?MyQuery=" & Me.MyTextBox.Text.Trim) [/CODE]

Use forms authentication to restrict user rights. Then use one function to download file. What exactly do you need?

What is the column of DeparturePlace? Number? What is the value of DropDownList1.SelectedValue?

Pass values using querystring like: [CODE]Response.Rediract("MySecondPage.aspx?DeparturePlace=" & Me.MyDropDownList1.SelectedValue & "&Destination=" & Me.MyDropDownList2.SelectedValue)[/CODE] :icon_wink:

What is the error that you get?

Put image control in template column or use image column.

Run this in your sql query analyzer: [code] USE master; GO EXEC sp_configure 'user instances enabled', '1'; [/code]

Try replacing [B]qnum.SelectedItem.Value[/B] with [B]qnum.SelectedValue[/B]

Does that server allows relaying or have you used some authentication method?

Did you set appropriate permissions on your database file? ASP.net user need read/write permissions.

What do you mean popup control? Something like message box, new browser window, show/hide div or what?

Simply pass values in querystring like: surveyeditor.aspx?title=MyTitle&Description=MyDescription To accomplish this in gridview use this in your edit button navigation path: surveyeditor.aspx?title=<%# Eval("Title")%>&Description=<%# Eval("Description")%>

I don't think there is a way to do this using standard asp.net controls. You need to use client side [B]javascript [/B]or [B]ajax [/B]approach.

Use ddl.SelectedValue.ToString

Did you import namespace System.Data.Odbc? Btw. You did not declare sConnection as string. Dim sConnection As String

First of all you should not mess with client computer using web. It always requires some ActiveX controls that need to be installed. Second, you do not need to search for entire HD, you could just set path on client side for client to fill.

I think you would have to install that com components you used in your application. I don't think there is another way.

Well it is much easier to use [B]AccessDataSource [/B]and it's wizard. :D

Use this code: [CODE]Dim g As Graphics = Graphics.FromImage(YourBitmap) g.SmoothingMode = SmoothingMode.HighQuality g.InterpolationMode = InterpolationMode.HighQualityBicubic g.PixelOffsetMode = PixelOffsetMode.HighQuality[/CODE] And when saving use this: [CODE]Dim myParams As EncoderParameters = New EncoderParameters(1) myParams.Param(0) = New EncoderParameter(System.Drawing.Imaging.Encoder.Quality, 80) YourBitmap.Save(YourPath, GetEncoderInfo(MimeType), myParams)[/CODE] This is GetEncoderInfo function: [CODE]Public Function GetEncoderInfo(ByVal MimeType As String) As ImageCodecInfo …

Why would you need to update it? Authentication will be automaticaly updated with IsOnline=False when time runs out.

[QUOTE]i know HTML is able to do so BUT is ASP.Net able to[/QUOTE] Well what is flash object then HTML? It uses object or embed tags which are standard HTML tags. :)