[Code]....
i got a function which will return object.Inside here, i retrieved my query using stored procedure and then, save the data into object.class. But, how i do it ???
e.g example
Query : Select name , age , add from tablename
Object : save the retrieved record into object
Output : i get the value juz by calling like object.getName(), object.getAge() and so on ..
[URL]above url contain a html table.I want to save this table value on XML and also want to save this table value on database MS2008.How to save html table values on database
View 3 RepliesI want to bind gridview with datatable in this dt ihave 4 columns , dt
Id Name isdelete value
1 xyz true
2 uio false
3 bbb true
4 ccc false
this is gridview
[Code]....
but i want not bind those rows whose isdelete coumn value is false and i want to show 4 th column as textbox and user will enter some text or number and if he click save button outside of gridview one record shld save in database
I have gridView with checkbox on each row, when user click "Submit" then I want a loop go through the gridview, then save those are checked.
ClientID | Client | Emails | chkBox |
[Code]....
On the code behind, how can I identify the data on each row to save to database?
[Code]....
Now I can upload image/Word document and store it in to our SQL database.
Also I can save image retrieved from our SQL database.
But I am having problem with retrieving Word document.
Right now I am doing this for word document:
[Code]....
This works, but IT ONLY shows in the browser. (I WANT TO SAVE THIS AS .DOC IN ONE OF OUR FOLDER)
For images (*.jpg *.gif) I can save it in our folder. Like this:
[Code]....
This saves as temp.jpg in our Temp folder.
I want to do exactly the same with word document.
But I cannot use Bitmap as image. It gives me error...
[Code]....
I have a Table,When user want to add Data,I save it to Data and Reload the Table. When they finish add Data,I have an arrData1. The problem is How can I send arrData1 to Ajax
[Code]....
How can In Controller SavePhone I can Retrive an Array ?
a simple way to filter SQL data when it is retrieved by a GridView control?
Among the various applications I need to create are selecting records based on user inputed criteria (via a DropDownList), and excluding records that have null values (which I need to allow in my database) in certain columns.
I have a problem to save data into SQL table.
I have two listbox controls, one contains the Author list and another contains the author of the particular record.There are two buttons to copy data from one list box to another listbox.
[Code]....
And aspx.cs code file is:
[Code]....
When click the arrow button it adds the author from authorlist to selectedAuthors listbox and vice versa but the problem is, How can I save those authors(newly added for that record) in database columns ?
how to get value this table output is
row 1, cell 1
row 1, cell 2
row 2, cell 1
row 2, cell 2
and save automatically in database no any where click
<table border="1">
<tr>
<td>row 1, cell 1</td> [code]....
I am retrieving two dates(start date and end date) from the table
for instance 8/7/2014 and 12/7/2014 i need to display all the dates which are in between these two selected dates in the asp.net calendar control.. How do i write the code in day_render event and compare these dates
actually my need is that, after uploading a doc file I want to save this doc file's text to database table, with the help of asp fileupload control. actually in real I dont want to save this whole file anywhere, but I just need the text to save in databse.
View 2 RepliesI have made a call logging application in which i have authorised a normal user to edit update and delete from the gridview.But i want to give the admin person rights to see all the complaints deleted updated edited..i have thought a lot but all in vain havent found.
View 1 RepliesI have a dropdownlist that pulls from a datasource. When a name is selected all information drops down to a formview. Once there 3 fields get populated from the dropdownlist and then there is 2 other fields that need user input. Once they hit submit, it should write to a different table in the same DB. I cannot get the fields to populate and write to the DB. Here is my code:
[code]...
Having serious trouble inserting data into my db... i am able to select and display data just not write it to the database..
[Code]....
Actually i have Textbox in Repeater, while entering value to the textbox and comes out from the textbox, the data which entered in textbox should stored in database.
View 1 Repliesi retrieve a data named semesterstartdate, after retrieving i neede to add day to the data. How can it be done?
View 2 Repliesthis information is i retrieve from database.
like for vb.net it has a function called print screen. for C#, is it possible to print it? if the user clicked a print button on the screen?
----> I have datatable which is passing to another page in session variable.
----> Now on another page i take the session variable into datatable.
datatable ds_table = new datatable();
ds_table = (datatable)session["table_value"];
----> so problem, is that , when i filtering some rows from ds_table . that taking effect in the session variable. if some rows deleted from ds_table. then it is also deleted from session variable.
----> so, anyone tell me why is this going to happene?
I use the DetailsView control to display selected employee's data for HR. The list of data elements has gotten pretty long so I thought I'd put some tables & panels inside the ItemTemplate and EditTemplate. Testing with NO code behind in effect works perfectly on display & update. Now I need to manipulate some stuff in the code behind which requires me to cast the controls I'm after. However old cast code doesn't work (it says the row index doesn't exist).
First is a clip of the DetailsView which gives me 3 nice columns.
[Code]....
When the data is retrieved through a stored procedure using the SQLDatasource control that is binded to a gridview control, I want to change some data that is in some of the columns. Can i do this in one of the events either in the gridview or data control? I know you can do some formatting on the aspx page side such as dates, etc. but was wondering if I can do it on the vb code side?
View 8 RepliesI have the following code in my webmatrix project
[Code]....
What i need to do is to make one of the cells change colour depending on the result. So say if the What column showed 1, 2 or 3 or would show in the table red green or amber.
I have this asp.net website that generate records of Staff. As you type staff's Id no. in a texbox and click the 'Generate record' button, the page will be redirect to the another page of which the report has to be viewed.
In my first aspx.cs (session.aspx):
[Code]....
I have my report.rpt which I have already populated with designated fields like:
Staff_No, First_Name, Middle_Name, Last_Name
Also, I have already drag the CrystalReport Viewer from toolbox in my second page.
That's all what I have done. Any thing that I forgot to do, I do not know.
I got no errors. But when I run it in the browser, the report does not displayed in the browser and I got this "The parameter is incorrect" text at the end of my browser.
-- I'm using SQL server for my database, Visual Studio 2008 (C#) for the codes and everything..
I have tried to query a table with an xml column by using XQuery and I can't get the Select to work.
All my knowledge/understanding of the subject comes from this MSDN article:
[URL]
so I am probably overlooking something minor:
I tried this query Select col1, Phone.Query('element CellPhone {I am not sure about what goes here} I tried {data('Phone/cellPhone} from aTable Where Phone.Exist('/Phone/cellPhone/text()[contains.,"412-8977"]') = 1 This syntax is definitely not fun.
Prior to using a ViewModel, I could easily pass the "soon to be edited" object directly to the view without needing to fuss over setting individual properties etc as the View conveniently accepted the Employee type directly..
[HttpGet]
public ActionResult EditEmployee(int? id)
{
EmployeeRepository ER = new EmployeeRepository();
Employee SomeEmployee = ER.GetEmployee(id.Value);
if(SomeEmployee!=null)
return View(SomeEmployee);
But now I'm using a ViewModel with DataAnnotations attributes applied over the top of various properties for validation purposes. Which creates a problem.. After fetching the "soon to be edited" object from the db, setting the ViewModel's values is suddenly a whole lot more complicated. I can't simply pass the retrieved object straight to the view, as the View now expects the VMEmployee type instead. I would like to be able to do something like:
[HttpGet]
public ActionResult EditEmployee(int? id)
{
EmployeeRepository ER = new EmployeeRepository();
Employee SomeEmployee = ER.GetEmployee(id.Value);
if(SomeEmployee!=null)
return View(new VMEmployee(SomeEmployee));
All paths seem to lead to a huge constructor which manually sets the values of each individual property. But I never had to do that before when I wasn't using a ViewModel. Model binding was a blessing! My objects also have complex child objects, which my form is also collecting values for, so this would be a huge/verbose task against DRY principals. I don't even really want to use a ViewModel, but am forced to because I need two different DataAnnotations rule sets for different validation scenarios applied to the same object.
All I want to do is be able to have two different DataAnnotations rule sets for different scenarios. I.e. public-facing www site vs internal-facing admin site. DataAnnotations doesn't seem to be flexible enough to easily cater for this common need. I've tried AutoMapper, but it throws an error saying it can't map my object types, I suspect because Employee was auto-generated by LINQ to SQL. What is the most elegant way to achieve this while sticking to DRY principals?
Having a problem with autocomplete I put autocomplete control with textbox For data to be retrieved from database, I am putting .asmx file and .cs file for that Now I am giving .asmx file path in autocomplete. asmx file contains path for .cs file If this is the situation, autocomplete dont work and in .cs file , event is not fired.
But if i put that event from .cs file directly into the codebehing file of that control, then it works ok
How can i call an event in .cs file that is placed inside a app_code folder seperately from .aspx and .cs file of the autocomplete control