|
Sandeep3678 wrote:
I know I could create the controls on run time but would want to use a better technique.
What about using GridView with Checkedbox column?
|
|
|
|
|
yes thats what im thinking but I need grouping here by category. Any best way to do it?
|
|
|
|
|
then, you will need the control that can work like treeview + gridview... or you can use two gridviews for that.. one for category and one for subscription... you can show the list of categories with hyperlink in gridview at the top.. if the user clicks on a particular category, you can show the list of related information with checked boxes.. but it won't be look nice.. it is better if you have a control that can use like TV + GV..
|
|
|
|
|
Or I could have a bound column for category and template column with Check box for subscription and group the gridview right? This seems to be a very viable option right now. Could you guide me through it?
|
|
|
|
|
Check this for grouping row in Gridview..
http://blog.zygonia.net/PermaLink,guid,c093836d-8d97-4e5b-8a1c-8218742cb686.aspx\
Check-out this for manipulating with chked boxes in GridView..
http://www.codeproject.com/aspnet/SelChkboxesDataGridView.asp
|
|
|
|
|
Hello. I'm working with a Custom Membership Provider and a login control. In Internet Explorer the Login Button of the Login Control does not work(it does not submit the page). The page has a master page. Somebody knows why?
-- modified at 10:43 Wednesday 7th November, 2007
|
|
|
|
|
I have a Listbox in an Ajax UpdatePanel, when the user clicks the submit button and navigates away from the page, I clear the data using ListBox.Items.Clear(); However, when the user clicks the back button in the browser the data is still in the ListBox.Items collection.. (Its invisible at first, but when you try and add a new item to the listbox, the old items show up again). *shrug* anyone ever had this problem?
|
|
|
|
|
Hi all,
Iam using the following code to send email attachments
<br />
HttpContext.Current.Response.Charset = ""<br />
Dim tw As New System.IO.StringWriter<br />
Dim hw As New System.Web.UI.HtmlTextWriter(tw)<br />
report.RenderControl(hw)<br />
'My.Computer.FileSystem.DeleteFile(HttpContext.Current.Server.MapPath("~\Attachments\" & ReportName))<br />
<br />
Dim attachment As String = HttpContext.Current.Server.MapPath("~\Attachments\" & ReportName)<br />
<br />
My.Computer.FileSystem.WriteAllText(attachment, tw.ToString, False)<br />
AppEmailService.SendMail(subject, body, attachment, receiver)<br />
tw.Close()<br />
hw.Close()<br />
tw = Nothing<br />
hw = Nothing
the first time any user sends an email, it is successfully sent. If i try to send the same attachment again, it is giving me an error that the attachment is being in use.
"The process cannot access the file 'c:\inetpub\wwwroot\ORM\Attachments\Number of operational Loss Events.xls' because it is being used by another process"
Any ideas
|
|
|
|
|
this is my stored procedure in oracle, am using oracle client,
cmd.parameter.add() to RETURN the value of the parameter but its not working.
PROCEDURE "SCOTT"."PROCEDURE2" (
"PARAM1" IN NUMBER, "PARAM2" out VARCHAR2) IS
varEname VARCHAR2(40):='xxx';
varComm REAL;
varSalary CONSTANT NUMBER:=1000;
comm_missing EXCEPTION;
BEGIN
SELECT ENAME,
COMM
INTO varEname,
varComm
FROM EMP
WHERE EMPNO = param1 ;---7369;
IF varComm IS NULL THEN
RAISE comm_missing;
else
dbms_output.put_line('Commision is ' || varcomm );
END IF;
param2:=varEname;
dbms_output.put_line(param2);
EXCEPTION WHEN comm_missing THEN
dbms_output.put_line('Commision is NULL');
WHEN no_data_found THEN
dbms_output.put_line('Employee Does not Exist');
END "PROCEDURE2";
I need to retrieve the value of param2 inside my Asp.net code.
Please help me with Ideas.
Salami
|
|
|
|
|
check out this link ..hope it will help u...
http://aspnet.4guysfromrolla.com/articles/062905-1.aspx
regards
Ramesh
|
|
|
|
|
How can I use a connection string stored in the web.config file to get a datatable from the sql server 2005 ?
thx in advance.
BiG RaLpH
|
|
|
|
|
Hi.
Your connection string of course might be different but here's what you do with that. Put the following inside <configuration></configuration> right after let's say </system.web> (Make sure it doesnt go inside system.web node)
<appSettings>
<add key="SQLConString" value="packet size=4096;data source=SERVER;persist security info=True;user id=USERUD;password=PASSWORD;initial catalog=DATABASE"/>
</appSettings>
In your code do the following to get connection:
Dim sConn As String<br />
sConn = ConfigurationSettings.AppSettings("SQLConString")<br />
Dim con As New System.Data.SqlClient.SqlConnection(sConn)<br />
con.Open()<br />
....<br />
....<br />
....<br />
con.Close()
That's it.
-- modified at 9:20 Wednesday 7th November, 2007
|
|
|
|
|
Thx
Now how can I get the table in that database lets name the table "Tabl1".
I want to copy it and put it in a instance of the table.
i.e.:
dim table as datatable
"table = Table1"
thx
BiG RaLpH
|
|
|
|
|
Use connection to connect to database. Create datagrid, dataset and dataadapter.
Fill your dataset using dataadapter and assing dataset to your datagrid.
NOTE: dg is the datagrid on your page. You can AutoGenerateColumns(True or False).
If you do just bind dataset to datagrid and that's it. If you want to play around you will have to built custom columns for your datagrid.
'Open connection<br />
con.Open()<br />
<br />
Dim strSQL As String = "SELECT * FROM Tabl1"<br />
<br />
'Create command and assign timeout value<br />
Dim cmdSelect As New System.Data.SqlClient.SqlCommand(strSQL, con)<br />
<br />
'Create data set<br />
Dim ds As New DataSet<br />
<br />
'Created adapter and fill dataset<br />
Dim da As New System.Data.SqlClient.SqlDataAdapter(cmdSelect)<br />
da.Fill(ds, "ANYTABLENAME")<br />
<br />
'Verify if data exists<br />
If ds.Tables(0).Rows.Count > 0 Then<br />
'Create dataview and assign sort by field and direction<br />
Dim dv As DataView = ds.Tables("ANYTABLENAME").DefaultView<br />
dg.DataSource = dv<br />
<br />
'Bind data to datagrid<br />
dg.DataBind()<br />
End If<br />
<br />
'Close connection<br />
con.Close()
|
|
|
|
|
thx alot but I'm having the error that con has not been initialized.
BiG RaLpH
|
|
|
|
|
Dim sConn As String
sConn = ConfigurationSettings.AppSettings("SQLConString")
Dim con As New System.Data.SqlClient.SqlConnection(sConn)
Dim selectCMD As SqlCommand = New SqlCommand("SELECT * FROM Customers", con)
selectCMD.CommandTimeout = 30
Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD
con.Open()
Dim custDT As DataTable = New DataTable
custDA.Fill(custDT, "Customers")
con.Close()
Now u have customers table in custDT ..
Regards,
Ramesh.
|
|
|
|
|
thx alot but I'm having the error that con has not been initialized.
BiG RaLpH
|
|
|
|
|
are you running on a sql Server?
If so shouldn't you do any authentication? User Id=;Password=;
check out the connection string in web.config
|
|
|
|
|
No I don't have any ID or Password this is y I'm amazed.
is there anything else that might go wrong that may coz this error.
BiG RaLpH
|
|
|
|
|
how r u connecting to sqlserver?
windows authentication....
just paste the connection string and ur code..
i will let u know any prob's in that..
|
|
|
|
|
the connection string is:
<add name="NameofConnection" connectionString="Data Source=W2K3SERVER;Initial Catalog=DATABASE;Integrated Security=True" providerName="System.Data.SqlClient"/>
My code is the code u gave me:
Dim sConn As String
sConn = System.Configuration.ConfigurationManager.AppSettings("NameofConnection")
Dim con As New System.Data.SqlClient.SqlConnection
con.ConnectionString = sConn
Dim selectCMD As SqlCommand = New SqlCommand("SELECT * FROM Table$", con)
selectCMD.CommandTimeout = 30
Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD
con.Open()
Dim custDT As DataTable = New DataTable
custDA.Fill(custDT)
con.Close()
the .fill doesn't take the 2 parameters I'm using asp.net 2.0 (maybe there is a difference)
BiG RaLpH
|
|
|
|
|
Hi.
I have a web page, which collects information about project (name, project date create, description, project date due, etc). One of the things I need to collect is the "project assigned to" information. For this purpose I need to build a table or any other structure that can support the following:
1. the table should have 5 rows as default
2. the table should have ability to add/remove rows if needed
3. the table will consist of 2 cell.
a. Role - dynamic drop-down (data will be populated from db)
b. Name - text field
4. adding/removing rows should not affect data entered in other fields. Basically if I filled all 5 rows and want to add sixth row my data will be there with new row added. The same goes for removing rows (I guess this is something had to do with State).
I've tried different things (datatable and datagrid) but couldn't complete all 4 point described above. Did anyone had experience with something like this or have any suggestions?
Thank you,
Alex.
|
|
|
|
|
alexfromto wrote: 3. the table will consist of 2 cell.
you mean, two columns?
I think that those facts are pretty okay with DataGrid. I have done something like that with Datagrid in ASP.NET 1.1...
alexfromto wrote: 1. the table should have 5 rows as default
you can bind with the empty dataset to your datagrid.
alexfromto wrote: 2. the table should have ability to add/remove rows if needed
For adding row, I used the footer template in Datagrid.
For removing row, I added the "Delete" link with command in grid template.
alexfromto wrote: a. Role - dynamic drop-down (data will be populated from db)
b. Name - text field
ItemTemplate is pretty okay for you. it allows you to add any web control (including dropdown ctl and textbox control) in Datagrid.
alexfromto wrote: 4. adding/removing rows should not affect data entered in other fields. Basically if I filled all 5 rows and want to add sixth row my data will be there with new row added. The same goes for removing rows
Yeah. It is very okay with Datagrid item template. but if you do some action, the postback will be occured.
|
|
|
|
|
Yes. I mean 2 columns.
1. I have no problem creating DataGrid. How can I assign empty DataSet to DataGrid. I've built a table (5 rows) with empty cell and added to my DataGrid. Is this the way of doing it?
2. Do you have anything code wise so I can see how add/remove works?
3. I did it and had no problem
4. didn't get exactly what you mean here. Will I lose data entered or datagrid will keep it?
Thanks a lot
|
|
|
|
|
OK. Firgure it out. Wow. Yeah.
|
|
|
|