i want create application like outlook or Thunderbird - ASP.NET Discussion Boards

Re: datatype problem

Greg Chelstowski4-Sep-09 4:20

Greg Chelstowski

4-Sep-09 4:20

Wrap your date strings in hashes:

string query = "select * from appointment where DATE >= #" + selectedDate.ToShortDateString() + "#  AND DATE<= #" + sel.ToShortDateString() + "#";

I would really advise you to write parameterized queries, though.
Read up on it.

var question = (_2b || !(_2b));

Re: datatype problem

Robert_Pan4-Sep-09 20:08

Robert_Pan

4-Sep-09 20:08

string query = "select * from appointment where DATE >'" + selectedDate.ToShortDateString() + "' AND DATE<'" + sel.ToShortDateString() + "'";

Gridview Button problem

RajpootRohan4-Sep-09 1:51

RajpootRohan

4-Sep-09 1:51

Hi to all,

I am stucked in a problem. I have a gridview in which there are two button columns.

On button click I want image to open in fax viewer. I tried like this.

But the problem is that the foreach is going through all the rows. I want that if a user clicks on a certain button then it should open the corresponding image.

Please assist me...

<br />
<asp:GridView ID="GridView1" runat="server" BackColor="White" DataKeyNames="UniqueID" <br />
                        BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" <br />
                        AutoGenerateColumns="False"><br />
                        <RowStyle ForeColor="#000000" /><br />
                        <FooterStyle BackColor="White" ForeColor="#000066" /><br />
                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /><br />
                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /><br />
                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /><br />
                                <Columns><br />
 <br />
        <asp:TemplateField HeaderStyle-Width="50px" HeaderText="SrNo" InsertVisible="False" SortExpression="SrNo"><br />
        <ItemTemplate><br />
        <asp:Label ID="SrNoLabel" runat="server" Text='<%# Bind("SrNo") %>'></asp:Label><br />
        </ItemTemplate><br />
        <HeaderStyle Width="50px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        <asp:TemplateField HeaderStyle-Width="50px" HeaderText="UniqueID" InsertVisible="False" SortExpression="UniqueID"><br />
        <ItemTemplate><br />
        <asp:Label ID="UniqueIDLabel" runat="server" Text='<%# Bind("UniqueID") %>'></asp:Label><br />
        </ItemTemplate><br />
        <HeaderStyle Width="50px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        <asp:TemplateField HeaderStyle-Width="50px" HeaderText="BridgeNo" InsertVisible="False" SortExpression="BridgeNo"><br />
        <ItemTemplate><br />
        <asp:Label ID="BridgeNoLabel" runat="server" Text='<%# Bind("BridgeNo") %>'></asp:Label><br />
        </ItemTemplate><br />
        <HeaderStyle Width="50px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        <asp:TemplateField HeaderStyle-Width="50px" ItemStyle-HorizontalAlign="Left" HeaderText="PlanNo" InsertVisible="False" SortExpression="PlanNo"><br />
        <ItemTemplate><br />
        <asp:Label ID="PlanNoLabel" runat="server" Text='<%# Bind("PlanNo") %>'></asp:Label><br />
        </ItemTemplate><br />
        <HeaderStyle Width="50px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        <asp:TemplateField HeaderStyle-Width="180px" ItemStyle-HorizontalAlign="Left"  HeaderText="Description" InsertVisible="False" SortExpression="Description"><br />
        <ItemTemplate><br />
        <asp:TextBox ID="DescriptionTextBox" Enabled="false" TextMode="MultiLine" runat="server" Text='<%# Bind("Description") %>'></asp:TextBox><br />
        </ItemTemplate><br />
        <HeaderStyle Width="180px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        <asp:TemplateField HeaderStyle-Width="50px" HeaderText="OldUniqueID" InsertVisible="False" SortExpression="OldUniqueID"><br />
        <ItemTemplate><br />
        <asp:Label ID="OldUniqueIDLabel" runat="server" Text='<%# Bind("OldUniqueID") %>'></asp:Label><br />
        </ItemTemplate><br />
        <HeaderStyle Width="50px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        <asp:TemplateField HeaderStyle-Width="80px" HeaderText="Image" InsertVisible="False" SortExpression="Image"><br />
        <ItemTemplate><br />
        <asp:Button ID="ButtonImg" runat="server" Width="80px" ToolTip='<%# Bind("Image") %>' Text="New Image" OnClick="On_Click" ></asp:Button><br />
        </ItemTemplate><br />
        <HeaderStyle Width="80px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        <asp:TemplateField HeaderStyle-Width="80px" HeaderText="OldImage" InsertVisible="False" SortExpression="OldImage"><br />
        <ItemTemplate><br />
        <asp:Button ID="ButtonOldImage" runat="server" Width="80px" ToolTip='<%# Bind("OldImage") %>' Text="Raw Image" OnClick="By_Click" ></asp:Button><br />
        </ItemTemplate><br />
        <HeaderStyle Width="80px"></HeaderStyle><br />
        </asp:TemplateField><br />
        <br />
        </Columns><br />
                    </asp:GridView><br />

protected void On_Click(object sender, EventArgs e)
{
    foreach (GridViewRow rowitem in GridView1.Rows)
    {
        Button ButtonImg = (Button)rowitem.Cells[6].FindControl("ButtonImg");
        btntext = ButtonImg.ToolTip.ToString();
        final_text = Server.MapPath(btntext);
    }
    System.Diagnostics.Process.Start(final_text);
}

cheers,
sneha

Re: Gridview Button problem [modified]

sashidhar4-Sep-09 2:17

sashidhar

4-Sep-09 2:17

System.Diagnostics.Process.Start(final_text);
will act as Start -->Run--> prompt

I am Not Sure This Will Work Or Not But Try It

Process.Start("UrPictureViewerExePathToInvoke" + imagePath)

in my system
UrPictureViewerExePathToInvoke= rundll32.exe C:\WINDOWS\system32\shimgvw.dll,ImageView_Fullscreen

Convert the code in C# and Do it

modified on Friday, September 4, 2009 8:30 AM

<font> tag become obsolete</font>

myinstincts4-Sep-09 1:40

myinstincts

4-Sep-09 1:40

while i was developing an application in asp.net i got the warning message as
"Validation (XHTML 1.0 Transitional): Element 'font' is considered outdated. A newer construct is recommended"

what is the alternative for this?

Re: tag become obsolete

myinstincts4-Sep-09 1:46

myinstincts

4-Sep-09 1:46

i used the font tag

Re: tag become obsolete

Not Active4-Sep-09 2:15

Not Active

4-Sep-09 2:15

Use CSS

only two letters away from being an asset

i want create application like outlook or Thunderbird

manish.m.meshram3-Sep-09 23:56

manish.m.meshram

3-Sep-09 23:56

Dear Sir,

Hi,
I want create application like outlook as in windows.
Aplicataion will read email through
smtp.
Any body have some idea how to read emails
from gmail, or yahoo.

In short appliction like outlook.

Thank You

Re: i want create application like outlook or Thunderbird

Arun Jacob4-Sep-09 0:03

Arun Jacob

4-Sep-09 0:03

Search for POP3Client class,

POP3 Client as a C# Class[^]
Smile | :)

Arun Jacob
http://codepronet.blogspot.com/

Re: i want create application like outlook or Thunderbird

Ashfield4-Sep-09 1:28

Ashfield

4-Sep-09 1:28

manish.m.meshram wrote:
I want create application like outlook as in windows.

Good start, a clear definition of your requirements

manish.m.meshram wrote:
Any body have some idea how to read emails

Doomed from this point on. If you don't know how to read emails, and can't be bothered to look at the faqs for gmail and yahoo, how are you going to do it?

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

get the bitmap output of the controls

behnam-s3-Sep-09 23:47

behnam-s

3-Sep-09 23:47

hi how can i get the output of a control (for example GridView) ,in image format.

Re: get the bitmap output of the controls [modified]

sashidhar4-Sep-09 1:09

sashidhar

4-Sep-09 1:09

May Be The Following Link May Help

http://www.codegod.de/WebAppCodeGod/Screenshot-of-Webpage-with-ASP-NET-AID398.aspx[^]
http://forums.asp.net/t/1465046.aspx[^]

http://aspdotnetcodebook.blogspot.com/2009/05/how-to-export-webpage-as-image-in.html[^]

~ Remember To Mark The Post(s) That Helped You As The ANSWER ~

modified on Friday, September 4, 2009 7:50 AM

Server to Server Communication

janat_Al_donia3-Sep-09 22:07

janat_Al_donia

3-Sep-09 22:07

hi every body
iwant to ask how can i implement communication between 2 web sites first web asks the second about some information and the other also keeps a record of information about clients (web pages) that connected with it.

its just like central server and clients connecting to it h dont know realy how to do this in asp.net

please help me with the code or give me an example.
thanks

Re: Server to Server Communication

N a v a n e e t h3-Sep-09 22:13

N a v a n e e t h

3-Sep-09 22:13

There is no direct way to communicate between two websites. Here are few possible methods.

Provide a web service for each website. So one website can use other website's web service to get data
Use a centralized database which each website uses. You can just query on this DB to get latest updates.

Navaneeth

How to use google | Ask smart questions

Re: Server to Server Communication

Arun Jacob3-Sep-09 22:31

Arun Jacob

3-Sep-09 22:31

Using WebService is a good option.
Laugh | :laugh:

Arun Jacob
http://codepronet.blogspot.com/

adding data

ankitjain11103-Sep-09 21:24

ankitjain1110

3-Sep-09 21:24

TextBox2.Text = selectedDate.DayOfWeek.ToString();
TextBox3.Text = selectedDate.ToShortDateString();
string connection2 = ConfigurationManager.AppSettings["conn"];
OleDbConnection con2 = new OleDbConnection(connection2);
OleDbDataAdapter da_detail = new OleDbDataAdapter();
DataSet ds_detail = new DataSet();
con2.Open();

//da_detail.Fill(ds_detail, "details");
//DataTable detail_dt = ds_detail.Tables["details"];

string query = "select * from appointment where DATE = '" + selectedDate.ToShortDateString() + "' ";
OleDbCommand pay_cmd2 = new OleDbCommand(query, con2);
DataRow row = null;
for (int x = 1; x <= 7; x++)
{
da_detail.SelectCommand = pay_cmd2;
//row = detail_dt.NewRow();
da_detail.Fill(ds_detail, "details");
detail_dt=ds_detail.Tables["details"];
//detail_dt.Rows.Add(row);
DateTime tempo = selectedDate.AddDays(1);
selectedDate = tempo;

}
GridView1.DataSource = detail_dt;
GridView1.DataBind();

this is the code.i want show the details of the whole week.but the code is not working.can u help me.

Re: adding data

Vimalsoft(Pty) Ltd3-Sep-09 21:29

Vimalsoft(Pty) Ltd

3-Sep-09 21:29

Why do you say its not working ? Do you get any sort of Error ?

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: adding data

ankitjain11103-Sep-09 21:33

ankitjain1110

3-Sep-09 21:33

the gridview is not displayed..i think its not getting any data.but the query is correct.it will fetch datas.some prob with datatable

Re: adding data

Blue_Boy3-Sep-09 21:37

Blue_Boy

3-Sep-09 21:37

Why you dont use TOP 7 insetead using for loop?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Re: adding data

ankitjain11103-Sep-09 21:52

ankitjain1110

3-Sep-09 21:52

but the prob is not coz of loop.its because datas r not getting appended in datatable.

Re: adding data

Vimalsoft(Pty) Ltd3-Sep-09 22:24

Vimalsoft(Pty) Ltd

3-Sep-09 22:24

ok i looked at the code , i dont understand why you loop. ok i see you fill the dataset and you give the name, now take that name use it in the grid's datamember property and try it again.

Re: adding data

N a v a n e e t h3-Sep-09 22:07

N a v a n e e t h

3-Sep-09 22:07

What a load of crap! Seriously, you code is flawed.

You don't need a for loop here. Add 7 days to the date and have only one query. Also just for displaying to grid, you don't need a DataSet. A simple reader should do. Here is the code with some improvements.

// use some meaningful names
string connectionString = ConfigurationManager.AppSettings["conn"];

// use parameterized queries to avoid SQL injection
// query altered to avoid unnecessary looping
string query = "select * from appointment where DATE >= @StartDate and DATE <= @EndDate";

// wrap the connection and command in using block to avoid resource leaks.
using(OleDbConnection connection = new OleDbConnection(connectionString))
using(OleDbCommand command = new OleDbCommand(query, connection);
{
    command.Parameters.AddWithValue("@StartDate", selectedDate.ToShortDateString());
    command.Parameters.AddWithValue("@EndDate", selectedDate.AddDays(7).ToShortDateString());

    connection.Open();
    // using a reader. You don't need a dataset as you are not persisting it in memory
    using(OleDbDataReader reader = command.ExecuteReader())
    {
        GridView1.DataSource = reader;
        GridView1.DataBind();        
    }
    connection.Close();
}

Note: Code written directly on CP editor. You may need to correct some compilation errors.

Smile | :)

Navaneeth

How to use google | Ask smart questions

How to authenticate with Active Directory?

baburman3-Sep-09 21:18

baburman

3-Sep-09 21:18

I am developing an application in ASP.NET. I need to do two things:

1- The user who logges in the application (through my login.aspx page) must also be authenticated by Active Directory since every user is also registered on AD and has the same user name.

2- After login, the application must run under his AD account instead of anonymous user, IUSR_MachineName.

any code example will be highly appreciated. Thanks

Re: How to authenticate with Active Directory?

Arun Jacob3-Sep-09 22:38

Arun Jacob

3-Sep-09 22:38

Which Authentication you are using?

Arun Jacob
http://codepronet.blogspot.com/

Re: How to authenticate with Active Directory?

baburman4-Sep-09 1:44

baburman

4-Sep-09 1:44

I have set both Integrated Windows Authentication and anonymous access in app setting from IIS console.

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