Har prøvet lidt men tror jeg er røget i...
kan du se hvordan jeg efter DropDownList1.SelectedItem.Value kan sætte en If sætning ind som ser og DropDownList2 er Primaer Key eller (ingen ting) så hvis det er Primaer Key så sætter den det ind og ellers går den bare videre..
Min kode er:
<%@ Page Language="VB" %>
<%@ import namespace="MySql.Data.MySqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><script runat="server">
</script>
<html xmlns="
http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
Database Navn:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
Tabel Navn:<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
Felt Navn1:
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
FeltType1:
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem Value="INTEGER">Autonummernering</asp:ListItem>
<asp:ListItem Value="CHAR(50)">Tekst</asp:ListItem>
<asp:ListItem Value="VARCHAR">Note</asp:ListItem>
<asp:ListItem Value="CHAR(100)">Lang Tekst</asp:ListItem>
<asp:ListItem Value="DATE(yyyymmdd)">Dato</asp:ListItem>
</asp:DropDownList>
Primæer Key
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem Value="PRIMARY KEY">Ja</asp:ListItem>
<asp:ListItem>Nej</asp:ListItem>
</asp:DropDownList><br />
Felt Navn2:
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
FeltType2:
<asp:DropDownList ID="DropDownList3" runat="server">
<asp:ListItem Value="INTEGER">Autonummernering</asp:ListItem>
<asp:ListItem Value="CHAR(50)">Tekst</asp:ListItem>
<asp:ListItem Value="VARCHAR">Note</asp:ListItem>
<asp:ListItem Value="CHAR(100)">Lang Tekst</asp:ListItem>
<asp:ListItem Value="DATE(yyyymmdd)">Dato</asp:ListItem>
</asp:DropDownList>
Primæer Key
<asp:DropDownList ID="DropDownList4" runat="server">
<asp:ListItem Value="PRIMARY KEY">Ja</asp:ListItem>
<asp:ListItem>Nej</asp:ListItem>
</asp:DropDownList><br />
Felt Navn3:
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
FeltType3:
<asp:DropDownList ID="DropDownList5" runat="server">
<asp:ListItem Value="INTEGER">Autonummernering</asp:ListItem>
<asp:ListItem Value="CHAR(50)">Tekst</asp:ListItem>
<asp:ListItem Value="VARCHAR">Note</asp:ListItem>
<asp:ListItem Value="CHAR(100)">Lang Tekst</asp:ListItem>
<asp:ListItem Value="DATE(yyyymmdd)">Dato</asp:ListItem>
</asp:DropDownList>
Primæer Key
<asp:DropDownList ID="DropDownList6" runat="server">
<asp:ListItem Value="PRIMARY KEY">Ja</asp:ListItem>
<asp:ListItem>Nej</asp:ListItem>
</asp:DropDownList><br />
<asp:Button ID="Button1" runat="server" Text="Button" /></div>
</form>
</body>
</html>
<%
<script language="VB" runat="server">
Private Sub Button1_Click(src As Object, e As EventArgs)
Dim con As MySqlConnection = New MySqlConnection("Data Source=localhost;Database=mysql;User Id=root;Password=")
con.Open()
Dim credb As MySqlCommand = New MySqlCommand("CREATE DATABASE " & TextBox1.Text & "", con)
credb.ExecuteNonQuery()
Dim usedb As MySqlCommand = New MySqlCommand("USE " & TextBox1.Text & "", con)
usedb.ExecuteNonQuery()
Dim cretbl As MySqlCommand = New MySqlCommand("CREATE TABLE " & TextBox2.Text & "(" & TextBox3.Text & " " & DropDownList1.SelectedItem.Value & " PRIMARY KEY, felt2 VARCHAR(100))", con)
cretbl.ExecuteNonQuery()
con.Close()
End Sub
</script>
%>