ASP.NET

HOW TO INSERT DATA FROM A TABLE IN my ASP page TO SQL SERVER DATABASE [modified]

23-May-10 12:43

Hi,

Yes your right, i only need to specify the OriginalString part. I solved the problem by using the debugger after i replied to your previous message.

When i was developing a Windows Form application I was using HTTpRequests etc and assigning the values to a picture box.

Thanks for the help.

ihbos22-May-10 20:32

ihbos

22-May-10 20:32

SALAM,
i use C# with ASP.NET.
I CREATE A TABLE IN MY PAGE ASP AND WHEN A USER INSERT DATA (int num,smalldate date,varbinary fichier)ON THE TABLE AND CLICK A BUTTON "DEPOT DOSSIER",so data will add to database.
my problem how to insert image and date and num from table in asp page to databse sqlserver .
and this what exactly i want to do with 2 photo: link to first photo http://pics.imagup.com/ano1/1274640272.jpg
and when the folder is created it must be like this: link to second photo

http://img62.imageshack.us/img62/5113/administrateurcert.png
Note: images show like a url in the ASP page.

can i use gridview in some case?
SALAM .

modified on Sunday, May 23, 2010 2:38 AM

Re: HOW TO INSERT DATA FROM A TABLE IN my ASP page TO SQL SERVER DATABASE

Not Active23-May-10 3:30

Re: HOW TO INSERT DATA FROM A TABLE IN my ASP page TO SQL SERVER DATABASE

23-May-10 3:30

This[^] shows how to insert images to database.

ihbos wrote:
can i use gridview in some case?

GridView is for display. Manipulating the data and inserting or retrieving from a database is separate.

I know the language. I've read a book. - _Madmatt

ihbos23-May-10 8:23

ihbos

23-May-10 8:23

thank you for your help
but i want to know how i can add data (string or date or int) which user insert into my table page ASP to my database table sqlserver .
Thanks and Salam.

Re: HOW TO INSERT DATA FROM A TABLE IN my ASP page TO SQL SERVER DATABASE

Not Active23-May-10 8:32

make different menu for site

23-May-10 8:32

There are so many examples of how to insert data into a database in books, articles, online, etc. Are you saying you have never seen any example? OMG | :OMG:

If so, then you need more help than we can give you here.

I know the language. I've read a book. - _Madmatt

farasat.mohammad22-May-10 18:37

farasat.mohammad

22-May-10 18:37

hi,
i wish to create a menu like this Site: http://www.dhgate.com .
are there component to make it?
please help me .thanks a lot.

Re: make different menu for site

Sandeep Mewara22-May-10 20:39

Re: make different menu for site

22-May-10 20:39

farasat.mohammad wrote:
are there component to make it?

Yes. They can be done using Javascript, HTML !

There are lots of menu's (not exactly the same though, a simpler version) article in CodeProject itself. Search it, try to use the one looks fine to you. You can use, Javascript, jQuery, AJAX based menus to get it. Suit your requirement and knowledge!

farasat.mohammad23-May-10 19:46

farasat.mohammad

23-May-10 19:46

thanks .
but can u give me a link about that? Blush | :O

my search haven't good result

Problem with declaring namespace

Eagle3222-May-10 12:21

Count number of records from a tabel and display result in a gridview column at run time.

22-May-10 12:21

Hi,

I am trying to use an External Web Service in my Web Site application i am developing. The problem occurs when declaring the namespace such as this:

using namespace.classname

Error: The type or namespace cannot be found.

Does this mean i have to put the C# class file into App_Code folder?

I was wondering if somebody could help me please in terms of replicating the problem i am facing? I am trying to use the following web service:

IMDB Web Service

I have followed the instructions but it still doesnt work. I have even copied the following code from the generated output file which you will see when you access the above URL into my global WebConfig file and it still doesnt work.

I am using .NET Framework 3.5 and VS 2008.

Thanks & Regards,

Eagle3222-May-10 11:58

Re: Count number of records from a tabel and display result in a gridview column at run time.

22-May-10 11:58

Hi I am using a gridview to display data from my table at runtime. I am new to ASP.NET.

I am not using boundfields but I am using Template fields. I specify the HeaderText and DataKeys

I am using a web service to provide me a DataSet of the chosen table and bind it to the GridView in page_load event.

I would like to count the number of records from a chosen table and display that in the Gridview.

I have written a method to return number of records by passing in a string parameter product name
but i am not sure of how to invoke the method so the value is shown in the GridView.

How could i go about doing this?

Do i need to invoke the method using Eval like this:

<asp:TemplateField HeaderText="ProductName" SortExpression="ProductName">
      <ItemTemplate>
       <%#GetRowCount(Eval(ProductName))%>
  </ItemTemplate>
</asp:TemplateField>

Would the above work?

Thanks,

Sandeep Mewara22-May-10 20:35

Re: Count number of records from a tabel and display result in a gridview column at run time.

22-May-10 20:35

Why to hit performance(and extra code!) so much when you can get the same information in the dataset of gridview along with other data?

Using webservice when you are getting data, also retrieve the count of rows in it.
Or, if you cannot do that, then before using it as a source to grid, append the count of rows to dataset and use the modified dataset as datasource of your grid. You are all set!

Eagle3223-May-10 1:32

Changing color on Boundfield text content

23-May-10 1:32

Can you provide me an example please if you dont mind?

Thanks,

lvq68422-May-10 8:21

lvq684

22-May-10 8:21

Hi.

I have this updatepanel, with some fields that are getting filled from an ObjectDataSource.
One of the fiels are a date, and i want this date to be marked as red (and maybe in bold) if the date is one day from today or later.

Problem is, I have no clue on how to do this, since I am new to asp.net!
So is there a way to add a method that changes this specific ItemStyle-ForeColor based on the content i get from my datalayer?

This is my updatepanel:

<asp:UpdatePanel ID="updatePanel" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <asp:GridView Width="1200" ID="gvTasks" runat="server" OnRowCreated="gvTasks_RowCreated" 

                DataSourceID="odsTaskList" GridLines="None" AutoGenerateColumns="false" CssClass="mGrid"
                PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" OnSelectedIndexChanged="GvTasks_SelectedIndexChanged"
                DataKeyNames="ID">

                <Columns>

                    <asp:BoundField DataField="Enddate2" HeaderText="Enddate" ItemStyle-ForeColor=RED-IF-OVERDUE-EXCEEDED ItemStyle-HorizontalAlign=Center>
                        <HeaderStyle Width="80px" HorizontalAlign="Center" />
                    <asp:BoundField>

                <Columns>
            <asp:GridView>
        <ContentTemplate>
    <asp:UpdatePanel>

Thanks alot!

Sandeep Mewara22-May-10 10:25

22-May-10 10:25

lvq684 wrote:
I have this updatepanel

It does not matter in your case.

lvq684 wrote:
i want this date to be marked as red (and maybe in bold) if the date is one day from today or later

You need to use RowDataBound of GridView for this.

protected void GridView_RowDataBound(Object sender, GridViewRowEventArgs e)
{  
   DataControlRowType rtype = e.Row.RowType;   
   if (rtype == DataControlRowType.DataRow && rtype != DataControlRowType.Footer 
       && rtype != DataControlRowType.Separator && rtype != DataControlRowType.Header 
       && rtype != DataControlRowType.Pager)   
   {  
      //Logic to get the color needed to be shown    
      Calendar cd = e.Row.FindControl("myCal") as Calendar;
      //Set whatever color you need to!
      cd.ForeColor = Color.Red;
   }
}

lvq68422-May-10 11:48

lvq684

22-May-10 11:48

Thanks alot for your answer, but I dont quite follow the code.
Whats up with the

Calendar cd = e.Row.FindControl("myCal") as Calendar;

And could you please paste the corresponding .aspx code for the Gridview please?

I am very grateful!

Sandeep Mewara22-May-10 20:31

22-May-10 20:31

I believe what i have provided is more than enough.

lvq684 wrote:
could you please paste the corresponding .aspx code

No! i wouldn't

lvq684 wrote:
but I dont quite follow the code

You said you have a calendar inside the grid, so that line gets the calendar control to you.

Looks like you are a fresher. Would suggest you to read book first.

how to draw vertical rule in asp.net

lvq68422-May-10 20:49

lvq684

22-May-10 20:49

Yes, as stated in the first post, I am new to asp.net.
It´s not a calendar but a simple string which holds the date. The date sorting is being issued elsewhere. But I´ll try changing the calendar to a string and fiddle with it.
Question is just how the page control calls this method. I will google some more.

Thanks.

developerit22-May-10 3:28

developerit

22-May-10 3:28

hi, iam using asp.net with c#,
in my page there are many images in top ,left , right,bottom i want to draw verticle line and horizontal lines like this as showed in below example .can you give example which helps me

||
image1 || || image9
|| ||
|| ||
image2 || || image9
|| ||
|| ||
|| ||
image3 || || image10
|| ||
||====================================||

image4 image5 image6 image7 image8

Re: how to draw vertical rule in asp.net

Yusuf22-May-10 7:01

Yusuf

22-May-10 7:01

You can use css to draw borders, see here[^]

Yusuf
May I help you?

Re: how to draw vertical rule in asp.net

Tej Aj23-May-10 21:24

Tej Aj

23-May-10 21:24

Check this post
it may help to draw vertical and horizontal rule

http://opexsolution.com/forum/viewtopic.php?f=15&t=43&p=126#p126[^]

xml to gridview

Tomlor198022-May-10 3:21

Tomlor1980

22-May-10 3:21

Hello all!
I'm new to asp.net and i'm trying to bind some XML data to a gridview.
abviously I'm not understanding how to do it properly because that my code doesn't seem to
work...Can anyone could help me please?

this is my xml:
#########################################
<?xml version "1.0" encoding "utf-8"?>
<dictionary>
<item>
<key>
<string> hello world </string>
</key>
<value> <anytype xmlns:q1="http://www.w3.org/2001/XMLSchame" d4p1:type="q1:int"
xmlns:d4p1="http-instance">45</anytype>
</value>
</item>
</dictionary>

and this is my code:
########################################
string path = "D:\\myXmlFile.xml";
DataSet oDs = new DataSet();
oDs.ReadXml(path);
GridView1.DataSource = oDs;
GridView1.DataBind();

thanks
Tom

Cross post

Not Active22-May-10 3:32

Looking for a pattern for managing URL in a Web Application

22-May-10 3:32

You were asked to not cross post. Please read the How to get an answer to your question[^]

I know the language. I've read a book. - _Madmatt

Re: xml to gridview

dan!sh 22-May-10 5:59

dan!sh

22-May-10 5:59

There are a lot more forums left. Why not post your question in all of them.

Nadia Monalisa22-May-10 2:51

Nadia Monalisa

22-May-10 2:51

Hello,
I am looking for a good design pattern that will solve managing Urls in a web application. At this moment, I have a chaos of hard coded url referring in every pages. If I change the page name, I get lost as I dont know how many pages I have to update where I used the url. So, I am assuming, there should be a pattern something named URL Factory etc. Cany you please give me a guidance... !

Another question, does it make any difference in performance if I use absolute URL instead of relative url ? I am thinking of developing a URL factory for my web application and so, if I use Absolute url, it may be easy to manintain my Url factory.

Regards.

Re: Looking for a pattern for managing URL in a Web Application

Not Active22-May-10 3:10