Thursday, July 22, 2010
Tuesday, June 15, 2010
Compiling SharePoint in cmd Prompt,,,
http://msdn.microsoft.com/en-us/library/aa973805(office.12).aspx
Compiling SharePoint in cmd Prompt,,,
http://www.c-sharpcorner.com/UploadFile/kirtan007/400/Default.aspx
Tuesday, June 8, 2010
SharePoint Videos Online...
http://office.microsoft.com/en-us/sharepoint-designer-help/demos-a-six-part-series-on-getting-the-most-out-of-sharepoint-designer-2007-HA010219984.aspx
Monday, May 17, 2010
Wednesday, May 12, 2010
Tuesday, May 11, 2010
Monday, May 10, 2010
TXTBOX...Enter Data Saving in the Mysql Table thru VB.Net Code
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim xx As String() = txtEmpdob.Text.Split("/")
Dim yy As String = (((xx(2).ToString & "-") + (xx(1).ToString & "-") + (xx(0).ToString)))
Dim cc As String() = txtEmpdoj.Text.Split("/")
Dim dd As String = (((cc(2).ToString & "-") + (cc(1).ToString & "-") + (cc(0).ToString)))
Dim strSql As String = ""
strSql = "insert into tab_employee (empcode,empname,empdob,empdoj,emplmntype,empdept,empnationality,empnricno,mthrtngue,mobileno,gender,maritalsts,religion,qualifications,certifications,specializations,yrsofexprnce,prvscomp,designation,lstdrawnsalary,noofmnthswrkd,awards,activities,hobbies,refname1,refcontact1,refname2,refcontact2,prsntaddress,permanentaddress) values('" & txtEmpCode.Text & "','" & txtEmpName.Text & "','" & yy & "','" & dd & "','" & ddlEmpType.SelectedValue & "','" & ddlEmpldept.SelectedValue & "','" & txtempnasnlty.Text & "','" & txtEmpnric.Text & "','" & txtEmpmthrtng.Text & "','" & txtEmpmobile.Text & "','" & ddlEmpGender.SelectedValue & "','" & ddlmaritalsts.SelectedValue & "','" & ddlreligion.SelectedValue & "','" & ddlqualifications.SelectedValue & "','" & txtEmpcertifi.Text & "','" & txtEmpSpeclzsn.Text & "','" & txtEmpyrsfexp.Text & "','" & txtEmpprvcomp.Text & "','" & txtEmpDesigntsn.Text & "','" & txtEmplstdrwnsal.Text & "','" & txtEmpmnthswrkd.Text & "','" & txtEmpAwards.Text & "','" & txtEmpActivities.Text & "','" & txtEmphobbies.Text & "','" & txtrefname1.Text & "','" & txtrefcontact1.Text & "','" & txtrefname2.Text & "','" & txtrefcontact2.Text & "','" & txtpresentadd.Text & "','" & txtpermanent.Text & "')"
sqlDB.savedata(strSql)
End Sub
Dim xx As String() = txtEmpdob.Text.Split("/")
Dim yy As String = (((xx(2).ToString & "-") + (xx(1).ToString & "-") + (xx(0).ToString)))
Dim cc As String() = txtEmpdoj.Text.Split("/")
Dim dd As String = (((cc(2).ToString & "-") + (cc(1).ToString & "-") + (cc(0).ToString)))
Dim strSql As String = ""
strSql = "insert into tab_employee (empcode,empname,empdob,empdoj,emplmntype,empdept,empnationality,empnricno,mthrtngue,mobileno,gender,maritalsts,religion,qualifications,certifications,specializations,yrsofexprnce,prvscomp,designation,lstdrawnsalary,noofmnthswrkd,awards,activities,hobbies,refname1,refcontact1,refname2,refcontact2,prsntaddress,permanentaddress) values('" & txtEmpCode.Text & "','" & txtEmpName.Text & "','" & yy & "','" & dd & "','" & ddlEmpType.SelectedValue & "','" & ddlEmpldept.SelectedValue & "','" & txtempnasnlty.Text & "','" & txtEmpnric.Text & "','" & txtEmpmthrtng.Text & "','" & txtEmpmobile.Text & "','" & ddlEmpGender.SelectedValue & "','" & ddlmaritalsts.SelectedValue & "','" & ddlreligion.SelectedValue & "','" & ddlqualifications.SelectedValue & "','" & txtEmpcertifi.Text & "','" & txtEmpSpeclzsn.Text & "','" & txtEmpyrsfexp.Text & "','" & txtEmpprvcomp.Text & "','" & txtEmpDesigntsn.Text & "','" & txtEmplstdrwnsal.Text & "','" & txtEmpmnthswrkd.Text & "','" & txtEmpAwards.Text & "','" & txtEmpActivities.Text & "','" & txtEmphobbies.Text & "','" & txtrefname1.Text & "','" & txtrefcontact1.Text & "','" & txtrefname2.Text & "','" & txtrefcontact2.Text & "','" & txtpresentadd.Text & "','" & txtpermanent.Text & "')"
sqlDB.savedata(strSql)
End Sub
Image Upload Example With Code in VB
Protected Sub btnupload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnupload.Click
If Path.GetExtension(fileupld.PostedFile.FileName).ToString.ToLower = ".jpg" Then
Dim filename As String
filename = DateTime.Now.ToString("ddMMyyyyhhmmss") & Path.GetFileName(fileupld.PostedFile.FileName)
hdnfield.Value = filename
fileupld.PostedFile.SaveAs(Server.MapPath("photo") & "/" & filename)
WebMsgBox.Show("Photo Uploaded Successfully")
EmpImage1.ImageUrl = "~/Photo/" & filename
Else
WebMsgBox.Show(" incorrect File")
End If
End Sub
VB MysqlDb Connection "Class" File.....
Imports Microsoft.VisualBasic
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
Imports System
Imports System.Data.Odbc
Public Class mysqldb
Dim con As New MySqlConnection
Private str As String
Dim constate As Boolean = False
Private ds As New DataSet
Private da As New MySqlDataAdapter
Private dt As DataTable
Private strStatus As String
Private Cmd As New MySqlCommand
Public Sub New()
Try
con.ConnectionString = (ConfigurationManager.AppSettings("conobj"))
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Catch ex As System.Exception
Throw New System.Exception("Error Occured in Opening DataBase, Contact Administrator!")
constate = False
End Try
End Sub
Public Function gettable(ByVal str As String, ByVal dt As DataTable) As DataTable
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
da = New MySqlDataAdapter(str, con)
ds = New DataSet()
da.Fill(ds)
dt = ds.Tables(0)
Catch ex As System.Exception
End Try
con.Close()
Return dt
End Function
Public Sub filldll(ByVal str As String, ByVal ddl As DropDownList)
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Dim ds1 As New DataSet
Dim da1 As New MySqlDataAdapter(str, con)
da1.Fill(ds1)
ddl.DataSource = ds1
ddl.DataTextField = "txt"
ddl.DataValueField = "val"
ddl.DataBind()
Catch ex As Exception
End Try
con.Close()
ddl.Items.Insert(0, "Select")
End Sub
Public Sub filllist(ByVal str As String, ByVal list As ListBox)
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Dim ds1 As New DataSet
Dim da1 As New MySqlDataAdapter(str, con)
da1.Fill(ds1)
list.DataSource = ds1
list.DataTextField = "txt"
list.DataValueField = "val"
list.DataBind()
Catch ex As Exception
End Try
con.Close()
'list.Items.Insert(0, "---Select---")
End Sub
Public Sub savedata(ByVal str As String)
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Dim cmd As New MySqlCommand(str, con)
cmd.ExecuteNonQuery()
Catch ex As Exception
End Try
con.Close()
End Sub
Public Function returnDataset(ByVal str As String) As DataSet
Try
''con.ConnectionString = (ConfigurationManager.AppSettings("conobj"))
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
da = New MySqlDataAdapter(str, con)
ds = New DataSet()
da.Fill(ds)
Return ds
Catch ex As Exception
Return Nothing
Finally
ds.Dispose()
con.Close()
da.Dispose()
End Try
End Function
Public Function returnExecuteNonQuery(ByVal str As String) As String
Try
''con.ConnectionString = (ConfigurationManager.AppSettings("conobj"))
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Cmd = New MySqlCommand(str, con)
strStatus = Cmd.ExecuteNonQuery()
Return strStatus
Catch ex As Exception
Return ex.Message.ToString()
Finally
con.Close()
Cmd.Dispose()
End Try
End Function
End Class
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
Imports System
Imports System.Data.Odbc
Public Class mysqldb
Dim con As New MySqlConnection
Private str As String
Dim constate As Boolean = False
Private ds As New DataSet
Private da As New MySqlDataAdapter
Private dt As DataTable
Private strStatus As String
Private Cmd As New MySqlCommand
Public Sub New()
Try
con.ConnectionString = (ConfigurationManager.AppSettings("conobj"))
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Catch ex As System.Exception
Throw New System.Exception("Error Occured in Opening DataBase, Contact Administrator!")
constate = False
End Try
End Sub
Public Function gettable(ByVal str As String, ByVal dt As DataTable) As DataTable
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
da = New MySqlDataAdapter(str, con)
ds = New DataSet()
da.Fill(ds)
dt = ds.Tables(0)
Catch ex As System.Exception
End Try
con.Close()
Return dt
End Function
Public Sub filldll(ByVal str As String, ByVal ddl As DropDownList)
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Dim ds1 As New DataSet
Dim da1 As New MySqlDataAdapter(str, con)
da1.Fill(ds1)
ddl.DataSource = ds1
ddl.DataTextField = "txt"
ddl.DataValueField = "val"
ddl.DataBind()
Catch ex As Exception
End Try
con.Close()
ddl.Items.Insert(0, "Select")
End Sub
Public Sub filllist(ByVal str As String, ByVal list As ListBox)
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Dim ds1 As New DataSet
Dim da1 As New MySqlDataAdapter(str, con)
da1.Fill(ds1)
list.DataSource = ds1
list.DataTextField = "txt"
list.DataValueField = "val"
list.DataBind()
Catch ex As Exception
End Try
con.Close()
'list.Items.Insert(0, "---Select---")
End Sub
Public Sub savedata(ByVal str As String)
Try
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Dim cmd As New MySqlCommand(str, con)
cmd.ExecuteNonQuery()
Catch ex As Exception
End Try
con.Close()
End Sub
Public Function returnDataset(ByVal str As String) As DataSet
Try
''con.ConnectionString = (ConfigurationManager.AppSettings("conobj"))
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
da = New MySqlDataAdapter(str, con)
ds = New DataSet()
da.Fill(ds)
Return ds
Catch ex As Exception
Return Nothing
Finally
ds.Dispose()
con.Close()
da.Dispose()
End Try
End Function
Public Function returnExecuteNonQuery(ByVal str As String) As String
Try
''con.ConnectionString = (ConfigurationManager.AppSettings("conobj"))
If con.State <> ConnectionState.Open Then
con.Open()
constate = True
End If
Cmd = New MySqlCommand(str, con)
strStatus = Cmd.ExecuteNonQuery()
Return strStatus
Catch ex As Exception
Return ex.Message.ToString()
Finally
con.Close()
Cmd.Dispose()
End Try
End Function
End Class
Tuesday, April 27, 2010
Saturday, April 24, 2010
Friday, April 23, 2010
Monday, April 19, 2010
Saturday, April 17, 2010
Monday, April 12, 2010
Monday, March 29, 2010
How to Uninstall IE 8 or 7 in Win 7, Vista and WinServer n XP...
Steps for Windows 7
To uninstall Internet Explorer 8, follow these steps:
Click StartCollapse this imageExpand this image, and then right-click Command Prompt, and choose Run as administrator.
Steps for Windows XP or for Windows Server 2003
When the uninstall program is finished, restart your computer.
To uninstall Internet Explorer 8, follow these steps:
- Close all programs.
- Click StartCollapse this imageExpand this image, and then click Control Panel.
- Under Programs, click Uninstall a program.
- In the tasks pane, click Turn Windows features on or off.
- In the list of windows features, clear the check box next to Internet Explorer 8.
- You receive a warning message in a pop-up window. Click Yes.
- Internet Explorer 8 will now be uninstalled. The system will restart after the installation.
Click StartCollapse this imageExpand this image, and then right-click Command Prompt, and choose Run as administrator.
- Note If you are prompted for an administrator password or for confirmation, type the password, or click Continue.
- At the command prompt, type the following: dism /online /Disable-Feature /FeatureName:Internet-Explorer-Optional-amd64.
- When prompted to restart the computer, choose Yes.
- To uninstall Internet Explorer 8, follow these steps:
- Close all programs.
- Click Start, and then click Control Panel.
- Click Uninstall a Program under the Programs category
- In the Tasks pane, click View installed updates.
- In the list of installed updates, double-click Windows Internet Explorer 8.
- Note If Windows Internet Explorer 8 does not appear in the list of installed updates, try the alternative steps for Windows Vista or for Windows Server 2008.
- In the Uninstall an update dialog box, click Yes.
- Note If you are prompted for an administrator password or for confirmation, type the password, or click Continue.
- Follow the instructions to uninstall Internet Explorer 8.
- When the uninstall program is finished, restart your computer.
- After you have finished, go to the "Did the "Let me fix it myself" steps fix the problem?" section to verify that your earlier version of Internet Explorer is restored.
Steps for Windows XP or for Windows Server 2003
- To uninstall Internet Explorer 8, follow these steps:
- Close all programs.
- Click Start, and then click Control Panel.
- Click Add or Remove Programs.
- In the list of currently installed programs, click Windows Internet Explorer 8, and then click Remove.
- Note If Windows Internet Explorer 8 does not appear in the list of installed updates, try the alternative steps for Windows XP or for Windows Server 2003.
When the uninstall program is finished, restart your computer.
Wednesday, March 24, 2010
Wednesday, March 17, 2010
What's a Database?
What's a Database? A SQL database is nothing more than an empty shell, like a vacant warehouse. It offers no real functionality whatsoever, but does provide a virtual space to store data. Data is stored inside of database objects called tables, and tables are the containers that actually hold specific types of data, such as numbers, files, strings, and dates.
A single database can house hundreds of tables containing more than 1,000 table columns each and they may be jam packed with relational data ready to be retrieved by SQL. Perhaps the greatest feature SQL offers is that it doesn't take much effort to rearrange your warehouse to meet your ever-growing business needs.
A single database can house hundreds of tables containing more than 1,000 table columns each and they may be jam packed with relational data ready to be retrieved by SQL. Perhaps the greatest feature SQL offers is that it doesn't take much effort to rearrange your warehouse to meet your ever-growing business needs.
How to Set or Create a Password for XL or Word Files...
Open new Excel Sheet---Enter Your Data---Click "Save as"---Find the Tools option---Select "General options"---Type your password---Re-enter the same Password---Click Save Button....
ScreenShots:-
ScreenShots:-
Monday, March 15, 2010
Tuesday, March 9, 2010
How To Manually Clean Out The "Temp Folder" In Windows...
1.Click on Start, type the following command in the search box, and then hit the Enter key.
%temp%
2.To remove individual folders or files, hold down your Ctrl key while left-clicking on each item you want delete. Release the Ctrl key when you're finished.
3.To delete these items, hit your Delete key or click the Organize button on the toolbar menu, followed by the Delete option.
4.If you'd instead like to remove everything inside the Temp folder, click on the Organize button and then choose Select All from the menu.
5.Again, to delete these items, hit your Delete key or click the Organize button on the toolbar menu, followed by the Delete option.
6.After all of the files have been deleted you can close the folder window and empty your Recycle Bin, permanently removing the files from your PC.
Tips:
1.You may receive a Error Deleting File or Folder message while the files are being deleted. This just means that one of the files is in use by a program right now. Click OK, close all open programs, and repeat the steps above. If you still receive the message, try restarting your PC and repeating the process again.
%temp%
2.To remove individual folders or files, hold down your Ctrl key while left-clicking on each item you want delete. Release the Ctrl key when you're finished.
3.To delete these items, hit your Delete key or click the Organize button on the toolbar menu, followed by the Delete option.
4.If you'd instead like to remove everything inside the Temp folder, click on the Organize button and then choose Select All from the menu.
5.Again, to delete these items, hit your Delete key or click the Organize button on the toolbar menu, followed by the Delete option.
6.After all of the files have been deleted you can close the folder window and empty your Recycle Bin, permanently removing the files from your PC.
Tips:
1.You may receive a Error Deleting File or Folder message while the files are being deleted. This just means that one of the files is in use by a program right now. Click OK, close all open programs, and repeat the steps above. If you still receive the message, try restarting your PC and repeating the process again.
Monday, March 8, 2010
How to Uninstall SQLSERVER 2005 Manually...
1. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap
2. Run ARP Wrapper (follow the instructions by dialog)
3. Delete each service step by step
4. While removing reporting services got error
Follow these steps
1.Stop Iis admin service
2.Stop world web publishing service
3.Run the ARP Wrapper
4.Uninstall reporting service
Afte that
Start both services (IIS ,World web web publishing)
One minute open inetmgr and
After you have uninstalled Reporting Services, you must manually delete the following in Internet Information Services (IIS) Manager.
• The ReportServer[$InstanceName] Reporting Services virtual directory
• The Reports[$InstanceName]Reporting Services virtual directory
• The ReportServer[$InstanceName] ReportServer application pool
(iis shows these then delete otherwise continue your installing sqlserver)
2. Run ARP Wrapper (follow the instructions by dialog)
3. Delete each service step by step
4. While removing reporting services got error
Follow these steps
1.Stop Iis admin service
2.Stop world web publishing service
3.Run the ARP Wrapper
4.Uninstall reporting service
Afte that
Start both services (IIS ,World web web publishing)
One minute open inetmgr and
After you have uninstalled Reporting Services, you must manually delete the following in Internet Information Services (IIS) Manager.
• The ReportServer[$InstanceName] Reporting Services virtual directory
• The Reports[$InstanceName]Reporting Services virtual directory
• The ReportServer[$InstanceName] ReportServer application pool
(iis shows these then delete otherwise continue your installing sqlserver)
Thursday, March 4, 2010
ftp://192.0.0.78/
Double click on the "My Computer" thn type in the address bar as ftp://192.0.0.78/ then type the password and access the FTP Server
Monday, March 1, 2010
Validation Server Control Description...
Validation in ASP.NET 2.0
Validation server controls are set of controls that enable you to work with the information your end users inputs into application. Application should always ensure that valid data is recorded. To ensure valid data is collected, we apply set of validations to data we collect. Validation is a set of rules that you apply to the data you collect. In this way, we can bring certain degree of discipline in end user.
We can understand validation under two categories: Client side validation and Server side validation. Client side validation involves validating user input before the page is posted to server. Server side validation involves performing checks on server instead of client. This is most secure form but comes at cost of performance.
ASP.NET introduced smart validation server controls to implement page level validations. They are capable of performing both server side and client side validations. So, Validation server controls offer the combined power of both approaches such that the security of application is never compromised.
ASP.NET 2.0 Validation server controls
Presently, ASP.NET 2.0 offers six validation controls. It also added new features like Validation groups and new JavaScript capabilities.
◦RequiredFieldValidator
◦CompareValidator
◦RangeValidator
◦RegularExpressionValidator
◦CustomValidator
◦ValidationSummary
Validation server controls are set of controls that enable you to work with the information your end users inputs into application. Application should always ensure that valid data is recorded. To ensure valid data is collected, we apply set of validations to data we collect. Validation is a set of rules that you apply to the data you collect. In this way, we can bring certain degree of discipline in end user.
We can understand validation under two categories: Client side validation and Server side validation. Client side validation involves validating user input before the page is posted to server. Server side validation involves performing checks on server instead of client. This is most secure form but comes at cost of performance.
ASP.NET introduced smart validation server controls to implement page level validations. They are capable of performing both server side and client side validations. So, Validation server controls offer the combined power of both approaches such that the security of application is never compromised.
ASP.NET 2.0 Validation server controls
Presently, ASP.NET 2.0 offers six validation controls. It also added new features like Validation groups and new JavaScript capabilities.
◦RequiredFieldValidator
◦CompareValidator
◦RangeValidator
◦RegularExpressionValidator
◦CustomValidator
◦ValidationSummary
Create Shortcuts for Shutdown/Restart/Lock/Hibernate/Sleep...
Shutdown Computer ==""Shutdown.exe -s -t 00""...
Restart Computer==""Shutdown.exe -r -t 00""...
Lock Workstation==""Rundll32.exe User32.dll,LockWorkStation""...
Hibernate Computer==""rundll32.exe PowrProf.dll,SetSuspendState""...
Sleep Computer==""rundll32.exe powrprof.dll,SetSuspendState 0,1,0""...
ScreenShots For Ex:-Rightclick on Desktop-->New--->Shortcut
Restart Computer==""Shutdown.exe -r -t 00""...
Lock Workstation==""Rundll32.exe User32.dll,LockWorkStation""...
Hibernate Computer==""rundll32.exe PowrProf.dll,SetSuspendState""...
Sleep Computer==""rundll32.exe powrprof.dll,SetSuspendState 0,1,0""...
ScreenShots For Ex:-Rightclick on Desktop-->New--->Shortcut
"Alt+Prnt Scrn" Key for Selected/Particular Window...
ormal Print Screen (To Get This Just Press "PrintScreen" Key in KeyBoard
To Get Particular/Selected Window "PrintScreen" Press "Alt+PrintScrn" Command 
Then Go To Accessories--->Open Paint---> Paste the Screenshot and Save as .Jpeg or.Png or. Jpg Formats
Sunday, February 28, 2010
Validation Server Control Description...
CompareValidator
Compares the value of one input control to the value of another input control or to a fixed value
CustomValidator
Allows you to write a method to handle the validation of the value entered
RangeValidator
Checks that the user enters a value that falls between two values
RegularExpressionValidator
Ensures that the value of an input control matches a specified pattern
RequiredFieldValidator
Makes an input control a required field
ValidationSummary
Displays a report of all validation errors occurred in a Web page
Compares the value of one input control to the value of another input control or to a fixed value
CustomValidator
Allows you to write a method to handle the validation of the value entered
RangeValidator
Checks that the user enters a value that falls between two values
RegularExpressionValidator
Ensures that the value of an input control matches a specified pattern
RequiredFieldValidator
Makes an input control a required field
ValidationSummary
Displays a report of all validation errors occurred in a Web page
"devenv" n "inetmgr" Commands...
Start-->Run--->cmd---->devenv--(Shortcut to open "VisualStudio")
Start-->Run--->cmd---->inetmgr--(Shortcut to open "IIS")
Start-->Run--->cmd---->inetmgr--(Shortcut to open "IIS")
"msconfig" Command...
start--->Run--->cmd--->"msconfig" -This Command is used to Stop/Start Applications
Thursday, February 25, 2010
Clearing Visual Studio "Start Page Recent Projects" :
Go to "REGEDIT" Then
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\ProjectMRUList
Clear the unnessasary project from this List.
Inline Coding & Code Behind Pages
"HTML" PAGE = Inline Coding Page
".CS or .VB" = Code Behind Page
".aspx" = ASP Pages
".CS or .VB" = Code Behind Page
".aspx" = ASP Pages
Subscribe to:
Posts (Atom)