I have a gridView and I would like to extract the PhotoPath (ftppath + filename (ftp://192.168.1.2/Jelly.jpg))
its in asp.net and I'm not sure how to retrieve the data ive set the gridView up for selection and I like to "upon" select store the PhotoPath in a string.
[Code].....
I have data in ParamList (from SQL reporting services database)which I want to display in a GridView. as ParameterName and VAlue. I am able to retrieve the parameters but can't figure out how to read them into ArrayList (or whatever method you coud suggest) and then bind to grid. Final grid should be like this-
ParameterName ParameterValue
Year 1011
Number1 0011
Number2 0101
Number3 0201
Here is the code I'm trying to figure out-
Dim intCount As Integer
Dim strparam As String
Dim strparam1 As String
Dim varResult As Object
Dim ParamList as string
ParamList = "Year=1011&Number1=0011&Number2=0101&Number3=0201"
varResult = Split(ParamList, "&")
Dim arrList As New ArrayList()
'loop through array and retrieve parms
For intCount = 0 To UBound(varResult)
varParam = Split(varResult(intCount), "=")
strparam1 = UCase(varParam(0))
strparam = varParam(1)
arrList = ???
Next
'and then display tsi data into a grid.
GridViewParams.DataSource = arrList
How to display the string data stored in a string[] variable into gridview?
View 9 Repliesi facing a problem to change the date format at gridview display.
below is my coding:
[code]....
I have SqlDataSource and GridView on web form. GridView.DataSourceID = mySqlDataSource.
When I call myGridView.DataBind(), all data successfully bind on the page.
How is it possible to read already got data from mySqlDataSource or myGridView objects as DataTable or DataView?
I am getting this JSON string from an ASP.Net webservice:
{"d":{"Table":[{"col1":123,"col2":"name","col3":"name","col4":100,"col5":"/Date(1153033200000)/"},{"col1":123,"col2":"name","col3":"name","col4":101,"col5":"/Date(1153033200000)/"},{"col1":123,"col2":"name","col3":"name","col4":102,"col5":"/Date(1153033200000)/"}]}}
In my jQuery how do I reference the Table code so I can loop through the data?
msg.d[i].col1
What am I missing? msg.d.table[i]?
i want to tranfer a xml string variable to DB2 store procedure. And then, i will open xml to get data to insert into tables . If in sqlserver i user OPENXML,.. But in DB2 i am a newmember. How can i do it in DB2 store procedure.
View 2 Replieshow can i get only
the year from string "dd/mm/yyyy" format
for example 31/12/2010
i want to display 2010 in a label1.text
I am reading data from Excel file using oledbdataadapter and binding to gridview.Every thing working fine.but if the cell is having some text along with bar sysmol ( | ) [Ex : 12345 | 789123] that cell data is not reading from excel file.All fileds in excel sheet is text format only.Some times it's reading correctly & some times it not reading(empty).Is there any problem with bar symbol ( | )
View 1 RepliesMr requirement is i am uploading a .txt file and read that .txt file and bind that data to ASP.NET Gridview control. My .txt file is look like below:
% Compressor type: GT12 C224(38) 55 Trim 0.38 A/R
% Turbine type: GT12 T202(35.5) 72 Trim 0.39 A/R
% Initial data file name:20050669-02.cdt
% Polar inertia: [kg.m2]
% Comment:DATA REDUCTION CODE REV 2.04 RELEASE 03-OCT-2004 (REFERENCE: REPORT 99-0145. REPORT 03-0901. TI-056)
% P reference: 100000Pa - T reference: 298 K
% NC WC PRC ETAC
% RPM KG/S T-T ----
115030.5714 0.0170 1.3398 0.5698
115030.5714 0.0239 1.3209 0.6155
115030.5714 0.0291 1.3020 0.6282
115030.5714 0.0339 1.2822 0.6377
115030.5714 0.0380 1.2576 0.6209
115030.5714 0.0416 1.2311 0.5955
134956.4286 0.0405 1.4045 0.6852
How to read this file and bind data to gridview control.
Right now i am using the following code but it stores whole data in a single column and a single row but i need it in four columns named NC, WC, PRC,ETAC and it's values in respected columns.
Code:
protected void Button1_Click(object sender, EventArgs e)
{
String ext = System.IO.Path.GetExtension(FileUpload1.FileName).ToUpper();
if (ext == ".TXT")
{
String content = System.Text.Encoding.ASCII.GetString(FileUpload1.FileBytes);
String[] ar = content.Split(';');
GridView1.DataSource = ar;
GridView1.DataBind();
}
}
how to get data in four columns in Gridview as a tabular format. I am using technologies Visual Studio 2005, ASP.NET 2.0,C#.NET 2.0 and Windows Xp Operating system.
I have a dropdownlist and a button.
When I click the dropdownlist,it will show all the data in a gridview.
Once I click the button,the whole data in the gridview will appear in the dummy table which I don't want it to do that.
What I want is,when I click the button,it will read row by row from the gridview and sent it one by one to my dummy table.
Problem is,how do I read the data row by row from the gridview with only one button?
How to read values of asp: table in grid view after binding.
I want to get values one by one in label in for loop and read values of table row one by one.
Like if i put check box in gridview and the row which is selected , i want to read value that asp:table in gridview.
How I bind grid, code attached.
Private Sub gvTransactionsBind(ByVal qry As String)
Dim adp As New SqlDataAdapter(qry, ConString)
adp.SelectCommand.CommandType = CommandType.Text
Dim ds As New DataSet
adp.Fill(ds)
gvTransactions.DataSource = ds
[Code] ....
I called the string in my Data layer
string connectionName = System.Configuration.ConfigurationSettings.AppSettings["Connection"].ToString();
now how could call it in SqlConnection con
I would like to read from a long string and just output the first 3 paragraphs of the string. How do I achieve this? I wanted to use this code to show (n) number of words but I have since changed to paragraphs.
public string MySummary(string html, int max)
[Code]....
I am trying to read a string of xml into a dataset by using the following code
[Code]....
As I proceed to bind the 'dsParameters' to a gridview, I was thrown the 'The IListSource does not contain any data sources'. As I step through my code, I found that xmlSR is null. Any idea why is that so?
I have an object datasource which is using Business object as a myconnection
The method i have defined under myconnection is
Publicstatic
DataTable getfn(String dtype,
String did,
String dprefix,
String dname)
{
datable table = new datatable(); then declared stored proceedure and defined parameters and assighned values
In the stored proceedure it has a query like select column1,coloumn2,coloumn3 As Call from table where
I need to take data from Call and display it to the gridview through object datasource .
Snap shot of asp code
<Columns>
<asp:BoundField DataField="DeptarmentID" HeaderText="DeptarmentID" ReadOnly="true" />
<asp:BoundField DataField="DepartmentCode" HeaderText="DepartmentCode" />
<asp:BoundField DataField="DepartmentName" HeaderText="DepartmentName" />
<asp:BoundField DataField="Active" HeaderText="Active" />
</Columns>
snap shot of page behind
protected void GridViewDept_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridViewDept.Rows[GridViewDept.EditIndex];
string code = ((TextBox)(row.Cells[2].Controls[0])).Text;
string name = ((TextBox)(row.Cells[3].Controls[0])).Text;
bool active =((TextBox)(row.Cells[4].Controls[0])).Text=="True"?true:false;
//bool active = ((CheckBox)(row.Cells[4].Controls[0])).Checked;
int id = System.Convert.ToInt32(row.Cells[1].Controls[0]);
}
I get error on the last line stating out of index error, how do get the value which is not set editable in the gridview
I am bounding column to gridview as mentioned below
BoundField boundField4;
boundField4 = new BoundField();
boundField4.HeaderText = "Employee Type";
boundField4.DataField = "Employee Type";
boundField4.ItemStyle.Wrap = false;
GridView1.Columns.Add(boundField4);
Now I want to Check the value of Employee Type column, so accordingly I will bound hyperlink field. How can I do this in following
if Employee Type = "Regular" thne hyperlink should be (Employee Type is bound field as I mentioned earlier)
http://website/pay.aspx?paytype="Regular"
else
http://website/pay.aspx?paytype="Daily"
i need to know how to read data from the xml file and i need to display that data in grid view.
View 1 Repliesi am working on the mobile application, and i want to read binary file .. its just contains the string.. e.g "hi Wel come". I have opened that file using filestream and try to read that file using binaryReader.. but it didn't read that file correctly. if i use
binaryreader.readstring();
it throws an exception of endOfstream. when i stored that stream into array of byte and read it through response.binaryWrite.... like
Response.clear();
Response.BinaryWrite(buffer);
Response.flush();
Response.close();
Response.end();
it shows me the correct result as i want ..i.e it shows the "hi wel come" on browser. like this i want to store that content of file into string
I want to execute xml file with in .aspx page for my sitemap.
if i user server.transfer it's ok in internet explorer but not look like xml file in chrome and firefox.
so how could i write complete xml from top to bottom in my aspx page so that it look's like a xml file
In my Gridview second row will be a Textbox, when the user types something on that based on business logics we do some calculation and display the result in the 3 rd and 4th rows using Javascript(while Textbox change event), but now the problem is i can type the vlaue and resutl will be displying now i have another button while that button click event i have to read the Gridview data and store back to Database this time i'm reading the data using
foreach (GridViewRow row in gvAmount.Rows)
{
Label userInputField = (Label)row.FindControl("lblTest");
if (userInputField != null && userInputField.Text != string.Empty)
{
Response.Write(userInputField.Text + "--");
}
}
but in the result row i didnt get the answer of result processed by Javascript instead of that its displaying the data of which i have loaded on page load event.
How do I loop the gridview to read or insert one row by one row?I have a database which has a Primary key. Currently,all the rows seems to appear at one time.Even when I use a counter,it did read one row from a textbox(which is for my testing to read one row) but in the database,it still inserts the whole rows from the gridview.I can't click button twice as it will occur an error "Primary Constraint".
View 6 RepliesI need to validate and read edited values from a gridview. Here is the scenario,I have a gridview which has two columns Iteam name and Item Rate. Number of rows are dynamic depending on the user. I get the Text boxes filled with DB data.
I need to do this,
1) Validate if the user has entered numeric using front end validation
2) Read the edited values by user for each row and insert into the database in server side
Below is the gridview Source I have
[Code]....
I am unable to read gridview contents
I have a GridView. In my RowDataBound event I add attributes for the mouse onclick event, which sets the row's background color to red when the row is clicked. This works. I have a button outside of the GridView. When I click this button, I want to read each row of the GridView, and if its background color is red I want to perform some processing on the row. I tried the following code and even when the row's background is red, I cannot get its background color (bgc is empty).
[Code]....