Gridview, databind retrieving value from database - C# Discussion Boards

i Have little bit experience in Bio-metric finger print modules.

i think u have to Use the Manufactures API's, For your Development.

Rajesh B --> A Poor Workman Blames His Tools <--

Hi all,
I have an object called “Report” that I want to serialize.
The saved object will be open at IE browser.
I want to save object from C# code with line at the head:

<?xml-stylesheet href="Report.xslt" type="text/xsl" ?>

How I do that?

I used with XmlSerializer from microsoft.

var serializer = new XmlSerializer(typeof(Report), NameSpace); writer = new StreamWriter(fullpath)); serializer.Serialize(writer, this);

The result is :

<?xml version="1.0" encoding="utf-8" ?> <Report xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/Report.xsd"> <StartDateTimeTest>22-9-2009 12:00:12</StartDateTimeTest>.....

And i want to get

<?xml version="1.0" encoding="utf-8" ?> <?xml-stylesheet href="Report.xslt" type="text/xsl" ?> <Report xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/Report.xsd"> <StartDateTimeTest>22-9-2009 12:00:12</StartDateTimeTest>.....

I am very desperate,
Thanks all.
Ido

I think on serialization only class members will be serialized...So the other way around is to Serialize the object to a string instead of serializing directly to a file...then you can insert the required stylesheet declaration string and afterwards load the formatted XML into a XML document and save it to a file.

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

You are fantastic.
Your answer give me an inspiration and i solve my problem by code:

// Load the style sheet. XslCompiledTransform xslt = new XslCompiledTransform(); xslt.Load("output.xsl"); // Execute the transform and output the results to a file. xslt.Transform("books.xml", "books.html");

from Microsoft site:
http://msdn.microsoft.com/en-us/library/system.xml.xsl.xslcompiledtransform.aspx[^]

thanks a lot,
Ido

Cheers

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

Hi guys, i have encountered a problem in finding control.

i have binded data to a label in a datalist to retreive a email and it works. but next, i have a new label by the name of "Testing". How do i grab the bound data from the label to put into a string?

Below will be the code i have on hand:

Part of the source code will be like

<asp:label id="Testing" text="<#% Eval(" email")%>"="" xmlns:asp="#unknown">

How do i grab the eval email value and put to a string? Kindly please help, thanks guys

looks like ASP to me - go there.

Never underestimate the power of human stupidity
RAH

Hey people. I am currently doing a social portal like Facebook. What i am facing over now is whenever a user makes an update, for example : Posted a new status or note.

Below, when pple click on the Note button, it will display the top 5 updates from the database. But this raises a question. Every update will have an UpdateID, but how do i actually know what updateID are they each.
This is because i allow other users to comment on each of these update. Without capturing the UpdateID, i will have trouble in inserting the right Comments onto the status or note.
Hope you guys understand what i am trying to intepret over here.

Source code

asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BorderStyle="None" Height="0px" Width="443px" GridLines="None" OnRowCommand="GridView1_RowCommand">

<Columns>

<asp:TemplateField>

<EditItemTemplate>

<asp:TextBox ID="CommentText" runat="server" Text='<%# Bind("FullName") %>'></asp:TextBox>

</EditItemTemplate>

<ItemTemplate>

<a href = ""><asp:Label ID="Label1" runat="server" Text='<%# Bind("FullName") %>'></asp:Label></a> wrote a note. 

<asp:Label ID="Label2" runat="server" Text='<%# Bind("TextInput") %>'></asp:Label> 

<asp:Button ID="WriteComment" runat="server" Text="Write Comment" Visible ="true"/> 

<asp:TextBox ID="Notestxtbox" runat="server" Columns="36" TextMode="MultiLine" MaxLength="100" Height="60px" Width="304px" Visible ="False"></asp:TextBox>

                    

                           

     

<asp:Button ID="ViewComment" runat="server" OnClientClick="window.open('ViewComment.aspx','','left=100,top=50,width=500,height=500,scrollbars=1');return false;" PostBackUrl="~/ViewComment.aspx" Text="View Comment" Visible ="false"/>

<asp:Button ID="NotePost" runat="server" OnClick="NotePost_Click" Text="Post" Visible ="false"/>  

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

Cs code

protected void NotePost_Click(object sender, EventArgs e)
{

foreach (GridViewRow row in GridView1.Rows)
{
// Selects the text from the TextBox
// which is inside the GridView control

string textBoxText = ((TextBox)row.FindControl("Notestxtbox")).Text;
TextBox noteText = ((TextBox)row.FindControl("Notestxtbox"));

if (textBoxText != "")
{
string strConnectionString = ConfigurationManager.ConnectionStrings["SocialSystemConnectionString"].ConnectionString;
SqlConnection myConnect = new SqlConnection(strConnectionString);

SqlCommand cmd = new SqlCommand("INSERT INTO [Comment] (TypeId,Email,TextInput,UpdateID) VALUES (@TypeId,@Email,@TextInput,@UpdateID)", myConnect);
cmd.Parameters.Add("@TypeId", SqlDbType.VarChar);
cmd.Parameters["@TypeId"].Value = "Notes";
cmd.Parameters.Add("@Email", SqlDbType.VarChar);
cmd.Parameters["@Email"].Value = Emaillbl.Text; //Session
cmd.Parameters.Add("@TextInput", SqlDbType.VarChar);
cmd.Parameters["@TextInput"].Value = textBoxText;
cmd.Parameters.Add("@UpdateID", SqlDbType.VarChar);
cmd.Parameters["@UpdateID"].Value = UpdateIDlbl.Text; //Session

myConnect.Open();
cmd.ExecuteNonQuery();
myConnect.Close();

noteText.Text = "";
}
}

}

protected void Notebtn_Click(object sender, EventArgs e)

{

GridView1.Visible = true;

GridView2.Visible = false;

GridView3.Visible = false;

string strConString = ConfigurationManager.ConnectionStrings["SocialSystemConnectionString"].ConnectionString;

SqlConnection con = new SqlConnection(strConString);

SqlCommand cmd = new SqlCommand("SELECT TOP 5 Types.TypeID, [Update].TextInput, [Update].UpdateID, [User].FullName FROM Types INNER JOIN [Update] ON Types.TypeID = [Update].TypeId INNER JOIN [User] ON [Update].Email = [User].Email WHERE [Update].TypeId = 'Notes' ORDER BY [Update].UpdateTime DESC", con);

con.Open();

SqlDataReader reader = cmd.ExecuteReader();

GridView1.DataSource = reader;

GridView1.DataBind();

reader.Close();

con.Close();

}

Learning

Julius88 wrote:
Without capturing the UpdateID

You need to get this otherwise how do you expect to find the record to update.

There are number of things wrong here
1 you are asking an ASP ? in the C# forum
2 You have dumped in a large amount of useless code
3 Your code is open to SQL injection - always a bad idea.

Never underestimate the power of human stupidity
RAH

Erm. I am using C# for this particular project. Isn't it?
Sorry if i misintepret.

Learning

Hi People. I am currently facing a problem to allow a href on a Databind item. For example, The TextInput stated below will retrieve all the links posted by a user. For instance, if a user posted www.youtube.com or www.friendster.com, it will allow them to click on the Label and proceed to the link in a new window. Could someone advise me how to work on it?

Code
<a href = ""> <asp:Label ID="Label2" runat="server" Text='<%# Bind("TextInput") %>'></asp:Label></a>

Learning

Hi Julius,
Check out this..Hope it will help you..

http://www.asp101.com/articles/john/repeater/default.asp[^]

What is it with people too dumb to ask in the ASP.NET forum ?

Christian Graus

Driven to the arms of OSX by Vista.

Erm. I am using C# for this particular project. Isn't it?
Sorry if i misintepret.
And just to remind you, you're kinda rude over here. Although you have contributed to this forum alot, it doesn't mean you can use the word dumb . Smile | :)

Learning

The issue is that your problem is more "web coding" related than it is "c#" related.

I don't do any ASP coding in C#, just WinForms, so I'll ignore such questions. People who know about web stuff are likely to read the ASP forum, and thus are far more likely to give you a useful answer

Help me! I'm turning into a grapefruit!
Buzzwords!

Well, considering your question had nothing to do with C#, but everything to do with ASP.NET, wouldn't it have been better to post in a more appropriate forum??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Hi,

How to get the values in a existing cookie into a windows application.Please reply me if you know solution.

Note: Request.cookie is not working in windows application

Thank you

You need to find out the location where cookies are stored(depends on each browser). Now read it as a normal file.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Hi Fellows

now let me ask you another doubt,I hope i'll get solved it quick.

1.i am working(programming)with visual studio 2005.
2.how to change the deployment aspects according to my likeness.
3.In Detail: How to change the place of bitmap and buttons in installation windows.
4.how to change progressbar style/color in installation windows.
Please give me any link that desribs abt Visual studiol deployment specifying the graphical modules

Your post has nothing to do with C#. Try Visual Studio[^] discussion board.

Smile | :)

Navaneeth

How to use google | Ask smart questions

How i cam hide menu dynamically

You didn't notice that we have an ASP.NET forum ?

Christian Graus

Driven to the arms of OSX by Vista.

HI here is my code i take 1 txt,1datagride,2 button,1 file dialog box .
on 1 button i open filedialog box select 1 excel file and fetch string in to txt box,and try to open this excel file in datagride view

WHEN I RUN MY PROGRAM A RUN TIME EXCEPTION THROWEN BY OLEDB IE,
Cannot update. Database or object is read-only.
error occures at connection.Open();
my excel file close when program running.
PLZ HELP

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.OleDb;

namespace filedialog
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

}

private void button2_Click(object sender, EventArgs e)
{

string filename = @"textBox1.Text";
String connectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();
//String connectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+filename +";"+"Extended Properties=Excel 8.0;";
OleDbCommand selectCommand = new OleDbCommand("SELECT * FROM [sheet1$]", connection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = selectCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);

// double sum = 0.0;
// We'll make some assumptions for brevity of the code.
System.Data.DataTable dataTable = dataSet.Tables[0];
dataGridView1.DataSource = dataSet.Tables[0];
MessageBox.Show(dataGridView1.RowCount.ToString());

connection.Close();
//openFileDialog1.ShowDialog();
//openFileDialog1.ShowDialog();

// return sum;
// directorySearcher1.FindAll();

}

private void button3_Click(object sender, EventArgs e)
{
OpenFileDialog FD = new OpenFileDialog();

FD .Filter="Excel|*.xls";

if (FD.ShowDialog() == DialogResult.OK)
{
textBox1.Text = " " + FD.FileName;
}

}

}

}

Are you trying to open the file that you are providing from Text Box??

if you are doing so then,

string filename = @"textBox1.Text";

this statement is wrong you should not precede with @ here,which means take the followed string as it is! In your case filename is takes as "textBox1.Text" which is not the file which you want to access.......

so change your line by removing @ symbol and qoutes.....
so your this line should be like this

string filename = textBox1.Text;

which will give you the file name provided in the testbox

hope this will work for you............ Smile | :)

Happy coding!!!!!!
Deep

It works thanks a lot