15,917,176 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by dp24 (Top 27 by date)
dp24
21-Jun-13 9:46am
View
ill try to make myself more clear, the query starts with this string "SELECT * FROM " & Me.DropDownList1.SelectedValue & " WHERE " &
the idea is to check if the check check box is checked and if it is add to the string.
but there are problems by doing that, because of the conditions. if the uses the condition for exemple " >5" and then a condtion " = 10" i need to add a AND to the string
dp24
21-Jun-13 9:23am
View
HI mate, that code its just a example of what i tried. I dont have to follow that code, i would prefer start a new code to.
Sorry for bad english
dp24
21-Jun-13 9:15am
View
Problem: i need to make a selection of the conditions that the user wants, to get a query so i can then make a database search
dp24
21-Jun-13 9:15am
View
Problem: i need to make a selection of the conditions that the user wants, to get a query so i can then make a database search
dp24
21-Jun-13 9:08am
View
when i press the button export, i want create a query with the condition that are checked in the checkboxes
dp24
21-Jun-13 9:07am
View
Deleted
when i press the button export, i want create a query with the condition that are checked in the checkboxes
dp24
21-Jun-13 9:07am
View
when i press the button export, i want create a query with the condition that are checked in the checkboxes
dp24
19-Jun-13 6:28am
View
guys, forget the sql! its not important
dp24
19-Jun-13 6:00am
View
and we can speake portuguese if you want, i am portguese and i could explain better what i want in portuguese
dp24
19-Jun-13 5:59am
View
hi, mate forget the string its not my main problem, i said sql but thats just a example i want the lablel to save values and the other things i menssioned.
dp24
7-Jun-13 9:53am
View
thanks alot! it worked :)
dp24
7-Jun-13 4:13am
View
Thanks for using your time to help me, im kinda noob at asp.net. and it says i need do declare the variable but i dont know what type i should declare
Protected Function GetData1() As DataTable
Dim dt As DataTable = FormatDataTable()
Dim dr As DataRow
Dim gridsession as . . .
dt = Session(gridsession)
' Populate the datatable with your data (put this in appropriate loop)
dr = dt.NewRow()
dr("id") = TextBox1.Text
dr("text") = TextBox2.Text
' Add the row
dt.Rows.Add(dr)
dt.AcceptChanges()
Return dt
Session(gridsession) = dt
End Function
could you help me?
Btw, thanks for all!
dp24
3-Jun-13 10:25am
View
thanks a lot mate!
dp24
3-Jun-13 9:05am
View
hello?
dp24
3-Jun-13 7:34am
View
i did it, it was the wrong paste
Protected Sub GridPrevistos_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs) Handles GridPrevistos.PageIndexChanging
GridPrevistos.PageIndex = e.NewPageIndex
GridPrevistos.DataBind()
End Sub
still disappears
dp24
3-Jun-13 6:56am
View
Protected Sub GridPrevistos_SelectedIndexChanged(ByVal sender As Object, ByVal e As GridViewPageEventArgs) Handles GridPrevistos.SelectedIndexChanged, GridPrevistos.PageIndexChanging
GridPrevistos.PageIndex = e.NewPageIndex
GridPrevistos.DataBind()
End Sub
i still press page 2 or 3 and the gridview dissapears
dp24
3-Jun-13 6:47am
View
and again im sorry for being dumb, but what do i put in the event?
Protected Sub GridPrevistos_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)
End Sub
dp24
3-Jun-13 6:39am
View
i dont have a pageIndexChanged Event
dp24
3-Jun-13 6:29am
View
Protected Sub Mes_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles Mes.SelectedIndexChanged
Me.anomes.Text = Me.Ano.SelectedValue & Me.Mes.SelectedValue
abre_ligacao()
MsgBox(Me.numempresa.Text)
Dim sqlprevistos As String = "SELECT top 100 num as Número,nome as Nome, ntrab as N_Trab,empresa as Empresa,cobranca as Cobrança,ROUND(remfixa*0.01,2) as Quota FROM Socios WHERE empresa='" & Me.numempresa.Text & "' ORDER BY num"
'Dim sqlprevistos As String = "SELECT * FROM cobranca"
Dim dsprevistos As DataSet = GetData(sqlprevistos)
If (dsprevistos.Tables.Count > 0) Then
GridPrevistos.DataSource = dsprevistos
GridPrevistos.DataBind()
Else
MsgBox("Não há dados para carregar!")
End If
fecha_ligacao()
End Sub
dp24
3-Jun-13 6:20am
View
yes it is, pls check
http://i.imagebanana.com/img/amdt43hh/Capturar.PNG
dp24
3-Jun-13 6:07am
View
im sorry, im kinda newbie its asp! i dont get the error now, but the gridview dissapers when i press in page 2 or 3... can you help me?
dp24
31-May-13 6:40am
View
check the solution 2 pls
dp24
31-May-13 6:34am
View
sorry for the delay, so i have my select buton working but i want to get the id of my field "cobranca" in vb code ill add a screenshot and the code where i wanna put in the solution bellow
dp24
31-May-13 5:44am
View
hey tadit, i dont want to be rude or something but i still having some issues with gridview that i seem im not understading. can i add you on skype or something so you can see my screen and see if you can understand my issue?
dp24
30-May-13 9:43am
View
ty
dp24
30-May-13 6:43am
View
and what about the second part of your code? i dont understand it, and i think its c# right?
dp24
30-May-13 6:17am
View
sorry for my questions and ty for your help it means a lot, but what is this xmlns:asp="#unknown"? and what do i put in the unknow?
and btw the second part of your code i think it is c# and im using vb.net as i refer in my example.
and i want to the delete button to erase the row where is at
Show More