|
Hi,
I'm creating a search page with multiple fields to be searched. Some are textbox, some are drop-downlist.
I wrote a code to add in the select parameters to the sqlDataSource when a field is search. However, no result is being shown in the gridview.
The code is shown below, please advice on any mistakes I have made:
<pre>
Protected Sub Submit_Button_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs)
Dim strSQL2 = ""
SqlDataSource1.SelectParameters.Clear()
If emp_id.Text <> "" Or name.Text <> "" Or country.SelectedItem.Value <> "" Or city.Text <> "" Or nearest.Text <> "" Or status.SelectedItem.Value <> "" Or agent.SelectedItem.Value <> "" Then
strSQL = "SELECT E.id, E.status, E.name as E_NAME, E.country, E.city, E.nearest1, E.nearest2, E.nearest3, E.nearest4, E.nearest5, E.email, E.mobile1, E.mobile2, E.home_no, E.msn, E.skype, E.moneybookers, E.agent_id, A.name as A_NAME, E.notes, E.suspend FROM employee as E left join employee as A on E.agent_id=A.id where "
If emp_id.Text <> "" Then
strSQL2 += "E.id=@id and "
SqlDataSource1.SelectParameters.Add(New Parameter("id", TypeCode.String, CType(emp_id.Text, String)))
End If
If name.Text <> "" Then
strSQL2 += "E.name=@name and "
SqlDataSource1.SelectParameters.Add(New Parameter("name", TypeCode.String, CType(name.Text, String)))
End If
If country.SelectedItem.Value <> "" Then
strSQL2 += "E.country=@country and "
SqlDataSource1.SelectParameters.Add(New Parameter("country", TypeCode.String, CType(country.SelectedItem.Value, String)))
End If
If city.Text <> "" Then
strSQL2 += "E.city=@city and "
SqlDataSource1.SelectParameters.Add(New Parameter("city", TypeCode.String, CType(city.Text, String)))
End If
If strSQL2 <> "" Then
strSQL += Left(strSQL2, Len(strSQL2) - 5)
Else
strSQL = Left(strSQL, Len(strSQL) - 7)
End If
SqlDataSource1.SelectCommand = strSQL + " order by E.name"
SqlDataSource1.DataBind()
Response.Write(SqlDataSource1.SelectParameters("city"))
Else
strSQL = "SELECT E.id, E.status, E.name as E_NAME, E.country, E.city, E.nearest1, E.nearest2, E.nearest3, E.nearest4, E.nearest5, E.email, E.mobile1, E.mobile2, E.home_no, E.msn, E.skype, E.moneybookers, E.agent_id, A.name as A_NAME, E.notes, E.suspend FROM employee as E left join employee as A on E.agent_id=A.id order by E.name"
SqlDataSource1.SelectCommand = strSQL
SqlDataSource1.DataBind()
End If
End Sub
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:rbdbConnectionString %>"
ProviderName="<%$ ConnectionStrings:rbdbConnectionString.ProviderName %>" >
</asp:SqlDataSource>
</pre>
|
|
|
|
|
asugama wrote: However, no result is being shown in the gridview
If no compilation error, just check your query and your database...
<< >>
|
|
|
|
|
I have used some javascript functions and css styles. now the problem is that all these functions and javascript is working properly with Internet Explorer but not with Mozilla Fire Fox.
Want to know the way sothat my functions and css work with others as well.
Plz give me some solution ASAP
With Thanks & Regards
Amit Sk Sharma
|
|
|
|
|
And of course we are all psychic enabling us to see the script and styles causing the problems......
|
|
|
|
|
Hi Amit
No One will come to know what happened ? please can you paste your javascirpt code here
|
|
|
|
|
dear sandeep
no any special function is there just validations through document.getelmentbyId('controlId').value I m using with alerts and some display settings in style.css but they are not working with Mozilla but working properly with IE.
searched on google also.
With Thanks & Regards
Amit Sk Sharma
|
|
|
|
|
Hi Amit
IE is not strictly W3C compliant as MoZilla browsers are using W3C compliant . do one thing use windows.document.getelementbyId('controlId') try it and regarding Style sheet what are you doing ?
|
|
|
|
|
The way to make it work in other browsers than IE is to write code according to the standard instead of writing code according to IE. IE has a lot of non-standard additions that doesn't exist in standard compliant browsers, like for example the document.all collection.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi all
I need lil advice from you all.
Well i am bit new to ASP.NET so i cant make good assumption out of it.
I am learning asp.net at the moment and soon i would be starting with my project of database driven website. So i was just wondering that do i have to sort out database first and then i should jump over to forms or it should be other way round. Well i think creating data first makes a sence as once data is finalized then i can modify the form accordingly.
Pleas give me some advice on this issue And also pls let me know if some body knows any good link for learning sql2005 to create database.
Thanks a lot
|
|
|
|
|
<students>
<id="501",name="ravi">
<id="502",name="kiran">
<students>
i need to bind xml to 2 dropdownbox in .net and once i clik on id i need to get the corresponding value in 2 dropdownbox
plz let me know
|
|
|
|
|
You can get the values from xml file to the dataset and once you have the data in dataset you can bind it to the dropdownlist control.
Best Regards,
Apurva Kaushal
|
|
|
|
|
HI
Please can any one give me idea how to read PDF file in C#.
Do we have any COM component to read PDF files ?
|
|
|
|
|
What do you mean by 'read' ? Do you want to convert to text, or just view them ? There are some projects on CP and on sourceforce, I believe.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Actually i want tp parse a padf file i.e i want to read some data present in the PDF file .........
i have use this code
FileStream readPDf = new FileStream(_fileName, FileMode.Open);
fileSize = readPDf.Length;
byte[] Buffer = new byte[(int)fileSize];
readPDf.Read(Buffer, 0, (int)readPDf.Length);
But in PDF they are formating by flatFormate similar like that
Data is present in Buffer but unable to decode it
|
|
|
|
|
PDFs are compressed, to turn that into something intelligible is a lot of work. Even uncompressed, they are complicated, and not jsut text. There's not even a guarentee that any sentence you see rendered on the screen will appear complete within the text of the uncompressed PDF.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi All
Iam facing an issue while trying to run a function inside a datagrid template column. here is my issue:
Code:
<asp:templatecolumn headertext="Net Total">
<itemtemplate> <%# GetAmount(Container.DataItem("Qty"),Container.DataItem("price"))%>
Error:
Cast from type 'DBNull' to type 'Decimal' is not valid.
My issue is that the first time i enter the page, the price and qty are null.
I want to be able to enter the page normally to add price and to calculate total.
Any suggestions...
Thanks
|
|
|
|
|
If you want to enter the value manually why do you set it equal to the data container?
If you want to do it this way then the data container, ie the dataset/table whatever, would have to have the schema set from the DB (which you can do with DataAdapter.FillSchema) or set from the code to contain the fields so that it will find those columns. Then I would suggest that the "GetAmount" function accept the 2 values as Objects in the signature then check for If Not IsDBNull(Object1) etc... then if they are null return something like 0.00 if not then return the value.
Cleako
|
|
|
|
|
How can i execute a javascript method at runtime from .cs file?
|
|
|
|
|
HI
you can do it by manu ways but after which event you want to fire javascript function
|
|
|
|
|
hi friends
how can i edit multiple rows
at a time
thanks
Laxmikant
Laxmikant
|
|
|
|
|
hi friends
how can i edit multiple rows
at a time
thanks
Laxmikant
Laxmikant
|
|
|
|
|
hi friends
how can i edit multiple rows
at a time
thanks
Laxmikant
|
|
|
|
|
give your query accordingly so that it updates multiple rows
Gautham
|
|
|
|
|
Dear All,
i am making web application using asp.net ,C# (Visual studio 2005).
i am making data entry form using gridview and detailview(for inserting , editing ,deleting). i am filtering gridview record using dropdownlist.and in case, there is no record of corresponding value.
i have given link to add new record by using detailView on other page. my problem is whenever there is no record. detail view only show insert and cancel(command), does not show all the field(entry field)
Even though i have made defultMode of detailview insert and Autogeneraterows true.
where i am going wrong. Please help
thanks
regards
imran khan
|
|
|
|
|
Hi
I am coverting a report made in Access Application which contains subreports within subreports.The nesting is upto five levels deep.As Crystal reports do not allow adding of subreports within subreports,how do i deal with it.
Is there some other way to deal with the problem.Any suggestions and help will be appreciated.
Regards
Shaurya
|
|
|
|