SQL Server 2005 Driver for PHP CTP (Community Technology Preview – February 2008) is avaialble for download.
Click here to download.
You can visit the SQL Server 2005 Driver for PHP Team Blog at http://blogs.msdn.com/sqlphp/
VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Here is the way you can connect to your Microsoft SQL Server 2005 from your java application via JDBC.
First you need to download the Microsoft SQL Server 2005 JDBC Driver.
You will get sqljdbc.jar which is all you needed. As a java programmer, you know how to use this, right?
You will get a user manual along with this download. Follow the instructions. Or here is a sample code for your quick reference:
1
2
3
4
5
6
7
8
9
10
| Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:sqlserver://servernameSQLEXPRESSinstance;database=yourdatabase;user=your username");
Statement stmt = conn.createStatement();
String qry = "SELECT * FROM yourtable";
ResultSet rs = stmt.executeQuery(qry);
while (rs.next()) {
// code;
} |
VN:F [1.9.18_1163]
Rating: 4.7/5 (6 votes cast)
I just got an interesting article on “Ten Qualities of an Effective Team Player”.
URL: http://www.allbusiness.com/human-resources/employee-development-team-building/8516-1.html
VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Button1.Attributes.Add("onclick", ClientScript.GetPostBackEventReference(Button1,"") + ";
this.value='Please wait...';this.disabled = true;");
If you check the source after rendering, it will look like this:
onclick="__doPostBack('Button1','');this.value='Please wait...';this.disabled = true;"
VN:F [1.9.18_1163]
Rating: 4.0/5 (2 votes cast)
First refer COM objects – Microsoft Office xx.xx Object Libraryand Microsoft Word xx.xx Object Library
Here is the C# code for reading a word document:
Microsoft.Office.Interop.Word.Application oWord = new Microsoft.Office.Interop.Word.Application();
object ofilename = @"C:testdoc.doc";
object o = System.Reflection.Missing.Value;
object oreadonly = true;
object ovisible = false;
Microsoft.Office.Interop.Word.Document oDoc = oWord.Documents.Open(ref ofilename, ref o, ref oreadonly
, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref o, ref ovisible, ref o, ref o, ref o, ref o);
textBox1.Text = oDoc.Content.Text; // contents available here
//Do not forget to quit other wize it will keep running in background
oDoc.Close(ref o, ref o, ref o);
oWord.Quit(ref o, ref o, ref o);
VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
WPF or Windows Presentation Foundation… formerly known as Avalon.
VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Knowledge Sharing continues…
VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Recent Comments