|
how to generate database backup automaticaly daily basis in sql server I'm facing this probelm plz help me?
|
|
|
|
|
|
Just create a sql job. You can either create a maintenance plan or just create a job. Either way, it's pretty easy if you open Sql Management Studio and poke around.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
hi
i am create a bus ticket booking website. but one difficulty arise about the bus status. the bus is display after mentioned departure time.
|
|
|
|
|
Do you really think that anyone can guess from this what is happening in your application?
|
|
|
|
|
sir
this is my sql table
Bus_no Bus_Name Departure_time Seat Fare Bus_type Start Journey_date Bus_Ref Status
88 mybys 18:00:00.0000000 32 150.00 NON_AC_32 Guwahati 2013-12-12 10000001 Active
the thing is that the above bus_no active after mentioned Departure_time. and Stored_procedure in my sql is:
GO
CREATE procedure [dbo].[Add_bus]
(@Bus_Name nvarchar(max),
@Dep_Time datetime,
@Seat_Details int,
@Bus_type varchar(200),
@start nvarchar(max),
@journey_date datetime,
@bus_ref int)
as
begin
INSERT INTO [MyBus].[dbo].[Bus_Detail]
([Bus_Name]
,[Dep_Time]
,[Seat_Details]
,[Bus_Type]
,[Start]
,[Journey_Date]
,[booked_seats],[bus_ref],[BusStatus])
VALUES
(@Bus_Name,@Dep_Time,@Seat_Details,@Bus_type,@start,@journey_date,@bus_ref,'Active')
end
modified 2-Jun-14 2:41am.
|
|
|
|
|
Looks like you have the wrong number of values, 9 fields and 8 values missing booked seats
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I'm trying to develop a custom scaffolder using the new Scaffolding framework in VS2013, but I'm having some problems understanding how to use the new ASPNet.Scaffolding.Core.Metadata.ModelMetadata class. Basically, I need to create a ModelMetdata instance based on a specified DataModel type, and pass it to the T4 template. Is there a special MetaDataProvider that I need to use for this? Any help would be appreciated.
Note that I'm not using the Entity Framework, so I don't have a DBContext to work with in this case. Just a C# class with DataAnnotations.
Thanks,
John P.
|
|
|
|
|
I am increasing my row by 1 like this... is there are the better way to do this:
currentRow = currentRow + 1
|
|
|
|
|
What are you talking about?
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
|
Other way?
can you explain your scenario ? you can use following syntax
currentRow += 1;
currentRow ++;
currentRow = currentRow + 1
|
|
|
|
|
Hi,
I have a web application running SSRS reports 2005 via rsweb:ReportViewer control
The reports are generated fine on IE 7-8 browsers. However I'm having some issues on the IE10.
When clicking on a hyperlink on the main report to load the sub report, the sub report is not generated in the rsweb:ReportViewer control. It navigates away from my application and it is generated in a new browser window. Also in the address bar of the browser. I've noticed that the URL of the report server is displayed with all the report parameters as query string. This is happening in IE 10 only.
Any idea how to resolve this issue?
Cheers
|
|
|
|
|
Add the following code snippet in web.config file:
<system.webServer>
<httpProtocol>
<customHeaders>
<clear/>
<add name="X-UA-Compatible" value="IE=8"/>
</customHeaders>
</httpProtocol>
<system.webServer>
Look at life through the windshield, not the rear-view mirror
|
|
|
|
|
Thanks for the reply DamithSL. I've tried your solution but it didn't resolve the issue.
Should the code be added to the config file of the web application or to the config file of the Report Server?
Thanks
|
|
|
|
|
During the publishing of my web application using VS 2010 I get the following message,
Web deployment task failed. (There was an error reading IIS configuration schema from 'C:\WINDOWS\system32\inetsrv\config\schema\'.)
Can anyone please advice me the resolution?
regards
Sultan
|
|
|
|
|
|
I've never used the web deployment, well maybe during VS2005 but that was almost 10 years ago.
Back in the old days, you use to be able to setup your IIS 5 / IIS 6 web server using software, that can read and write the IIS website metabase config files in the windows operating system. Very easy to read and write too using managed code or c++ on Windows XP.
Since IIS 7, the web config is now written to the web.config file in your project folder. So you just copy the project to your server, and just point IIS 7+ folder path to the web site project folder. Now you click on the bind link to test the bind to the server.
I'm pretty sure that the feature your speaking about is legacy, and I'm not really sure why it's still there. Some folks still use IIS 5 and IIS 6 to host web sites on, which is not very secure in today's world.
The Application pool is not written to the web config, so you have to program that by hand. If your having trouble programming the app pool, or setting permissions for the app pool in the website folder, That's another complex project.
I like the new system, because deployment time is much faster now.
Sample system.webServer. This sample programs the default page name, sets the maximum upload size, and sets compression for static and dynamic pages to TRUE. You can do much more, but this works for me on my projects. The rest of the settings are default settings.
<system.webServer>
<defaultDocument>
<files>
<remove value="iisstart.htm"/>
<remove value="index.html"/>
<remove value="index.htm"/>
<remove value="Default.asp"/>
<remove value="Default.htm"/>
<add value="index.aspx"/>
</files>
</defaultDocument>
<security>
<requestFiltering>
<requestLimits maxAllowedContentLength="52428800"/>
</requestFiltering>
</security>
<urlCompression doStaticCompression="true" doDynamicCompression="true"/>
</system.webServer>
I don't know of too many people that use the feature in question. But you have to have the IIS 6 metabase compatibility turned on for Windows Vista, 7 and 8 in order for it to work I think.
http://www.iis.net/learn/manage/managing-your-configuration-settings/metabase-compatibility-with-iis-7-and-above[^]
|
|
|
|
|
I have a scenario where I have to create multiple sheets in excel and bind data to those sheets and download. Now I have code for creating 1 sheet. I have creatied a HTML Table and binded it to excel. In the same way I have to create multiple sheets from Html table and download the excel file.
filename = filename + " Case Study";
Query_ValuesSelection = "Select * from case_study_information where locid="+DD_Location.SelectedValue.ToString()+" and methodid="+DD_Methods.SelectedValue;
MySqlCommand command = new MySqlCommand(Query_ValuesSelection, con);
datareader = command.ExecuteReader();
if (datareader.HasRows)
{
datareader.Read();
sb.Append("<table class='Tickets'>");
//sb.Append("<tr style='color:white'>");
//sb.Append("<td style='background-color:#3a4f63' colspan=" + datareader.FieldCount.ToString() + "><b>" + DD_Location.SelectedItem.Text.ToString() + "</b></td>");
//sb.Append("</tr>");
datareader.Read();
for (int colCount = 0; colCount < datareader.FieldCount; colCount++)
{
string str = datareader.GetName(colCount).ToString();
if (datareader.GetName(colCount).ToString() == "Sample Photo")
{
sb.Append("<tr height='150'>");
sb.Append("<td><b>" + str + "</b></td>");
string filepath = Server.MapPath("Images//Case Studies//" + DD_Location.SelectedItem.Text.ToString() + ".png");
// sb.Append("<td><img src='http://localhost:53340/Retrospective/Images/epa.jpg'/></td>");
sb.Append("<td><img src='" + filepath + "'/></td>");
}
else
{
if (datareader.GetName(colCount).ToString() != "locid" && datareader.GetName(colCount).ToString() != "MethodId")
{
sb.Append("<tr>");
sb.Append("<td><b>" + str + "</b></td>");
sb.Append("<td><b>" + datareader[colCount].ToString().Trim() + "</b></td>");
}
}
sb.Append("</tr>");
}
sb.Append("</table>");
}
else
Response.Write(@"<script language='javascript'>alert('No Case Study Information for the selected location')</script>");
}
System.Text.StringBuilder sb1 = new System.Text.StringBuilder();
sb1 = sb;
if (datareader.HasRows)
{
HttpContext.Current.Response.ContentType = "Application/x-msexcel";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=\"" + filename + ".xls" + "\"");
HttpContext.Current.Response.Write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
HttpContext.Current.Response.Write("<head>");
HttpContext.Current.Response.Write("<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>");
HttpContext.Current.Response.Write("<!--[if gte mso 9]><xml>");
HttpContext.Current.Response.Write("<x:ExcelWorkbook>");
HttpContext.Current.Response.Write("<x:ExcelWorksheets>");
HttpContext.Current.Response.Write("<x:ExcelWorksheet>");
HttpContext.Current.Response.Write("<x:Name>" + filename + "</x:Name>");
HttpContext.Current.Response.Write("<x:WorksheetOptions>");
HttpContext.Current.Response.Write("<x:Print>");
HttpContext.Current.Response.Write("<x:ValidPrinterInfo/>");
HttpContext.Current.Response.Write("</x:Print>");
HttpContext.Current.Response.Write("</x:WorksheetOptions>");
HttpContext.Current.Response.Write("</x:ExcelWorksheet>");
HttpContext.Current.Response.Write("</x:ExcelWorksheets>");
HttpContext.Current.Response.Write("</x:ExcelWorkbook>");
HttpContext.Current.Response.Write("</xml>");
HttpContext.Current.Response.Write("<![endif]--> ");
HttpContext.Current.Response.Write("</head>");
HttpContext.Current.Response.Write("<body>");
HttpContext.Current.Response.Write(sb.ToString());
//HttpContext.Current.Response.Write(sb1.ToString());
HttpContext.Current.Response.Write("</body>");
HttpContext.Current.Response.Write("</html>");
HttpContext.Current.Response.Write("<body>");
HttpContext.Current.Response.Write(sb.ToString());
//HttpContext.Current.Response.Write(sb1.ToString());
HttpContext.Current.Response.Write("</body>");
HttpContext.Current.Response.Write("</html>");
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
|
|
|
|
|
I was purchased web hosting space and after purchased web domain. That day I am hosted a website on my space. But my major problem is the gprs data logger send the data on my IP address. But I don't know how I can read the data and save my file on every 5 minutes.
please help me how I can do this
muruga
|
|
|
|
|
|
how to run event of asp contol by javascript code?
|
|
|
|
|
|
Hello Friends, I am newer to this site
|
|
|
|
|
Welcome!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|