|
Hi!
I have a problem.
I don't know how to attach properly my menu web control to my database.
No. Don't laugh, please...
It's a bigger issue than you think, just read on.
You see, the menuitems are changing often and per permission level. This means that the menuitems must be stored in an XML file and cached. Each time there's an update, its recached.
I am using a typed dataset (myMenuItems.xsd) from wizard with the table adapter
<br />
private MenuItemsTableAdapters.MenuItemsTableAdapter myMITA = <br />
new test.MenuItemsTableAdapters.MenuItemsTableAdapter();<br />
<br />
private test.myMenuItems.MenuItemsDataTable myMI;<br />
<br />
private DataSet myDS = new DataSet();<br />
<br />
private XmlDataDocument myTemp;<br />
<br />
[...].br />
<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
if (!Page.IsCallback)<br />
{<br />
myMI = myMITA.GetData();<br />
myTemp = new XmlDataDocument();<br />
[...].br />
<br />
The humble question I ask is where do I go from there? I mean, how do I stuff the XML document with the menuitems, and how do I then stuff it into the cache and into the menu control?
My boss laid a project on me that is slightly above my technical competence for the moment. I would appreciate any help.
Thank you,
Antoine Dubuc
Transcontinental
|
|
|
|
|
If they change often and per permission level (do you mean per user?), then the cache is probably not the right place for these.
|
|
|
|
|
Hi,
The permissions vary from not logged in, logged in, and admin. Its the internationalization that makes that a headache. Any idea how to manage dynamically from a database a menu control?
Thank you,
Antoine Dubuc
Transcontinental
|
|
|
|
|
I have a table table1 which sores row and column number as:
Row_num Col_num
1 1
2 1
3 1
1 2
2 2
I want to find out the maximum of the row_ num and maximum og the col_num..
Plz send me the query
|
|
|
|
|
select max(row_num) as maxRowNum, max(Col_num) as maxCol_num from table1
I Love SQL
|
|
|
|
|
Hi
I have to database in sql sever 2000
db1 & db2
I want db2 backup in db1 .
I have taken db1 bacckup
After tht how i do restore
Plz Help
|
|
|
|
|
Do you mean you want to overwrite the data of db1 database with that of db2.
Thanking you in Advance
Regards
Pratik Shah
|
|
|
|
|
|
Hi,
Since you already have the backup of db1 (assumed, as said by you) you can just drop the database db1 and restore the data of db2 in a new database and give the dbname as db1. (This can be done using the Enterprise Manager in SQL 2000).
Kind regards
PS
Thanking you in Advance
Regards
Pratik Shah
|
|
|
|
|
I assume you want to copy everything from db2 to db1.
1. Backup db2.
2. Right click db1, go to All Task/Restore Database..
3. Check "FROM Device".
4. Select the device by click on button "Select Devices".
5. Add the backup file that you backup from db2. Click button "OK".
6. Go to tab "Option". Change the physical file name to db1.mdf and db1.ldf.
7. Check option "Force restore over existing database".
8. You should know how to continue now.
btw, please check Management/Current Activity/Process Info to make sure no connection is connected to db1.
Eliz.K
www.oin1.com
|
|
|
|
|
I need some advice on replication...
I set up a new push-subscription on my server, when I change the data (which should then be replicated) the server reports "No replicated transactions available"
In my Replication Monitor the changes are noted under the "Publisher to Distributor History" but still it reports the above message upon synchronization.
Why could this be?
_______________________________________________________________________
http://www.readytogiveup.com/[ ^]
"you can't forget something you never knew..." M. Du Toit
|
|
|
|
|
This problem occurs when SQL replication goes KooKoo, typically after a database restore.
The quickest (and probably only) fix is to remove all the Publications and start from scratch.
Search SQL Server 2005 Books Online for "Removing Replication"
_______________________________________________________________________
http://www.readytogiveup.com/[ ^]
"you can't forget something you never knew..." M. Du Toit
|
|
|
|
|
Hi
HOw to create Backup of database using query for a fixed time?
I do not want to use Wizard.
plz help as soon as possible.
Thanks
|
|
|
|
|
This will create a backup:
BACKUP DATABASE pubs TO DISK = N'c:\temp\pubs.bak'
but I have no idea if that's what you need, since I don't know what you mean by 'for a fixed time'. Could you explain?
|
|
|
|
|
Thnks for replay
BACKUP DATABASE Parikrama TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SQLSpyNetJob.bak'
WITH NOINIT, NOSKIP, STATS = 10
can anyone tell wht is the meaning of STATS =10 in above query.
And plz tell me i want query tht taking automatically bacup of database with in interval0f 10-10 minutes by job scheduler .
Thanks
|
|
|
|
|
Care Career wrote: database
SQL Server Books On Line[^] are your friend. That means with statistics update based on a 10% sample of the data.
Creating a backup every 10 minutes is only likely to work for a very small database, as backup can take more time than this. Creating a job to do this on a scheduled interval takes more than one query, and is best done using the database maintenance wizard. It is possible manually, but the procedure is more lengthy than can be described here. Use the reference I have provided, and look up SQL Server Agent tasks, or Database maintenance.
|
|
|
|
|
thnx lot
Can u tell how to start Sql server agent?
1069 logon faliure error is coming when i start sql server agent.
Thnx
|
|
|
|
|
|
Rob Graham wrote: That means with statistics update based on a 10% sample of the data.
Are you sure?
This is what I found:
STATS [ = percentage ]
Displays a message each time another percentage completes, and is used to gauge progress. If percentage is omitted, SQL Server displays a message after each 10 percent is completed.
The STATS option reports the percentage complete as of the threshold for reporting the next interval. This is at approximately the specified percentage; for example, with STATS=10, if the amount completed is 40 percent, the option might display 43 percent. For large backup sets, this is not a problem, because the percentage complete moves very slowly between completed I/O calls.
|
|
|
|
|
hi,
i want to know that whether or not reportviewer control support subscript & superscript ?
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Rupesh Kumar Swami wrote: reportviewer control support subscript & superscript ?
Have you actually tried it?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
hi paul,
i tried , but up till now i have no result found. i also try for crystalreport viewer but in CrystalReportViewer case i am sure that it does not support subscript & superscript.
have you any idea about superscript & subscript in Microsoft Reporting service related to VS.NET 2005(ReportViewer control)?if yes , please guide me or send any link.
Thanks in advance.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
hello
i have a database where i get links out off for images standard is 1 image per page but sometimes i want to load multible images on to a page without changing the page everytime i have got 1 asp page were can load aal of the record from the database from i want to add a script thats checking if the is a link for second image availeble if it's there then that he show it if not he does nothing. i think it a true or false script but i dont know how toe work it out
cool349
|
|
|
|
|
From your description, I'm not 100% sure what you are trying to achieve but I think I know. Anyway, if you were creating an ASP.NET page and you wanted to display the images, I would wrap each required image up inside its own control. The control would have a primary key identifier that told it which image to download from the database and the control would then be responsible for displaying the resulting image.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi,
I have two tables reciept and issue.
Reciept have the foloowing details
partno date rquantity rrate
a 10/1/2005 50 15
a 15/4/2005 10 22
a 11/7/2005 40 20
Issue have the foloowing details
partno date iquantity irate value
a 14/1/2005 10 10
a 15/5/2005 20 22
a 1/8/2005 20 22
what i have to do is
take the quatity from issue table subtract from the rquantity of reciept table until rquatity becomes 0 then we have to store some calucated result in "Value" column
iquantity(irate-rrate)
example, first we have to subtract
10 from the 50, the remainder is 40 ,store 10(10)+10(10-15)=50
20 from the 40, the remainder is 20,store 20(22)+20(22-22)=440
20 from the 20, the remainder is 0,,store 20(20)+20(22-20)=440
Can anyone tell to solve this?
Chaitra N
|
|
|
|