|
Are you using internal Visual Studio IIS?
Parwej Ahamad
|
|
|
|
|
|
Go to Project Property -> Web -> Start URL:
http://localhost:xxxx/default.aspx
Note: xxxx is port no. When you run the application you will see port no that IIS used.
Thanks
Parwej Ahamad
|
|
|
|
|
Hi,
Below error is displayed when i read excel file using oledb4.0. The code is working well for other applications on same server.
System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at UploadExcelFile.SaveXlsFileCols(Int32 int_FileId, String str_filePath, String str_extension, String str_fileName)
Though same code is running for other application on same server.
protected void SaveXlsFileCols(int int_FileId, string str_filePath, string str_extension, string str_fileName)
{
string connString = string.Empty;
if (str_extension == "xls")
{
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str_filePath + ";Extended Properties=\"Excel 8.0;\"";
}
else
{
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + str_filePath + ";Extended Properties=\"Excel 12.0;\"";
}
// Create the connection object
using (OleDbConnection oledbConn = new OleDbConnection(connString))
{
try
{
if (oledbConn.State == ConnectionState.Open)
{
oledbConn.Close();
}
// Open connection
oledbConn.Open();
DataTable dbSchema = oledbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();
// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM ["+WorkSheetName+"]", oledbConn);
|
|
|
|
|
do you have Microsoft Access installed on the host on which the application is running?
Help people,so poeple can help you.
|
|
|
|
|
Hi,
Im using datepicker using standalone jquery. The datepicker works perfectly in WebForm. Now i decided to use a site master on my sample project and I add some web content form also inside the site.master.
In my web content form i add search function with date range.
Now, the problem was, after using web content form, datepicker no longer showing the icon "..." beside my asp:textbox.
Please see below tags in my site.Master page.
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Scripts>
<asp:ScriptReference Path="~/scripts/datepickerjs/jquery-1.3.1.min.js" />
<asp:ScriptReference Path="~/scripts/datepickerjs/jquery-ui-1.7.1.custom.min.js" />
<asp:ScriptReference Path="~/scripts/datepickerjs/daterangepicker.jQuery.js" />
</Scripts>
</asp:ScriptManager>
i also place the css in site.master inside the head tag.
<link rel="Stylesheet" type="text/css" href="style/datepickercss/ui.daterangepicker.css" />
<link rel="Stylesheet" type="text/css" href="style/datepickercss/redmond/jquery-ui-1.7.1.custom.css" title="ui-theme" />
In my web content form i place the script after the asp:Content tag.
<script type="text/jscript">
$(function() {
$("#txtDateFrom").datepicker({
changeMonth: true,
changeYear: true,
buttonText: 'Select Date From',
buttonImage: 'images/calendar.gif',
buttonImageOnly: true,
showOn: 'button'
});
});
$(function() {
$("#txtDateTo").datepicker({
changeMonth: true,
changeYear: true,
buttonText: 'Select Date To',
buttonImage: 'images/calendar.gif',
buttonImageOnly: true,
showOn: 'button'
});
});
</script>
Finally, when i run my project the "..." is not showing. Normally, when i used web form this "..." will show and i can select a date, but now after switching to web content form, "..." is no longer visible.
Thanks
if(you type your code here) {
Messagebox.Show("You help me a lot!");
}
else {
You help me = null;
}
|
|
|
|
|
klaydze wrote: $("#txtDateFrom").datepicker({
Using a MasterPage will change the id. You may want to try
$("[id$='txtDateFrom']").
to get the id that ends in txtDateFrom
[Edit for correct punctuation]
|
|
|
|
|
Hi bVagadishnu,
You help me alot. Works perfectly!!!
Thanks
if(you type your code here) {
Messagebox.Show("You help me a lot!");
}
else {
You help me = null;
}
|
|
|
|
|
Hi,
I have a query which returns more than 5 Lakhs record which has to export to Excel(.xls). How to split the recors into 65000 each and export to a single excel file with multiple number of sheets.
The database which i am using is oracle. Can any one help me with this either via query in oracle or through coding.
Thanks,
N Padmanabhan.
|
|
|
|
|
|
Thanks for your help. That article is developed using 2008. But i need it in 2005.
|
|
|
|
|
ok, Sir;
try the following:
1. Start a new web project/site.
2. copy the code and paste it and into new files.
3. build the project/site.
4. run the project/site.
Good Luck
Help people,so poeple can help you.
|
|
|
|
|
When i click on link button,an error occurs
The state information is invalid for this page and might be corrupted.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: The state information is invalid for this page and might be corrupted.
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MainMaster.master.cs" Inherits="MainMaster" EnableViewState="false" %>
How to solve this error?
|
|
|
|
|
|
I have search google,but I do'nt understand where is the problem.This error occures only whent i clicked link button.
|
|
|
|
|
Guys, i got stuck with the some functionality, which i really needed for a tool.. Can we create a ascx file at runtime??.
My tool uses ascx file, to display a widget.. Now i want to create widgets at runtime, so i need to create ascx file runtime. Is this Possible any answers?? Please help me to move forward.
Thanks in advance..!
|
|
|
|
|
So, you need an XML parser
Help people,so poeple can help you.
|
|
|
|
|
hi
i am using visual web developer 2010 express
i am new to it
1)is there any control which looks like a label but acts like a button if so i need to know it(labelbutton if any),where is it
2)i am having a button in master page on the click of which should go to an aspx page so how to call it can anyone help me with it.
K.Gayathri
|
|
|
|
|
Perhaps you need to learn a little of ASP.NET here:
- http://asp.net-tutorials.com/[^]
MalarGayu wrote: 1)
<asp:LinkButton ID="LinkButton1" runat="server">LinkButton</asp:LinkButton>
MalarGayu wrote: 2)
Set the onclick event of the button and access the onclick from code behind:
-Design View
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
- Codebehind
protected void Button1_Click( object sender, EventArgs e )
{
}
|
|
|
|
|
You can use Link Button,and to provide look like Linkbutton set properties as
<asp:LinkButton ID="LinkButton11" runat="server" Font-Underline="False"
CausesValidation="False" onclick="LinkButton2_Click"><font color="white" size="1">DEPARTMENTS</font></asp:LinkButton>
|
|
|
|
|
Hi,
I want to disable the checkbox if the gridview cell 4 has KS value.
Getting object reference not set in gv=Gridview1.SelectedRow
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow gv ;
gv =GridView1.SelectedRow;
if (gv.Cells[4].Text == "KS")
{
if (gv.RowType == DataControlRowType.DataRow)
{
CheckBox chkDelete = (CheckBox)gv.Cells[0].Controls[0];
chkDelete.Enabled = false;
}
}
}
Need help
Thanks
S.Guhananth
|
|
|
|
|
when working in .net 2010 ajax tap container does not appear but appear in .net 2008.
|
|
|
|
|
midosoft1 wrote: tap
Well, there's no "tap"...
You mean the ajax extension tab in the toolbox?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
no i talked about AjaxTabContainer Control the ajax control.
|
|
|
|
|
midosoft1 wrote: AjaxTabContainer Control the ajax control
I thought so but with your typo I was only asking for clarity.
http://weblogs.asp.net/yousefjadallah/archive/2010/04/16/installing-ajax-control-toolkit-4-in-visual-studio-2010.aspx[^] might help you if you haven't already found this...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|