|
Sorry for not providing the details....
My database looks like this.
SNo Restaurent Items
1 Rest1 Item1
2 Rest1 Item2
3 Rest2 Item1
4 Rest2 Item3
5 Rest2 Item4
6 Rest3 Item2
7 Rest3 Item4
Which means that, Rest1 contains only Item1, Item2
Rest2 contains only Item1, Item3, Item4
Rest3 contains only Item2, Item4
And my report should be like a comparison chart.
Restaurent values on Y-axis and Item values on X-axis and inside the report,if Rest1 is having Item1, then a tick mark should be placed in that particular column .Similarly a tick mark under Item2 but null values for item3 and item4
modified on Saturday, December 15, 2007 4:38:38 AM
|
|
|
|
|
|
Hi,
This is from chandrakanth.
Actullay i am able to upload the picture into Sqlserver2005.
But i can not able to get the picture.
And i want to show the picture in Gridview.
can any one tell me what are all things have to change in my code.
here the code is
protected void btnRetrive_Click(object sender, EventArgs e)
{
IDataReader objReader;
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
objReader= KF.Search.GetUserIdImages(txtuid.Text);
dt.Load(objReader);
gdvImagesRetrive.DataSource = dt;
gdvImagesRetrive.DataBind();
}
GetUserIdImages ------ that metyhod code is....
public static IDataReader GetUserIdImages(string strImageUserId)
{
try
{
byte[] imagestr;
Database objDataBase = DatabaseFactory.CreateDatabase();
DbCommand objDbCommand = objDataBase.GetStoredProcCommand("STP_KF_Images_Retrive");
objDataBase.AddInParameter(objDbCommand, "@UserId", DbType.String, strImageUserId);
IDataReader objDataReader;
objDataReader = objDataBase.ExecuteReader(objDbCommand);
while (objDataReader.Read())
{
imagestr = (byte[])objDataReader.GetValue(1);
}
return objDataReader;
objDataReader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
can any one tell me what are all things sholud change.
Thanks and Regards
Chandrakanth
Chandrakanth
|
|
|
|
|
The way I do it is store the image path in the DB and then just retrieve the path an set it to the asp:image control in the Grid's ItemTemplate column.
Hope this helps !
|
|
|
|
|
Hi,
This is from chandrakanth.
Actullay i am able to upload the picture into Sqlserver2005.
But i can not able to get the picture.
can any one tell me what are all things have to change in my code.
here the code is
protected void btnRetrive_Click(object sender, EventArgs e)
{
IDataReader objReader;
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
objReader= KF.Search.GetUserIdImages(txtuid.Text);
dt.Load(objReader);
gdvImagesRetrive.DataSource = dt;
gdvImagesRetrive.DataBind();
}
GetUserIdImages ------ that metyhod code is....
public static IDataReader GetUserIdImages(string strImageUserId)
{
try
{
byte[] imagestr;
Database objDataBase = DatabaseFactory.CreateDatabase();
DbCommand objDbCommand = objDataBase.GetStoredProcCommand("STP_KF_Images_Retrive");
objDataBase.AddInParameter(objDbCommand, "@UserId", DbType.String, strImageUserId);
IDataReader objDataReader;
objDataReader = objDataBase.ExecuteReader(objDbCommand);
while (objDataReader.Read())
{
imagestr = (byte[])objDataReader.GetValue(1);
}
return objDataReader;
objDataReader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
can any one tell me what are all things sholud change.
Thanks and Regards
Chandrakanth
Chandrakanth
|
|
|
|
|
|
Hi while uploading some things i want to use FileUpload:
<input id="fileUpload" type="file" runat="server" name="fileUpload">
While uploading the url:
I will get like this text in that:
C:\Documents and Settings\Administrator\Desktop\first.doc
Now after fill this i want that doc name
So in my button click event i given like this:
Dim strName As String
strName = System.IO.Path.GetFileName(fileUpload.PostedFile.FileName)
TextBox1.Text = strName
With out button click event, its want to fill the textbox that strname how to do that plz give me some ideas regarding that...,</input>
Thanks & Regards,
Mageshh,
please don't forget to vote on the post
|
|
|
|
|
Hello Friends,
I want your help.So please help me for this query.If we have a grid .If we select a grid row the row data will be dispalyed in textboxes avilable.That code i know.But i want to display the row datas into another page when we select a row in grid.How is it possible.Please help me by sending code to me..Thanks
|
|
|
|
|
Get the ID using the Datakeynames and Query in the other page? or pass the values as querystring.
Hope this helps.
|
|
|
|
|
hello frnd,
i have developed a application using asp.Net 2.0 and take the use of AJAX in it.
Please tell me a way to fill the dropdownlist using AJAX.
i have already done the code for the same but it not running well.
any code sample...?
thankx in advance
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
koolprasad2003 wrote: Please tell me a way to fill the dropdownlist using AJAX.
Are you using AJAX toolkit or your own XMLHTTP code ? If it is tookit, put the drop down inside an update panel
|
|
|
|
|
hello........
I want to import excel file to ms access in asp.net using c#.
Thanks.....
|
|
|
|
|
You want to upload an excel file to the server, and then on the server put the details of that file into an Access database ? Will you have strict rules on the format of the Excel file ? If not, how will you know for sure the import will put the data where you want it ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
u havent understand my question....
i want to some logic ya code in answer of this question
|
|
|
|
|
When I tried to open the security tab in the web site administration tool, I got an error message that Unable to connect to SQL Server database.
I searched in the google and found a solution. That is to create a connection string in web config named "LocalSqlServer" and run aspnet_regsql command in my database. but this will create some additional tables and stored procedures.
I don't feel comfort with this additional connection string and database objects. Is there any other options to configure security?
Thanks and regards,
Hogan
modified on Saturday, December 15, 2007 12:57:27 AM
|
|
|
|
|
ASP.NET Security framework needs these tables and Stored Procedures in order to store Membership and profile.So I dont think you can do without them.But what you can do is store them in a different database and just make your Web application point to them.But you will still need a connection string to that database and the other Membership settings...
Hope this helps.
|
|
|
|
|
Ok. Can I use custom membership to use my own tables and stored procedures
|
|
|
|
|
sure you can, but thats a lot of work.Its easier to just code your own system rather than overriding each table and stored procedure if you know what I mean.
|
|
|
|
|
But my member table has different structure. I want my own table to store the member informations.
|
|
|
|
|
I am using ASP.net 2.0 to develop a web application in which I am playing a video file using "active movie player (media player)". How do I know that the video file playing is completed from ASP.Net code (using any script is OK).
with regards
kiran
|
|
|
|
|
Hi all
I am trying to develop a application which will create a dynamic web pages for user.
Example : User will select the designs and images etc...
and he can create upto to 3 pages.
1 user can create 3 pages.
how can i do this. can any give an idea how to start this.
THX
Keerthi
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
It depends, if you want to let them enter raw HTML, just store it and serve it. If you want to offer templates, then you need an editor and you need an engine to fill the templates with the settings to make the pages.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi can any one tell me ..
If a dataset contains 100 rows, how to fetch rows between 5 and 15 only??
Vishnu Narayan Mishra
Software Engineer
|
|
|
|
|
Vishnu Narayan Mishra wrote: If a dataset contains 100 rows
Dataset can't contain rows, a datatable can contain instead. Data table has a Select() method where you can query datatable. Try that.
|
|
|
|
|
Can anyone recommend a good control for working with 3D objects (move objects in 3D, move camera, filled areas, etc) that is preferably free?
Secondly, what is the best technology/framework for working with 3D graphics on web pages?
Thanks.
|
|
|
|