4advanced

Take a look at these : [url]http://aspalliance.com/622[/url] [url]http://www.c-sharpcorner.com/UploadFile/vishnuprasad2005/SetupProjects12022005022406AM/SetupProjects.aspx?ArticleID=0488bf0b-7cf6-4e31-a9b5-38aa4ae8cd47[/url] [url]http://msdn.microsoft.com/en-us/library/wx3b589t(VS.80).aspx[/url]

Maybe cmd.CommandType needs to be stated as text.

you can use the sqlcommand.parameters.addwithvalue("@yourParameterName", yourValue) which should be efficiënt enough to update the values... for example: [code] string sql = "UPDATE aspnet_Membership SET Password = @NewPassword WHERE UserId=@UserId AND ApplicationId=@ApplicationId" oCom.CommandText=sql; oCom.Parameters.AddWithValue("@UserId", yourUserIdValue); oCom.Parameters.AddWithValue("@ApplicationId", "yourApplicationId"); object retVal = null; retVal = oCom.ExecuteScalar(); if(retVal != null & retVal > -1) …

List<MyClass> list = (List<MyClass>)ListView1.DataSource

Dear reader, I'm using an IHttpHandler to show content of a PDF saved in a SQL Server 2005 database. I can't figure out why it keeps showing me [B]"File does not begin with %PDF-"[/B] When I directly write out the bytes to the response it all works fine.... Let me …

use this funtion to find the control [CODE] Private Shared Function FindControlRecursive(ByVal Root As Control, ByVal Id As String) As Control If Root.ID = Id Then Return Root End If For Each Ctl As Control In Root.Controls Dim FoundCtl As Control = FindControlRecursive(Ctl, Id) If FoundCtl IsNot Nothing Then Return …

This example code explains maybe :=) [code] Dim _DT As DataTable = Nothing Private Sub Form2_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load _DT = New DataTable _DT.BeginLoadData() For i As Integer = 0 To 5 Dim _Col As DataColumn = New DataColumn("", System.Type.GetType("System.String")) _DT.Columns.Add(_Col) _Col.Dispose() _Col = …

If you don't want the blank row to be shown you have to set the 'enable adding' property in the designtime to be false.

Try this [code] Private Sub DataGridView1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles DataGridView1.KeyUp If Keys.Enter Then Dim _Dt As DataTable = Me.DataGridView1.DataSource If _Dt IsNot Nothing Then Dim _NewRow As System.Data.DataRow = _Dt.NewRow _Dt.Rows.Add(_NewRow) Me.DataGridView1.DataSource = _Dt _NewRow = Nothing _Dt.Dispose() _Dt = Nothing End If End If …

Ossehaas, Check the StreamingContext class for additional info.... I think it will help ya out.... According MSDN: [code] Imports System Imports System.Text Imports System.Runtime.Serialization.Formatters.Binary Imports System.Runtime.Serialization Imports System.IO Imports System.Security.Permissions Class Program Shared Sub Main(ByVal args() As String) Try SerializeAndDeserialize() Catch exc As System.Exception Console.WriteLine(exc.Message) Finally Console.WriteLine("Press <Enter> to exit....") …

*only for your attention* I guess you should also check the TextFieldParser object :=) [code] Using MyParser As Microsoft.VisualBasic.FileIO.TextFieldParser = My.Computer.FileSystem.OpenTextFieldParser(filename, delimiter) End Using [/code]

[code]Dim newRow as DataRow = yourDatagrid.newrow() newRow.Item(0) = "yourText" etc. etc. etc. yourDatagrid.rows.add(newRow) [/code]

There are a few options but one of the simplest is to detach the database from the server, copy the phisical files to the new dataserver's datapath and attach it to the new dataserver. For those actions you have to import [i]Microsoft.SqlServer.Management.Smo.SmoApplication[/i] and use the [i]EnumAvailableSqlServers()[/i] to find the available …

Can you tell us what happens before we have to puzzle? (think about getting your car back to the shop & ask the technician if he can tell you what's wrong with your car?)

Why not storing them in a [i]List(Of String)[/i]? [code] Dim listOfNames As New List(Of String) Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim newName As String = "" newName = InputBox("Enter the candidates name:", _ "candidatename", "", 500, 500) If Not String.IsNullOrEmpty(newName) Then listOfNames.Add(newName) …

I really don't understand a thing about your question! If you are asking for some help you really need to explain everything into details. We can't guess about what your goals are.....

An excellent resource for you is : [url]http://www.startvbdotnet.com/[/url]

[QUOTE=samir_ibrahim;793832]Thank you Ramy for your reply I know API are still supported, but my question was Is "ALL" API calls are included? I guess most of them. [/QUOTE] Does it matter if 'all' or 'most' are supported? What are you trying to point out with that.....? (the same on your …

First, try it in the same sub/function. If it works you can export the functionality to some global functions/subs try this: [code] Try strCon = "provider=SQLOLEDB;User id=" & U & ";Password=" & P & ";Server=" & S & ";database=" & D Con = New System.Data.OleDb.OleDbConnection(strCon) Con.Open() 'EXECUTE YOUR COMMAND HERE …

Have you ever checked the Date options? date.Day, date.Month, date.Year etc etc etc

Something like this? It will expand the last column in the datagridview. You can edit it to your needs :=) [code] Private Sub DataGridView1_DataBindingComplete(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewBindingCompleteEventArgs) Handles DataGridView1.DataBindingComplete Dim _DGV As DataGridView = DirectCast(sender, DataGridView) _DGV.Columns(_DGV.ColumnCount - 1).AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill End Sub [/code]

You must have 2 parameters declared in your Stored Procedure, called @DR and @CR, both of the type Decimal. While looping through your rows in your LoadCashBookDataSet.Tables(0) you have to execute the command based on the stored procedure & active connection. So, each time you have passed a row, you …

Databind() is a function which needs to be called when binding data to a datagrid in ASP.NET ! Only use datasource when binding in Windows.Forms solutions! [I]yourGrid.DataSource = yourDataSource[/I] If you had checked the posts on the first page you would have found out the solution....it has been mentioned a …

My.User.Name Environment.UserName.ToString() You can checkout the [I]My[/I] or [I]Environment[/I] objects to find more interesting things. The My.Computer.Clock object provides properties to find the current local time for the computer and the UTC time. It also exposes the millisecond count from the computer's system timer.

[QUOTE=sierrasoft;794599]How to change screen resolution programmatically in vb.net 2.0 ?[/QUOTE] Check this : [url]http://dotnet.mvps.org/dotnet/faqs/?id=setscreenresolution&lang=en[/url]

Check the MSDN website....there are too much changes.....

The default size of the threadpool is 25 ;) Regards, Richard The Netherlands

Create a templatefield, insert the checkbox and afterwards, check with FindControl() wether the checkbox has been checked. The mastercheckbox needs to be inserted in the headerrow of the control. Also there can be checked with FindControl(). If it's checked, reload the page. Be aware that the controls need to have …

Google will be your friend ;)

What's the error it's givving you? Did you try the stored procedure in your sqlserver? regards