Click here to Skip to main content
15,914,642 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Disable the File Save As Button Pin
Brady Kelly5-Jun-07 23:33
Brady Kelly5-Jun-07 23:33 
AnswerRe: Disable the File Save As Button Pin
badgrs5-Jun-07 22:37
badgrs5-Jun-07 22:37 
GeneralRe: Disable the File Save As Button Pin
.NET- India 5-Jun-07 23:39
.NET- India 5-Jun-07 23:39 
GeneralRe: Disable the File Save As Button Pin
badgrs6-Jun-07 0:28
badgrs6-Jun-07 0:28 
AnswerRe: Disable the File Save As Button Pin
RichardGrimmer6-Jun-07 5:21
RichardGrimmer6-Jun-07 5:21 
QuestionBulk Insertion Pin
24891285-Jun-07 20:25
24891285-Jun-07 20:25 
QuestionTo update the database after another user changes the data Pin
mukkanti0075-Jun-07 20:12
mukkanti0075-Jun-07 20:12 
QuestionSeaching in vs 2.0 Pin
n_gchaitra5-Jun-07 19:51
n_gchaitra5-Jun-07 19:51 
I want to seach the data based on the value entered in the text boxes and dropdown list.
I have written the folling code. but getting error "Incorrect syntax near the keyword 'and' while running. What can i do for this?


Sub bindresult(ByVal sqlstr As String)
Dim ds As New DataSet()
Dim comm As New SqlDataAdapter(sqlstr, dbconn)
dgresult.DataSource = ds
comm.Fill(ds)
dgresult.DataBind()
navi.Visible = True
lblnopg.Text = dgresult.PageCount
End Sub

Protected Sub Btnsearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Btnsearch.Click
If Txtascd.Text.Trim = "'" Then
Txtascd.Text = ""
Exit Sub
End If
If txtip.Text.Trim = "'" Then
Txtascd.Text = ""
Exit Sub
End If
If txtmobile.Text.Trim = "'" Then
Txtascd.Text = ""
Exit Sub
End If
dgresult.CurrentPageIndex = 0
ViewState.Remove("vstr")
If Txtascd.Text.Trim <> "" Then

vstr = " and assetcode='" & Txtascd.Text.Trim & "'"
ViewState("vstr") = vstr
End If

If Ddmodel.SelectedIndex <> 0 Then
vstr = " and model='" & Ddmodel.SelectedItem.Text & "'"
ViewState("vstr") += vstr
End If

If txtmobile.Text.Trim <> "" Then

vstr = " and mobile='" & txtmobile.Text.Trim & "'"
ViewState("vstr") = vstr
End If
If txtip.Text.Trim <> "" Then

vstr = " and ip='" & txtip.Text.Trim & "'"
ViewState("vstr") = vstr
End If

vstr = ViewState("vstr")
sqlstr = "select 'LNO'=assetcode,'SerialNo'=serialno,'Model'=model,'Mobile'=mobile, 'IP'=ip from A_laptops " + vstr + " order by lno asc"
ViewState("sqlstr") = sqlstr
bindresult(sqlstr)
End Sub




AnswerRe: Seaching in vs 2.0 Pin
Chetan Ranpariya5-Jun-07 21:05
Chetan Ranpariya5-Jun-07 21:05 
GeneralRe: Seaching in vs 2.0 Pin
n_gchaitra5-Jun-07 22:48
n_gchaitra5-Jun-07 22:48 
GeneralRe: Seaching in vs 2.0 Pin
n_gchaitra5-Jun-07 23:08
n_gchaitra5-Jun-07 23:08 
QuestionRe: Seaching in vs 2.0 Pin
Not Active6-Jun-07 5:22
mentorNot Active6-Jun-07 5:22 
QuestionUrgent Pin
jamesmani2k55-Jun-07 19:42
jamesmani2k55-Jun-07 19:42 
AnswerRe: Urgent Pin
badgrs5-Jun-07 22:31
badgrs5-Jun-07 22:31 
GeneralRe: Urgent Pin
jamesmani2k56-Jun-07 17:55
jamesmani2k56-Jun-07 17:55 
AnswerPlease read forum guidelines Pin
leckey6-Jun-07 4:06
leckey6-Jun-07 4:06 
QuestionGetting value of a label after clicking on delete button in Gridvew Pin
AaronNeo5-Jun-07 19:35
AaronNeo5-Jun-07 19:35 
AnswerRe: Getting value of a label after clicking on delete button in Gridvew Pin
Harini N K5-Jun-07 19:50
Harini N K5-Jun-07 19:50 
GeneralRe: Getting value of a label after clicking on delete button in Gridvew Pin
AaronNeo5-Jun-07 20:22
AaronNeo5-Jun-07 20:22 
QuestionActive directory Authentication Pin
alok_2k35-Jun-07 19:30
alok_2k35-Jun-07 19:30 
QuestionCheckedlist box Pin
Devkranth Kishore Vanja5-Jun-07 19:00
Devkranth Kishore Vanja5-Jun-07 19:00 
AnswerRe: Checkedlist box Pin
Chetan Ranpariya5-Jun-07 19:31
Chetan Ranpariya5-Jun-07 19:31 
GeneralRe: Checkedlist box Pin
Devkranth Kishore Vanja5-Jun-07 19:52
Devkranth Kishore Vanja5-Jun-07 19:52 
GeneralRe: Checkedlist box Pin
Venkatesh Mookkan6-Jun-07 0:05
Venkatesh Mookkan6-Jun-07 0:05 
QuestionSave html content to SqlServer Pin
freshonlineMax5-Jun-07 18:30
freshonlineMax5-Jun-07 18:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.