|
Here is the C#.NET code...
// Connection String to Excel Workbook
string excelConnectionString = @"Provider=Microsoft .Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
// Create Connection to Excel Workbook
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]", connection);
connection.Open();
// Create DbDataReader to Data Worksheet
using (DbDataReader dr = command.ExecuteReader())
{
// SQL Server Connection String
string sqlConnectionString = "Data Source=.; Initial Catalog=Test;Integrated Security=True";
// Bulk Copy to SQL Server
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "ExcelData";
bulkCopy.WriteToServer(dr);
}
}
}
|
|
|
|
|
Hy,
I have a requirement in which i have to show multiple files in a single iframe at one go so dat i can print them at a single click without having to open print dialog multiple times.The file type can be .pdf,.xls,.txt ets.
Please help
|
|
|
|
|
I have a gridview in my form which I am populating data using SqlDataSource. The gridveiw has insert, update and delete. But somehow I forgot to write the RowEditingEvent.
Upon my surpise, when I clicked on Edit button in the grid while executing, the row automatically become editable. Obviously, I have declared the columns with EditItemTemplate.
Is the RowEditing Event not required when I use ObjectDataSource or SqlDataSource? I couldn't find such event in the msdn example also MSDN Link
Thanks
meeram395.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
|
Hello team,
I am in a very critical situation, wherein I will have to take an important decision. I have some existing C programs. Those C programs takes input from .DBF (dBase III) files and .BTR (BTRIEVE) files.
I have been given 2 options:
1) Convert .DBF files to .BTR files and .BTR files to .DBF files. These convertion can be done using .NET. If yes, give me some code snippets or some links where I can get the code.
2) Or using .NET is there any other way to replace this BTRIEVE concept itself? In other ways, instead of BTRIEVE, can we go for some other technology?
Pls advise....
|
|
|
|
|
Is there anyone who can respond to my query. This is bit urgent...Pls help me out...
|
|
|
|
|
currently i m using asp.net 2005 with c# (framework 2.0). i want to restrict the user to click the save button twice or more than that. Using ajax, i implemented it
<ajaxToolkit:AnimationExtender ID="Anibtnsave" runat="server" TargetControlID="btnsave">
<Animations>
<OnClick>
<EnableAction Enabled="false" /></OnClick>
</Animations>
</ajaxToolkit:AnimationExtender>
the above block will disable the button. its working fine. but i used few validation controls (ajaxToolkit:ValidatorCalloutExtender).
when i click the button the validation pop-ups and also button getting disable. please help me. - KARAN
|
|
|
|
|
Try this:
private void checkButtonDoubleClick(Button button)
{
System.Text.StringBuilder sbValid = new System.Text.StringBuilder();
sbValid.Append("if (typeof(Page_ClientValidate) == 'function') { ");
sbValid.Append("if (Page_ClientValidate() == false) { return false; }} ");
sbValid.Append("this.value = 'Please wait...';");
sbValid.Append("this.disabled = true;");
sbValid.Append(this.Page.ClientScript.GetPostBackEventReference(button, ""));
sbValid.Append(";");
button.Attributes.Add("onclick", sbValid.ToString());
}
Copied from here
http://forums.asp.net/t/1362149.aspx[^]
|
|
|
|
|
Nice ideas in this thread. I like.
|
|
|
|
|
great arun. thanks a lot.
also the same i would like to apply for an dropdownlist. because according to the selection of dropdown value, i m changing the button textvalue. according to the text value i m calling different functions.so when user select the dropdownlist item, it take some time. during that time, user should not click the button obviously.
so i want to disable the button while user selecting item from dropdownlist until the text changes.
how to achieve it? help me - KARAN
|
|
|
|
|
Dear Tech Guys,
I want to know ,how to develop messenger with Video chat like Yahoo messenger.
Please provide reference articles.
Thanks
Srinivas
|
|
|
|
|
You look like too lazy to even Google it out. I am sure there would be no point asking what have you tried till now.
Go here:
http://www.google.com
http://www.codeproject.com
Use keywords like - chat, messenger, etc. You will get lots of articles.
|
|
|
|
|
(sigh) People these days are used to spoonfeeding. Help yourself buddy. research first on what you want to do and then based on your researches, ask questions. It would be an interesting discussion if it was done that way.
|
|
|
|
|
Hi All,
i want to integrate google calender api in .net how to do this.please help me to do this?
Thanks ,
Amit Patel
|
|
|
|
|
|
|
Following is my code for login:
void Page_Load(object sender, EventArgs e) {
string appURL = "http://www.mysite.com/Login.aspx";
string strPostData = String.Format("login={0}&password={1}",
"myloginname", "mypassword");
// Setup the http request.
HttpWebRequest wrWebRequest = WebRequest.Create(appURL) as
HttpWebRequest;
wrWebRequest.Method = "POST";
wrWebRequest.ContentLength = strPostData.Length;
wrWebRequest.ContentType = "application/x-www-form-urlencoded";
wrWebRequest.CookieContainer = new CookieContainer();
// Post to the login form.
StreamWriter swRequestWriter = new
StreamWriter(wrWebRequest.GetRequestStream());
swRequestWriter.Write(strPostData);
swRequestWriter.Close();
// Get the response.
HttpWebResponse hwrWebResponse =
(HttpWebResponse)wrWebRequest.GetResponse();
// Have some cookies.
CookieCollection ccCookies = hwrWebResponse.Cookies;
// Read the response
StreamReader srResponseReader = new
StreamReader(hwrWebResponse.GetResponseStream());
string strResponseData = srResponseReader.ReadToEnd();
srResponseReader.Close();
// Display the response.
Response.Write(strResponseData);
}
It logs me in successfully but when I click on any link, it logs out.
Please let me know what's going wrong.
|
|
|
|
|
From Your code it looks like you are login from other side,
What you need to do is when you login successfully you need to set session values,
And when you go to other page check this value so you will not log out.
hint is when you sent login successfully response from other site, send some values like 'userid',
and set this id session value.
|
|
|
|
|
Please provide detailed description about delegates and events. i am get little confuse in both.
1:need of delegate in asp.net??
|
|
|
|
|
|
|
You don't know about www.google.com
|
|
|
|
|
Hi
I am using AJAX TabContainer control with following settings. When I change a tab the postback happens and whole page refreshes. Because AutoPostBack="true"> . To AJAxify the behavior, I added UpdatePanel around it but still the page is refreshing. The control need to go to server because user controls contains some grids which need to be populated.
<br />
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager><br />
<asp:UpdatePanel ID="upTLTop" runat="server" UpdateMode="Conditional"><br />
<ContentTemplate><br />
<br />
<AjaxCT:TabContainer ID="tcProducts" runat="server" ActiveTabIndex="0" Style="height: 100%;<br />
vertical-align: top; margin: 0px; padding: 0px;" OnActiveTabChanged="Products_OnActiveTabChanged" AutoPostBack="true"><br />
<AjaxCT:TabPanel runat="server" HeaderText="MBS" ID="pnlMBS"><br />
<ContentTemplate><br />
<uc1:ucA ID="ucA1" runat="server" /><br />
</ContentTemplate><br />
</AjaxCT:TabPanel><br />
<AjaxCT:TabPanel runat="server" HeaderText="ABS" ID="TabPanel1"><br />
<ContentTemplate><br />
<uc2:ucB ID="ucB1" runat="server" /><br />
</ContentTemplate><br />
</AjaxCT:TabPanel><br />
</AjaxCT:TabContainer><br />
</ContentTemplate><br />
</asp:UpdatePanel><br />
<br />
<br />
How can I disable the page refresh and at the same time server side operation happens in this case?
Please advise. Thanks
AJ
Follow your goals, Means will follow you ---Gandhi---
|
|
|
|
|
Hi
I have two user controls on one aspx page. UC1 has a grid which contains a link button column which user clicks. Based on the value of clicked cell, I need to show some data into UC2.
1. How do I pass data from UC1 to UC2?
2. How do I invoke a function of UC2 from UC1?
Please advise. Thanks
AJ
Follow your goals, Means will follow you ---Gandhi---
|
|
|
|
|
mittalpa wrote: 1. How do I pass data from UC1 to UC2?
You can make use of Session or Delegates here.
mittalpa wrote: 2. How do I invoke a function of UC2 from UC1?
If it is a method needed by both the user controls, place it in a separate class and have it public/internal. Then call it from both the user controls.
|
|
|
|