Re: HttpContext.Current.Server.MapPath - ASP.NET Discussion Boards

how to enter dataset value into the combobox as Selected Text

Amit Spadez17-Jun-10 1:43

17-Jun-10 1:43

Hello all,
I'm working on some Desktop based Project in VB.Net in which I have made a page (say UpdateData.aspx) to update the employeeDetails.In that page, There is a DataGridView that displays all the detials. So, I'm using the cell_click event of the gridview. So, When I click on the gridview row, it retrieves all the records which are then populated into respective fields, except into 3 combobox fields.
I don't know what to do with them to enter some particular value into those comboboxes as those also contain some datasource.
And My code is like the following:

ds = obj.GetDetails(objBo)
If ds.Tables(0).Rows.Count>0 Then
comboItemName.SelectedText = ds.Tables(0).Rows(0)("itemName")
comboItemSerialNo.SelectedText = ds.Tables(0).Rows(0)("SerialNo")
END

please help...

Thanks in advance

Re: how to enter dataset value into the combobox as Selected Text

shreekar17-Jun-10 1:59

shreekar

17-Jun-10 1:59

vinci007 wrote:
some Desktop based Project

I assume this was a typo.

Provided that you have setup the data source for the comboboxes in the template (if using them), and the selected text matches the valid entries, the display should be correct. You may also need to provide the selectedvalue properties though.
What is the error/problem?

Shreekar

Re: how to enter dataset value into the combobox as Selected Text

Amit Spadez17-Jun-10 2:05

Amit Spadez

17-Jun-10 2:05

Yeah, there are valid datasource in the combobox. The problem is that the value is not shown in the "comboItem" combobox for editing... in other words , combobox doesn't get value on edit...
what could be the error...

Re: how to enter dataset value into the combobox as Selected Text

shreekar17-Jun-10 3:30

shreekar

17-Jun-10 3:30

Please share the relevant code as the sequence of events might have some bearing on the problem.
Can you see the list of values in the dropdown?

Shreekar

Dynamic grid problem

Amit Patel198517-Jun-10 1:19

Amit Patel1985

17-Jun-10 1:19

Hi All i m creating the grid using the following way
<pre>
private void loadDynamicGrid(Int32 startTime, Int32 endTime, String firstTime)
{
//Create an instance of DataTable
//Create an ID column for adding to the Datatable
dt = new DataTable();
DataColumn dcol = new DataColumn(ID, typeof(System.Int32));
dcol.AutoIncrement = true;
dt.Columns.Add(dcol);
DataRow drow = null;
drow = dt.NewRow();
//Add the row to the datatable.
dt.Rows.Add(drow);

BoundField bfield = new BoundField();

if (String.Compare(firstTime, "firstTime") != 0)
{
GrdDynamic.Columns.Clear();
bfield.HeaderText = "     " + "MODALITY" + "     ";
bfield.HeaderStyle.BackColor = Color.LightGray;
bfield.HtmlEncode = false;
GrdDynamic.Columns.Add(bfield);
}

foreach (DataColumn col in dt.Columns)
{

for (Int32 index = startTime; index < endTime; index++)
{
Int32 hour = index;

for (Int32 minute = 0; minute <= 3; minute++)
{
//BoundField bfield = new BoundField();
bfield = new BoundField();
String headertext1 = ((hour.ToString()) + ":" + (15 * minute));
String[] headerText = headertext1.Split(':');

if (headerText[0].Length == 1)
{
bfield.HeaderText = " 0" + headerText[0] + ":" + headerText[1];
}
else
{
bfield.HeaderText = " " + headerText[0] + ":" + headerText[1];
}

if (headerText[1].Length == 1)
{
bfield.HeaderText = bfield.HeaderText + "0 ";
}
else
{
bfield.HeaderText = bfield.HeaderText + " ";
}
bfield.HtmlEncode = false;

GrdDynamic.Columns.Add(bfield);
//GrdDynamic.CellSpacing = 1;
}
}
}

//Initialize the DataSource
GrdDynamic.DataSource = dt;
//Bind the datatable with the GridView.
GrdDynamic.DataBind();

}

</pre>

i want to add link button in grid cell based on some condition.

how to do this
<pre>

calling function using following call.

</pre>

HttpContext.Current.Server.MapPath

KishoreT17-Jun-10 0:03

KishoreT

17-Jun-10 0:03

I have an xml configuration file in my project.

when I am working in debug mode of .net IDE it is working fine, but when i tried to launch the project from IE, it is taking different path

ex:
below code works well in debug mode, but unable to launch in IE directly (http://localhost/WebProj/login.aspx)

Pathtype A:

HttpContext.Current.Server.MapPath(@"\Configuration\xyz.xml");

below code works well in IE and debug mode but having different problem.
Pathtype B:

HttpContext.Current.Server.MapPath("") + @"\Configuration\xyz.xml";

Problem: I have a folder MainPages under root folder of the project. under this I have AdminPages. These admin pages are not retrieving if I used pathtype B specified above and gives error no page available, but works fine when pathtype A specified above is used which runs in debug mode only but not able launch from IE.

Help me please.

Re: HttpContext.Current.Server.MapPath

Jens Meyer17-Jun-10 1:18

Jens Meyer

17-Jun-10 1:18

Hi KishoreT,

if i understand you right, you have the xml-file in a subdirectory of the root of the webpage. The subdirctory is "Configuration". Therefore i suggest you use the following to get the path:

HttpContext.Current.Server.MapPath(@"~\Configuration\xyz.xml");

The difference is the ~ (tilde) character. It represents the homedirectory or root of the webapp.

Hope this helps

Regards

Jens

When in trouble,
when in doubt,
run in circles,
scream and shout

Re: HttpContext.Current.Server.MapPath

KishoreT17-Jun-10 2:02

KishoreT

17-Jun-10 2:02

Hey thank u its working by placing ~.

AjaxPro and Actionchart issue?

Jeneesh K. Velayudhan16-Jun-10 23:17

Jeneesh K. Velayudhan

16-Jun-10 23:17

Hi,

am using actionchart in one of my asp.net 2.0 application. also now am using "AjaxPro.AjaxHandlerFactory,AjaxPro.2" in this application for that i have added one handler in web.config file.

<httpHandlers>

</httpHandlers>
</system.web>

like that.

After that, my action chart is not working!!!
But if am commenting the handler part, action chart will work, but ajaxPro willnot work.

Please help me ASAP.
I have to resolve by the end of today Frown | :(

Thanks & Regards,
Jeneesh K. Velayudhan

ASP.Net MVC 2.0 Sample Project Required

Member 401661616-Jun-10 22:46

Member 4016616

16-Jun-10 22:46

Hi All,
I am Developing a web base project using asp.net mvc 2.0 architecture for my current window based application.
The following things will be used in my project.
1.The Menu and sub Menus
2.Support for multiple database
3.The view for displaying record fetch from the database
4.Making connection to service

so if anybody can give the url for similar projects which i can refer to it will be quite helpful

Thanks in advnace
Ramesh singh

Re: ASP.Net MVC 2.0 Sample Project Required

R. Giskard Reventlov16-Jun-10 23:12

R. Giskard Reventlov

16-Jun-10 23:12

See here: ASP.Net MVC[^]

me, me, me

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

nils illegitimus carborundum

returning null value from procedure

developerit16-Jun-10 22:05

developerit

16-Jun-10 22:05

hi iam using asp.net2.0 with c# with sql server 2000

when iam executing the procedure in local system it is working fine.but when iam executing in client system procedure returns null value, i have checked all connection string , and session value all are working

can you correct the code which helps me

SqlConnection concreate = new SqlConnection(strcon);

string pp = "";
pp = "create procedure getsum( @BranchKey int,@FromDate smalldatetime,@ToDate smalldatetime, @tot decimal output )";
pp += "as";
pp += "\n";
pp += "set @tot=(SELECT  SUM(Amount) FROM   AllTransactions WHERE BranchKey=@BranchKey  and  (TransCode <> 0) and (TransDate > @FromDate) and (TransDate < @ToDate)  GROUP by  BranchKey)";
pp += "return @tot";
pp += ";";


SqlCommand cmdcreate = new SqlCommand(pp, concreate);
concreate.Open();
cmdcreate.ExecuteNonQuery();
concreate.Close();

SqlConnection conproc = new SqlConnection(strcon);
conproc.Open();
SqlCommand cmdproc = new SqlCommand("getsum", conproc);
cmdproc.CommandType = CommandType.StoredProcedure;


cmdproc.Parameters.AddWithValue("@BranchKey", Convert.ToInt32(Session["BranchKey"]));
DateTime dt = Convert.ToDateTime(txtfrom.Text.ToString());
string fromDate = dt.ToShortDateString();
DateTime dt1 = Convert.ToDateTime(txtto.Text.ToString());
string toDate = dt1.ToShortDateString();
cmdproc.Parameters.AddWithValue("@FromDate", fromDate);
cmdproc.Parameters.AddWithValue("@ToDate", toDate);

SqlParameter p1 = cmdproc.Parameters.Add("@tot", SqlDbType.Decimal);
p1.Direction = ParameterDirection.Output;
if ((cmdproc.ExecuteScalar() != DBNull.Value) && (cmdproc.Parameters["@tot"].Value) != DBNull.Value)
{
    decimal ot = Convert.ToDecimal(cmdproc.Parameters["@tot"].Value);
    if (ot != null)
    {
        txttotal.Text = ot.ToString();
        conproc.Close();
    }
}
else
{


    clsdataset.ShowAlertMessage("No Data");

}

Re: returning null value from procedure

Tej Aj17-Jun-10 0:52

Tej Aj

17-Jun-10 0:52

check this post

http://opexsolution.com/forum/viewtopic.php?f=15&t=55&p=169#p169[^]

Re: returning null value from procedure

shreekar17-Jun-10 1:54

shreekar

17-Jun-10 1:54

Not an answer, but a question - Why are you creating the SP in your code?

Shreekar

Re: returning null value from procedure

T M Gray17-Jun-10 10:13

T M Gray

17-Jun-10 10:13

Is the data the same in the two systems? Are you sure the query returns anything?

From the documentation for ExecuteScalar:
The first column of the first row in the result set, or a null reference (Nothing in Visual Basic) if the result set is empty.

You could try getting rid of the output parameter and just using a SELECT instead of a SET and RETURN.

Also, look into @ strings rather than lots of concatenation.

Updateprogress bar

sjs4u16-Jun-10 21:39

sjs4u

16-Jun-10 21:39

Hi,

I want to use progress bar in my webpage.
I dont want third party control.
How can i use AJAX updateprogress.

Thanks
sjs4u

Re: Updateprogress bar

saini arun16-Jun-10 22:51

saini arun

16-Jun-10 22:51

http://ajax.net-tutorials.com/controls/updateprogress-control/[^]

Found above page as first result on google.

Gridview sorting

Abbas_here16-Jun-10 21:13

Abbas_here

16-Jun-10 21:13

Hi Freanids,
I am using a Gridview in my project but when i implement sorting on columns its giving following error randomly,
Error is bellow:

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Kindly help me on this issue, how i resolve it.

Thanks in advnace
Arsad

Re: Gridview sorting

Manas Bhardwaj16-Jun-10 21:33

Manas Bhardwaj

16-Jun-10 21:33

Did you try to google [^]the error message?

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Gridview sorting

Abbas_here17-Jun-10 0:53

Abbas_here

17-Jun-10 0:53

Hi Manas,

Thanks for your suggestion on this actually i tried it before but i didn't succeed at that time as the most of comments suggest to add commond timeout attribute in connection string, for now i again implement it at this time no error occured, as i say it was randomly occur so hoping for best.

Thanks for help
Abbas

Re: Gridview sorting

shreekar17-Jun-10 1:51

shreekar

17-Jun-10 1:51

The query timeout happens for the query. So next time it happens, check the query that is executed. Compare it with the query that does not time out.
Maybe that will help?

Shreekar

Re: Gridview sorting

Abbas_here17-Jun-10 3:33

Abbas_here

17-Jun-10 3:33

thanks Shreekar.

How to rewrite the url ?

Sudhanshu Mani Tripathi16-Jun-10 20:27

Sudhanshu Mani Tripathi

16-Jun-10 20:27

I want to rewrite the url based on query string in asp.net with c#. it means if url comes
http://app.tasktrek.in/Citylist.aspx?Id=1
then it should be look like
http://app.tasktrek.in/Citylist.aspx/Noida in url

where Id=1 for noida ,

Also have any solution in which I do not want to confiure IIS?

How to do it in asp.net .

Re: How to rewrite the url ?

Abhijit Jana16-Jun-10 20:50

Abhijit Jana

16-Jun-10 20:50

URL Rewriting is very much common thing for an ASP.NET Application. There are many way that you can do it and depends on your ASP.NET Framework it may simple to implement also. Did you search google before posting the question over here ?

Here is few links that will help you.
URL Rewriting with ASP.NET[^]
http://msdn.microsoft.com/en-us/library/ms972974.aspx[^]

Cheers !
Abhijit Jana | MVP
Web Site : abhijitjana.net | Follow Me @ twitter
Read my Latest Article :Mastering Debugging in VS 2010

Re: How to rewrite the url ?

Sudhanshu Mani Tripathi17-Jun-10 3:03

Sudhanshu Mani Tripathi

17-Jun-10 3:03

Hi Abhijit I studied the above url that u have sent but i am not getting any changes in url when implement.
Actually i want if incoming url is http://localhost:53365/UrlRewrite/City.aspx?Id=1"
then it convert into http://localhost:53365/UrlRewrite/City.aspx/Noida
where noida is cityname that depends on querysring value.

please help me.

Last Visit: 31-Dec-99 18:00 Last Update: 3-May-24 13:36

Refresh

ᐊ Prev 1...862 863 864 865866867 868 869 870 871 Next ᐅ

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