how to fetch the details of SPace allocated to Database by query. I.e. i want to fetch the details of Space allocation (Total space allocated, used space and free space) via query.
Is their any solution to it? currently i have to manually go to the specific database's taskpad to read the values and write it in my report.
i'm writing a stored proc and if a field i return is longer then 200 characters, i want to truncate, find the last space, remove any characters after that space, then add some full stopseg:
INSERT INTO @rec(articleid, abstract)
SELECT a.id,
CASE
[code]...
I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
I have a drive 'F' with 40G free space. I try to restore a database whose data + log file size is 60G.
The restore fails. Is it because a full restore needs free disk space of 60G in this case?
I am not getting image from Sql Server Database.
Actually I placed a gridview in my project ,in that gridview I placed an images control in that gridview and I want to get the images from Sql DB to gridview.
i want to fetch data from Oracle Data base using Tab key , like when user enter ID in one text box and press Tab key it should fetch data in other text boxes , i am using web form.
View 1 RepliesI need a basic system that uploads a file to the server and stores the details in a database, with the ability to add/ edit/ delete whats there.
Most of the solutions I've seen have been far to indepth. I'd like something very simple so I can pick it apart and modify it.
I am in trouble writing connectionstring in app.config. Actually database name contains space in its name. following is the connectionstring i want to put in app.config. but when i do the same it gives me error. how to solve this problem ?
<add name="Connection" connectionString="Driver={Microsoft Access Driver (*.mdb)};Dbq=C:Program FilesInsigniaTime & Attendence.mdb;Uid=;Pwd=admin;" />
here, database is access db having name as 'Time & Attendence.mdb'
How to replace a character in a String to space or white-space?
View 3 Repliesfetch one row only from database and display its value in message box in asp.net
View 3 RepliesSplit of from [URL]
tel me some code to refresh my asp page automatically after say 40 minutes to fetch latest data from database.
I want to show the password from database into Label,I have wright code following
SqlConnection con = new SqlConnection(@"Data Source=TEGADEV1SQL2K5EXPR;Initial Catalog=mydatabase;Integrated Security=True;Pooling=False"); SqlCommand cmd = new SqlCommand("select password from reg where username='" + username + "'", con);
cmd.Parameters.AddWithValue("@username", username); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt);
Lable.Text=......
I have use datatable how to read data from above code what will be the code wright Lable.Text=...
I have 1 listbox named lbCountry
i have inserted each selected value from listbox into database by following code:
[code]....
now i dont know how to fetch data from database and fill listbox with multiple selected value.
I have many country check boxes on page and i want to search data from database based on check boxes checked i.e. user can check check single or multiple checkboxes. So how can i fetch the data/records from database based on same.
View 1 RepliesI want three fields in dropdown list in gridview . Pending , Solved , Escalate.
When I first submit the record it should show pending, then from dropdown I want to update it to solved or escalate , and it will be update with dropdown in database. How can I do this process....
I have .Net web application which connects to Oracle 10g database. I want to check for space availibility before creating Indexes. Also if space is not sufficient then I would like to send an Email message to admin. How to do that from .Net web application?
View 2 RepliesI am fetching data from .xls file and storing it in to database. Then my users work on a single table where I stored all .xls data. But the problem is that it takes tooooo much time.. So, I want to use cache. But I never used this... Can any one tell me this example how can I use cache with database for increasing application speed?
View 2 RepliesI have a problem with DataSet.GetXml() in ASP.NET 4.0:
First I populate the dataset with some tables.
Then I run the .GetXml() method on the dataset and some XML is returned. The output of this method is not want I want it to be, however.
The desired result is this:
[code]....
How do I stop this from happening? I mean, how do I stop the cell from being included at all?
In ASP.NET 1.1 the same code is used and the desired output is returned. This means that it is probably some new thing in 4.0 that I have to switch on/off. But what?
i'm trying to fetch data from xml in the sql query.
DECLARE @xmlDelete xml
SET
@xmlDelete =
'<DocumentElement>
<row FSFF_FeesItemID="185" FSI_ID="104" />
<row FSFF_FeesItemID="187" FSI_ID="104" />
<row FSFF_FeesItemID="187" FSI_ID="105" />
</DocumentElement>'
;
WITH
r_set AS
(
SELECT
T1
.c1.value('(./FSFF_FeesItemID/text())[1]',
'int')
AS [id1]
,
T1
.c1.value('(./FSI_ID/text())[1]',
'int')
AS.......................................
I am using ASP.NET Forms Authentication for my application. I have made my Password Format "Clear", so no problems with the password encryption. I need to create a view(in SQL server) to display all Administrators in my System. ie aspnet_Roles.LoweredRoleName='administrator' The fields needed are UserName and Password
View 1 RepliesI have an storedprocedure which checks the following scenario:
An email will be sent to multiple customers simulataenously. the email addresses are seperated by semi colon. I have to save that mail in a table and then in the same procedure, I have to check each email address and whether it is of any customer in the customer table.. If it is of customer, then i have to insert an entry in another notes table. For this i am doing the following operation in Stored procedure:
[Code]....
the above is the part of storedprocedure i wrote. The problem is I get an error when executing this stroed procedure in Asp.net
Could not allocate space for object 'dbo.tbl_Notes'.'PK_tbl_Notes' in database 'ProjDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. and following that code, i am executing another SqlBulkCopy operation in front-end .. that returns the following error:
System.Data.SqlClient.SqlException: Could not allocate a new page for database 'ProjDB' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
In oracle we can do this by using rowid.
select * from tableName where rowid = (select max(rowid) from tableName);
but i don't know equivalent of rowid in sql server.
I have two tables and following are the structure of both the tables
Tbale 1
Field1 Field2 Field3
d1 01 26/03/2011
d2 02 26/03/2011
d3 03 27/03/2011
Table2
Field1 Field2 Field3
01 6.15 14.25
02 7.30 16.25
03 6.00 18.25
My expected output when i search records by table1.field3 (say 26/03/2011)
Tbale 1
Table1.Field1 Table2.Field2 Table3.Field3 Table2.field2 Table2.Field3
d1 01 26/03/2011 6.15 14.25
d2 02 26/03/2011 7.30 16.25
d3 03 27/03/2011
Inorder to get the above result, what query should i write?
Are there any ways in ASP.net to fetch data from the server without extending the session timeout? This needs to be done every few minutes without user interaction until the page is closed.
Additional context, as requested:
The pages in my webapp needs to poll the server every few minutes to check for a particular condition (emergency maintenance scheduled for 30 minutes time, in this instance). When the condition is true, the page will display a message to the user. When the condition is false, nothing needs to happen.
As I understand it, postbacks to the server reset the time until the session expires. We do not want the session to be extended/refreshed/reset/whatever the word is every time the page polls the server. I need a way to poll the server automatically without resetting the session timeout.
I have an aspx master/content page scenario. The parent page has an IFrame which points to a child.aspx. The child.aspx has a checkbox, On page_load of child.aspx, I want to show/hide the checkbox depending on the following logic:
- if the child.aspx is opened directly, then I have to show the checkbox.
- if the child.aspx is opened in the IFrame, then I have to hide the checkbox.
Basically, I want to check in child.aspx, if it contains a parent window then hide the checkbox control otherwise show it.I will prefer the show/hide code in codebehind in Page_load event as I have to execute some more logic depending on whether the it is opened from parent window or not.
Till now I did the following:
In child.aspx
<asp:Content ID="Content1" ContentPlaceHolderID="Main" Runat="Server">
<script language="javascript" type="text/javascript">
function DoesParentExists()[code].....
Using RegisterClientScriptBlock, I get error in JS. That the object hfDoesParentExist doesn't exist 'coz the control is not yet created. Right? I tried using RegisterStartupScript but in codebehind I always get null in hidden variable. I don't want to use the on button click or something like it. I need it on page_load event only.