Comments by postonoh (Top 94 by date)

my id=pgNum. Is there way to make this pick up the Pagenumber in the ChapsString.Add(chptr.PageNumber.ToString() + " " + " " + chptr.ChapterTitle);

did thanks.

The question is how do I wire the values retrieve from the ajax call to the pages after pages are drawn. The values are coordinates of hot link for the each page. Also I am

Having problem taking the value I receive and wire it to the my pages
so they will show up on the page.

How do I wire my ajax to c# code back to my Jquery page code. My ajax to c# Web Method works. Thanks for your patience.

Having problems linking up my database stored weblinks to the flipbook coordinates pages for an iPad. My thoughts were moving faster then my hand could type.

I have web links stored in my database. I need to retrieve the links which my c# code does. my Jquery code allows me to draw even and odd pages like a book. On this pages from are CMSystem we create map out links in rectangular design that are hot-spots. I trying to recreate this with the iPad. It works with web browser(IE, Chrome, etc). I hope I am explaining right.

Thanks I change the webconfig to give to the aspx file I will fix the code later.

I have the url which is http://www.somewebsite.com/books/client/images.jpg

how do I take the string an replace with this I have the url which is http://www.somewebsite.com/client/images.jpg

I know I have to something in javascript:
var URL = somestring.replace('/books','');

How would I strip the /books out my url. using javascript

Yes to the removing the /books at the beginning path. I can post all my code not alot.

thanks by the way

yes

I can have both aspx and cshtml views in one application. That is what I mean.

Let me understand. I can create aspx pages with razor pages. I will try if so you have been very valuable to me. thanks. If this works I only have to rewrite two forms

Made one change it works thanks

not working

if (item.reviewed == false)
if (item.reviewed == true)

public List<mycombinedquerymodel> Files(int? id)
{


var uploads = (from u in _db.Patients
where u.PatientsId == id
select u.FilesUrl).FirstOrDefault();


if (uploads != null)
{
var dir = new DirectoryInfo(uploads);

IEnumerable<fileinfo> filelist = dir.EnumerateFiles("*.*", SearchOption.AllDirectories);

var query = (from file in filelist
where file.Length > 0
let fileName = file.Name
select new MyCombinedQueryModel
{
FileName = file.Name
}).ToList();


return query;
}
return null;
}

This does not address my question. I need to query the column that has the string location of the files and display file in a grid.

I understand how to you directory.getfiles. I save upload fines to a dynamic string path that is stored in a SQL server database. I need to get the path that is was stored to upload and download files form their location.

I understand how to you directory.getfiles. I save upload fines to a dynamic string path that is stored in a SQL server database. I need to get the path that is was stored to upload and download files form their location.

I know how to do it this way and add another tab or link. I need to upload the files while saving all the other data on the page.

I know how to do it this way and add another tab or link. I need to upload the files while saving all the other data on the page.

I know how to do it this way and add another tab or link. I need to upload the files while saving all the other data on the page.

Thanks I created the code in C# but will copy for future.

What I am trying to accomplished is when a user saves a itemnumber it insert just the number item he has chosen.

I know I can't create a trigger in c# i should have given a better description to my question. The problem with this is that I have three product that exist may all ready exist in the table what will stop it from loop through the table and insert multiple.

What I really need is an update on the table here is the SQL statement

update Quantity
set Quantity = (
select q.Quantity - 1 from dbo.Quantity q
join dbo.OrderDetails o on q.OrderDetailId = o.OrderDetailId
join dbo.Doctors d on o.DoctorsId = d.DoctorsId
where q.Quantity > 0 )

http://msdn.microsoft.com/en-us/vstudio/bb688084 vb
http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b c#
examples of linq queries

I change the code to this :
DB.Cart cart = (from c in _db.Carts
where c.CartRecordId == ShoppingCartId && c.ProductId == id
select c).ToList()[0];
_db.DeleteObject(cart);

Anything better please let me know.

Shmuel Zang you are one of the reason I joined the site. Thanks.

Thanks will try.

Tailspin does not work error messages.

Thanks, Will take a look

I figure it out thanks for you help. The problem was, I was not making sure the ID for each pk,fk was set.

Thanks,

figure out how to grab the user that is log on. now I need insert that doctors pk into the fk of patients

I created a custom role provider for forms security. I have the following three tables. User, User_In_Role, and Roles. I need for when a user register. It places the into the default group of new user. I submitted this question I believe I had the fix but did not work. I believe with the aspnetdb.net security sproc this is the key to making sure the new user set properly.

My original question is here:
http://www.codeproject.com/Questions/343705/How-set-a-default-role-with-custom-RoleProvider

Yes! sorrow I did not mention this.

I appreciate the sarcastic responses. But my experience up to now has been back end work. Had no need for this information. But, I am glad for people like thatraja and Trollslayer who believe in the success of all and not puerile comments from congenital people.

thanks

Thanks, I check my upload code where the if / else statement. I commented them out and the code working know. I have to find a easier way to do multiple uploads.

Here is some additional information. When I test it with VS2008 on local and on the test server it works fine. no problem.

I have no clue how to do this. but I will look in my code for the loop problem.

I really appreciation this information. I new to using XML so thanks. I learning and want to do it right the first time. So thanks I used the XSD to create my XML Schema. Thanks again.
I believe that everyone needs a mentor to lead them into to success!

I really appreciation this information. I new to using XML so thanks. I learning and want to do it right the first time. So thanks I used the XSD to create my XML Schema. Thanks again.
I believe that everyone needs a mentor to lead them into to success!

thanks

Also I have page that is data driven and user search for companies when he select which companies he/she wants it saves the selection to XML file. They want to be able to recall them later use this file to populate other pages at a different time.

I tried something like this at first.

XmlTextReader obj = new XmlTextReader(@"c:\temp\reg.xml");
string sr= "";
while(obj.Read())


switch (obj.NodeType)
{
case XmlNodeType.Element:
sr = obj.Name;
break;
case XmlNodeType.Text:

//this.SubConstructionManagerLabel1.Text = obj.GetAttribute("BusinessName");
rows.SubConstructionManager1.Text = obj.GetAttribute("BusinessName");
//break;
rows.SubContactName1.Text = obj.GetAttribute("OwnerName");
//break;
rows.SubAddress1.Text = obj.GetAttribute("Address");
// break;
rows.SubCity1.Text = obj.GetAttribute("City");
//break;
rows.SubState1.Text = obj.GetAttribute("State");
// break;
rows.SubZip1.Text = obj.GetAttribute("ZipCode");
// break;
rows.SubPhone1.Text = obj.GetAttribute("Phone");
// break;
rows.SubFax1.Text = obj.GetAttribute("Fax");
//break;
rows.SubEmail1.Text = obj.GetAttribute("Email");
break;
}

Change code look like this now can see data from xml.

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(@"c:\temp\reg.xml");
XmlNodeList xmlnodelist = xmldoc.;
XmlNode xmlnode = xmldoc;
rows.SubConstructionManager1.Text = xmlnode["BusinessName"].InnerText;
rows.SubContactName1.Text = xmlnode["OwnerName"].InnerText;
rows.SubAddress1.Text = xmlnode["Address"].InnerText;
rows.SubCity1.Text = xmlnode["City"].InnerText;
rows.SubState1.Text = xmlnode["State"].InnerText;
rows.SubZip1.Text = xmlnode["ZipCode"].InnerText;
rows.SubPhone1.Text = xmlnode["Phone"].InnerText;
rows.SubFax1.Text = xmlnode["Fax"].InnerText;
rows.SubEmail1.Text = xmlnode["EmailAddress"].InnerText;

Thanks, I put this snippet of code out here so maybe someone can inform me what I am missing.
I will do some research on other forums.

Thanks for you insight,

Yes it is null, I am trying to insert the data found in the xml document to the text boxes

Line 981: obj.ReadStartElement("BusinessName", rows.SubConstructionManager1.Text);

NullReferenceException: Object reference not set to an instance of an object.]
Test.UI.Controls.TestPage.BaseProjectReferralTableControl.loadXML() in f:\Test\Test\App_Code\Test Page\TestPage.Controls.cs:981
Test.UI.Controls.TestPage.BaseProjectReferralTableControl..ctor() in f:\Test\Test\App_Code\Test Page\TestPage.Controls.cs:754
Test.UI.Controls.TestPage.ProjectReferralTableControl..ctor() +43
ASP.project_referral_TestPage_aspx.__BuildControlProjectReferralTableControl() in f:\Test\Test\Test Page\TestPage.aspx:542
ASP.project_referral_TestPage_aspx.__BuildControl__control27(Control __ctrl) in f:\Test\Test\Test Page\TestPage.aspx:539
System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container) +12
System.Web.UI.UpdatePanel.CreateContents() +118
System.Web.UI.UpdatePanel.set_ContentTemplate(ITemplate value) +222
ASP.project_referral_TestPage_aspx.__BuildControlProjectReferralTableControlUpdatePanel() in f:\Test\Test\Test Page\TestPage.aspx:539
ASP.project_referral_TestPage_aspx.__BuildControlForm1() in f:\Test\Test\Test Page\TestPage.aspx:25
ASP.project_referral_TestPage_aspx.__BuildControlBody1() in f:\Test\Test\Test Page\TestPage.aspx:24
ASP.project_referral_TestPage_aspx.__BuildControlTree(Test_Test_TestPage_aspx __ctrl) in f:\Test\Test\Test Page\TestPage.aspx:1
ASP.project_referral_TestPage_aspx.FrameworkInitialize() in f:\Test\Test\Test Page\TestPage.aspx.cs:912308
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +56
System.Web.UI.Page.ProcessRequest() +80
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.project_referral_TestPage_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\Test\964f5007\2c6ae9b9\App_Web_xmte9nts.0.cs:0
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

can you give code full code with the search filter

Just to try in understand.

You want to add when user press the enter key.
Answer to display in a text box.
Also if user press the backspace the backspace remove data in the cell only
but when press delete key it delete the row and subtract value.

I missing something because the session is saying null when I place a break and step into

I believe the Session.Add("Key", rows); should be this
Session["ID"] = rows;
Session["Name"] = rows;
Session["Address"] = rows;

I believe the Session.Add("Key", rows); should be this
Session.Add("ID", rows);
Session.Add("Name", rows);
Session.Add("Address", rows);

nullReference not set to an instance of an object

Session is showing null but my rows are showing selected.

I tried this getting error message.

I can change the data structure. no problem. I just need an idea on the best way to do this. with sample code.

Ok.. I have the code that when user check the box for referral it puts a number 1 in the database column referral. so when a user go to save it has to first check to see if check box is check then check the sql server database column referral if not empty add 1 to the existing number.

I have created edit/update pages for partial save data. This allows user if they don't have all necessary information from a client they can save and return at a later date.

Thanks for pointing me the right direction. I had to move this cmd.Parameters["@p_CustomerID_out"].Direction = ParameterDirection.Output;
under the cmd.Parameters["@p_CustomerID_out"].Value = recID + 1;
fix the problem.

Thanks figure how to append selected. thanks get still getting the following error message.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. Researching this now

thanks

Made the following changes


cmd.Parameters.Add(new SqlParameter("@p_CustomerID_out", SqlDbType.Int));
if (recMode == 0)
{
// New record
cmd.Parameters["@p_CustomerID_out"].Value = recID + 1;
}
else
{
//Editing a record
cmd.Parameters["@p_CustomerID_out"].Value = recID;
}

cmd.Parameters.AddWithValue("@p_CompanyName", SqlDbType.NVarChar).Value = CompanyName.Text;
cmd.Parameters["@p_CustomerID_out"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@p_Title", SqlDbType.NVarChar).Value = Title.Text;
cmd.Parameters.Add("@p_Contact", SqlDbType.NVarChar).Value = ContactName.Text;
cmd.Parameters.Add("@p_Address", SqlDbType.NVarChar).Value = Address.Text;
cmd.Parameters.Add("@p_City", SqlDbType.NVarChar).Value = City.Text;
cmd.Parameters.Add("@p_State", SqlDbType.NVarChar).Value = State.Text;
cmd.Parameters.Add("@p_ZipCode", SqlDbType.NVarChar).Value = ZipCode.Text;
cmd.Parameters.Add("@p_Telephone", SqlDbType.NVarChar).Value = Telephone.Text;
cmd.Parameters.Add("@p_FaxPhone", SqlDbType.NVarChar).Value = FaxPhone.Text;
cmd.Parameters.Add("@p_CellPhone", SqlDbType.NVarChar).Value = CellPhone.Text;
cmd.Parameters.Add("@p_EmailAddress", SqlDbType.NVarChar).Value = EmailAddress.Text;
foreach (ListItem item in Category.Items)
{
if (item.Selected && item.Value != "0")
{
cmd.Parameters.Add("@p_Category", SqlDbType.NVarChar).Value = Category.Text;
cmd.ExecuteNonQuery();
}
}

now getting error code:

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

I am trying to if possible append items selected in the list box and insert them into the category column in the table. Can you help with this.

I am trying both types in the database to see which saves with the dashes and cell is cell phone my mistake thanks.

Thanks. this works.

I have tested the view against the database. The view gives me 60 days forward and 60 in the past in case a something was missed.

I just need sample code on when I click the search button the stored procedure uses the startdate and enddate as the keys to re-populate the gridview.

Thanks!

I understand that first one table is updated then from the table an id is inserted into the second then third and so on.

I guess the question I am asking is what order do I have to write it.


I asking the order of insert when writing the query is it

right to left table1 insert into table2
right to left table2 insert into table3
right to left table1 insert into table3

Can you give me a insert query example

I know I change it to 0, 0 and the checkboxes come up false which mean unchecked. when I click the boxes to turn them true. They still read false

Thanks

Problem two is fixed the remove button what not showing up on its current row.

example code please

Hey I change the database and made projectname primary key.Now when I go to add an new account it give the error message error trying to modify primary key.

The text boxes are set for numeric only. So if an user type anything that is not numeric it show an error on the side. The reason I showed you the code is because, it works and populate the necessary boxes when calculated. The problem I am having is when I place percentages in the boxes manually and save it write the information to the database. Yet when I have the press calculate button the percentage shows up in the proper textboxes, click the save button the percentage are there when I query the database. At first I thought it was because the percentage boxes set to readonly. change them to allow number to be entered and same results.

Thanks

Reason for my vote of 5
answer perfect

Reason for my vote of 5
fix problem

will correct!

will try thanks.

Thanks.

can you give me generic example