i have a gridview as follows:
Sub marks result
eng 56 p
maths 45 f
science 67 p
S.S 78 p
im using the mail function to send the marks to the student. how to convert these gridview rows to the table rows or how to pass the gridview datas into mail function as'message'
i want store all the datas of xl sheet into sqlserver database table. i am using asp.net 2.0 and sqlserver 2005. pls provide the coding.
View 2 Replieshow can i read datas from table control
View 4 Replieshow can i dynamically insert datas from database into Table and display the table
View 1 RepliesI have a gridview in a webform. When the page is laoded the data from xml is binded to gridview. Say i have twenty product details in xml. Now i have written code to bind those details with gridview its working fine.
i want to display like this, for exmaple if there are twenty records i want to display ten datas on left and ten datas in right, find the sample below,
Records in dataset,
a 1
b 2
c 2
d 3
this is the way i want to display in gridview,
a 1 c 2
b 2 d 3
I'm wondering if it's a GridView is able to display data from my VB.NET Script.
My GridView is connected to a SQL server wich display datas from an user which can have a few accounts.
My script write one password per line.
How can I display passwords in the same lines from the GridView ?
i am making an application using a datagridview... And I am very new to it. And I need to edit my datas in gridview using a dropdown list.
So this is the flow of the program. As the page load, my gridview will appear, with the datas from the database binded to it, so far I have done that already. Every row in the gridview has an edit hyperlink, so when I click that, I can change the values in that row using a dropdownlist, wherein, the item in my dropdown are aswell from my database.
I have a list with computers, username and other values in a SQL server.
I can diplay this on a gridview with a SQL script.
However i wan't to filter the list by the windows's username.
When a user logon from this windows account and goes to the ASP.NET web page he could shows only the list that contains his username...
I'm able to ask to the SQL server the SQL login, computer name wich we are logged on but no the windows login.
If someone known how make a kind of filter, i can display the windows username with a VB.NET script
how to join two datatable datas into one datatable to show in one gridview
i.e in 1 datatable i have username and pwd and in another datatable i have that user details. how to show all these in one datatable to get those values display in gridview(asp.net)
I have AspTable which is full of data
Table TableDDl = new Table(); and I have DataTable
DataTable DataTableDDl = new DataTable();
who can I put the same data from AspTable in the same place in DataTable ?
Ex...If I have "Hello" in (third row and first cell) in AspTable....Who can I put "Hello" in (Third Row and First Colum in DataTable) >>>But for add data...
I try
DataTable1.Load(Table1);
But it didn't work because it want a reader....I want the same thing but With AspTable
for my web part,i need to show some data of data table.now,i m developing in asp.net with c#.how i convert to html table from data table?And also,i don't need to show some columnsuch as ItemID.my data table will be like this.
ItemID ItemName Qty Price Unit Amount
I-0001 ItemOne 10 100 Box 1000
I-0002 ItemTwo 20 200 Card 4000
I-0003 ItemThree 30 300 Tab 9000
itemID column is not need to show.i want only itemname,qty,price,unit,amount columns.
please give me right way.
I read a lot of tutorials to learn what was the way to manage accessdata on a MySQL database from my ASP.NET, but there still something to whichremains unclear is the formatting of data and the ideal time to do so.For example, if I have a sentence like the following:"Je voudrais t'aider à résoudre ton problème"
When I pass the variable that contains this sentence, I wonder who the quotea problem because the SQL query in this setting look like this:"'I want to help you solve your problem'The quote of "t'aider" comes as the end of ther string in the query string. So I have to the format the string to double the quote to be able to pass it in the database..Maybe I missed the good tutorials, so if you have any links
I have a form in which I display data from a database table, change the data and then update the database table. The form consists of textboxes, so all data displayed in the form is string. However - one data is int in the database table (the rest is varchar), so I need to convert it from string to int when I update the database table. How do I do it?
[Code]....
And, strangely enough, the same code doesn't work with parameters. How is that?:
[Code]....
[Code]....
I have the following PHP that reads in a CSV file and outputs rows/cells of an HTML table. ASP.net equivalent?
<?php
$f = fopen("spreadsheet.csv", "r");
while (($line = fgetcsv($f)) !== false) {
if(trim($line) != '' && $line != "
" && $line != "
") {
echo '<tr>';
foreach ($line as $cell) {
echo "<td>" . htmlspecialchars($cell) . "</td>";
}
echo "</tr>
";
}
}
fclose($f);
?>
I see various options like [URL] but being clueless about ASP.net, I'm afraid I don't know how to make them work.
I am newbie to asp.net I have a html table with 3 fields,
Scheme Name : Sample Scheme
sl_no dividend date dividend %
1 2/1/2009 26
2 2/5/2010 22
3 2/1/2010 23
The associated db table dividend_master should get updated like this:
sch_name dividend_no dividend_date dividend_per
Sample Scheme 1 2/1/2009 26
Sample Scheme 2 2/5/2010 22
Sample Scheme 3 2/1/2010 23
how do i achieve this using arraylist? thx in advance sankari
I need to export the repeater which is populated with ajax.
 <asp:Panel id="Panel1" runat="server">
<div id="response_message">
<div id="response_" runat="server" style="">
[Code].....
Here is my javascript code. its not working to export record.
I have a large XML file (3000+ nodes) that I want to represent in a TreeView on ASP.NET. I cannot databind it to a XMLDataSource because loading the TreeView will then be way too slow (I never even waited long enough to see it finish...)
So the solution for this would be to use the PopulateOnDemand property of the TreeNodes to load data only when needed. Problem is, I can't think of a way to acheive this...
How can-I, based on the ID of a node, search a XMLDocument to get all the childnodes of the node having this ID?
XML would look like that:
<document ID=1>
<document ID=2>
<document ID=3>
</document>
</document>
<document ID=4>
</document>
</document>
There are nor rules on how much levels it can go down or anything...
I write a countdown timer in jQuery and i need to keep some datas in a session when countdown ends. Datas have to be sent to server to update. How can i handle this situation. I am new in jQuery and asp.net so could you explain this briefly
View 4 RepliesI am using "Classified Ad" starter kit of Asp.net 2.0. In the Post Ad feature that using the ad "CategoryPath" control that recursively update link based on user select ad category. After user satisfied with the ad Category selection, the control generate a complete button link of the entire path.
If I am going to convert CategoryPath control from Asp.net to MVC / Ajax, how about I am going to do this?
i have project using sql2005 as database. i want to convert the 1 View (or some of my table) to Access that admin can download it.
what is the easiest way to do that?
protected void btnGeneratePDF_Click(object sender, EventArgs e) {
try {
string sess = Session["LogId"].ToString();
sqlCon = new SqlConnection(conString);
sqlCom = new SqlCommand("usp_Invoice_Master", sqlCon);
sqlCom.CommandType = CommandType.StoredProcedure;
[CODE]....
i have a page default.aspx .....
View 5 RepliesHow to access datas based on user roles in asp.net ? For example : i have two admins (admin1, admin2). In the frontend ,admin1 has full access to datas(view,add,edit,delete all datas) while admin2 has limited access to datas(view,add,edit,delete certain datas alone and not all datas)
View 2 RepliesI used the below code to return the datas from one excel file. My question is if i suppose need to get the records from morethan one excel file using joins, how it is possible.
[Code]....
developing a product (like shopping cart) in ASP.NET/C# 3.5. It is common for all the shopping sites. The following is my task,I need to get the datas from customer database (It may be SQLServer, MySQL or Oracle and the database structure also different). For example i need the following items for my product from the customer database,Category ID (Category or Product) Category Name Parent Category Description Cost Quantity Thumbnail image url Original image url Related products So how to get above values from the customer database and what should be the best concept to do this because i don't know anything about customer database (I don't know whether it is SQLServer or MYSQL and also i don't know the database name, table name or column name).
View 4 Replies