|
there are few system stored procs that returns the inforamtion about the database objects. take a look at those.
sp_databases <br />
sp_tables <br />
sp_columns
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
HI all
I am trying to create a autocomplete textbox i used this code
The code in c# it is working fine but when i convert to VB it is giving error . 
on page load()
" acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)"
can any one tell me what i am missing in the code.
MY CODE
--------------
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))
acSearch.PageType = Me.[GetType]().BaseType
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)
End Sub
<ajaxpro.ajaxmethod()> _
Public Function GetSearchData(ByVal s As String) As System.Data.DataTable
Dim conn As New SqlConnection("server=DSS1;uid=sa;pwd=sa;database=Northwind")
Dim cmd As New SqlCommand("SELECT FirstName FROM Employees WHERE FirstName LIKE @FirstName + '%'", conn)
cmd.Parameters.Add("@FirstName", s)
Dim da As New SqlDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds, "Employee")
Return ds.Tables("Employee")
End Function
-----------------
Keerthi
|
|
|
|
|
What error are you getting?
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Thx For reply
The Error is
C:\Inetpub\wwwroot\20-3-2006\TextBoxAutoCompletion\WebForm1.aspx.vb(31): 'WebCustomControl.Lab.Autocomplete.AutoCompleteHandler' is a delegate type. Delegate construction permits only a single AddressOf expression as an argument list. Often an AddressOf expression can be used instead of a delegate construction.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))
acSearch.PageType = Me.[GetType]().BaseType
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)
End Sub
Keerthi
|
|
|
|
|
kirthikirthi wrote: acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Thx Michael Sync
It working
Keerthi
|
|
|
|
|
iam using this method for(Response.AppendHeader("content-disposition", _
"attachment; filename=" & name))file downloading ...its working fine with all types file extensions...the problem is that now i installed
DAP download for fast accessing ..now the problem is that when i down load the rtf file using this method it is not getting the rtf file ..instead it is gettind default.aspx file to down load how this problem will be solved
|
|
|
|
|
Can any one tell me how to solve this problem?
Server Error in '/DataEditor' Application.
--------------------------------------------------------------------------------
Access is denied.
Description: An error occurred while accessing the resources required to serve this request. You might not have permission to view the requested resources.
Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'D:\inetpub\wwwroot\DataEditor\Reference.aspx'.
|
|
|
|
|
Hi,
try to give rights to the director named DataEditor..
Thanks,
Sun Rays
Rate this post if you like answer.
My Articles
|
|
|
|
|
I have given begindcode
while(dr10.Read())
{
Response.Write("<img src=~\"uploads\" width=\"39\" border=\"1\" height=\"40\">");
}
HTML CODE
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="lbl4" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"picture") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Its not retrieving
krishna
|
|
|
|
|
|
Have a look at this One[^], Two[^].
What exactly is the problem?
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
Please understand, i hope u people will help me thats y iam keep sending dont mistake me r to get angry...
The producer wht u had send all storing link to the db, but i have stored a image file name as (9.jpg) no image was there, image was in separate folder having this image file 9.jpg.
In out put its receiving like 9.jpg( no image ), so how to link with that folder to retrieve the image.
Advance Thanx,
krishna
|
|
|
|
|
Hi,
as you have just store image name in your database and your inmage is in another folder of your application.
So, first you have to get image name from database and then you have to concat the string of folder path of that image with file name, then you will get image.
see this below code.
your page is in forms directory and yr image is in images directory.
So now on page.
String path = Server.MapPath("../Images/" + filenameFromDatabase);
So you will get ......../Images/image1.jpg path. Now open the file.
Thanks,
Sun Rays
Rate this post if you like answer.
My Articles
|
|
|
|
|
Which one is this ' filenameFromDatabase' means ?
krishna
|
|
|
|
|
|
ok, all that I understand up till this moment is that you store the File Name in the Database and the Corressponding Images are stored in the folder in the server, right? can you show only the code that you use to set src property of Img?
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
Response.Write("");
krishna
|
|
|
|
|
krishnavaradharajan wrote: Response.Write("");
sorry, I really don't understand what you are trying to do with the above code.
Here is the tip to solve you problem. If I have to display a Image which lies in a virtual folder in my application then I would write the code as below.
HTML
<-img id="ImgFile" runat="server">
Code-Behind
string FileName = "Pic101.gif"; <br />
ImgFile.Src = "./Images/" + FileName;
Same code will work for you with the ImageName picked from the Database and provided the corressponding Image folder should be available in the given virtual path and Corressponding Image should also availble in the folder.
Try it out.
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
|
Its working fine iam retrieving images, but ....
For example : customer may upload 2 - 3 product details with image so we have 10 options to image upload.
So the condition is given like if i click button in new page by checking for karnataka state than all the product pictures should be displayed. because the condition iam checking for karnataka(like that i have to create 26 stats)
here iam receiving all the images as same.(it should be come different images according to that respective products.
krishna
|
|
|
|
|
krishnavaradharajan wrote: Please understand, i hope u people will help me thats y iam keep sending dont mistake me r to get angry...
Have you tried the suggestion given by me ? What happened when you tried it. I don't think posting continuously won't help you. Try the suggestion and let me know. You code looks completely stupid to me.
|
|
|
|
|
hi friends
I hosted the asp.net2.0.but it showed the error..but asp.net1.1 working properly..any difference betwen asp.net1.1 and asp.2.0 hosting.
regards
saravanan
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
There are some differences.. If your host supports both ASP.NET 1.1 and 2.0 then there should be one option to select which version you wanna use..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
hi i have one doubt , i have one dropdownlist and i populating 10 state_names from database, and i m using this code
string strStateId = ddlStateID.SelectedItem.ToString();
now i m selecting fifth item in dropdownlist and send it to databas e 4 update.but i m using this code if i selected fifth item but it is taking as first item only.. plz..tell me how can i do this..
thanks 2 all..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
