|
Hey,
im building a page using asp.net (c#).
I have never done it before but would like to build a search feature that searches my mysql database and returns relevant results.
I have searched the net for help and found some tutorials, altough they are not that good. While in the beginning the search would not be used much its my hope to be getting a lot of people using the search function eventually, so I would like to build it using the best approach so I will not have any bad problems or errors down the line.
Does any one know of any good articles, or tutorials that could help me out?
thankyou.
|
|
|
|
|
Since your search function is simply going to query a database for results, consider this as you would any other MySQL data-access request. You'll have a SELECT statement that supports parameters for retrieving records from your MySQL database. The parameter values will be supplied by your user by entering "whatever" in your "Search" box. You'll execute the query and bind the results to whatever makes sense for your search results (e.g. a GridView, or DataList, or Repeater... depending on how you want the search results to display).
|
|
|
|
|
Dear all,
Is there anyone who can help me about CallbackEventHandler basic sample code which has the logic of loading a value without refreshing the page.....please do some help....as Im studying...the logic of getting it processed.
thanks in advance
apol
|
|
|
|
|
How i can select a single cell from asp.net grid on click event of mouse ??
plz help
jagmit
|
|
|
|
|
I think you are going to have to give a little more information on what you wish to accomplish in order for us to help you more.
Where is the click event coming from? A linkbutton in the grid? or are you talking about adding a onclick event to a datacell?
Cheers
Disgyza
Programmer Analyst
|
|
|
|
|
Hi all
I am trying SQL to XML means i want to store SQL table records in XML
And
Again XML to SQL
Can any one give me an idea
Than Q
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
What database server are you using? Is it SQL Server
|
|
|
|
|
Hi THX for reply
Yes it is SQL server
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
Now, can you provide an example of what is it that you want?
|
|
|
|
|
In sql server i have an table called "WW"
That table records i want to copy to XML file (WW.xml)
I done the SQL to XML like this
Dim dsn, sqlEmp As String
dsn = "Provider=SQLOLEDB;server=;uid=;pwd=;database=Test"
sqlEmp = "select * from WW"
Dim connection As New OleDbConnection(dsn)
Dim command As New OleDbDataAdapter(sqlEmp, connection)
Dim dsCustomers As New DataSet
command.Fill(dsCustomers, sqlEmp)
dsCustomers.WriteXml(Server.MapPath("WW.xml"))
It will transfer all the records to XML file
Now i want to this XML file to transfer to SQL server New Table
How can i do this
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
Hi Friend,
I Envisage the <new table=""> has two Columns.
Private Con As SqlConnection
Private Com As SqlCommand
Private DSET As DataSet
Con = New SqlConnection("Your Connection String")
Com = New SqlCommand("Insert <newtable> Values(@ID,@Name )", Con)
'/*** If the TWO column are String Type ***/
Com.Parameters.Add("@ID", SqlDbType.VarChar, 5)
Com.Parameters.Add("@Name", SqlDbType.VarChar, 50)
DSET = New DataSet()
DSET.ReadXml("<path here="">WW.xml")
Dim R As Int32
Con.Open()
For R = 0 To DSET.Tables(0).Rows.Count - 1
Com.Parameters("@ID").Value =DSET.Tables(0).Rows(R)(0)
Com.Parameters("@Name").Value =DSET.Tables(0).Rows(R)(1)
Com.ExecuteNonQuery()
Next
Con.Close()
With Regards,
Pandian S
|
|
|
|
|
Hi THX for reply
Plz can u chk u this what wrong here
It is giving this ERROR ------ Declare "@code"
Dim Con As OleDbConnection
Dim Com As OleDbCommand
Dim DSET As DataSet
Con = New OleDbConnection("Connection String")
Com = New OleDbCommand("Insert into ww Values(@Code,@Month))", Con)
Com.Parameters.Add("@Code", OleDbType.VarChar, 200, "@Code")
Com.Parameters.Add("@Month", OleDbType.VarChar, 200, "@Month")
DSET = New DataSet
DSET.ReadXml(Server.MapPath("WW.xml"))
Dim R As Int32
Con.Open()
For R = 0 To DSET.Tables(0).Rows.Count - 1
(ERROR) Com.Parameters("@Code").Value = DSET.Tables(0).Rows(R)(0)
Com.Parameters("@Month").Value = DSET.Tables(0).Rows(R)(1)
Com.ExecuteNonQuery()
Next
Con.Close()
-- modified at 2:00 Wednesday 16th August, 2006
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
plz help me to invoke the OnTextChanged event to the TextBox placed in the footer template of the grid.On changing the TextBox text property the corresponding data matching the to the text should be displayed it the adjacent rows ..
plz somebody help to goforward in my project
ashok kumar.y
|
|
|
|
|
How can I convert excel file,Word document file to pdf in asp.net
Mansoor
|
|
|
|
|
Why delete the previous message and then start a new thread? You should respond in the thread that you already started.
|
|
|
|
|
Hi!
I am using ASP.net 1.1 TextBox control, it has a "wrap" property which takes the sentence to the next line by adding a carriage return if the user reaches the end of a line. This property is not working with FireFox, can any one please help, how to code the TextBox control so that it's wrap property works with firefox as well.
Many Thanks in advance.
happy coding!
|
|
|
|
|
You are using a feature that is not part of the HTML standard, so it's not available in all browsers.
Let's take a step back. Why are you using this feature in the first place? What is it that you need it for?
---
b { font-weight: normal; }
|
|
|
|
|
Mansurali wrote: How do i convert any other file format to PDF in ASP.NET
ASP.NET is a framework for writing web applications (e.g. web sites and web services). You cannot use ASP.NET to convert files.
You can use other classes in the .NET Framework for this purpose if you want.
However, your request is too vague. For example, what file formats do you want to convert to PDF?
e.g. Do you want to convert:
* Autocad Drawings
* AVI files
* ESRI Shape Files
* C# source code files
* DLLs
* Executable files
* Excel spreadsheets
* HTML files
* .INI files
* ISO disk images
* MP3 files
* Powerpoint presentation
* WMA (Windows Media Audio) files
* WMV (Windows Media Vidio) files
* Word Documents
* XML files
* ZIP files
As you can see from this list, all these files are included in your request, but how, exactly, would you like an Executable File to be rendered into a PDF?
|
|
|
|
|
Colin,
You have answered to wrong posting .
happy coding!
|
|
|
|
|
No, I did not answer the wrong post. The person I replied to deleted their post and then posted it again (in a new thread) after you posted your post. It can all get rather confusing when people are inconsiderate like that.
|
|
|
|
|
I'm using the selectedIndex of a drop down list to determine if the user select an item
If dropdownlistMember.SelectedIndex > -1
do a bunch of stuff
else
send an error message to the user
Its a zero based drop down list
The problem is that SelectedIndex is never -1.
If I step through the code, when the user does not make a selection, the index is 0. If they select the first item, the index is 0 ( it should be)
If they select the second item, index is 1 ( it should be)
I tried initializing the index during page load if not post back
If Page.IsPostBack = False Then
dlIdNums.SelectedIndex = -1
But index is always 0
Any ideas?
thanks
|
|
|
|
|
Add a new item in the drop down with ' ' as the text and value as -1, that should be first item in the drop down. I was having the same problem i did this way.
Ram
|
|
|
|
|
great - thanks for the idea
|
|
|
|
|
can't get this to work
The drop down list is populated when the program is run ( by reading in records from a table)
I add a new item with text ' ' and value = '1
but when I step through the code, the first item always has an index = 0 even though I've just set it to -1
Don't understand how to change this
Even if no item is selected, the index is = 0 which means if no item is selected, the first item will always be selected
|
|
|
|
|
Hi,
I have a website on a dedicated web server that can't communicate with a sql server 2000 database sitting behind a firewall. My website is written in asp.net 2 and c# 2 and port 1433 has been opened through the firewall to allow access. On the db server is an admin database set up to use asp.net authentication. I am running Visual Web Dev 2005 Express on the web server to test the application and initially I want to connect to that db and set up mu app and asp 'admin' users. For that I would normally use the 'Website/ ASP.NET Configuration' menu option within the IDE. At the moment I just get a connection error:
Server Error in '/asp.netwebadminfiles' Application.
--------------------------------------------------------------------------------
Access is denied.
Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.
Error message 401.2.: Unauthorized: Logon failed due to server configuration. Verify that you have permission to view this directory or page based on the credentials you supplied and the authentication methods enabled on the Web server. Contact the Web server's administrator for additional assistance.
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Server Error in '/asp.netwebadminfiles' Application.
--------------------------------------------------------------------------------
Access is denied.
Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.
Error message 401.2.: Unauthorized: Logon failed due to server configuration. Verify that you have permission to view this directory or page based on the credentials you supplied and the authentication methods enabled on the Web server. Contact the Web server's administrator for additional assistance.
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Now which server is the problem on - the web server?? What do I need to do to connect with this db? Help!  Thanks in advance.
Chris
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
