Ver Mensaje Individual
  #1 (permalink)  
Antiguo 08/11/2004, 09:17
carlostapia
 
Fecha de Ingreso: septiembre-2004
Mensajes: 141
Antigüedad: 20 años, 6 meses
Puntos: 0
ayud ano entiendo este error

hola miren me da este error

BC30451: Name 'fechai' is not declared

no entiendo como lo declaro , me ayudan porfa voy a poner el codigo que va en mi aspx

Sub Getinforme(Sender As Object, E As EventArgs)



fechai= dia_i.selectedItem.text & "/" & mes_i.selectedItem.text & "/" & ano_i.selectedItem.text

fechaf= dia_f.selectedItem.text & "/" & mes_f.selectedItem.text & "/" & ano_f.selectedItem.text


Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter

MyConnection = New SqlConnection("server=(local);database=callcenter_ net;User ID=sa;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("sp1", MyConnection)

MyCommand.SelectCommand.CommandType = CommandType.StoredProcedure

MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@Beginning_Date", SqlDbType.DateTime))
'MyCommand.SelectCommand.Parameters("@Beginning_Da te").Value = BeginDate.SelectedDate
MyCommand.SelectCommand.Parameters("@fechai").Valu e = BeginDate.SelectedDate

MyCommand.SelectCommand.Parameters.Add(New SqlParameter("@Ending_Date", SqlDbType.DateTime))
'MyCommand.SelectCommand.Parameters("@Ending_Date" ).Value = EndDate.SelectedDate
MyCommand.SelectCommand.Parameters("@fechaf").Valu e = endDate.SelectedDate

DS = new DataSet()
MyCommand.Fill(DS, "Sales")

MyDataGrid.DataSource=DS.Tables("Sales").DefaultVi ew
MyDataGrid.DataBind()
End Sub