CSS Links - CSS tutorial: "CSS TUTORIAL :"
www.svdeals.com
This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!
Thursday, December 27, 2007
Wednesday, December 19, 2007
Tuesday, November 27, 2007
add identity column, using the SELECT INTO statement, to table '%.*ls', which already has column '%.*ls' that inherits the identity property.
Cannot add identity column, using the SELECT INTO statement, to table '%.*ls', which already has column '%.*ls' that inherits the identity property.: "add identity column, using the SELECT INTO statement"
select IDENTITY(INT, 10, 1) AS i2,* into testasd from vprodfinal
select IDENTITY(INT, 10, 1) AS i2,* into testasd from vprodfinal
Monday, November 26, 2007
Page 2 - Configuring a Linked Microsoft Access Server on SQL 2005 Server
Page 2 - Configuring a Linked Microsoft Access Server on SQL 2005 Server: "Configuring a Linked Microsoft Access Server on SQL 2005 Server - Linked Servers on SQL 2005 Server "
exec sp_addlinkedserver @server='AccessDb',
@srvproduct='Access',
@provider='Microsoft.Jet.OLEDB.4.0',
@datasrc='C:\data\Categories.mdb'
www.svdeals.com super value deals
exec sp_addlinkedserver @server='AccessDb',
@srvproduct='Access',
@provider='Microsoft.Jet.OLEDB.4.0',
@datasrc='C:\data\Categories.mdb'
www.svdeals.com super value deals
Saturday, November 24, 2007
Using Queries to Convert Text Fields to Numerics
Using Queries to Convert Text Fields to Numerics: "Using Queries to Convert Text Fields to Numerics"
CDbl("3.2") =3.2
CDbl([MyField]) -->>>If MyField contains "3.2", 3.2If MyField contains "ABCD", a Type Mismatch error occurs
CDbl("3.2") =3.2
CDbl([MyField]) -->>>If MyField contains "3.2", 3.2If MyField contains "ABCD", a Type Mismatch error occurs
Thursday, November 15, 2007
FAQTs - Knowledge Base - View Entry - Internet: Web Server: Microsoft Information Server: IIS: How start/stop IIS from MSDOS command line?
FAQTs - Knowledge Base - View Entry - Internet: Web Server: Microsoft Information Server: IIS: How start/stop IIS from MSDOS command line?: "Web Server: Microsoft Information Server: IIS: How start/stop IIS from MSDOS command line?"
iisreset.exe /restart
iisreset.exe /restart
Monday, September 24, 2007
Dynamically Remove Gridview Rowstyle - ASP.NET Forums
Dynamically Remove Gridview Rowstyle - ASP.NET Forums: "Dynamically Remove Gridview Rowstyle"
www.svdeals.com
www.svdeals.com
Friday, September 21, 2007
Friday, September 7, 2007
Thursday, September 6, 2007
Auto save download Archive website, Save web pages programmatically as .HTML asp.net
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
SavePage("http://localhost/tstProj/scrapage.aspx", "c:\scrapage.html")
End Sub
Private Sub SavePage(ByVal Url As String, ByVal FilePath As String)
Dim iMessage As CDO.Message = New CDO.Message
iMessage.CreateMHTMLBody(Url, _
CDO.CdoMHTMLFlags.cdoSuppressNone, "", "")
Dim adodbstream As ADODB.Stream = New ADODB.Stream
adodbstream.Type = ADODB.StreamTypeEnum.adTypeText
adodbstream.Charset = "US-ASCII"
adodbstream.Open()
iMessage.DataSource.SaveToObject(adodbstream, "_Stream")
adodbstream.SaveToFile(FilePath, _
ADODB.SaveOptionsEnum.adSaveCreateOverWrite)
End Sub
End Class
For the above to compile you will need to add a reference to CDO, which is usually found sneaking deep in your C:\WINNT\System32 as C:\WINNT\System32\cdosys.dll
www.visli.com hot cake deals
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
SavePage("http://localhost/tstProj/scrapage.aspx", "c:\scrapage.html")
End Sub
Private Sub SavePage(ByVal Url As String, ByVal FilePath As String)
Dim iMessage As CDO.Message = New CDO.Message
iMessage.CreateMHTMLBody(Url, _
CDO.CdoMHTMLFlags.cdoSuppressNone, "", "")
Dim adodbstream As ADODB.Stream = New ADODB.Stream
adodbstream.Type = ADODB.StreamTypeEnum.adTypeText
adodbstream.Charset = "US-ASCII"
adodbstream.Open()
iMessage.DataSource.SaveToObject(adodbstream, "_Stream")
adodbstream.SaveToFile(FilePath, _
ADODB.SaveOptionsEnum.adSaveCreateOverWrite)
End Sub
End Class
For the above to compile you will need to add a reference to CDO, which is usually found sneaking deep in your C:\WINNT\System32 as C:\WINNT\System32\cdosys.dll
www.visli.com hot cake deals
Thursday, August 23, 2007
Flash Video buttons may be cut off or resized
Flash Video buttons may be cut off or resized: "Flash Video buttons may be cut off or resized"
www.svdeals.com super value deals
www.svdeals.com super value deals
SQL Server Helper - Date Functions - Get Days in a Month Function
SQL Server Helper - Date Functions - Get Days in a Month Function: "Get Number of Days in a Month Function"
http://www.svdeals.com/ super value deals
http://www.svdeals.com/ super value deals
Wednesday, August 22, 2007
use count & group by with union - SQL Server / MSSQL Forum
use count & group by with union - SQL Server / MSSQL Forum: "use count & group by with union "
http://www.svdeals.com/ super value deals
http://www.svdeals.com/ super value deals
Subscribe to:
Posts (Atom)
