Does someone have some souce code to an asp.net web site.

I would really appreciate anyone's help.

:rolleyes: I have the following with an ado.net routine called.

Public Sub DoModify()
Dim bm As BindingManagerBase = Me.DataGrid1.BindingContext(Me.DataGrid1.DataSource,...

Dim substr As String = dr.Item(4)

if substr is {System.DBNull}
substr = ""


if substr is "" then
do not do substr = substr.Substring(0, 2)
else
substr = substr.Substring(0, 2)

I have an sql table that consist of three key constraints
Policy_Nbr, Trans_CodeOrig, Trans_Eff_Date. Now I need to create a stored procedure that will handle
violations on the table. What I mean...

I have the following procedure

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/* ------------------------------------------------------------
PROCEDURE: ...

I need to remove the prefix(domain name) if exist in front of a username from a session variable.


paramsql.Value = Session("ssNtUser")

say the domain is za

username is macupryk

I would...

click on modify button?
Public Sub DoModify()
Dim bm As BindingManagerBase = Me.DataGrid1.BindingContext(Me.DataGrid1.DataSource, Me.DataGrid1.DataMember)
===>>> Dim dr As DataRow...

If you want to insert DON'T do this

Dim dr As DataRow = CType(bm.Current, DataRowView).Row
Dim addform As New AddTransOverride(dr)
Dim retval As DialogResult =...

How do I pass a two character for dr.Item(4) in the following:
ExecOnTransOverride.ins(dr.Item(1), dr.Item(2), dr.Item(3), dr.Item(4), dr.Item(5), dr.Item(6), dr.Item(8), dr.Item(7), DateTime.Now,...

I have the following structure defined in a given form called transoverride.vb


Public Structure structTransoverride
Public Account_Name As String
End Structure

at the top of my...

When I am in Debug mode, I want to set the value of the textbox on the dialog form.
What happens the dialog form appears before , even when I am starting debug bug mode.
The values of the textbox...

I have the error coming when I call a dialog form passing a parameter.

An unhandled exception of type 'System.Exception' occurred in microsoft.visualbasic.dll

Additional information: Can't...

I have a stored procedure and it is not saving the values in the table. How can I view that the stored procedure is saving the values.

Private Sub DoSave()
Dim ConnectionString As String...

I have the following two functions. My goal is to highlight a row in a
datagrid and delete a row. Problem arises when I click on the delete button.
Below are two sub routines for DoDelete. Which...