ASP.NET

Re: Import excel data in sqlserver 2000 without using DTS

18-Feb-10 0:48

R u looking For this..!
Import Data from Excel to SQL Server[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

farogh haider18-Feb-10 1:39

farogh haider

18-Feb-10 1:39

Thanks alot,
It's working fine.

can we use bulk insert.

Farogh Haider
Web developer

Re: Import excel data in sqlserver 2000 without using DTS

sashidhar18-Feb-10 1:40

Re: Import excel data in sqlserver 2000 without using DTS

18-Feb-10 1:40

Dont Forget to mark it answer if it helps..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

FEMDEV18-Feb-10 0:49

FEMDEV

18-Feb-10 0:49

If it's just a table that you need to get in excel, go for a excel macro.
not more then 5 lines of code.

Re: Import excel data in sqlserver 2000 without using DTS

sashidhar18-Feb-10 0:51

How to add Textbox Dynamically

18-Feb-10 0:51

He is asking using asp.net not vb macros brother..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

It_tech18-Feb-10 0:20

18-Feb-10 0:20

Hi all,

How can i add a TextBox on a form every time a row in a grid is added.The Gridview refreshes every two minutes for additional row and would like to have a text box next to the Row in a grid to leave a note about the data being added. So for each entry on a grid i would like to have a text box automatically created next to the new row on a gridview.So that i can leave some comments about the data being added on the grid.

Here is the Gridview :

<asp:GridView ID="gvResult" runat="server" AllowPaging="True" CellPadding="4"
Height="16px" Width="45px" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">

<EmptyDataTemplate>
<asp:Label runat="server">
NO Message List...
</asp:Label>
</EmptyDataTemplate>
<Columns>

<asp:BoundField DataField="CR_CLI" HeaderText="CR_CLI"
SortExpression="CR_CLI" />

How Can I add a text Box that is Just Blank after each Row on a Grid

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:vp2ConnectionString %>"
SelectCommand="SELECT CR_CLI FROM Call WHERE (CR_CLI LIKE '7%') ORDER BY CR_CLI DESC">
</asp:SqlDataSource>

sashidhar18-Feb-10 0:46

18-Feb-10 0:46

R u Looking For This..!

http://www.c-sharpcorner.com/UploadFile/Art%20Scott/GridViewInsertANewRow09012006165053PM/GridViewInsertANewRow.aspx[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

It_tech18-Feb-10 1:12

18-Feb-10 1:12

Many thanks for your help.Its Much appreciated.
I dont really need the Edit and Delete Row.What I need is to add a text box Netx to each entry record on a Grid.

Lets Say for instance a gridview has one column and has three rows od data showing on the form.

CR_Cli
777777 ---- I need a textbox 1
88888 ---- textbox 2
8888 ------ Textbox 3 etcc.....

after each entry on a Gridview i need a blank text box Next to it.

Can you please advice on this one?

sashidhar18-Feb-10 1:24

Re: How to add Textbox Dynamically [modified]

18-Feb-10 1:24

What is the condition for adding a textbox, or you need it consecutive rows..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

It_tech18-Feb-10 1:38

18-Feb-10 1:38

Thanks so Much for your help.The condition is every time a new record is being added to a gridview a corrsponding textbox should be created.

The page refreshes every few seconds to see data coming through.When the grid gets three record for instance we need to have a corresponding three textbox to leave a comment about each entry.

The textbox shouldnt be a databind control.

Thanks

-- Modified Thursday, February 18, 2010 7:44 AM

sashidhar18-Feb-10 1:50

18-Feb-10 1:50

By Default Keep the gridview column as textbox and then in pageload change the textbox in template field to label and add the data..!
I didnt tried but i think it will hellp u.

<asp:GridView ID="GridView1" runat="server"
    AutoGenerateColumns="False" DataKeyNames="EmployeeID"
    DataSourceID="ObjectDataSource1">
    <Columns>
        <asp:BoundField DataField="LastName" HeaderText="LastName"
          SortExpression="LastName" />
        <asp:TemplateField HeaderText="Hai">
            <ItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

It_tech18-Feb-10 2:17

18-Feb-10 2:17

Thanks so Much.It works very well.Sorry to bother you how can i link First row in a grid to the first textbox so that the Note left on the grid corresponds to each row and textbox?

Many thanks

It_tech18-Feb-10 3:01

To set image for the condition in crystal report

18-Feb-10 3:01

Are you there?

JC.KaNNaN18-Feb-10 0:11

JC.KaNNaN

18-Feb-10 0:11

HI all,
I'm working with crystal report.i have generated report successfully by using dataset.In that i have few columns that populates True Or False value.
the thing is i want to set one image(say red colour) if the value is 'true' and another image(say green colour) if it is 'false'.. how can i do this, In using crystalreport in web appliction....
I know that there is some way to set the ' if- else' condition, But i don't know how to do it.
Please help me..

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Re: To set image for the condition in crystal report

tronix0118-Feb-10 6:24

tronix01

18-Feb-10 6:24

just right-click to the "picture-field" and click format object,
then click general and check suspend.

after that, press the x-2 button and write the a formel like that in it:

if ({myBoolField} = true) then<br />
    false <br />
else<br />
    true;

that means:
if myBoolField = true don't suspend the "picture-field", else suspend the "picture-field"

see also:
http://msdn.microsoft.com/en-us/library/ms225356%28VS.80%29.aspx[^]

hope this helps

UrlRewriting depends on the Browser-Language

tronix0117-Feb-10 23:38

tronix01

17-Feb-10 23:38

hello

i'm looking for some help for the following problem.

i developed a asp.net 2.0 multilanguage webpage using localization with resource-files (FR and EN content).
all of my aspx - pages are in the same folder but i want that the search engines detect the text of both languages.

to solve that problem i atteched the Intelligencia.UrlRewriter.dll from www.urlrewritingnet.com to my project.

later i've implement the following rule in my web.config file to make the french-content visible for the search engines

<rewrite name="rule1" url="^/(.*)/(.*)/fr/(.*).aspx" to="/$1/$2/$3.aspx"></rewrite>

that means, if someone enters directly:
www.mypage.com/folder1/folder2/fr/default.aspx
it will be rewritten to:
www.mypage.com/folder1/folder2/default.aspx

is that enough to make the french-content visible for the search engines ?

and...

how can i redirect or rewrite from
www.mypage.com
to
www.mypage.com/folder1/folder2/fr/default.aspx ,
if anybody enters the website and uses fr-FR as the default browser-language ?

How can i solve that ?

thanks for any help

arkiboys17-Feb-10 23:21

arkiboys

17-Feb-10 23:21

Hello,
In code, how can I change the user's role from one to another?
Let's say the user1 is in Role1. I would like to change his role to Role2
Thanks

Re: login roles - c#

Gaurav Dudeja India17-Feb-10 23:47

Gaurav Dudeja India

17-Feb-10 23:47

see this ASP.NET Security[^]

Re: login roles - c# [modified]

sashidhar18-Feb-10 0:20