Re: Date Format In XML in converting excel file in a folder - ASP.NET Discussion Boards

Dhruv.SoluSoft10-Sep-09 1:04

10-Sep-09 1:04

There are 2 sollutions :

- You can use ItemTemplate with TemplateColumn. It will be useful if you want to format the contents, and you need specific control for specific content.

- Going on SQL side, you can adjust the query itself to produce the firstname+lastname's combination, if you just want to display the information.

Datalist

KhandelwalA9-Sep-09 20:38

KhandelwalA

9-Sep-09 20:38

I m showing product details in datalist with a image...........and i want to enlarge the size of image on enlarge button..........how its possible..............plz guide me a bit.............. Smile | :)

Re: Datalist

Parwej Ahamad9-Sep-09 20:50

Parwej Ahamad

9-Sep-09 20:50

Try to use css dynamicaly. Please go with this discussion:
http://www.daniweb.com/forums/thread87716.html[^]

Parwej Ahamad
ahamad.parwej@gmail.com

FLV

geeeeeeeetha9-Sep-09 20:33

geeeeeeeetha

9-Sep-09 20:33

Hi,

how to upload flv file in asp.net?

Regards
jayabharathi

Re: FLV

Ravi Mori9-Sep-09 20:45

Ravi Mori

9-Sep-09 20:45

hi
To embed the flv file in the page you need to wrap that into a flash and refer to the below link for a example
view the source
http://blogs.ugidotnet.org/kfra/archive/2006/10/04/50003.aspx[^]

And here is another link for streaming data of flv file

http://blogs.ugidotnet.org/kfra/archive/2006/10/04/50003.aspx[^]

Date Format In XML in converting excel file in a folder

rummer9-Sep-09 20:09

rummer

9-Sep-09 20:09

How we get XML tag value in MM/DD/YYYY format in .net with c# ??

<br />
 private string getXmlTagDate(XmlElement xEle, string name)<br />
    {<br />
        XmlNodeList xList;<br />
        string text;<br />
        xList = xEle.GetElementsByTagName(name);<br />
        if (xList.Count > 0)<br />
        {<br />
            text = xList[0].InnerText.ToString();<br />
            text = Convert.ToDateTime(text).ToShortDateString();<br />
        }<br />
        else<br />
        {<br />
            text = "00/00/0000";<br />
        }<br />
        return text;<br />
    }<br />
<br />

this function work properly for text value and we get this in date format

<br />
<br />
<?xml version="1.0" standalone="yes"?><br />
<NewDataSet><br />
  <PinType_TABLE><br />
    <pinname>HALF UNIT</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>50</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>6000</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-02-01T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
  <PinType_TABLE><br />
    <pinname>Full</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>100</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>12000</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-02-03T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
  <PinType_TABLE><br />
    <pinname>fourth unit</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>25</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>3000</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-05-21T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
  <PinType_TABLE><br />
    <pinname>s.s</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>0</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>0</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-07-16T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
</NewDataSet><br />
<br />

Re: Date Format In XML in converting excel file in a folder

Parwej Ahamad9-Sep-09 21:00

Parwej Ahamad

9-Sep-09 21:00

Just i would like to clerify you query that are facing problem with the date formate while you are converting XML file into excel file ?

Parwej Ahamad
ahamad.parwej@gmail.com

Re: Date Format In XML in converting excel file in a folder

keyur satyadev9-Sep-09 23:19

keyur satyadev

9-Sep-09 23:19

rummer wrote:
text = Convert.ToDateTime(text).ToShortDateString();

text= Convert.ToDateTime(text).Tostring("MM/dd/yyyy");

Regards
Keyur Satyadev

query

mylogics9-Sep-09 19:24

mylogics

9-Sep-09 19:24

hiii m tryin to submit the values of dynamically created textbox on button click.i have writen following code on button click:

protected void Button2_Click(object sender, EventArgs e)
    {
        OleDbDataReader dr = null;
        string str = "Select Count(Specification)From ProductSpecification";
        OleDbCommand cmd = new OleDbCommand(str, conn);
        conn.Open();
        string Count = cmd.ExecuteScalar().ToString();
        int count = Convert.ToInt32(Count);
        conn.Close();
        str = "Select * From ProductSpecification";
        cmd = new OleDbCommand(str, conn);
        conn.Open();
       // dr = cmd.ExecuteReader();
        //DataTable dt = new DataTable();
       // dt.Load(dr);
        
        for (int i = 1; i <= count; i++)
        {
            txt = new TextBox[count]; 
            //string s=dr["Specification"].ToString();
            //TextBox text = (TextBox)Panel2.FindControl(txt[i].ID);
            ///TextBox txtctrl = (TextBox)Panel2.FindControl("txt" + i.ToString());
            txt[i] = new TextBox(); 
            txt[i].ID = "txt" + i.ToString();
            string s1 = txt[i].Text;
            string s2 = "Insert Into ProductSpecification(Value)Values('"+s1+"')";
            cmd = new OleDbCommand(s2, conn);
            cmd.ExecuteNonQuery();
           
        }
        conn.Close();
    }

but it is givin error and also it is not taking the value of textbox:
error:Syntax error in INSERT INTO statement.

Re: query

Suresh Suthar9-Sep-09 20:07

Suresh Suthar

9-Sep-09 20:07

mylogics wrote:
txt[i] = new TextBox(); txt[i].ID = "txt" + i.ToString(); string s1 = txt[i].Text;

Use this

txt = new TextBox(); 
txt= Page.FindControl("txt" & i.ToString);
string s1= txt.Text

Be an Eagle, Sky is Yours.

Re: query

mylogics9-Sep-09 20:14

mylogics

9-Sep-09 20:14

hiii now i have changed my code to:

protected void Button2_Click(object sender, EventArgs e)
    {
        OleDbDataReader dr = null;
        string str = "Select Count(Specification)From ProductSpecification";
        OleDbCommand cmd = new OleDbCommand(str, conn);
        conn.Open();
        string Count = cmd.ExecuteScalar().ToString();
        int count = Convert.ToInt32(Count);
        conn.Close();
    
        for (int i = 0; i <= Convert.ToInt32(Count) - 1; i++)
        {
            TextBox txtCtrl = (TextBox)Panel2.FindControl("txt" + (i + 1));
            Label lblctrl = (Label)Panel2.FindControl("lbl" + (i + 1));
            if (txtCtrl != null) 
            {
                string s = txtCtrl.Text;
                string s2 = lblctrl.Text;
                string s1 = "Update ProductSpecification Set Value='"+s+"'Where Specification='"+s2+"'";
                cmd = new OleDbCommand(s1, conn);
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
                //TextBox1.Text = TextBox1.Text + "," + txtCtrl.Text;
            }
        }

    }

but it is givin error:
Syntax error in UPDATE statement.
plz help...

Re: query

Suresh Suthar9-Sep-09 20:22

Suresh Suthar

9-Sep-09 20:22

mylogics wrote:
string s1 = "Update ProductSpecification Set Value='"+s+"'Where Specification='"+s2+"'";

Dear Friend

Please write you query with space between where cluase and single quote

string s1 = "Update ProductSpecification Set Value='"+s+"'  Where Specification='"+s2+"'";

Be an Eagle, Sky is Yours.

Re: query

mylogics9-Sep-09 20:28

mylogics

9-Sep-09 20:28

i have written the query as u said but still givin same error...

Re: query

Suresh Suthar9-Sep-09 20:46

Suresh Suthar

9-Sep-09 20:46

If you passing text with single qoute like D'Souza then replace single quoute with ''.

Be an Eagle, Sky is Yours.

Re: query

rummer9-Sep-09 20:16

rummer

9-Sep-09 20:16

Hi sir i want to say my code is for text but i want 2 ask u how we use this code for date format.

Re: query

Suresh Suthar9-Sep-09 20:24

Suresh Suthar

9-Sep-09 20:24

Plz explain.
put you code here...

Be an Eagle, Sky is Yours.

Re: query

Christian Graus9-Sep-09 21:29

Christian Graus

9-Sep-09 21:29

your code is a disaster from start to finish. It has zero chance of working. You should rethink it, and perhaps do some study, so you have a basic idea of what you are doing. you should also read up on paramaterised queries, once your code is not totally useless, it will become totally insecure, due to SQL injection attacks. Once you fix that, it will also work for dates, as a side benefit.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: query

Christian Graus9-Sep-09 21:27

Christian Graus

9-Sep-09 21:27

Well, this has to be the most ridiculous code I've seen in a long time.

mylogics wrote:
txt[i] = new TextBox();
txt[i].ID = "txt" + i.ToString();
string s1 = txt[i].Text;
string s2 = "Insert Into ProductSpecification(Value)Values('"+s1+"')";

Well, why would you expect s1 to be anything, but an empty string ? What on earth are you expecting here ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

java TAPI is connecting to ASP.Net Application

kareemmahammed9-Sep-09 18:57

kareemmahammed

9-Sep-09 18:57

i want to devlop a virtual tele phone which is acts like a normal phone using computer only.
in this we design a key board on the screen and when i press a number it goes to call .the number will be saved after .all of the application i want to done in ASP.Net .But i search in many sites it is not able to devlop TAPI (Telephony Appliacation Programming Inter face)in ASP.Net .

So i want to devlop TAPI in JAVA and then using that files how can implement virtual phone using ASP.Net application.

Re: java TAPI is connecting to ASP.Net Application

Christian Graus9-Sep-09 19:02

Christian Graus

9-Sep-09 19:02

kareemmahammed wrote:
So i want to devlop TAPI in JAVA and then using that f

This question has nothing to do with ASP.NET. I assume you want to write a java applet. In that case, if you use ASP.NET to write the page that holds the applet or not, is irrelevant to your overall goal.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Dropdownlist select only first value

haleemasher9-Sep-09 18:54

haleemasher

9-Sep-09 18:54

here is my code whenever i want to change the value of my dropdownlist i select only first value it can't
change to any other value. plz chk and reply

private void bounddropdownlist()
    {
        string query = "select CouponName,CouponTypeID from CouponType";
        DAL Helper = new DAL();
        Helper.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
        ds = new DataSet();
        ds = Helper.ExecuteDataSet(CommandType.Text, query, null);
        ddlCType.DataValueField = "CouponTypeID";
        ddlCType.DataTextField = "CouponName";
        ddlCType.DataSource = ds;
        ddlCType.DataBind();
    }

Re: Dropdownlist select only first value

Christian Graus9-Sep-09 18:59

Christian Graus

9-Sep-09 18:59

Well, again, your code really sucks. You need to abandon this project, and work on something more simple while you are just learning and cannot write commercial quality code. You seem to not know anything about ASP.NET and how it works yet.

haleemasher wrote:
ddlCType.DataBind();

Every time you do this, the selected index is reset. I assume you call it in page load, and it therefore runs prior to your event, which is the problem.

haleemasher wrote:
string query = "select CouponName,CouponTypeID from CouponType";
DAL Helper = new DAL();
Helper.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
ds = new DataSet();
ds = Helper.ExecuteDataSet(CommandType.Text, query, null);

This is an absolute joke.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Dropdownlist select only first value

haleemasher9-Sep-09 19:07

haleemasher

9-Sep-09 19:07

u mean i will write

ddlCType.DataBind();

in page load or i write all my code in pageload????

Re: Dropdownlist select only first value

Christian Graus9-Sep-09 19:08

Christian Graus

9-Sep-09 19:08

I assume this method is being called by pageload now ? What is calling it ?

I am saying if you do this in page load, or any time prior to trying to access the selection, it will reset the selection. In fact, you should use IsPostback blocks to only load the data the first time, after that, it is in viewstate

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Dropdownlist select only first value

N a v a n e e t h9-Sep-09 19:12

N a v a n e e t h

9-Sep-09 19:12

I think DataSet and DataTable are the most misused classes in .NET framework. Smile | :)

Navaneeth

How to use google | Ask smart questions

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.