|
It has the following error..
The type or namespace name 'dbdatarecord' could not be found (are you missing a using directive or an assembly reference?)
|
|
|
|
|
System.Data.Common.DbDataRecord
I didn't get any requirements for the signature
|
|
|
|
|
The following error came?
The type or namespace name 'dbdatarecord' could not be found (are you missing a using directive or an assembly reference?)
Where to add this line? Please explain briefly?
|
|
|
|
|
replace dbdatarecord with System.Data.Common.DbDataRecord
I didn't get any requirements for the signature
|
|
|
|
|
Can some body tell me how to implement one to one chat in Asp.net application like gmail. I simply can not figure out any solution. I tried to google this but everything I am getting is group chat like chat room. I need one to one chat. Like when you login to the application it will show the list of users online. Click on one user to chat with him/her only. Any kind of help will be appreciated.
Plz plz plz help me....
Sagar Pattnayak
Software Developer
Sun-Dew Solutions
+91-9831169962
|
|
|
|
|
Hi all, I have the same question here. I am trying to build a chat application for my webpage. What i need to do have is implement private chat. So far i have done the chat application using a database and using a timer which checks every 3-5 secs to refresh the messages.
My question is :
I need to eliminate the use of timer and want to implement it as a condition. i.e only if the user enters a chat into the box should the other person refresh his text box and it shouldnt be run on a timer. Is it possible? Please help.
|
|
|
|
|
Hi
How can I implement weather API of http://www.accuweather.com
in website.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
trilokharry wrote: How can I implement weather API of http://www.accuweather.com
With code?
I didn't get any requirements for the signature
|
|
|
|
|
Hi my gridview in inside the update panel..
then also my events are getting postback , whas the probs? y update panel is not working for me?
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Member 3879881 wrote: Hi my gridview in inside the update panel..
then also my events are getting postback , whas the probs? y update panel is not working for me?
I didn't get your problem. If your control is inside the Updatepanel, then that part will take part in the post back. Then what is your problem ?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi Jana thansk for ur reply,
My problem is if we mention anything in updatepanel control , the page wont get postback...,
But for me its getting postback...,
This is what my prob...,
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Which control event are your firing for post back ? Is it inside Update panel or outside of update panel ? Can you please put those line of code over here.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
My Gridview is inside the update panel ...,
I have sorting and paging on it...,
Both the things getting postback...,
SAmple code:
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:GridView ID="UsualVolUp" CellPadding="0" CellSpacing="0" AutoGenerateColumns="False"
runat="server" Width="100%" GridLines="None" OnRowCommand="UsualVolUp_RowCommand"
OnRowDataBound="UsualVolUp_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="Change (Rs.)" HeaderStyle-CssClass="GridHeadC Rborder"
ItemStyle-CssClass="GridDataR Rborder" ItemStyle-Wrap="False" ItemStyle-VerticalAlign="middle">
<HeaderTemplate>
Change
<br>
(Rs.)
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="netchg" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Volume <br> (000's)" HeaderStyle-Wrap="true"
ItemStyle-CssClass="GridDataR_Alt Rborder"
ItemStyle-VerticalAlign="middle" ItemStyle-Wrap="true" HeaderStyle-CssClass="GridHeadC Rborder"
HeaderStyle-ForeColor="#ffffff" SortExpression="Vol_Traded">
<HeaderTemplate>
<asp:LinkButton CssClass="blcktxt" ID="lnkbtnVol_Traded" runat="server" CommandArgument="Vol_Traded" CommandName="Sort">Volume <br> (000's)</asp:LinkButton>
<asp:PlaceHolder ID="placeholderVol" runat="server"></asp:PlaceHolder>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="Volume" runat="server"></asp:Label>
</ItemTemplate>
<ItemStyle Width="25%" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Diff (000's) " HeaderStyle-CssClass="GridHeadC Rborder"
ItemStyle-CssClass="GridDataR Rborder" ItemStyle-Wrap="False" ItemStyle-VerticalAlign="middle">
<HeaderTemplate>
Diff
<br>
(000's)
</HeaderTemplate>
<ItemStyle CssClass="GridDataR Rborder"></ItemStyle>
<ItemTemplate>
<asp:Label ID="Diff" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView></td></tr>
<tr id="PrevNext" runat="server">
<td align="right" colspan="5">
<asp:LinkButton ID="prev" runat="server" OnClick="Lower_PrevClick" Text="Prev" CssClass="PagerLink1"></asp:LinkButton>
<asp:LinkButton ID="next" runat="server" OnClick="Lower_NextClick" Text="Next" CssClass="PagerLink1"></asp:LinkButton>
</td>
</tr>
<tr id="TR_NoData" runat="server" visible="false">
<td colspan="5" class="Nodata" align="center">
No Data Found</td>
</tr>
</table>
</ContentTemplate>
</asp:UpdatePanel>
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Member 3879881 wrote: <asp:updatepanel id="UpdatePanel1" runat="server" xmlns:asp="#unknown">UpdateMode="Conditional">
Why did you make UpdateMode="Conditional" ? .
Did you call UpdatePanel1.Update() from any where of you code ?
If you change the UpdateMode from Always to Conditional, you need to call Update() method Explicitly for Update that Panel. And I think this is the reason .
Try to Make it "Always" Or if you don't need it to postback always, Just call UpdatePanel1.Update() while Paging and Sorting from Codebehind. That will resolve your problem.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi if i didnt give updatemode its default value always...,
Then also i am getting postback only...,
Sample i have created one form in my webapplication
In side my update panel one textbox and one button is there...,
wHEN I Click the button the textbox will get text as "hi"...,
This one also getting postback...,
whats teh excat probs?, im't getting...,
In my server system i have installed framework 2.0 and ajax extension...,
y its getting postback for the button click event
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Hello Brothers pls helpme,
I want to create bogagregator site .
users can update blog'posts or url and title.
usres can rerieve it (title) as links from database to gridview .
How can i make titles are the links of posts(urls)
here is the code:
<>
&lt;asp:GridView ID="GridView1" runat="server" CellPadding="4" Font-Bold="True" Font-Names="Courier New"
Font-Size="13pt" ForeColor="#333333" GridLines="None" Style="z-index: 119; left: 17px;
position: absolute; top: 422px" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"&gt;
&lt;FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /&gt;
&lt;RowStyle BackColor="#CCCCFF" ForeColor="#333333" /&gt;
&lt;EditRowStyle Font-Bold="True" ForeColor="#804000" /&gt;
&lt;SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /&gt;
&lt;PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" /&gt;
&lt;HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /&gt;
&lt;AlternatingRowStyle BackColor="White" /&gt;
&lt;Columns&gt;
&lt;asp:BoundField DataField="title" HeaderText="title" SortExpression="title" /&gt;
&lt;asp:BoundField DataField="url" HeaderText="url" SortExpression="url" /&gt;
&lt;asp:BoundField DataField="languages" HeaderText="languages" SortExpression="languages" /&gt;
&lt;asp:BoundField DataField="categories" HeaderText="categories" SortExpression="categories" /&gt;
&lt;asp:BoundField DataField="description" HeaderText="description" SortExpression="description" /&gt;
&lt;asp:BoundField DataField="author" HeaderText="author" SortExpression="author" /&gt;
&lt;asp:BoundField DataField="city" HeaderText="city" SortExpression="city" /&gt;
&lt;asp:BoundField DataField="country" HeaderText="country" SortExpression="country" /&gt;
&lt;asp:BoundField DataField="date" HeaderText="date" SortExpression="date" /&gt;
&lt;/Columns&gt;
&lt;/asp:GridView&gt;
|
|
|
|
|
Simple way is to use template field and a Hyperlink field inside that template field.
|
|
|
|
|
<asp:ScriptManager runat="server" ID="ScriptMangaer1">
</asp:ScriptManager>
<div id="MainBody" class="MainBody">
<table>
<tr>
<td>
<table>
<tr>
<td>
<asp:UpdatePanel ID="updtpnlDDL" runat="server">
<ContentTemplate>
<asp:DropDownList ID="ddlCategory" runat="server" AutoPostBack="True" >
</asp:DropDownList>
<ajaxToolkit:CascadingDropDown ID="CascadingDropDown1" runat="server"
Category="Category"
TargetControlID="ddlCategory"
PromptText="Category"
LoadingText="Please Wait..."
ServicePath="FindCategory.asmx" ServiceMethod="GetCategoryWithAll">
</ajaxToolkit:CascadingDropDown><br />
<asp:DropDownList ID="ddlSubCategory" runat="server" AutoPostBack="True">
</asp:DropDownList>
<ajaxToolkit:CascadingDropDown ID="CascadingDropDown2" runat="server"
Category="SubCategory"
TargetControlID="ddlSubCategory" ParentControlID="ddlCategory"
PromptText="Sub Category"
LoadingText="Please Wait..."
ServicePath="FindCategory.asmx" ServiceMethod="GetSubCategoryWithAll">
</ajaxToolkit:CascadingDropDown>
<asp:Button ID="btngo" runat="server" OnClick="btngo_Click" Text="Go" />
</ContentTemplate> </asp:UpdatePanel>
</td>
<td valign="top">
</td>
</tr>
</table>
</td>
<td>
</td>
</tr>
<tr>
<td>
<asp:UpdatePanel ID="UpdatePanelCat" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:DataList runat="server"
id="dlCategory"
CellPadding="0"
CellSpacing="0"
RepeatDirection="Horizontal"
RepeatColumns="3">
<HeaderTemplate>
<h3>
Category Details
</h3>
</HeaderTemplate>
<ItemTemplate>
<div class="CurrentNews">
<table>
<tr>
<td>
<b> <%#Eval("CatName")%> </b><br />(<%#Eval("CatDescription")%>)
</td>
</tr>
<tr>
<td colspan="1">
<div class="BorderRing">
<img src='../Handler.ashx?Size=S&ImageID=<%# Eval("ImageId") %>' alt='Thumbnail Photo of <%# Eval("ImageId") %>' />
</div>
</td>
</tr>
</table>
</div>
</ItemTemplate>
</asp:DataList>
</ContentTemplate>
</asp:UpdatePanel>
<asp:UpdatePanel ID="UpdatePanelSubCat" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:DataList runat="server"
id="dlSubCategory"
CellPadding="0"
CellSpacing="0"
RepeatDirection="Horizontal"
RepeatColumns="3">
<HeaderTemplate>
<h3>
SubCategory Details
</h3>
</HeaderTemplate>
<ItemTemplate>
<div class="CurrentNews">
<table>
<tr>
<td>
<b> <%#Eval("SubCatName")%> </b><br />(<%#Eval("SubCatDescription")%>)
</td>
</tr>
<tr>
<td colspan="1">
<div class="BorderRing">
<img src='../Handler.ashx?Size=S&ImageID=<%# Eval("ImageId") %>' alt='Thumbnail Photo of <%# Eval("ImageId") %>' />
</div>
</td>
</tr>
</table>
</div>
</ItemTemplate>
</asp:DataList>
</ContentTemplate>
</asp:UpdatePanel>
</td>
<td>
</td>
</tr>
</table>
<table>
<tr>
<td>
<asp:LinkButton ID="lnkCategory" runat="server">Add New Category</asp:LinkButton><br />
<asp:LinkButton ID="lnkSubCategory" runat="server">Add New Sub Category</asp:LinkButton>
</td>
</tr>
</table>
<ajaxToolkit:ModalPopupExtender ID="ModalPopUpforCategory"
runat="server"
BackgroundCssClass="modalBackground"
DropShadow="true"
PopupControlID="pnlCategory"
TargetControlID="lnkCategory"
CancelControlID="btnClose" >
</ajaxToolkit:ModalPopupExtender>
<asp:Panel id="pnlCategory" runat="server" style="display:none" cssclass="modalPopup">
<asp:UpdatePanel runat="server" ID="updatePanelCategory" UpdateMode="conditional">
<ContentTemplate>
<asp:DetailsView ID="dvCategory"
runat="server"
AutoGenerateRows="False"
AllowPaging="True"
DataKeyNames="CatCode"
CssClass="dvTextAlign">
<Fields>
<asp:TemplateField HeaderText="Category Code">
<EditItemTemplate>
<asp:TextBox ID="txtCatCode" runat="server" Text='<%# Bind("CatCode") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="txtCatCode" runat="server" ></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblCatCode" runat="server" Text='<%# Bind("CatCode") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Category Name">
<EditItemTemplate>
<asp:TextBox ID="txtCatName" runat="server" Text='<%# Bind("CatName") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Category Name is Necessary" ControlToValidate="txtCatName" Display="None"></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="ValidatorCalloutExtender1" runat="server" TargetControlID="RequiredFieldValidator1" HighlightCssClass="ValidCheck" >
</ajaxToolkit:ValidatorCalloutExtender>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="txtCatName" runat="server" Text='<%# Bind("CatName") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Category Name is Necessary" ControlToValidate="txtCatName" Display="None"></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="ValidatorCalloutExtender1" runat="server" TargetControlID="RequiredFieldValidator1" HighlightCssClass="ValidCheck" >
</ajaxToolkit:ValidatorCalloutExtender>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblCatName" runat="server" Text='<%# Bind("CatName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<custom:longtext DataField="CatDescription" HeaderText="Category Description" Height="100px" Width="250px" />
<asp:TemplateField HeaderText="Hot Category">
<EditItemTemplate>
<asp:DropDownList ID="ddlCategory" runat="server">
<asp:ListItem Selected="True" Value="N">Normal</asp:ListItem>
<asp:ListItem Value="H">Hot</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="ddlCategory" runat="server">
<asp:ListItem Selected="True" Value="N">Normal</asp:ListItem>
<asp:ListItem Value="H">Hot</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblHotCategory" runat="server" Text='<%# Bind("HotCategory") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Photo">
<ItemTemplate>
<table border="0" cellpadding="0" cellspacing="0" class="photo-frame">
<tr>
</tr>
<tr>
<td><img src='../Handler.ashx?Size=S&ImageId=<%# Eval("ImageId") %>' class="photo_198" style="border:2px solid white;width:50px;" alt='Thumbnail of Photo Number <%# Eval("CatName") %>' /></td>
</tr>
</table>
</ItemTemplate>
<EditItemTemplate>
<asp:FileUpload ID="fUpPhoto" runat="server"/>
</EditItemTemplate>
<InsertItemTemplate>
<asp:FileUpload ID="fUpPhoto" runat="server"/>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="">
<EditItemTemplate>
<asp:Label ID="lblError" runat="server" Text=""></asp:Label>
</EditItemTemplate>
<InsertItemTemplate>
<asp:Label ID="lblError" runat="server" Text=""></asp:Label>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblError" runat="server" Text=""></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
</ContentTemplate>
</asp:UpdatePanel>
<div style="text-align: right; width: 100%; margin-top: 5px;">
<asp:Button ID="btnClose" runat="server" Text="Close" Width="50px" CausesValidation="False" />
</div>
</asp:Panel>
<ajaxToolkit:ModalPopupExtender ID="ModalPopupForSubCategory"
runat="server"
BackgroundCssClass="modalBackground"
DropShadow="true"
PopupControlID="pnlSubCategory"
TargetControlID="lnkSubCategory"
CancelControlID="btnClose" >
</ajaxToolkit:ModalPopupExtender>
<asp:Panel id="pnlSubCategory" runat="server" style="display:none" cssclass="modalPopup">
<asp:UpdatePanel runat="server" ID="updatePanelSubCategory" UpdateMode="conditional">
<ContentTemplate>
<asp:DetailsView ID="dvSubCategory"
runat="server"
AutoGenerateRows="False"
AllowPaging="True"
DataKeyNames="SubCatCode"
CssClass="dvTextAlign">
<Fields>
<asp:TemplateField>
<EditItemTemplate>
<asp:DropDownList ID="ddlCategory" runat="server">
</asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="ddlCategory" runat="server">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblCategory" runat="server" Text='<%# Bind("CatName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="SubCategory Code">
<EditItemTemplate>
<asp:TextBox ID="txtSubCatCode" runat="server" Text='<%# Bind("SubCatCode") %>' ></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="txtSubCatCode" runat="server" Text='<%# Bind("SubCatCode") %>' ></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblSubCatCode" runat="server" Text='<%# Bind("SubCatCode") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="SubCategory Name">
<EditItemTemplate>
<asp:TextBox ID="txtSubCatName" runat="server" Text='<%# Bind("SubCatName") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="SubCategory Name is Necessary" ControlToValidate="txtSubCatName" Display="None"></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="ValidatorCalloutExtender1" runat="server" TargetControlID="RequiredFieldValidator1" HighlightCssClass="ValidCheck" >
</ajaxToolkit:ValidatorCalloutExtender>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="txtSubCatName" runat="server" Text='<%# Bind("SubCatName") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="SubCategory Name is Necessary" ControlToValidate="txtSubCatName" Display="None"></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="ValidatorCalloutExtender1" runat="server" TargetControlID="RequiredFieldValidator1" HighlightCssClass="ValidCheck" >
</ajaxToolkit:ValidatorCalloutExtender>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblSubCatName" runat="server" Text='<%# Bind("SubCatName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<custom:longtext DataField="SubCatDescription" HeaderText="SubCategory Description" />
<asp:TemplateField HeaderText="Photo">
<ItemTemplate>
<table border="0" cellpadding="0" cellspacing="0" class="photo-frame">
<tr>
<td><img src='../Handler.ashx?Size=S&ImageId=<%# Eval("ImageId") %>' class="photo_198" style="border:2px solid white;width:50px;" alt='Thumbnail of Photo Number <%# Eval("SubCatName") %>' /></td>
</tr>
</table>
</ItemTemplate>
<EditItemTemplate>
<asp:FileUpload ID="fUpPhoto" runat="server"/>
</EditItemTemplate>
<InsertItemTemplate>
<asp:FileUpload ID="fUpPhoto" runat="server"/>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<EditItemTemplate>
<asp:Label ID="lblError" runat="server" Text=""></asp:Label>
</EditItemTemplate>
<InsertItemTemplate>
<asp:Label ID="lblError" runat="server" Text=""></asp:Label>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblError" runat="server" Text=""></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
</ContentTemplate>
</asp:UpdatePanel>
<div style="text-align: right; width: 100%; margin-top: 5px;">
<asp:Button ID="Button1" runat="server" Text="Close" Width="50px" CausesValidation="False" />
</div>
</asp:Panel>
</div>
|
|
|
|
|
Actually there is problem with Validation remove the Validation All r working Fine.Thank You
|
|
|
|
|
Hi...
I have developed a site through ASP.NET using VB. Whenever i go to the site, I am only able to visit the static pages. As soon as I try to visit any page linked to registration completion or the login completion, I am getting the following error:
"Server error in / Application"
Please reply as soon as possible for the solution to the given issue...
Thanks n Regards,
Gaurav
|
|
|
|
|
Could you please tell the details of the error.
One possible reason may be that you are not able to connect to Database. Please check connection string and database connection.
|
|
|
|
|
Hi Anurag.... thanx for the response... The complete error code that is visible to me is as follows:
"Server Error in / Application"
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
|
|
|
|
|
Hi all,
I am new to sapi 5.1.I am using this in an web application.Actually my requirement is to produce mp3 format as output using sapi 5.1.I can able to get wav as output.I dont want any third party sofwares to convert this.I want sapi only to get mp3 as output.Can anyone plz help me.i am running out with this issue for past 1 week.
|
|
|
|
|
Hi Friends,
I have data in excel and i want to transfer data from excel to datagrid,
having columns name,date of join and salary,how can i transfer excel data
to grid. pls let me know how to make the connection, can you send the code for that.
Regards,
Arpita
|
|
|
|
|
First of all, if you want to show your Excel data in a datagridview on an aspx page, you have to upload that spreadsheet onto the server. Best way - use the FileUpload control.
I'm only going to show you one way of doing what you want to do. If you don't like it, at least you'll have some reference on how to approach it.
To "make the connection" with an excel spreadsheet, you need to add reference to Interop.Excel.dll, Interop.Microsoft.Office.Core.dll and Interop.VBIDE.dll in your project first.
Then, in your code:
using System.Data.OleDb;
private void ExcelToGrid()
{
DataTable dt = new DataTable("sheet");
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + MapPath("Yourfilename.xls";extended properties=Excel 8.0");
OleDbDataAdapter SheetAdapter = new OleDbDataAdapter("select * from [$Sheet1]", conn);
SheetAdapter.Fill(dt);
DataGridView1.DataSource = dt;
DataGridView1.DataBind();
}
That should really do the trick. Obviously, you need to change $Sheet1 to whatever your sheet is called in the spreadsheet. And read up on versions of the Jet engine - i can't guarantee it's gonna work with all the living versions of Excel.
var question = (_2b || !(_2b));
modified on Monday, February 23, 2009 7:05 AM
|
|
|
|