Comments by Sriram Ramachandran (Top 98 by date)

yup.. Either way ... in @Liststyle or in @Listsolidyarn ... I would pass values in either parameters leaving one value empty..

No, I don't get values at all. The question is : I need to pass null or empty sql parameters in order to get the records from DB?

Page Load=> Fetch raw data.
Filter to select particular records=> 5 Textbox and if all 5 TB are passed, output expected: if not No records even I got records in DB.
How do you want me show the input and output ??

yeah I just pass 1 parameter which has value and pass 4 parameters as empty.. No Records found... But there is a data ....
Even I tried passing null value

So I need to run the SQL function passing empty parameters also..

Simple: Got 5 search Checkboxes... I would select any of the one//two/.. checkboxes in order to search the data. If I search using all fields: Can get expected outcome. But When I select 1,2,3,4 out of 5(leaving any checkbox empty).. No records

Thanks.. It worked. But how this is working??? Why 10000.0??

yeah its ASP.NET and its GRIDVIEW and not DataGrid

The button is at footerrow..

Yeah I've handled the code too. But that function is not called when I click the button. Thats my problem..

I know this already. This doesn't solve my problem...

Understood and worked ... Thanks....

cmd.Parameters.AddWithValue("@color", parameters); The value of parameters would be '1','2' and this pass to SQL SP to @color.
select Sizes,SUM(Quantity) as Quantity from tbl_SizeBreakup where (Combo_Color in (@color)) Group By Sizes ...
So will this work??

Can't I pass the Combo in C# as combo[] ??

I didnt save the data. Just wanna see the details before saving to the DB. Just displaying whatever typed in Gridview

I don't know how it is added again as I used items.insert("select") once.

Can I know what the problem is?

ok but when checked with breakpoint: I got the output mapped to C:\ only- before checking file Exists code.

yup it works .. thanks

I thnk its not virtual directories... Its just creating folders in my published application itself. Not new folder under wwwroot.

No error. I published in IIS. The folders ve not created.

I am using <asp:Textbox>. How to use onkeyup in this?

Yeah atlast, I am trying that...

as soon as the TextBox_D got value in its textbox, I need to throw a message. So I need to write only on TextBox_D method. Which method would be apt one?

I doesn't know which property to use? Using OnTextChange, Only after typing the method gets invoked.

let me try with that ...

Actually I can print my gridview.. Its working fine... prtMenu(label)I need to print above the gridview which shows the value as undefined ... But prtMenu fetched the value correctly

thanks ...

In pageload, default I loaded gridview with 1 row. Then retrieved from DB, it returns 3. So gridview mismatched with rows I guess

I guess I identified the problem. Initially in pageload, I bind the gridview to have 1 row with textbox for each columns in default. Since the rowcount returns 3, there is only one row present in gridview. So, code according to it...

thanks I'll try it out and let me know whether it works or not ??

DamithSL ... Am I doing everything in right way ??? or just guide me ??? I think this was right

Actually after completing the coding part, I will move all folders in C:\\inetpub\\wwwroot(IIS)Application and required folders to access... so the root would give me C:\ path where I can find the images in specific ...
Upload folder is in respective folders where I'll move to server(IIS) after completing the code...

should access all files using rootfolder(E:\\)

Could not find a part of the path 'E:\Sriram\Project\sgportalapplication\Monoprix\SS_15\STYLE_3\Images\Chrysanthemum.jpg'. ...
'E:\Sriram\Project\sgportalapplication (where application resides)
My folder access requirement is E:\Monoprix(Session) and so on

Actually I need to store the image in E:\Monoprix(session[brandname])\Season(season.sel.item)\style(style.item)\Images\filename..
The image should store in corresponding folders using session["brandname"]... and should also retrieve the image from this location only ....

E:\Sriram\Project\sgportalapplication

yeah done that already.. still no output .. I mean image is not displaying...

I could see the page is getting refreshed when I hit the Upload button. The function for the button is the above code...

Thanks Nilesh..I got the problem solved but the image has not been displayed. The image path is right when debugging but nothing displays.... Do I need to add any code??

Does anyone help me pls ???

@Nandakishore G N : Could you pls tell me what would be the issue behind this ??

Or I need to create a gridview with Rows manner instead of columns but the gridview doesn't supports rows
So I need to design in Columns and in pageload, I need to convert the Columns to Rows...

Actually the requirement is a gridview with 15 headertext followed by 15 textboxes in 1st row. Initially in the pageload, it displays the the gridview which goes out of the browser area(mean need to scroll right). And also I ve a add new row(need to convert to column) which duplicates the row for next entry. So, I need to change the rows to columns which displays the textbox in a vertical manner. The conversion was successful where I could see in debugging but not in the browser.

ASPX code
<asp:GridView ID="gvlistmonoprix" runat="server"
ShowFooter="True" AutoGenerateColumns="False"
CellPadding="4" ForeColor="Black"
GridLines="Horizontal" Width="640px"
ShowHeaderWhenEmpty="True" BackColor="White" BorderColor="#CCCCCC"
BorderStyle="None" BorderWidth="1px">

<columns>

<asp:TemplateField HeaderText="Color">
<itemtemplate>
<asp:TextBox ID="color" Width="100px" runat="server" TextMode="MultiLine">



<footerstyle horizontalalign="Left">
<footertemplate>
<asp:Button ID="ButtonAdd" runat="server" CssClass="blueButton1"
Text="Add New Color" ValidationGroup="null" OnClick="addnewrowmonoprix_click" />


<asp:TemplateField HeaderText="1 mois">
<itemtemplate>
<asp:TextBox ID="mois1" runat="server" OnTextChanged="calculatetotal_textchanged" AutoPostBack="true">

DataTable outputTable = new DataTable();

// Add columns by looping rows

// Header row's first column is same as in inputTable
outputTable.Columns.Add(inputTable.Columns[0].ColumnName.ToString());

// Header row's second column onwards, 'inputTable's first column taken
foreach (DataRow inRow in inputTable.Rows)
{
string newColName = inRow[0].ToString();
outputTable.Columns.Add(newColName);
}

// Add rows by looping columns
for (int rCount = 1; rCount <= inputTable.Columns.Count -1; rCount++)
{
DataRow newRow = outputTable.NewRow();

// First column is inputTable's Header row's second column
newRow[0] = inputTable.Columns[rCount].ColumnName.ToString();
for (int cCount = 0; cCount <= inputTable.Rows.Count - 1; cCount++)
{
string colValue = inputTable.Rows[cCount][rCount].ToString();
newRow[cCount + 1] = colValue;
}
outputTable.Rows.Add(newRow);

}
return outputTable;


Is this the code wrong? Got output when I make cheeckpoints in coding but not in output screen ??

Friends Someone help me ... I couldn't find the problem....

I got the output as expected when I use Checkpoint and see the output in Datasource...But the output in browser its different .... Don't no whats happening??

I mean I couldn't find the problem in above code ... No output ...

@Jas ....
Could you send me ur email id so that I can share my codings and screenshots of my works..

But it didn't worked for me ... My problem is for each row returned from SQL, I need to create a GRIDVIEW ....

I've already checked this code which does creates just one gridview dynamically... But I need for more than 2 gridviews ....

thanks Jas... Will check it out whether it works for me ...

http://stackoverflow.com/questions/4187354/create-multiple-gridviews-in-code-behind

the website I browsed thought to be useful... But couldn't find the solution

Yes Solved with some other ideas...

thanks jas ... I already googled it and done to my requirement .....

ok I ll try that ...

ok then I'll try some other methods ....

Whenever the page is loaded, i ll always fetch the 1st row in gridview. which i wrote the code as
Label id1 = (Label)gvMailList.Rows[0].FindControl("Label1");
if it is 1... I ll make that row(which is 1st row always) as a different color

But I ve a doubt ... The SNO has values 1,2,3 and how to fetch those numbers using ITEMTEMPLATE...

thanks ... I ll try and reply u asap

<asp:TemplateField HeaderText="S.No">

<itemtemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Container.DataItemIndex+1 %>'>

<itemstyle horizontalalign="Left" width="10px" height="20px">


<asp:BoundField DataField="From" HeaderText="From" >
<itemstyle horizontalalign="Left" height="20px">


<asp:TemplateField HeaderText="Subject" ItemStyle-HorizontalAlign="Center" ControlStyle-ForeColor="Blue">
<itemtemplate>
<asp:HiddenField ID="hdnMailID" runat="server" Value='<%#Eval("Mail_Msg_ID")%>' />
<asp:LinkButton ID="lbView" OnClick="lbView_Click" runat="server" Text='<%#Eval("Subject")%>'>

<itemstyle horizontalalign="Left" height="20px">

My intention on the word responsive in the sense ... "A website should be able to view in any kind of screens without scrolling and the contents should be placed automatically based on the screens it is viewed"

Hi OriginalGriff,

Thanks for sharing. I know to design a responsive website. I just asked is there any tool to convert HTML code conversion to a responsive one ????

thanks karthik

I m sorry... Can u share some codes regarding that ????

nope, it doesn't work because I called execute like this
private void StartTask()
{
if (!this.Stopped)
{
Thread thread = new Thread(new ThreadStart(Execute));
thread.Start();
}
}

Look at this code ....
public class Task
{
public void Execute()
{
Dosomeaction();
}
public void Dosomeaction(gridview )
{
// This runs perfect where I access gridview from another class
}
}


If I didnt call Dosomeaction in execute function, then this function doesn't work at all ...

private void Execute()
{
Reminder();
Abeyance();
Dosomeaction();
} I couldn't pass the gridview values in execute function or else this dosomeaction() doesn't run in my program...

now i can access it .... but got stuck up with another problem. I'm using thread with timer. As you know, it executes with specific functions like Start(),Stop(), Execute() sequentially. My one of the functionality with timer works fine in Execute function. But need to call that DosomeAction function where i could not pass the gridview value. What am I supposed to do now ???

Execute ()
{
//how to call DoSomeAction function ????
}

public void Dosomeaction(System.Web.UI.WebControls.GridView gridview)
{


}

Thanks for your reply Karthik... I'll just try and say you the result

hi ganesh ... I checked ....... but i dont think this is working for me .......... For each 10 mins, I ll update DB... When I check DB, the update hasn't happened.. What to do now ???? Any help pls

thanks a lot ... i ll see to it .....

I am sorry Ganesh.... Can you share some links to create windows service which has simple examples........ Because I am new in windows service...

sorry bro .... I ll post the code

thanks ..........

yeah ok ... just tell me the other way....
Or how abt writing web services defining time to execute automatically ???? is that good way

I am actually fetching mails from mail server. I wrote the application as like when it opens, mails will be fetched from mail server and put it in SQL server DB. So if the application opens automatically for 10 mins, mails will be fetched frequently and put in server DB.
This is the reason....

Can u explain with example considering gmail as mail server. I need some source codes to learn...

I need to change the background color of the gridview row based on comparing current date and fetching date from the gridview. Is that possible ????? for eg:: current date is 31/10/2013 and date from gridview column is 25/10/2013. So fetched date is less than current date. So I need to change the rows which are less than current date to green background color.

hi piyush...

I searched in many websites .... I couldn't find the exact solution. Can u send me some websites to refer???? or share the code for me

no its not working ......... Same error.........Input string is not in a correct format .....

Or atleast --- When I type something in textbox, I should be able to get the value of the textbox when enter key is pressed

actually I doesn't knew to do that part .... need some codings

I should able to type text(email) in textbox and when pressed enter key, it should add in div content and also shuld automatically send emails to those mail id's listed in div content

Thanks .... I'll check this out ........

i m getting only for current system date.... The meeting names are placing at corresponding dates like 12/12/2013 and its not navigating too .......... Can anyone help me pls ???

My Corresponding aspx file

<%@ Page Language="C#" MasterPageFile="~/MasterKitchen.master" AutoEventWireup="true"
CodeFile="GoogleLike.aspx.cs" Inherits="WebFormAdmin_GoogleLike" %>
<%@ Register Assembly="DayPilot" Namespace="DayPilot.Web.Ui" TagPrefix="DayPilot" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
<style type="text/css">
</style>

<style type="text/css">
.style1
{
height: 24px;
}
</style>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
<asp:ScriptManager ID="ScriptManager1" runat="server">

<asp:UpdatePanel ID="updatepanel5" runat="server" UpdateMode="Always">
<contenttemplate>

<table style="width:100%">
<tr>
<td style="background-color: #33628a; " align="right" class="style1">
 

</td>
<td colspan="2" style="background-color: #33628a; margin-left: 120px;
color: white; font-size: 25px; " align="center"
class="style1" >
Calendar
</td>

<td style="background-color: #33628a; " align="right"
class="style1">
 
</td>
</tr>
<tr>
<td>
 
</td>
</tr>
<tr>
<td valign="top" style="width:150px">
<DayPilot:DayPilotNavigator ID="DayPilotNavigator1" runat="server"
BoundDayPilotID="DayPilotCalendar1"
SelectMode="Week"
ShowMonths="3"
CssClassPrefix="navigator_google_"
DataStartField="startdate"
DataEndField="enddate"
VisibleRangeChangedHandling="CallBack"
önVisibleRangeChanged="DayPilotNavigator1_VisibleRangeChanged"
>
<br />
<br />
<div style="height:20px"></div>
</td>
<td valign="top">

<daypilot:daypilotcalendar id="DayPilotCalendar1" runat="server"
DataStartField="startdate" DataEndField="enddate" datatextfield="Meeting Name" DataValueField="MeetingId"
datatagfields="Meeting Name, MeetingId"

Days="7"
EventCorners="Rounded"
MoveBy="Top"
CellSelectColor="#cccccc"
ShowAllDayEventStartEnd="false"
EventArrangement="Full"
EventHeaderVisible="true"
ShowEventStartEnd="true" style="top: 0px; left: 0px; height: auto; width: 100%"
önCommand="DayPilotCalendar1_Command"

ScrollLabelsVisible="false"
DurationBarVisible="false"
BackColor="white"
NonBusinessBackColor="white"
EventBackColor="#638EDE"
EventBorderColor="#2951A5"
HourNameBackColor="#F3F3F9"
CornerBackColor="#F3F3F9"
HourFontColor="#42658C"
HeaderFontColor="#42658C"
EventFontColor="white"
ShowToolTip="true"
EventFontFami

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class WebFormAdmin_SelectNetwork : System.Web.UI.Page
{
WorkspaceBAL objBAL = new WorkspaceBAL();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
select_people.Visible = false;

_LoadNetwkHdList();
display.Visible = false;
}
}


//Bind the Network Header List
void _LoadNetwkHdList()
{
DataTable dt = new DataTable();
dt = objBAL.GetNetwkList("SelectNetwork");
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "NetwkName";
DropDownList1.DataValueField = "NetwkID";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("Select", "0"));
}


protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
select_people.Visible = true;
int ss = Convert.ToInt32(DropDownList1.SelectedValue);
// _BindEmployeelistByNetwkID(Convert.ToInt32(ddlNetwkName.SelectedValue));
DropDownList2.DataSource = objBAL.GetNetWorkDetailslist(Convert.ToInt32(Session["UserId"]), Convert.ToInt32(ss));
DropDownList2.DataTextField = "EmployeeName";
DropDownList2.DataValueField = "NetwkID";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, new ListItem("Select", "0"));
}

protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
display.Visible = true;
Name.Text = DropDownList2.SelectedItem.Text;

}

}

s ryanDev ..... i binded in ddl1 ..... My concept is
ddl1 --- Select network ---- cat (working)
ddl2 --- Select people ---- a (works but i couldn't select b,c,d) ...



void _LoadNetwkHdList()
{
DataTable dt = new DataTable();
dt = objBAL.GetNetwkList("SelectNetwork");
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "NetwkName";
DropDownList1.DataValueField = "NetwkID";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("Select", "0"));
}

The case is .... dropdownlist2 contains 4 values(a,b,c,d)..... and i make them display in page whatever the item is selected ..... if c is selected .... always it selects 'a'... i couldn't get the values of b,c,d ....

I m checking postBack event

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
select_people.Visible = false;

_LoadNetwkHdList();
display.Visible = false;
}
}