|
|
|
There sure is a lot of info on how to move information from a table column to a listbox. But nothing, so far, on how to go from a listbox to a table.
I have a master record where I record the primary key of various secondary tables. This is a data base of zoning requirements for various building types. the various tables list legal setbacks, minimum building size, maximum building height, etc. It is a relational database where I can name a building type- store, church, etc.- and get out its requirements.
But I have to get the primary keys of the various tablesinto this master table first before I can get the requirements for a building type out of the data base.
It seems to me the easy way is to have a listbox, or some such thing, display the various choices of heights, acceptable building areas, maximum building heights and then let the data collector make a selection and see the index number written in the proper field on the master record. The listbox or whatever has to show the complete record so the data collector knows what the index number represents.
But I can't find anything that describes how to do this.
Maybe somebody knows where this process is written up already.
|
|
|
|
|
mhh112 wrote: Maybe somebody knows where this process is written up already.
What more do you need? You query the database given certain criteria and get a resultset back. That has been very well documented.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
I 'm populating the images in the listview control from the database.... but now i want to get only broken images from the server(eg images which are not showing, cross box) so my user can fix those images in the server. I want to put a checkbox in the search criteria so either they can see all the images from the table or only broken images.
Is there any way of doing that from asp.net or with javascript.
Any help will be appreciated.
Thanks.
|
|
|
|
|
|
In your ItemDataBound for your ListView somethnig like this should do it:
if(chkShowBroken.Checked)
{
e.Item.Visible = !File.Exists(Server.MapPath(yourImagePath));
}
else
{
e.Item.Visible = File.Exists(Server.MapPath(yourImagePath));
}
|
|
|
|
|
Thanks for the reply.
I tried this solution but for me the file will always exist as it's coming from the database but at that time image might have not transfered to the production server. So is there any way to check the size of the image for the "red cross" image (which is a broken image) or it's dimension 28 X 30.
Is there any way to check with javascript and hide the other items with css.
Thanks.
modified on Tuesday, February 2, 2010 12:47 PM
|
|
|
|
|
If it hasn't been uploaded yet it won't exist on the hard disk. File.Exists looks for the physical file on the disk. If you are storing the file name in the database that code should still work. If you are storing the actual bytes of the image in a blob in the database then you probably should change your design and start storing on the filesystem instead. If you are getting a red x then the file doesn't exist at the URL you are pointing to.
|
|
|
|
|
Fields in the database are ImageID, ImageFileLioaction, ImageFileName. I am passing these value through the sproc like this 'http://www.xyz.com'+ImageFileLocation+ImageFileName eg ('http://www.xyz.com/images/small/abc_small.jpg").
When I view my listview, the images in the production server I can see them but those which are not transfered to the prouction server will show as red X. The listview has near more than 2000 records. So I want the user to see only those rows where image is red x. So they can transfer those images to server through another application.
Is there any other way to solve this problem.
|
|
|
|
|
Dim i, j As Integer
Dim xlApp As Excel.Application
Dim xlSht As Excel.Worksheet
Dim rng As Excel.Range
xlApp = New Excel._ExcelApplication
xlApp.DisplayAlerts = False
xlApp.Workbooks.Add()
xlSht = CType(xlApp.Sheets(1), Excel.Worksheet)
xlSht.Name = "BDIS-Download"
I was trying to assign the grid results to an excel sheet and received the following message: Expression is a value and therefore cannot be the target of an assignment
Dim dc As DataColumn
Dim dr As DataRow
For i = 0 To grdResult.Columns.Count - 1
xlSht.Cells(i + 1) = grdResult.Columns(i)
Next
With xlSht
rng = CType(.Columns(1), Excel.Range)
rng.AutoFit()
End With
xlApp.ActiveWorkbook.Close(True, "C:\BDISTest.xls")
xlApp.Quit()
ReleaseComObject(rng)
ReleaseComObject(xlSht)
ReleaseComObject(xlApp)
|
|
|
|
|
Shouldn't that read something like this[^]?
xlSht.Cells(i + 1).Value2 = grdResult.Columns(i)
I are Troll 
|
|
|
|
|
Hi guys,
I have developed a lengthy form, some time end user takes more than an hour to fill in and submit that form to database. All code is inside updatepanel and script manager control this is requirement. so end user is either filling in the form or sitting idle it doesn't make any difference.
I dont want to increase session timeout.
Is there anyway to fire button's submit event after 10 mins to enable the form to submit data automatically if user doesn't click the submit button.
any help would be really appreciated.
thanks
kind regards,
learner
|
|
|
|
|
From the description, it has to be one huge form to fill. I hope you have not placed entire thing into a single page.
What you can do is when the user navigates from one page to another, do a partial save so that you don't loose data.
"No matter how many fish in the sea; it will be so empty without me." - From song "Without me" by Eminem
|
|
|
|
|
thanks for your response danish,
but i think i couldn't explain my problem properly.
now scenario is Off course form is lenghty and everything is working absolutely fine there is no problem with insertion, updation or deletion. Now the problem is sometimes users take more time than normal that's why session got expire, my boss asked me to save data after 10 mins either end user submit or not. even all blank fields.
system can save form even there is not any field filled in.
Now my problem is that how I could store data after every 10 mins automatically.
any suggestion would be appreciated.
kind regards,
learner
|
|
|
|
|
Learner520 wrote: now scenario is Off course form is lenghty
That is what you should look to get rid off. Functionality might work. But think of someone using their mobile phones (no 3G) to browse your website or someone with almost dead internet connection. I would be very frustration to wait for ages to get form loaded.
Hence, I suggested to split form across the pages and you can save them when user moves from one page to another.
BTW if you still need to have save happening with current structure, you would need Ajax. You can keep your submit button in an UpdatePanel and then trigger its click event regularly. You can use a Timer for this. Set its interval as 10 mins and handle Elapsed event to call Save/Submit button click.
Use of UpdatePanel would help you getting rid of the page reload. Also, if you are doing save on regular basis, you will need to keep track if save is called first time or not. You should do save first and Update then after.
"No matter how many fish in the sea; it will be so empty without me." - From song "Without me" by Eminem
modified on Tuesday, February 2, 2010 9:58 AM
|
|
|
|
|
thanks danish
I have done in the same way as you told.
kind regards
learner
|
|
|
|
|
Hi i have a user control, in tht with in updatepanel...,
two link buttons are there using tht i am binding a repeater control values...,
the user control link button click events working in some pages and some pages giving error as
"sys.webforms.pagerequestmanagerservererrorexception : input string was not in correct format"...,
see in the following url...,
Right side "Latest/Highest Rated" block inside two link buttons
1) is Latest topic
2) is Highest Rated
Working Url:
http://www.indiainfoline.com/discuss/blogs/
Not working Url:
http://www.indiainfoline.com/Discuss/Blogs/Markets-in-2010-/474397
i dont know whts the exact probs...,
Plz help me out to rectify this..,
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Why have you posted this question again when it has only been here for a few hours?
|
|
|
|
|
hi all talented people
here is my query:
how to send bulk emails automatically from database time to time using vb.net windows application.
your suggesstion is highlyyyyyyyyyyyyyyyyy welcome
thanks in advance
if some one have idea about this problem plz find out me on:abdulwahab79@gmail.com
|
|
|
|
|
it is easier to send the email using a stored procedure in SQL Server that is scheduled a job to send it
if this is not the way you want to go please explain to me in more detail and ill try to help you
|
|
|
|
|
Try to develop an windows application sending mail and assign it to task scheduller..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
You can schedule a job and can set the time<pre> when to send an email.
Firstly, you need to configure your database for sending mails. Connect to your database---> Go to Management ----> Right Click database mail and configure database mail.
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
|
Use Windows Service for your purpose....
|
|
|
|
|
There are many examples of sending emails from a VB application, and windows scheduler will fire the application at the desired time, but have you considered writing a windows service if the requirement is to send at fixed intervals? BTW, there is no need to use SQL Server to send emails, there are built in classes in the .net framework and its very simple.
Bob
Ashfield Consultants Ltd
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
